rapid review 70-463 (65 to 80)

Guaranteed of 70-463 exam topics materials and lab for Microsoft certification for examinee, Real Success Guaranteed with Updated 70-463 pdf dumps vce Materials. 100% PASS Implementing a Data Warehouse with Microsoft SQL Server 2012 exam Today!

2021 Apr 70-463 Study Guide Questions:

Q65. 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? 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

P. Create a SQL Server Agent job to execute the 

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

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

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


Q66. You are building a SQL Server Integration Services (SSIS) package to load product data sourced from a SQL Azure database to a data warehouse. Before the product data is loaded, you create a batch record by using an Execute SQL task named Create Batch. After successfully loading the product data, you use another Execute SQL task named Set Batch Success to mark the batch as successful. 


You need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or Load Products task fails. 

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


Answer: 



Q67. You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables. 

You have the following requirements: 

The deployment model must support changing the content of connection strings by 

using parameters at execution time. 

The deployment model must automatically log events to the SSISOB database. 

Maximize performance at execution time. 

You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Use a project deployment model. Modify connection manager properties to use project parameters. 

B. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments. 

C. Use a package deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package. 

D. Use a project deployment model. Modify connection manager properties to use package parameters. 

Answer: A 


Q68. You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. The package consists of several data flow tasks. 

The package experiences intermittent errors in the data flow tasks. 

If any data flow task fails, all package error information must be captured and written to a SQL Server table by using an OLE DB connection manager. 

You need to ensure that the package error information is captured and written to the table. 

What should you do? 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

P. Create a SQL Server Agent job to execute the 

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

Q. Create a table to store error information. Create an error output on each data flow 

destination that writes OnError event text to the table. 

R. 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: I 


Q69. 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: 



70-463 rapidshare

Regenerate actual test 70-463:

Q70. Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed. 

You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. 

What should you do? 

A. Create a reusable custom logging component. 

B. Use the gacutil command. 

C. Use the Project Deployment Wizard. 

D. Run the package by using the dtexec /rep /conn command. 

E. Add a data tap on the output of a component in the package data flow. 

F. Create an OnError event handler. 

G. Use the dtutil /copy command. 

H. Deploy the package by using an msi file. 

I. Run the package by using the dtexec /dumperror /conn command. 

J. Run the package by using the dtexecui.exe utility and the SQL Log provider. 

K. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration. 

Answer: J 

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

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


Q71. You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.) 



Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in the Employee table. You need to assign the appropriate constraints and table properties to ensure data integrity and visibility. On which column in the Employee table should you use an identity specification to include a seed of 1,000 and an increment of 1? 

A. DateHired 

B. DepartmentID 

C. EmployeeID 

D. EmployeeNum 

E. FirstName 

F. JobTitle 

G. LastName 

H. MiddleName 

I. ReportsToID 

Answer: C 


Q72. You are designing a SQL Server Integration Services (SSIS) package to execute 12 Transact-SQL (T-SQL) statements on a SQL Azure database. The T-SQL statements may be executed in any order. The T-SQL statements have unpredictable execution times. 

You have the following requirements: 

. The package must maximize parallel processing of the T-SQL statements. 

. After all the T-SQL statements have completed, a Send Mail task must notify administrators. 

You need to design the SSIS package. 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.) 


Answer: 



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

You need to give users belonging to a specific Active Directory group access to the Data Quality Server. 

Which SQL Server application should you use? 

A. Data Quality Client with administrative credentials 

B. SQL Server Configuration Manager with local administrative credentials 

C. SQL Server Data Tools with local administrative permissions 

D. SQL Server Management Studio with administrative credentials 

Answer: D 


Q74. You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database. 

The package contains a data flow task that has seven source-to-destination execution trees. 

Only three of the source-to-destination execution trees are running in parallel. 

You need to ensure that all the execution trees run in parallel. 

What should you do? 

A. Set the EngineThreads property of the data flow task to 7. 

B. Set the MaxConcurrentExcecutables property of the package to 7. 

C. Create seven data flow tasks that contain one source-to-destination execution tree each. 

D. Place the data flow task in a For Loop container that is configured to execute seven times. 

Answer: A 


70-463 exam engine

High value microsoft sql server 70-463:

Q75. Your company is evaluating the data cleansing capabilities of SQL Server Data Quality Services (DQS). 

A stand-alone server will be used to host DQS, as well as all related services necessary to run this service. 

You need to install the DQS components on the server by using the minimum amount of steps possible. You also need to grant permissions to a login named DataStewards to enable DataStewards to edit and execute DQS projects. 

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


Answer: 



Q76. 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? 

A. Create a Subscription View in MDS. 

B. Access the product entity tables in the MDS database directly. 

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

D. Use change data capture on the product entity tables. 

Answer: A 


Q77. You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data to a Windows Azure SQL Database database. 

An automated process must validate all related Environment references, parameter data types, package references, and referenced assemblies. The automated process must run on a regular schedule. 

You need to establish the automated validation process by using the least amount of administrative effort. 

What should you do? 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

P. Create a SQL Server Agent job to execute the SSISDB.catalog.create_execution and SSISDB.catalog.start_execution stored procedures. 

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

R. 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: N 


Q78. 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? 

A. Install the Analysis Services OLE DB Provider. 

B. Make the data available for DQS operations. 

C. Run the Data Quality Server Installer. 

D. Install ADOMD.NET. 

Answer: C 

Explanation: 

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

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


Q79. You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model- The model consists of two entities: one named Customer and one named State. You opened the Customer entity. 

Currently, data stewards can enter any text value in the Customer entity's State attribute. You must restrict the entry of values in the State attribute to members defined in the State entity. 

You need to configure the State attribute of the Customer entity. 

Which command should you use? (To answer, select the appropriate command in the answer area.) 


Answer: 



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

OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by 

using SQL Server Management Studio. 

You need to execute the package and minimize the number of event types that are logged. 

Which setting should you use? (To answer, change the appropriate setting in the answer 

area.) 


Answer: 




see more http://www.2passeasy.com/exam/70-463/