Microsoft 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam
Page: 2 / 48
Total 237 questions
Question #6 (Topic: Topic 1)
You are building a SQL Server Integration Services (SSIS) package to load data from all
files that are automatically copied to a directory each night through an external FTP
process.
You need to load data from all copied files to a destination table in SQL Server.
Which three steps 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.)
[Microsoft-70-463-13.0/Microsoft-70-463-7_2.png]
files that are automatically copied to a directory each night through an external FTP
process.
You need to load data from all copied files to a destination table in SQL Server.
Which three steps 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.)
[Microsoft-70-463-13.0/Microsoft-70-463-7_2.png]
Answer: [Microsoft-70-463-13.0/Microsoft-70-463-7_3.png]
Question #7 (Topic: Topic 1)
You are developing a SQL Server Integration Services (SSIS) package to load data into a
data warehouse.
[Microsoft-70-463-13.0/Microsoft-70-463-8_2.png]
You need to establish the correct order for loading each table to maximize parallel
processing.
Which order should you use?
data warehouse.
[Microsoft-70-463-13.0/Microsoft-70-463-8_2.png]
You need to establish the correct order for loading each table to maximize parallel
processing.
Which order should you use?
A. 1. DimCurrency, DimScenario, DimAccount in parallel 2. DimOrganization 3. FactFinance
B.
C. DimCurrency, DimOrganization in parallel 2. DimScenario, DimAccount in parallel 3. FactFinance
D. 1. DimCurrency, FactFinance in parallel 2. DimOrganization, DimScenario, DimAccount in parallel
E. 1. FactFinance 2. DimOrganization, DimScenario, DimAccount in parallel 3. DimCurrency
F. 1. DimCurrency 2. DimOrganization 3. DimScenario, DimAccount in parallel 4. FactFinance
Answer: A
Question #8 (Topic: Topic 1)
You are developing a SQL Server Integration Services (SSIS) project that copies a large
amount of rows from a SQL Azure database. The project uses the Package Deployment
Model. This project is deployed to SQL Server on a test server.
You need to ensure that the project is deployed to the SSIS catalog on the production
server.
What should you do?
amount of rows from a SQL Azure database. The project uses the Package Deployment
Model. This project is deployed to SQL Server on a test server.
You need to ensure that the project is deployed to the SSIS catalog on the production
server.
What should you do?
A. Open a command prompt and run the dtexec /dumperror /conn command.
B. Create a reusable custom logging component and use it in the SSIS project.
C. Open a command prompt and run the gacutil command.
D. Add an OnError event handler to the SSIS project.
E. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
F. Open a command prompt and run the dtexec /rep /conn command.
G. Open a command prompt and run the dtutil /copy command.
H. Use an msi file to deploy the package on the server.
I. Configure the SSIS solution to use the Project Deployment Model.
J. Configure the output of a component in the package data flow to use a data tap. K. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
Answer: I
Question #9 (Topic: Topic 1)
You are creating a SQL Server Master Data Services (MDS) model for a company.
The source data for the company is stored in a single table that contains the manager-to-
subordinate relationships.
You need to create a hierarchy representing the organizational structure of the company.
Which hierarchy type should you use?
The source data for the company is stored in a single table that contains the manager-to-
subordinate relationships.
You need to create a hierarchy representing the organizational structure of the company.
Which hierarchy type should you use?
A. Organizational
B. Recursive
C. Non-Mandatory Explicit
D. Many-to-Many
Answer: B
Question #10 (Topic: Topic 1)
You install a SQL Server 2012 database engine instance on a production server. A month
later, you install SQL Server 2012 Integration Services (SSIS).
You must develop an SSIS project and deploy it to the server by using the Project
Deployment model.
Operations Log records that are outside the configured retention period must be cleaned
automatically.
You need to create the SSIS catalog on the production server.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
later, you install SQL Server 2012 Integration Services (SSIS).
You must develop an SSIS project and deploy it to the server by using the Project
Deployment model.
Operations Log records that are outside the configured retention period must be cleaned
automatically.
You need to create the SSIS catalog on the production server.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
A. Enable XP Command Shell.
B. Enable CLR Integration.
C. Enable OLE Automation.
D. Start the SQL Server Browser service.
E. Enable Cross Database Ownership Chaining
F. Start the SQL Server Agent service
G. Enable Ad Hoc Remote Queries.
Answer: B,F
