← Back to exam page

70-463 – Implementing a Data Warehouse with Microsoft SQL Server 2012

Loading demo links...

Showing 10–12 of 15 questions

Question 10 (Volume A)

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?

Select an option, then click Submit answer.

  • ○

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

    Create a custom .NET application based on the Knowledgebase class.
  • ○

    Create a data quality project.
  • ○

    Create a CLR stored procedure based on the Knowledgebase class.
  • ○

    Create a Master Data Services (MDS) business rule.
Question 11 (Volume B)

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?

Select an option, then click Submit answer.

  • ○

    Use the Expression task.
  • ○

    Use the Script task.
  • ○

    Develop a custom task.
  • ○

    Use the Script component.
  • ○

    Develop a custom component.
Question 12 (Volume A)

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?

Select an option, then click Submit answer.

  • ○

    Create a Subscription View in MDS.
  • ○

    Access the product entity tables in the MDS database directly.
  • ○

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

    Use change data capture on the product entity tables.