Click here for :Free SSC Mock test by topic

You work as a database administrator at ABC.com. Your duties include administrating a SQL Server 2008 server database named ABC-DB05, which hosts the SQL Server Analysis Services (SSAS) role. While querying ABC- DB05, you are presented with a Duplicate Key error. You receive an instruction from the CIO to make minor modifications to the ErrorConfiguration feature to resolve this problem. Which of the following actions should you take?
1)The store procedure should be modified.

2)The Data Viewer object should be modified.

3)The connection string should be modified.

4)The dimension should be modified.


  • : 272
  • : 4
    Previous Next

    The dimension should be modified.

    Suggest other answer
    Login to Discuss/suggest the answer...


    Anirudh
    39306
  • Exam: 70-448 MS SQL Server 2008, Business Intelligence





    Recommended Learning for you

    You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. The SSIS data flow will transfer data to a SQL Server 2008 database named CKProducts. You want to ensure that the data flow refreshes the existing data in CKProducts with the data in the data flow. What should you do?
    You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. The SSIS package must contain a Data Flow task with a Fuzzy Grouping transformation that creates data. You received instructions to debug the SSIS package. To this end you need to browse the output data of the Fuzzy Grouping transformation in order to check on the constraints currently on the Fuzzy Grouping transformation. What should you do?
    You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow that adds the data from a source query to a result table for Abc.com. You want to add the rows that are included in the destination table. What should you do? (Choose all that apply)
    You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. The SSIS data flow obtains data from two databases that are hosted on two separate SQL Server 2008 database servers. Each source is based on a SELECT statement that includes an ORDER BY clause. However, you receive the following error message when you connect the paths from the two sources: Data Flow Task: The input is not sorted. The input Merge Join Left Input (80 must be sorted. You need to ensure that the data from every query is contained in every row in the data flow. You thus need to determine a way to accomplish this. What should you do?
    You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance that includes the following components: * An OnError method * A data flow job that is included in a For Loop container * A Flat File result component that uses a Flat File connection controller. You want to log error data from an expression that contains the package version to a Word file whenever an error occurs. What should you do?
    You work as a database administrator at Abc.com. The Abc.com network contains 15 SQL Server 2008 database servers. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package that has to be interpolated on all 15 database servers. However, you are unable to access the file system of the servers. You thus need to modify the package setting attributes while the package is running. What should you do?
    You work as a database administrator at Abc.com. You are currently creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You decide to make use of the SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster. You create a complex package which takes a considerable amount of processing time. You need to ensure that package can be restored if it runs while a failover is occurring. What should you do?
    You work as a database administrator at Abc.com. The Abc.com network contains a SQL Server 2008 database server named ABC-DB01. You decide to create a SQL Server 2008 Integration Services (SSIS) package on ABCDB01. You need to develop a recovery plan for ABC-DB01. What should you do?
    You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. The SSIS package must contain six Data Flow tasks and three Control Flow tasks. What should you do?
    You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008 Integration Services (SSIS) instance using Business Intelligence Development Studio. Abc.com makes use of a Common Data Flow component in the package that implement normally. You want to add a sample of the Common Data Flow component. However, the component does not appear in the toolbox. You need to add the Common Data Flow component to the toolbox. What should you do?
    Close(X)
    Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material

    Share the Knowledge

    You can help us to improve by giving your valuable suggestions at admin@quhasa.com

    By using the service of this site, I agree that I will serve wholeheartedly and will not indulge in any sort of activity that threats the integrity of the organisation I am working for / I work for.
    I have a firm believe in the notion that knowledge should be open source and helping the needy and deserving part of society will always be my motto.

    Knowledge is the power, Dont miss any paper, Subscribe to us







    Follow us at



    Privacy Policy