Latest MCTS 70-448 Dumps Real Exam Download 71-80

Ensurepass

QUESTION 71

You build and deploy a SQL Server 2008 Integration Services (SSIS) package.

During package development, the XML configuration is not specified.

You need to apply the configuration to the deployed package. What should you do?

 

A. Use the Deployment utility.

B. Use the SETX command line utility.

C. Use the DTUTIL command line utility.

D. Use the DTEXEC command line utility.

 

Correct Answer: D

Explanation

Explanation/Reference:

 

 

QUESTION 72

You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a

Data Flow task.

You need to modify the package to write all rows that generate errors to a text file.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

 

A. Use the SSIS log provider for the SQL Profiler.

B. Use the SSIS log provider for the text file.

C. Use a Flat File Destination component.

D. Use a Raw File Destination component.

E. Add an Error output to the Data Flow component

 

Correct Answer: CE

Explanation

Explanation/Reference:

 

 

QUESTION 73

You are editing a SQL Server 2008 Integration Services (SSIS) package by using Business Intelligence

Development Studio. The package uses a custom data flow component. The package runs successfully.

You attempt to add another instance of the custom data flow component to the package. The data flow component does not appear in the toolbox or in the Choose Toolbox Items dialog box.

You need to add the custom data flow component to the toolbox.

What should you do?

 

A. Copy the assembly to the appropriate folder.

B. Add the assembly to the Global Assembly Cache.

C. Register the assembly by using the REGSVR32 utility.

D. Register the assembly by using the Assembly Registration utility (REGASM.EXE).

 

Correct Answer: A

Explanation

Explanation/Reference:

 

 

QUESTION 74

You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster.

You have a complex package that takes a long time to run.

You need to ensure that if the package executes during a failover, the package can be resumed at the point of failure.

What should you do?

 

A. Cluster the SSIS service. Add the SSIS service to its own cluster resource group.

B. Cluster the SSIS service. Add the SSIS service to the SQL Server cluster resource group.

C. Implement checkpoints within your package. Restart the package whenever a failover occurs.

D. Implement transactions within your package. Restart the package whenever a failover occurs.

 

Correct Answer: C

Explanation/Reference:

 

 

QUESTION 75

You maintain SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 instance.

You need to design a failure recovery plan for packages that are deployed to a SQL Server.

What should you do?

 

A. Back up the master database.

B. Back up the model database.

C. Back up the MSDB database.

D. Back up the tempdb databse.

 

Correct Answer: C

Explanation

Explanation/Reference:

 

 

QUESTION 76

You maintain a SQL Server 2008 Integration Services (SSIS) instancE.The instance stores packages in a SQL Server 2008 instance.

You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in a shared directory.

What should you do?

 

A. Execute the dtutil command.

B. Execute the dtexec command.

C. Execute the dtexecui command.

D. Execute the dtswizard command.

 

Correct Answer: A

Explanation

Explanation/Reference:

 

 

QUESTION 77

You are developing a SQL Server 2008 Integration Services (SSIS) project in Business Intelligence

Development Studio.

You configure the project properties as shown in the following image.

You need to create a deployment manifest for all packages in the project.

What should you do?

clip_image002

 

A. Build the Integration Services project.

B. Modify the AllowConfigurationChanges property of the project.

C. Copy each package. Rename each copy with a .SSISDeploymentManifest file extension.

D. View the code of each Data Transformation Services (DTS) package. Copy the first <DTS:Property> xml node to a file with a .SSISDeploymentManifest file extension.

 

Correct Answer: A

Explanation/Reference:

 

 

QUESTION 78

You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple

Execute SQL tasks.

You need to configure the package to restart at the point of failure after the package downloads the files.

What should you do?

 

A. Configure the FTP tasks to support transactions.

B. Configure the Execute SQL tasks to support transactions.

C. Move all the FTP tasks to a sequence container.

D. Configure the package to use a checkpoint.

 

Correct Answer: D

Explanation

Explanation/Reference:

 

 

QUESTION 79

You are developing a SQL Server 2008 Integration Services (SSIS) package.

The package performs the following tasks:

Processes multiple files by using a ForEach Loop container.

Imports the contents of the files to a table by using a Data Flow task.

Logs the results of the status into a table by using an Execute SQL task.

You need to ensure that all the tasks of the package except the Execute SQL task execute within a single transaction.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

 

A. In the Foreach Loop container, configure the TransactionOption property to NotSupported.

B. In the Data Flow task, configure the TransactionOption property to Required.

C. In the package, configure the TransactionOption property to Required.

D. In the package, configure the TransactionOption property to NotSupported.

E. In the Execute SQL task, configure the TransactionOption property to NotSupported.

F. In the Execute SQL task, configure the TransactionOption property to Supported.

 

Correct Answer: CE

Explanation

Explanation/Reference:

 

 

QUESTION 80

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by using your local development environment.

You deploy the package to the file system in the production environment. The users report that the connection strings contained in the package are blank. The package fails to execute.

You need to change the protection level of the package to ensure that users can view and execute the package.

Which protection level should you use?

 

A. DontSaveSensitive

B. EncryptAllWithUserKey

C. EncryptAllWithPassword

D. ServerStorage

 

Correct Answer: C

Explanation/Reference:

 

 

Download Lates MCTS 70-448 Real Free Tests , help you to pass exam 100%.