← Back to exam page

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

Loading demo links...

Showing 13–15 of 15 questions

Question 13 (Volume C)

You are deploying a new SQL Server Integration Services (SSIS) package to five servers.

The package must meet the following requirements:

.NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.

The Connection Managers used in the package must be configurable without editing and redeploying the package. The deployment procedure must be automated as much as possible. Performance must be maximized.

You need to set up a deployment strategy that meets the requirements.

What should you do?

Select an option, then click Submit answer.

  • ○

    Add an OnError event handler to the SSIS project.
  • ○

    Use an msi file to deploy the package on the server.
  • ○

    Open a command prompt and run the gacutil command.
  • ○

    Open a command prompt and run the dtutil /copy command.
  • ○

    Open a command prompt and run the dtexec /rep /conn command.
  • ○

    Open a command prompt and run the dtexec /dumperror /conn command.
  • ○

    Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
  • ○

    Create a reusable custom logging component and use it in the SSIS project.
  • ○

    Configure the SSIS solution to use the Project Deployment Model.
  • ○

    Configure the output of a component in the package data flow to use a data tap.
  • ○

    Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
Question 14 (Volume A)

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?

Select an option, then click Submit answer.

  • ○

    Run the DQSInstaller.exe command.
  • ○

    Install the data providers that are used for data refresh.
  • ○

    Install ADOMD.NET.
  • ○

    Run the dbimpexp.exe command.
Question 15 (Volume C)

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

You need to design a package to change a variable value during package execution by using the least amount of development effort.

What should you use?

Select an option, then click Submit answer.

  • ○

    Term Lookup transformation
  • ○

    Expression task
  • ○

    Data Profiling task
  • ○

    Fuzzy Lookup transformation
  • ○

    Data Cleansing transformation