QUESTION 11

You develop and deploy a SQL Server Integration Services (SSIS) package. The package is stored in the file system. You need to execute the package without importing it to the SSIS server. What should you use to execute the package? (Each correct answer presents a complete solution. Choose all that apply.)

 

A.     catalog.start_package

B.      dtexec

C.      SQL Server Management Studio

D.     SQL Server Agent

 

Correct Answer: BD

 

 

QUESTION 12

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 use of Slowly Changing Dimension Transformation Outputs. One of the output options causes Derived Column transformations to create columns for the expired row and the current row indicators. Which option is the output that causes this?

 

A.     Unchanged Output

B.      Inferred Member Updates Output

C.      Historical Attributes Inserts Output

D.     Fixed Attribute Output

E.      Changing Attributes Updates Output

 

Correct Answer: C

 

 

QUESTION 13

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 running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the ValidateExternalMetaData property for a data flow. Which of the following represents the data type for this property?

 

A.     Integer

B.      IDTSExternalMetadataColumn100

C.      String

D.     Boolean

 

Correct Answer: D

 

 

QUESTION 14

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 Multicast transformation. Which of the following is TRUE with regards to Multicast transformation? (Choose two.)

 

A.     It prevents a package from creating logical copies of data.

B.      It allows a package to create logical copies of data.

C.      It distributes its input to one or more outputs.

D.     It distributes its input to a single output.

 

Correct Answer: BC

 

 

QUESTION 15

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 make use of the GenerateAndPersistNewIndex Fuzzy Lookup transformation option. Which of the following is the purpose of this option?

 

A.     It allows for a current index to be reused.

B.      It allows for a new index to be created, without saving it.

C.      It allows for a new index to be created and saved, without maintaining it.

D.     It allows for a new index to be created, saved, and maintained.

 

Correct Answer: C

 

 

QUESTION 16

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. You have decided to make use of Expression Task. Which of the following is TRUE with regards to Expression Task?

 

A.     It creates and evaluates expressions that set variable values at runtime.

B.      It provides code to perform functions that are not available in the built-in tasks and transformations that SQL Server Integration Services provides.

C.      It runs an application or batch file as part of a SQL Server Integration Services package workflow.

D.     It allows you to run SQL statements during package execution.

 

Correct Answer: A

 

 

QUESTION 17

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 18

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 19

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 20

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

 

Free VCE & PDF File for Microsoft 70-463 Real Exam

Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…