70-463 Exam Questions - Online Test

70-463 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Act now and download your Microsoft 70 463 exam test today! Do not waste time for the worthless Microsoft exam 70 463 tutorials. Download Latest Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012 exam with real questions and answers and begin to learn Microsoft microsoft 70 463 with a classic professional.

Q11. You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day. 

Referential integrity must be enforced declaratively. 

You need to design a solution that can join a single time dimension to both fact tables. 

What should you do? 

A. Create a time mapping table. 

B. Change the level of granularity in both fact tables to be the same. 

C. Merge the fact tables. 

D. Create a view on the sales table. 

Answer: C 

Q12. You are developing a SQL Server Integration Services (SSIS) package. 

To process complex scientific data originating from a SQL Azure database, a custom task component is added to the project. You need to ensure that the custom component is deployed on a test environment 

correctly. What should you do? 

A. Add an OnError event handler to the SSIS project. 

B. Open a command prompt and run the gacutil command. 

C. Configure the SSIS solution to use the Project Deployment Model. 

D. Open a command prompt and run the dtexec /dumperror /conn command. 

E. Configure the output of a component in the package data flow to use a data tap. 

F. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility. 

G. Open a command prompt and run the dtexec /rep /conn command. 

H. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server. 

I. Use an msi file to deploy the package on the server. 

J. Open a command prompt and run the dtutil /copy command. 

K. Create a reusable custom logging component and use it in the SSIS project. 

Answer: B 

Reference: 

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

Q13. You are developing a SQL Server Integration Services (SSIS) package. 

The package control flow will contain many tasks. The tasks will execute consecutively and none will execute more than once. Certain groups of tasks will share variable and transaction scope. 

You need to group tasks together while enabling them to be collapsed and expanded as a group. 

Which item should you use from the SSIS Toolbox? (To answer, select the appropriate item in the answer area.) 

Answer: 

Q14. You are developing a SQL Server Integration Services (SSIS) package. 

You need to design a package to change a variable value during package execution by using the least amount of development effort. 

What should you use? 

A. Express on task 

B. Data Cleansing transformation 

C. Fuzzy Lookup transformation 

D. Term Lookup transformation 

E. Data Profiling task 

Answer: A 

Q15. You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature. 

You have added a CDC Source component to the data flow to read changed data from the source system. 

You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations. 

Which data flow transformation should you use? 

A. Audit 

B. DQS Cleansing 

C. CDC Splitter 

D. Pivot 

Answer: D 

Q16. You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database. 

The package contains a data flow task that has seven source-to-destination execution trees. 

Only three of the source-to-destination execution trees are running in parallel. 

You need to ensure that all the execution trees run in parallel. 

What should you do? 

A. Set the EngineThreads property of the data flow task to 7. 

B. Set the MaxConcurrentExcecutables property of the package to 7. 

C. Create seven data flow tasks that contain one source-to-destination execution tree each. 

D. Place the data flow task in a For Loop container that is configured to execute seven times. 

Answer: A 

Q17. You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS) project. 

The first package that you create in this project contains a package connection that accesses a flat file. Additional packages in the project must also access this file. 

You need to define and reuse the flat file connection in all project packages. 

What should you do? 

A. Convert the package Connection Manager in the first package to a project Connection Manager. 

B. Copy the package Connection Manager and paste it into the second package. 

C. Convert the project to the Package Deployment model. 

D. Set the ProtectionLevel property of the package Connection Manager to DontSaveSensitive to reuse the flat file connection. 

Answer: A 

Q18. You are implementing a SQL Server Integration Services (SSIS) 2012 package that loads data from various flat files and a Windows Azure SQL Database database. 

Daily transactions must be loaded into a staging database. All the SSIS tasks will use the CurrentDate variable as the transaction date. 

You need to set the CurrentDate variable to the date stored in a control table of the Windows Azure SQL Database database when the package starts. You need to achieve this goal by using the least amount of development effort. 

What should you use to set the variable? 

A. an Expression task 

B. an Execute SQL task 

C. a Script component 

D. a Script task 

Answer: B 

Q19. You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a production server. The package contains sensitive information secured by using the EncryptSensitiveWithUserKey package protection level. 

You are preparing the package for deployment by the production operations team. 

You need to ensure that the production operations team can open and execute the package without re-entering the sensitive information. 

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.) 

Answer: 

Q20. You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). 

You need to complete the post-installation configuration. 

What should you do? 

A. Run the DQSInstaller.exe command. 

B. Install the data providers that are used for data refresh. 

C. Install ADOMD.NET. 

D. Run the dbimpexp.exe command. 

Answer: A 

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

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