Online Access Free 70-463 Practice Test

NO: 210
In your ETL process, there are three external processes that need to be executed in sequence, but you do not want to stop execution if any of them fails.
Can this be achieved by using precedence constraints? If so, which precedence constraints can be used?

• A.Yes, this can be achieved by using completion precedence constraints between the first and the second, between the second and the third, and between the third Execute Process task and the following task.
• B.No, this cannot be achieved just by using precedence constraints.
• C.Yes, this can be achieved by using failure precedence constraints between the first and the second, and between the second and the third Execute Process tasks, and by using a completion precedence constraint between the third Execute Process task and the following task.
• D.Yes, this can be achieved by using completion precedence constraints between the first and the second and between the second and the third Execute Process tasks, and by using a success precedence constraint between the third Execute Process task and the following task.

You are designing a SQL Server Integration Services (SS1S) package that uploads a file to a table named Orders in a SQL Azure database.
The company's auditing policies have the following requirements:
*An entry must be written to a dedicated SQL Server log table named OrderLog.
*The entry must be written as soon as the file upload task completes.
You need to meet the company's policy requirements. Which event handler should you use?

• A.OnProgress
• B.Onlnformation
• C.OnComplete
• D.OnPostExecute

You have a data warehouse.
You need to create a SQL Server Integration Services (SSIS) package to meet the following requirements:
-The package must be deployed.
-The package must be parameterized.
-The package execution must be automated.
In which sequence should you perform the actions? To answer, move all of the actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation

You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to download data files.
You create project parameters to store the username and password that are used to access the FTP site.
You need to ensure that the username and password values are encrypted when they are deployed.
What should you do?

• A.Convert the project to the Legacy Deployment model.
• B.Set the ProtectionLevel property of the package to EncryptSensitiveWithPassword.
• C.Set the Sensitive property of the parameters to True.
• D.Convert the parameters to package parameters.

You are maintaining a SQL Server Integration Services (SSIS) package. The package uses custom functionality that is implemented in Microsoft Visual C#.
The implementation of the custom functionality changes overtime. The design of the package allows you to deploy new releases of the custom functionality without redeploying the entire package.
You need to implement and deploy an update to the custom functionality without requiring package redeployment.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

Explanation
Box 1:

Box 2:

Box 3: