Microsoft 70-463 Exam Questions Instant Access

Question 1

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.

The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server.

The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project.

You need to meet the requirements by using the least amount of administrative effort.

What should you do?

AFor each target server, create separate registry entry configurations. Select the registry entry at package execution time.

BFor each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.

CCreate one SSIS catalog Environment. Change the values of each Environment variable at package execution time.

DFor each target server, create a separate XML configuration file. Select the XML configuration file at package execution time.

Answer : B

Question 2

Which of the following statements about simple and complex data movements are true? (Choose all that

apply.)

ASimple data movements only have a single data source and a single data destination.

BComplex data movements require data to be transformed before it can be stored at the destination.

CIn simple data movements, data transformations are limited to data type conversion.

DIn complex data movements, additional programmatic logic is required to merge source data with
destination data.

Answer : B, D

References:

http://colleenmorrow.com/2014/12/09/exam-prep-70-463-introduction-to-ssdt/

Question 3

Answer : G

http://msdn.microsoft.com/en-us/library/hh479588.aspx

http://msdn.microsoft.com/en-us/library/hh213290.aspx

http://msdn.microsoft.com/en-us/library/hh213373.aspx

Question 4

You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse.

You need to establish the correct order for loading each table to maximize parallel processing.

Which order should you use?

A1. DimCurrency, DimScenario, DimAccount in parallel
2. DimOrganization
3. FactFinance

Bl. DimCurrency, DimOrganization in parallel
2. DimScenario, DimAccount in parallel
3. FactFinance

C1. DimCurrency, FactFinance in parallel
2. DimOrganization, DimScenario, DimAccount in parallel

D1. FactFinance
2. DimOrganization, DimScenario, DimAccount in parallel
3. DimCurrency

E1. DimCurrency
2. DimOrganization
3. DimScenario, DimAccount in parallel
4. FactFinance

Answer : A

References:

http://msdn.microsoft.com/en-us/library/ms139892.aspx

http://msdn.microsoft.com/en-us/library/ms141261.aspx

Question 5

Answer : I

Question 6

Answer : I

Question 7

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base.

In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Team Type, does not yet have a domain.

You need to complete the mapping of the Team Type column.

What should you do?

AAdd a column mapping for the Team Type column.

BMap a composite domain to the source column.

CCreate a composite domain that includes the Team Type column.

DAdd a domain for the Team Type column.

Answer : D

References:

http://msdn.microsoft.com/en-us/library/ff877917.aspx

http://msdn.microsoft.com/en-us/library/hh213015.aspx

http://msdn.microsoft.com/en-us/library/gg524799.aspx

Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 70-463 Exam Questions