70-448 MS SQL Server 2008, Business Intelligence
| Exam Name | 70-448 MS SQL Server 2008, Business Intelligence |
|---|---|
| Description | 70-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 Type | MASTER EXAM |
| Authenticity | 10005 |
| creator | Anirudh(39352) |
.
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:
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:
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:
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?
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:
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?
* 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:
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:
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:
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:
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:
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:
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?
What should you do?
Answer:
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?
What should you do?
Answer:
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:
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:
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:
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?
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:
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:
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:
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:
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:
