[Free] 2018(May) Dumps4cert Braindumps Microsoft 70-463 Dumps with VCE and PDF Download 121-130

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

Implementing a Data Warehouse with Microsoft SQL Server 2012

Question No: 121 DRAG DROP – (Topic 2)

You are loading a dataset into SQL Server. The dataset contains numerous duplicates for the Artist and Song columns.

The values in the Artist column in the dataset must exactly match the values in the Artist domain in the knowledge base. The values in the Song column in the dataset can be a close match with the values in the Song domain.

You need to use SQL Server Data Quality Services (DQS) to define a matching policy rule to identify duplicates.

How should you configure the Rule Editor? (To answer, drag the appropriate answers to the answer area.)

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 122 – (Topic 2)

You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to download data files.

You create project parameters to store the username and password that are used to access the FTP site.

You need to ensure that the username and password values are encrypted when they are deployed.

What should you do?

  1. Convert the parameters to package parameters.

  2. Set the Sensitive property of the parameters to True.

  3. Set the ProtectionLevel property of the package to EncryptSensitiveWithPassword.

  4. Convert the project to the Legacy Deployment model.

Answer: B

Question No: 123 HOTSPOT – (Topic 2)

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

An existing user must be denied access to a certain hierarchy node for an existing model. You need to configure the user#39;s permissions.

Which user management menu item should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 124 – (Topic 2)

You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages.

The new capability is not available as an SSIS task. Each package must be extended with the same new capability.

You need to add the new capability to all the packages without copying the code between packages.

What should you do?

  1. Use the Expression task.

  2. Use the Script task.

  3. Develop a custom task.

  4. Use the Script component,

  5. Develop a custom component.

Answer: C Explanation: References:

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

Question No: 125 DRAG DROP – (Topic 2)

You are building a fact table in a data warehouse.

The table must have a columnstore index. The table cannot be partitioned. You need to design the fact table and load it with data.

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

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 126 – (Topic 2)

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?

  1. Audit

  2. Source Assistant

  3. Script Task

  4. Conditional Split

Answer: D 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

Question No: 127 – (Topic 2)

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?

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

  2. Enable Snapshot Isolation on the data warehouse.

  3. Add an IsCurrent column to the student dimension.

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

Answer: D

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

Question No: 128 – (Topic 2)

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. All packages in the project must log custom messages.

You need to produce reports that combine the custom log messages with the system- generated log messages. What should you do?

  1. Use an event handler for OnError for the package.

  2. Use an event handler for OnError for each data flow task.

  3. Use an event handler for OnTaskFailed for the package.

  4. View the job history for the SQL Server Agent job.

  5. View the All Messages subsection of the All Executions report for the package.

  6. Store the System::SourceID variable in the custom log table.

  7. Store the System::ServerExecutionID variable in the custom log table.

  8. Store the System::ExecutionInstanceGUID variable in the custom log table.

  9. Enable the SSIS log provider for SQL Server for OnError in the package control flow.

  10. Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow,

  11. Deploy the project by using dtutil.exe with the /COPY DTS option.

  12. Deploy the project by using dtutil.exe with the /COPY SQL option.

  13. Deploy the .ispac file by using the Integration Services Deployment Wizard.

  14. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.

  15. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.

  16. Create a SQL Server Agent job to execute the

    SSISDB.catalog.create_execution and SSISDB.catalog.start_execution stored procedures.

  17. Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table.

  18. Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.

Answer: G

Question No: 129 HOTSPOT – (Topic 2)

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:

Dumps4Cert 2018 PDF and VCE

Question No: 130 – (Topic 2)

You are designing a fact table in a SQL Server database. The fact table must meet the following requirements:

鈥nclude a columnstore index.

鈥llow users to choose up to 10 dimension tables and up to five facts at one time.

鈥aximize performance of queries that aggregate measures by using any of the 10 dimensions.

鈥upport billions of rows.

鈥se the most efficient design strategy.

You need to design the fact table to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

  1. Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the dimensional key columns.

  2. Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the measure columns.

  3. Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on the dimensional key columns and the measure columns.

  4. Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on only the measure columns.

Answer: C

100% Dumps4cert Free Download!
Download Free Demo:70-463 Demo 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

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