Microsoft 70-463 ExamImplementing a Data Warehouse with Microsoft SQL Server 2012 / 2014

Total Question: 237 Last Updated: January 15,2018
  • Updated 70-463 Dumps
  • Based on Real 70-463 Exams Scenarios
  • Free 70-463 pdf Demo Available
  • Check out our 70-463 Dumps in a new PDF format
  • Instant 70-463 download
  • Guarantee 70-463 success in first attempt
Package Select:

Questions & Answers PDF

Practice Test Software

Practice Test + PDF 30% Discount

Price: $65.95 $29.99

Buy Now Free Trial

70 463 dumps : Jan 2018 Edition

Examcollection microsoft 70 463 Questions are updated and all 70 463 exam answers are verified by experts. Once you have completely prepared with our 70 463 pdf exam prep kits you will be ready for the real 70 463 training kit pdf exam without a problem. We have Down to date Microsoft 70 463 dumps dumps study guide. PASSED 70 463 exam First attempt! Here What I Did.

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

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:

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

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


Q82. 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: 


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

You use a Data Profiling task to examine the data from a source system. You need to establish: 

. The minimum and maximum dates for the datetime columns in the source data 

. The minimum, maximum, and average values for numeric columns in the source data 

You need to use the appropriate profile type in the Data Profiling task. 

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

Answer: 


Q84. You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. 

The reference data to be used in the transformation does not change. 

You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance. 

What should you do? 

A. Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor. 

B. Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor. 

C. Select the DropExistingMatchlndex option in the Fuzzy Lookup Transformation Editor. 

D. Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure. 

E. Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure. 

Answer:

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


Q85. 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. DQS Cleansing 

B. Merge Join 

C. Pivot 

D. Conditional Split 

Answer:


Q86. 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 Windows Azure SQL Database. 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. Multicast 

B. Conditional Split 

C. Destination Assistant 

D. Script Task 

Answer:


Q87. 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 settings should you select? (To answer, select the appropriate setting or settings in the answer area. Each Change Type may be used once, more than once, or not at all.) 

Answer: 


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

The package contains several tasks that must repeat until an expression evaluates to 

FALSE. 

You need to add and configure a container to enable this design. 

Which three 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: 


Q89. You are developing a SQL Server Integration Services (SSIS) package that loads data into a data warehouse hosted on Windows Azure SQL Database. 

You must combine two data sources together by using the ProductID column to provide complete details for each record. The data retrieved from each data source is sorted in ascending order by the ProductID column. 

You need to develop a data flow that imports the data while meeting the requirements. 

How should you develop the data flow? (To answer, drag the appropriate transformation from the list of transformations to the correct location in the answer area.) 

Answer: 


Q90. You are designing a data warehouse for a software distribution business that stores sales by software title. It stores sales targets by software category. Software titles are classified into subcategories and categories. Each software title is included in only a single software subcategory, and each subcategory is included in only a single category. The data warehouse will be a data source for an Analysis Services cube. 

The data warehouse contains two fact tables: 

. factSales, used to record daily sales by software title 

. factTarget, used to record the monthly sales targets by software category 

Reports must be developed against the warehouse that reports sales by software title, category and subcategory, and sales targets. 

You need to design the software title dimension. The solution should use as few tables as possible while supporting all the requirements. 

What should you do? 

A. Create three software tables, dimSoftware, dimSoftwareCategory, and dimSoftwareSubcategory and a fourth bridge table that joins software titles to their appropriate category and subcategory table records with foreign key constraints. Direct the cube developer to use key granularity attributes. 

B. Create three software tables, dimSoftware, dimSoftwareCategory, and dimSoftwareSubcategory. Connect factSales to all three tables and connect factTarget to dimSoftwareCategory with foreign key constraints. Direct the cube developer to use key granularity attributes. 

C. Create one table, dimSoftware, which contains Software Detail, Category, and Subcategory columns. Connect factSales to dimSoftware with a foreign key constraint. Direct the cube developer to use a non-key granularity attribute for factTarget. 

D. Create two tables, dimSoftware and dimSoftwareCategory. Connect factSales to dimSoftware and factTarget to dimSoftwareCategory with foreign key constraints. Direct the cube developer to use key granularity attributes. 

Answer:


Related 70-463 Articles