Want to Pass 70-463 Exam In Next HOURS? Get it now →
October 11, 2017

Today Big Q: 70 463 pdf?

Our pass rate is high to 98.9% and the similarity percentage between our 70 463 training kit pdf study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Microsoft 70 463 dumps exam in just one try? I am currently studying for the Microsoft exam 70 463 exam. Latest Microsoft microsoft 70 463 Test exam practice questions and answers, Try Microsoft exam 70 463 Brain Dumps First.

Q81. You administer a SQL Server Integration Services (SSIS) solution in the SSIS catalog. A SQL Server Agent job is used to execute a package daily with the basic logging level. 

Recently, the package execution failed because of a primary key violation when the package inserted data into the destination table. 

You need to identify all previous times that the package execution failed because of a primary key violation. 

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:


Q82. You are developing a SQL Server Integration Services (SSIS) package that imports data from a relational database to a data warehouse. 

You are importing data from a relational table named Projects. The table has change data capture enabled on all columns. 

You need to process only the most recent values from rows that have been inserted or updated since the previous execution of the package. 

Which query should you use as the data source? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:

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

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

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


Q83. You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools. 

A package Connection Manager has been parameterized with project scope. 

You need to display the parameters that have been generated for the Connection Manager. 

What should you use? To answer, select the appropriate setting or settings in the answer area. 

Answer: 


Q84. You are a database developer of a Microsoft SQL Server 2012 database. You are designing a table that will store Customer data from different sources. The table will include a column that contains the CustomerID from the source system and a column that contains the SourceID. A sample of this data is as shown in the following table. You need to ensure that the table has no duplicate CustomerID within a SourceID. You also need to ensure that the data in the table is in the order of SourceID and then CustomerID. 

Which Transact- SQL statement should you use? 

A. CREATE TABLE Customer 

(SourceID int NOT NULL IDENTITY, 

CustomerID int NOT NULL IDENTITY, 

CustomerName varchar(255) NOT NULL); 

B. CREATE TABLE Customer 

(SourceID int NOT NULL, 

CustomerID int NOT NULL PRIMARY KEY CLUSTERED, 

CustomerName varchar(255) NOT NULL); 

C. CREATE TABLE Customer 

(SourceID int NOT NULL PRIMARY KEY CLUSTERED, 

CustomerID int NOT NULL UNIQUE, 

CustomerName varchar(255) NOT NULL); 

D. CREATE TABLE Customer 

(SourceID int NOT NULL, 

CustomerID int NOT NULL, 

CustomerName varchar(255) NOT NULL, 

CONSTRAINT PK_Customer PRIMARY KEY CLUSTERED 

(SourceID, CustomerID)); 

Answer:


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

The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse. 

You need to create a separate data flow path for data that has been modified since it was last processed. 

Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.) 

A. Multicast 

B. Data Conversion 

C. Lookup 

D. Slowly Changing Dimension 

E. Aggregate 

Answer: A,C 

Explanation: A: The transformation that distributes data sets to multiple outputs. 

The transformation that distributes data sets to multiple outputs. 

C: Lookup Transformation 

The transformation that looks up values in a reference table using an exact match. 

Note: 

* SQL Server Integration Services provides three different types of data flow components: 

sources, transformations, and destinations. Sources extract data from data stores such as 

tables and views in relational databases, files, and Analysis Services databases. 

Transformations modify, summarize, and clean data. Destinations load data into data 

stores or create in-memory datasets. 

Incorrect: Not B: Data Conversion Transformation The transformation that converts the data type of a column to a different data type. Not D: Slowly Changing Dimension Transformation The transformation that configures the updating of a slowly changing dimension. Not E: The Aggregate transformation applies aggregate functions, such as Average, to column values and copies the results to the transformation output. Besides aggregate functions, the transformation provides the GROUP BY clause, which you can use to specify groups to aggregate across. 


Q86. You are deploying a new SQL Server Integration Services (SSIS) package to several 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 the package. 

. The deployment procedure must be automated as much as possible. 

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

What should you do? 

A. Use the gacutil command. 

B. Use the dtutil /copy command. 

C. Use the Project Deployment Wizard. 

D. Create an OnError event handler. 

E. Create a reusable custom logging component. 

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

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

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

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

J. Deploy the package by using an msi file. 

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

Answer:


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

task in the package checks product stock levels and sets a package variable named InStock to TRUE or FALSE depending on the stock level found. 

After the successful execution of the Execute SQL task, one of two data flow tasks must run, depending on the value of the InStock variable. 

You need to set the precedence constraints. 

Which value for the evaluation operation should you use? (To answer, select the appropriate option for the evaluation operation in the answer area.) 

Answer: 


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

The package control flow will contain many tasks. The tasks will execute consecutively and none will execute more than once. Certain groups of tasks will share variable and transaction scope. 

You need to group tasks together while enabling them to be collapsed and expanded as a group. 

Which item should you use from the SSIS Toolbox? (To answer, select the appropriate item in the answer area.) 

Answer: 


Q89. You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2012. 

The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database database will be provided by a project parameter. 

You need to create a solution to meet the requirements by using the least amount of administrative effort and maximizing data flow performance. 

What should you do? 

A. Use an SSIS Script task that uses the custom assembly to parse the text data when inserting it. 

B. Use an SSIS Script transformation that uses the custom assembly to parse the text data when inserting it. 

C. Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data. 

D. Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data. 

Answer:


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

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

B. Create a custom .NET application based on the Knowledgebase class. 

C. Create a data quality project. 

D. Create a CLR stored procedure based on the Knowledgebase class. 

E. Create a Master Data Services (MDS) business rule. 

Answer:

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

http://msdn.microsoft.com/en-us/library/ff877917.aspx http://msdn.microsoft.com/en-us/library/microsoft.masterdataservices.services.datacontracts.knowledgebase.aspx 

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



see more http://www.ubraindumps.com/70-463-dumps/