Latest MCSE 70-463 Real Exam Download 61-70

Ensurepass

 

QUESTION 61

You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

 

You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing data quality projects.

 

Which of the following are benefits of data quality projects? (Choose all that apply.)

 

A. It enables you to perform data cleansing on your source data by using the knowledge in a DQS

knowledge base.

B. It allows you to perform data matching on your source data by using the knowledge in a DQS knowledge base.

C. It allows you to perform data matching on your source data by using the matching policy in a knowledge base.

D. It enables you to perform data cleansing on your source data by using the matching policy in a knowledge base.

 

Correct Answer: AC

 

QUESTION 62

You work as a database developer at ABC.com. The ABC.com network consists of a single domain named

ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

 

You have been asked to revise a SQL Server Integration Services (SSIS) package. The package only includes Execute SQL tasks.

 

To make sure that, in the event of an Execute SQL task failing, changes made by all of the Execute SQL

tasks is rolled back. To do this, you want to alter the TransactionOption property of the package.

Which of the following is the value that must be set for the TransactionOption property of the package?

A. NotSupported.

B. Supported.

C. NotRequired.
D. Required.

 

Correct Answer: D

 

QUESTION 63

You work as a database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

 

You have recently created an SQL Server Integration Services (SSIS) project catalog that contains two Environments. A single Environment Variable, named ConnectionString, of type string is specified by each environment. The project also has a project Connection Manager configured to link up with the data warehouse.

 

You have been instructed to make sure that deployed packages are executed using any of the specified

Environments.

 

Which of the following suitably describes an Environment Variable?

 

A. An environment variable specifies the data that will be used by a package.

B. An environment variable can be used to manage Integration Services objects in the catalog.

C. An environment variable defines a literal value that can be assigned to a parameter during package execution.

D. An environment variable allows you to use folders to organize your projects and environments.

E. An environment variable is a container of variables that can be referenced by Integration Services projects.

 

Correct Answer: C

 

QUESTION 64

You work as a senior database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

 

You are hosting a training exercise for ABC.com’s junior database developers. You are currently discussing an EventHandlerClass property that is used to retrieve or configure a value that indicates whether the container participates in transactions.

Which of the following is the EventHandlerClass property that you are discussing?

A. The TransactionOption property.

B. The Executables property.

C. The LoggingOptions property.
D. The Variables property.

 

Correct Answer: A

 

QUESTION 65

You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

 

You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the effects of setting IsolationLevel transaction property of a Data Flow task to Chaos.

 

Which of the following suitably describes the effect?

 

A. It prevents pending changes from more highly isolated transactions from being overwritten.
B. It prevents shared locks from being issued and exclusive locks from being honored.

C. It prevents other users from updating the data.

D. It reduces blocking by storing a version of data that one application can read while another is modifying the same data.


Correct Answer: A

 

QUESTION 66

You work as a database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

 

You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured to import data into a SQL Azure hosted data warehouse.

 

You have decided to make use of the Environment Variable package configuration as part of your solution. Which of the following is TRUE with regards to the Environment Variable package configuration?

A. It stores the property path inside the package and the value outside the package.
B. It stores both the property path and the value outside the package.

C. It is used to fetch a value from a variable in a calling package.
D. It is the most commonly used configuration type.

 

Correct Answer: A

 

QUESTION 67

You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

 

You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing the Fuzzy Lookup transformation.

 

Which of the following is TRUE with regards to the Fuzzy Lookup similarity threshold setting? (Choose all that apply.)

 

A. Increasing the threshold can improve the speed of matching.

B. Increasing the threshold can deteriorate the speed of matching.

C. The nearer the value is to 1, the nearer the resemblance of the lookup value to the source value must be to qualify as a match.

D. The nearer the value is to 1, the further the resemblance of the lookup value to the source value must be to qualify as a match.

 

Correct Answer: AC

 

QUESTION 68

You work as a database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

 

You have created a SQL Server Integration Services (SSIS) project that you are preparing to deploy using the Integration Services Deployment Wizard.

Which of the following is the third step in the Integration Services Deployment Wizard’s process?

A. Review

B. Select Destination

C. Deploy/Results

D. Select Source

 

Correct Answer: A

 

QUESTION 69

You work as a database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

 

You have received reports regarding a current existing SQL Server Integration Services (SSIS) package


not completing its execution, and not transferring data. You have decided to make use of the Package

Deployment Model.

Which of the following is TRUE with regards to using the Package Deployment Model?

A. CLR integration is NOT required on the database engine.

B. Environment-specific parameter values are stored in environment variables.

C. Events that are created by the package are captured automatically and saved to the catalog during execution.

D. Events that are created by the package are NOT captured automatically during execution.

 

Correct Answer: AD

 

QUESTION 70

You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog. You need to add the Environment to the project. Which stored procedure should you use?

 

A. The catalog.create_execution stored procedure.

B. The catalog.create_environment_variable stored procedure.
C. The catalog.create_environment_reference stored procedure.
D. The catalog.add_data_tap stored procedure.

 

Correct Answer: C

Download Latest 70-463 Real Free Tests , help you to pass exam 100%.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.