get the app get the app       get the app       get the app

70-448 MS SQL Server 2008, Business Intelligence

Exam Name70-448 MS SQL Server 2008, Business Intelligence
Description70-448 MS SQL Server 2008, Business Intelligence questions and Answers exams contains the questions from various interview of IT industry.These questions are helpful to crack the IT interview.
Exam TypeMASTER EXAM
Authenticity10005
creatorAnirudh(39048)
Create QuestionPDF   Start Exam

Back to Parent Category
Question: 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?

Answer:You should use the SQL Server Destination.


Question: 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?

Answer:You should consider adding a Data Viewer object to the Data Flow task.


Question: 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)

Answer:You should consider using a Merge Join Transformation and a Lookup Transformation.


Question: 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?


Answer:You should refresh the sorting properties in each source component.


Question: 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?


Answer:You should consider using the VersionGUID variable.


Question: 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?

Answer:You should create a SQL Server Configuration type using the SSIS Package Configuration Wizard. Then you should select a centralized Microsoft SQL Server in order to store the package configuration.


Question: 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?

Answer:You should consider running checkpoints in the package prior to restarting the package when a failover occurs.


Question: 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?

Answer:You should consider backing up the master database.


Question: 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?

Answer:You should consider creating two Control Flow tasks and one Data Flow task on a container. Then the TransactionOption property of the container should be set to Required.


Question: 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?

Answer:You should consider placing a copy of the assembly in the proper folder.


Question: You work as a database administrator at Abc.com. You are responsible for creating a SQL Server 2008 Integration Services (SSIS) instance. The SSIS instance contains a Data Flow task that reproduces millions of rows for Abc.com. The data flow checks for a match against a reference table that contains of 50,000 rows, including every row that will be used during the data flow. You need to ensure that the data flow runs in the least amount of time.
What should you do?


Answer:You should consider selecting a Lookup transformation in conjunction with the Full cache option.


Question: You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) sample. The SSIS sample includes a number of data flows. You want to use Business Intelligence Development Studio to control the data that passes through each path in the data flow. However, you need to ensure that the data flow logic is not affected.
What should you do?


Answer:You should use the Data Viewer tool.


Question: 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. You want to specify the XML configuration for the package. What should you do?

Answer:You should use the DTEXEC command line utility.


Question: You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008 server instance. Abc.com makes use of The SSIS instance to run several SQL Server 2008 Integration Services (SSIS) packages. To ensure Abc.com productivity, you need to ensure that the database server runs normally. What should you do?

Answer:You should consider configuring the BlockedSignatureStates registry entries to Block unsafe, untrusted signs as well as unsigned instances.


Question: You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance for Abc.com. The SSIS instance uses a default connection manager to connect to a component. You develop an XML configuration file to provide the required authentication information for your report. However, you receive an error message stating that you are unable to log in successfully to the package. You need to ensure that the package is able to run normally. What should you do?

Answer:You should consider modifying the XML configuration file.


Question: You work as a database administrator at Abc.com. Abc.com network contains a development database server named ABC-DB06 and a production database server named TESCKLING-DB01. You are creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You include ABC-DB06 in the SSIS package. You publish the package to ABCDB06 but discover that you are not able to move the data between ABC-DB06 and ABC-DB01. You receive the following error message:
The package could not link to ABC-DB06.
You need to modify the package to reference the ABC-DB06 when it is implemented. What should you do?


Answer:You need to select the Connection Manager check box on the Connection Managers tab of the Execute Package utility and then change the connection string.


Question: 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. You make use of local development environment in order to check the package. You then publish the package to the file system on a production server named ABC-DB02. However, Abc.com users inform you that they are unable to access the package. You need to ensure that Abc.com users are able to access and run the package. What should you do?

Answer:You should use the EncryptAllWithPassword option.


Question: 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 references packages in a SQL Server 2008 sample. You want to publish the SSIS package to another SSIS sample which reserves its packages in a common directory. What should you do?

Answer:You should consider running the dtutil command for the package.


Question: You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package. The SSIS package gets data from a FTP server by using numerous FTP tasks. The package also manages data using various Execute SQL tasks. You need to make sure that the package is set to restart after the package downloaded the files. What should you do?

Answer:You should consider configuring the package to use a checkpoint.


Question: You work as a database administrator at Abc.com. The Abc.com network contains a production database server named ABC-DB01. You have recently created a SQL Server 2008 Integration Services (SSIS) instance that you tested in a local development environment. You deploy the SSIS instance to ABC- DB01. You need to ensure that the protection level for users is configured when they run the package. What should you do?

Answer:You should use the EncryptAllWithUserKey option.