Certleader 2018 New 70-463 Exam Dumps (PDF & VCE) Download: https://www.certleader.com/70-463-dumps.html

Cause all that matters here is passing the Microsoft 70-463 exam. Cause all that you need is a high score of 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 exam. The only one thing you need to do is downloading Testking 70-463 exam study guides now. We will not let you down with our money-back guarantee.

2016 Nov 70-463 question

Q91. You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. 

You are developing the part of the SSIS package that populates the ProjectDates dimension table. The business key of the ProjectDates table is the ProjectName column. 

The business user has given you the dimensional attribute behavior for each of the four columns in the ProjectDates table: 

ExpectedStartDate - New values should be tracked over time. 

ActualStartDate - New values should not be accepted. 

ExpectedEndDate - New values should replace existing values. 

ActualEndDate - New values should be tracked over time. 

You use the SSIS Slowly Changing Dimension Transformation. 

You must configure the Change Type value for each source column. 

Which Change Type values should you select? (To answer, drag the appropriate value from the list of values to the correct location or locations in the answer area.) 

Answer: 


Q92. You manage a SQL Server Master Data Services (MDS) environment. 

A new application requires access to the product data that is available in the MDS repository. 

You need to design a solution that gives the application access to the product data with the least amount of development effort. 

What should you do? 

A. Create a Subscription View in MDS. 

B. Access the product entity tables in the MDS database directly. 

C. Use SQL Server Integration Services (SSIS) to extract the data and put it in a staging database. 

D. Use change data capture on the product entity tables. 

Answer:


Q93. You are reviewing the design of a student dimension table in an existing data warehouse hosted on SQL Azure. 

The current dimension design does not allow the retention of historical changes to student attributes such as ParentOccupation. 

You need to redesign the dimension to enable the full historical reporting of changes to multiple student attributes including ParentOccupation. 

What should you do? 

A. Add CurrentValue and PreviousValue columns to the student dimension. 

B. Enable Snapshot Isolation on the data warehouse. 

C. Add an IsCurrent column to the student dimension. 

D. Add StartDate and EndDate columns to the student dimension. 

Answer:

Explanation: Adding a start and end date will give you this ability as when a record is inserted and given a start and end date, you’ll have the ability to determine when they were active therefore giving you a retention of historical changes 


Q94. You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on SQL Azure. One of the columns in the data source is named ProductCode. 

Some of the data to be loaded will reference products that need special processing logic in the data flow. 

You need to enable separate processing streams for a subset of rows based on the source product code. 

Which data flow transformation should you use? 

A. Audit 

B. Source Assistant 

C. Script Task 

D. Conditional Split 

Answer:

Explanation: 

http://msdn.microsoft.com/en-us/library/ms137640.aspx http://msdn.microsoft.com/en-us/library/ms141150.aspx http://msdn.microsoft.com/en-us/library/ff929138.aspx http://msdn.microsoft.com/en-us/library/ff929116.aspx 


Q95. You are designing a SQL Server Integration Services (SSIS) package configuration strategy. 

The package configuration must meet the following requirements: Include multiple properties in a configuration. Force packages to load all settings in the configuration. Support Encrypting File System (EFS) formats. You need to select the appropriate configuration. 

Which configuration type should you use? 

To answer, select the appropriate option from the drop-down list in the dialog box. 

Answer: 


Replace 70-463 free practice questions:

Q96. You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database. 

When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server. You need to ensure that the SQL Server Agent job can execute the SSIS package. Which four actions 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: 


Q97. You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer dimension table by using a data flow task. 

Changes to the customer attributes must be tracked over time. 

You need to produce a checksum value to identify the rows that have changed since the last Extract, Transform and Load (ETL) process execution. You need to use the least amount of development effort to achieve this goal. 

Which transformation should you use? (To answer, select the appropriate transformation in the answer area.) 

Answer: 


Q98. 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? 

A. Natural 

B. Explicit 

C. Parent 

D. Recursive 

Answer:

Reference: http://technet.microsoft.com/en-us/library/ff487006.aspx 

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

Reference: http://technet.microsoft.com/en-us/library/ee633759.aspx 


Q99. A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog. 

To troubleshoot some data issues, you must output the data streaming through several data flows into text files for further analysis. You have the list of data flow package paths and identification strings of the various task components that must be analyzed. 

You need to create these output files with the least amount of administrative and development effort. 

Which three stored procedures should you execute 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: 


Q100. You are the Master Data Services (MDS) administrator at your company. 

An existing user needs to integrate data from other systems into MDS. 

You need to give the user permissions to integrate data. 

Which user management menu item should you select? (To answer, configure the 

appropriate option or options in the dialog box in the answer area.) 

Answer: