Share real and effective Microsoft MCSE 70-463 exam dumps for free. 13 Online 70-463 Exam Practice test questions and answers, online 70-463 pdf download, easy to learn! Get the full 70-463 Dumps: https://www.leads4pass.com/70-463.html (Total Questions: 270 Q&A) to make it easy to pass the exam!
[PDF] Free Microsoft MCSE 70-463 pdf dumps download from Google Drive: https://drive.google.com/open?id=1yaPn06Rg_Rqgxs00lH8kt4PccTl5qUpW
[PDF] Free Full Microsoft pdf dumps download from Google Drive: https://drive.google.com/open?id=1AwBFPqkvdpJBfxdZ3nGjtkHQZYdBsRVz
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014: https://www.microsoft.com/en-us/learning/exam-70-463.aspx
Skills measured
- Design and implement a data warehouse (10–15%)
- Extract and transform data (20–25%)
- Load data (25–30%)
- Configure and deploy SSIS solutions (20–25%)
- Build data quality solutions (15–20%)
Latest effective Microsoft MCSE 70-463 Exam Practice Tests
QUESTION 1
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?
A. Add an OnError event handler to the SSIS project.
B. Use an msi file to deploy the package on the server.
C. Open a command prompt and run the gacutil command.
D. Open a command prompt and run the dtutil /copy command.
E. Open a command prompt and run the dtexec /rep /conn command.
F. Open a command prompt and run the dtexec /dumperror /conn command.
G. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe
utility.
H. Create a reusable custom logging component and use it in the SSIS project.
I. Configure the SSIS solution to use the Project Deployment Model.
J. Configure the output of a component in the package data flow to use a data tap.
K. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
Correct Answer: D
QUESTION 2
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?
A. Express on task
B. Data Cleansing transformation
C. Fuzzy Lookup transformation
D. Term Lookup transformation
E. Data Profiling task
Correct Answer: A
QUESTION 3
You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse
every night.
The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used
the Fuzzy Lookup transformation to choose the closest-
matching string from a reference table of allowed values. The number of rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.
The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading
performance.
What should you do?
A. Change the Exhaustive property to True.
B. Change the similarity threshold to 0.55.
C. Change the similarity threshold to 0.40.
D. Increase the maximum number of matches per lookup.
Correct Answer: B
http://msdn.microsoft.com/en-us/library/ms137786.aspx
QUESTION 4
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project will be deployed to an SSIS catalog folder where Environments have already been created. You need to
deploy the project.
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.s
