Microsoft 70-463 Online Practice Questions and Exam Preparation

Microsoft 70-463 Online Questions & Answers

• Question 271:

  You have a data warehouse that contains all of the sales data for your company.

  You plan to create a SQL Server Integration Services (SSIS) package to extract a list of files from a database and to load the files to the data warehouse.

  You need to design a control flow for the SSIS package. The control flow must meet the following requirements:

  Load the data in a single transaction.

  Load multiple tables in parallel after extracting the data.

  Which types of containers should you add to the design? To answer, drag the appropriate container types to the correct locations. Each container type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

  Select and Place:

  

  

• Question 272:

  You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. A package in the project extracts data from a Microsoft 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.create_execution_dump stored procedure with the package execution_id.
  B. Execute the catalog.add_data_tap stored procedure with the package execution_id.
  C. Run the DTEXEC utility with the /Reporting V option.
  D. Run the DTEXEC utility with the /Logger option.
  D. Run the DTEXEC utility with the /Logger option.

  ---

  References: https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility

• Question 273:

  You develop a SQL Server Integration Services (SSIS) project by using the Project Deployment model.

  The project contains many packages. It is deployed on a server named Development!. The project will be deployed to several servers that run SQL Server 2012.

  The project accepts one required parameter. The data type of the parameter is a string.

  A SQL Agent job is created that will call the master.dtsx package in the project. A job step is created for the SSIS package.

  The job must pass the value of an SSIS Environment Variable to the project parameter.

  The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter.

  You need to configure SSIS on the Development1 server to pass the Environment Variable to the package.

  Which four actions should you perform in sequence by using SQL Server Management Studio? (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 274:

  A SQL Server Integration Services (SSIS) package named DataFeed interacts with an external vendor data feed. The package is executed several times a day, either as part of other packages' control flow or by itself. The external data feed is unreliable because network failures and slow response times are frequent. The package is currently deployed on the file system.

  To analyze the reliability of the external data feed, you must collect execution data.

  Every time the DataFeed package is executed, the following information must be logged:

  Start Time

  End Time

  Execution Result

  Execution Duration

  You need to design a logging solution that meets the requirements by using the least amount of administrative and development effort.

  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 275:

  You are installing SQL Server Data Quality Services (DQS).

  You need to give specific users access to the Data Quality Server.

  Which SQL Server application should you use?

  A. SQL Server Configuration Manager
  B. SQL Server Data Tools
  C. SQL Server Management Studio
  D. Data Quality Client
  C. SQL Server Management Studio

  ---

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

• Question 276:

  You deploy a server that has SQL Server installed.

  You deploy a SQL Server Integration Services (SSIS) package to the server.

  You need to automate the execution of the package. The solution must ensure that you receive a notification if the package fails to execute.

  In which order should you perform all the actions? To answer, move all of the actions to the answer area and arrange them in the correct order.

  NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

  Select and Place:

  

  

• Question 277:

  You work as a senior database developer 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 are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the use of Domain-based attributes in Master Data Services.

  Which of the following is TRUE with regards to using Domain-based attributes? (Choose all that apply.)

  A. It is an attribute with values that are populated by members from another entity.
  B. It is an attribute with values that are populated by members from the same entity.
  C. It allows users to enter invalid attribute values.
  D. It prevents users from entering invalid attribute values.
  A. It is an attribute with values that are populated by members from another entity.
  D. It prevents users from entering invalid attribute values.

• Question 278:

  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.

  Subsequent to deploying a new SQL Server Integration Services (SSIS) project to the SSIS catalog, you want to output the data streaming via a number of data flows into text files for added examination. You have acquired a list of data flow

  package paths and identification strings of the various task components that requires examination. You want make sure that the output files are created in the easiest way possible. To achieve this, you need to make use of three stored

  procedures in a specific sequence.

  Which of the following is the second stored procedure in the sequence?

  A. catalog.startup_package
  B. catalog.start_package
  C. catalog.validate_package
  D. catalog.create_execution
  D. catalog.create_execution

• Question 279:

  You work as a database developer 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 are in the process of creating a SQL Server Integration Services (SSIS) package. You are including a custom task element to deal with complicated scientific information derived from a SQL Azure database.

  You want to test the custom task element prior to deploying it into the production environment. You have to make sure that the custom task element is properly deployed into the testing environment.

  Which of the following actions should you take?

  A. You should consider making use of dtexecui.exe from the command prompt.
  B. You should consider making use of gacutil.exe from the command prompt.
  C. You should consider making use of dtutil.exe from the command prompt.
  D. You should consider making use of SSISUpgrade.exe file from the command prompt.
  B. You should consider making use of gacutil.exe from the command prompt.

• Question 280:

  You work as a senior database developer 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 are hosting a training exercise for ABC.com's junior database developers. You are currently discussing the Fuzzy Lookup transformation. You want to show them how to set parameters for the fuzzy lookup.

  Which tab of the Fuzzy Lookup Transformation Editor should you access?

  A. The General tab.
  B. The Advance tab.
  C. The Columns tab.
  D. The Reference Table tab.
  B. The Advance tab.