Microsoft 70-463 Online Practice Questions and Exam Preparation

Microsoft 70-463 Online Questions & Answers

• Question 231:

  You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database.

  The package is deployed to SQL Server.

  The package is not producing the desired results.

  You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.

  What should you do?

  A. Execute the catalog.add_data_tap stored procedure with the package execution_id.
  B. Execute the catalog.create_execution_dump stored procedure with the package execution_id.
  C. Run the DTEXEC utility with the /DumpOnError option.
  D. Run the DTEXEC utility with the /Reporting V option.
  C. Run the DTEXEC utility with the /DumpOnError option.

• Question 232:

  You work as a database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.

  You have received reports regarding a current existing SQL Server Integration Services (SSIS) package not completing its execution, and not transferring data. You have decided to make use of the Project Deployment Model.

  Which of the following is TRUE with regards to using the Project Deployment Model?

  A. CLR integration is required on the database engine.
  B. CLR integration is not required on the database engine.
  C. Events that are created by the package are captured automatically and saved to the catalog during execution.
  D. Packages are executed using the dtExec and DTExecUI execution utilities.
  A. CLR integration is required on the database engine.
  C. Events that are created by the package are captured automatically and saved to the catalog during execution.

• Question 233:

  You need to design a data load strategy for a data warehouse fact table. The solution must use an ordered data load.

  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.

  Select and Place:

  

  

• Question 234:

  You are a data warehouse developer responsible for developing data cleansing processes.

  Duplicate employees exist in an employee dimension.

  You need to map, discover, and manage domain values based on the employee dimension.

  Which Data Quality Services (DQS) option should you use? (To answer, select the appropriate option in the answer area.)

  Hot Area:

  

  

• Question 235:

  You are editing a SQL Server Integration Services (SSIS) package that uses checkpoints.

  The package performs the following steps:

  1. Download a sales transaction file by using FTP.

  2. Truncate a staging table.

  3. Load the contents of the file to the staging table.

  4. Merge the data with another data source for loading to a data warehouse.

  

  The checkpoints are currently working such that if any of the four steps fail, the package will restart from the failed step the next time it executes.

  You need to modify the package to ensure that if either the Truncate Staging Table or the Load Sales to Staging task fails, the package will always restart from the Truncate Staging Table task the next time the package runs.

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

  Select and Place:

  

  

• Question 236:

  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. Audit
  B. Merge Join
  C. Merge
  D. CDC Splitter
  D. CDC Splitter

  ---

  The CDC splitter splits a singleflow of change rows from a CDC source data flow into different data flows for Insert, Update and Delete operations

  References: https://docs.microsoft.com/en-us/sql/integration-services/data-flow/cdc-splitter

• Question 237:

  You have a SQL Server Integration Services (SSIS) package that runs on a server named SQL1 and connects to a SQL Server database on a server named SQL2.

  You schedule the package to run via a SQL Server Agent job.

  The package fails and generates the following error message: “Unknown server or Access is Denied”.

  You discover that the package is configured to authenticate by using Windows authentication and that the SQL Server Agent on SQL1 uses NT Service\SQLSERVERAGENT as a service account.

  You verify that other jobs run on the server without errors.

  You create a user account named CONTOSO\JobProcess1 and provide all of the required access to the tables on SQL2.

  You need to ensure that the package runs successfully via the SQL Server Agent job.

  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.

  Select and Place:

  

  

• Question 238:

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

  The package sources data from an HTML web page that lists product stock levels.

  You need to implement a data flow task that reads the product stock levels from the HTML web page. Which data flow sources should you use? (Select Two.)

  A. Raw File source
  B. XML source
  C. Custom source component
  D. Flat File source
  E. script component
  C. Custom source component
  E. script component

• Question 239:

  Which of the following statements about simple and complex data movements are true? (Choose all that apply.)

  A. Simple data movements only have a single data source and a single data destination.
  B. Complex data movements require data to be transformed before it can be stored at the destination.
  C. In simple data movements, data transformations are limited to data type conversion.
  D. In complex data movements, additional programmatic logic is required to merge source data with destination data.
  B. Complex data movements require data to be transformed before it can be stored at the destination.
  D. In complex data movements, additional programmatic logic is required to merge source data with destination data.

  ---

  References: http://colleenmorrow.com/2014/12/09/exam-prep-70-463-introduction-to-ssdt/

• Question 240:

  You are deploying a new SQL Server Integration Services (SSIS) project to the test environment.

  A package in the project uses a custom task component.

  You need to ensure that the custom object is deployed on the test environment correctly.

  What should you do?

  A. Run the package by using the dtexec /rep /conn command.
  B. Create a reusable custom logging component.
  C. Create an OnError event handler.
  D. Use the gacutil command.
  E. Use the dtutil /copy command.
  F. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
  G. Run the package by using the dtexec /dumperror /conn command.
  H. Use the Project Deployment Wizard.
  I. Deploy the package by using an msi file.
  J. Add a data tap on the output of a component in the package data flow.
  D. Use the gacutil command.

  ---

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