Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Aug Microsoft Official New Released 70-463
100% Free Download! 100% Pass Guaranteed!

Implementing a Data Warehouse with Microsoft SQL Server 2012

Question No: 21 – (Topic 1)

You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in staging tables in preparation for a data warehouse load.

The package and all three Execute SQL product tasks have their TransactionOption property set to Supported.

You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will roll back their changes.

What should you do?

  1. Change the TransactionOption property of the package to Required.

  2. Change the TransactionOption property of all three Execute SQL product tasks to Required.

  3. Move the three Execute SQL product tasks into a Foreach Loop container.

  4. Move the three Execute SQL product tasks into a Sequence container.

Answer: A Explanation:

References:

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

Question No: 22 – (Topic 1)

You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database.

The company#39;s auditing policies have the following requirements:

鈥n entry must be written to a dedicated SQL Server log table named OrderLog.

鈥he entry must be written as soon as the file upload task completes. You need to meet the company#39;s policy requirements.

Which event handler should you use?

  1. OnPostExecute

  2. OnWarning

  3. OnExecStatusChanged

  4. OnVariableValueChanged

Answer: A

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

Question No: 23 – (Topic 1)

Occasionally a job that executes an existing SQL Server Integration Services (SSIS)

package does not complete and nothing is processed.

You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.

What should you do?

  1. Create a reusable custom logging component.

  2. Use the gacutil command.

  3. Use the Project Deployment Wizard.

  4. Run the package by using the dtexec /rep /conn command.

  5. Add a data tap on the output of a component in the package data flow.

  6. Create an OnError event handler.

  7. Use the dtutil /copy command.

  8. Deploy the package by using an msi file.

  9. Run the package by using the dtexec /dumperror /conn command.

  10. Run the package by using the dtexecui.exe utility and the SQL Log provider.

  11. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

Answer: J Explanation: References:

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

Question No: 24 – (Topic 1)

You are deploying a project to the SQL Server Integration Services (SSIS) catalog.

You need to ensure that the project is deployed to the production environment with the least amount of administrative effort.

What should you do?

  1. Create an On Error event handler.

  2. Add a data tap on the output of a component in the package data flow.

  3. Use the gacutil command.

  4. Create a reusable custom logging component.

  5. Run the package by using the dtexecui.exe utility and the SQL Log provider.

  6. Run the package by using the dtexec /rep /conn command.

  7. Use the Integration Services Deployment Wizard.

  8. Run the package by using the dtexec /dumperror /conn command.

  9. Use the dtutil /copy command.

  10. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

  11. Deploy the package by using an msi file.

Answer: G

Reference:

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 No: 25 – (Topic 1)

You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains records for each user permitted to run reports against the warehouse; and the dimDistrict table contains information about sales districts.

The system is accessed by users from certain districts, as well as by area supervisors and users from the corporate headquarters.

You need to design a table structure to ensure that certain users can see sales data for only certain districts. Some users must be permitted to see sales data from multiple districts.

What should you do?

  1. Add a district column to the dimUser table.

  2. Partition the factSales table on the district column.

  3. Create a userDistrict table that contains primary key columns from the dimUser and dimDistrict tables.

  4. For each district, create a view of the factSales table that includes a WHERE clause for the district.

Answer: C

Question No: 26 – (Topic 1)

You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure.

Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart.

You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented.

What should you do?

  1. Create a junk dimension for the geography dimension.

  2. Implement change data capture.

  3. Create a conformed dimension for the geography dimension.

  4. Create three geography dimensions.

Answer: C

Question No: 27 – (Topic 1)

You are the data steward for a Business Intelligence project.

You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project.

You need to produce the CSV file with the least amount of development effort. What should you do?

  1. Create an Integration Services package and use a Data Profiling transform.

  2. Create a custom .NET application based on the Knowledgebase class.

  3. Create a data quality project.

  4. Create a CLR stored procedure based on the Knowledgebase class.

  5. Create a Master Data Services (MDS) business rule.

Answer: C

Reference:

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

Question No: 28 – (Topic 1)

You are installing the Data Quality Client on user desktops.

You need to ensure that the prerequisite software components are installed.

Which components must be present to meet this goal? (Each correct answer presents part of the solution. Choose all that apply.)

  1. SQL Server Management Studio

  2. Internet Explorer 6.0 SP1 or later

  3. Microsoft Silverlight 5

  4. .NET Framework 3.5 SP1

  5. .NET Framework 4.0

  6. Microsoft Silverlight 4

  7. SQL Server Data Tools

Answer: B,E

Explanation: Before installing DQS, make sure that your computer meets the minimum system requirements.

Data Quality Client requirement:

NET Framework 4.0 (installed during the Data Quality Client installation, if not already installed)

Internet Explorer 6.0 SP1 or later

Question No: 29 – (Topic 1)

You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The package and all three Execute SQL tasks have their TransactionOption property set to Supported.

You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their changes.

What should you do?

  1. Move the three Execute SQL tasks into a Sequence container.

  2. Move the three Execute SQL tasks into a Foreach Loop container.

  3. Change the TransactionOption property of all three Execute SQL tasks to Required.

  4. Change the TransactionOption property of the package to Required.

Answer: D

Reference:

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

http://msdn.microsoft.com/en- us/library/microsoft.sqlserver.dts.runtime.dtstransactionoption.aspx

Question No: 30 – (Topic 1)

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?

  1. Run the DQSInstaller.exe command.

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

  3. Install ADOMD.NET.

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

100% Dumps4cert Free Download!
70-463 PDF
100% Dumps4cert Pass Guaranteed!
70-463 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.