Cause all that matters here is passing the Microsoft 70 463 training kit pdf exam. Cause all that you need is a high score of 70 463 exam Implementing a Data Warehouse with Microsoft SQL Server 2012 exam. The only one thing you need to do is downloading Testking 70 463 pdf exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Microsoft 70-463 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 70-463 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/70-463-exam-dumps.html
Q61. You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation.
The reference data to be used in the transformation does not change.
You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance.
What should you do?
A. Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.
B. Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
C. Select the DropExistingMatchlndex option in the Fuzzy Lookup Transformation Editor.
D. Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
E. Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.
Answer: A
Reference: http://msdn.microsoft.com/en-us/library/ms137786.aspx
Q62. You are developing a SQL Server Integration Services (SSIS) package.
To process complex scientific data originating from a SQL Azure database, a custom task component is added to the project. You need to ensure that the custom component is deployed on a test environment
correctly. What should you do?
A. Add an OnError event handler to the SSIS project.
B. Open a command prompt and run the gacutil command.
C. Configure the SSIS solution to use the Project Deployment Model.
D. Open a command prompt and run the dtexec /dumperror /conn command.
E. Configure the output of a component in the package data flow to use a data tap.
F. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
G. Open a command prompt and run the dtexec /rep /conn command.
H. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
I. Use an msi file to deploy the package on the server.
J. Open a command prompt and run the dtutil /copy command.
K. Create a reusable custom logging component and use it in the SSIS project.
Answer: B
Reference:
http://msdn.microsoft.com/en-us/library/ms403356.aspx
Q63. You administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition:
You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.
You need to ensure that the following requirements are met:
The first row of the file contains the first row of data.
Each record is of the same length.
The date follows the U.S. date format.
The file supports international characters.
What should you do? (To answer, simply select the option or options in the answer area that you would configure.)
Answer:
Q64. A SQL Server Integration Services (SSIS) package was deployed two weeks ago with the Project Deployment Model.
Sometimes the package is started as part of a multistep SQL job. At other times, the package is started manually by a database administrator by using the Object Explorer in SQL Server Management Studio.
You need to identify the authenticated user responsible for starting the package each time it executes.
How can you find this information?
A. In the SSISDB.[catalog], query the .[executions] view.
B. In the SSISDB.[catalog] , query the [event_messages] view.
C. In SQL Server Management Studio, view the SQL Agent Job History.
D. In SQL Server Management Studio, view the SQL Agent Error Log.
E. In SQL Server Management Studio, view the SQL Server Log.
Answer: A
Q65. You are the data steward at your company.
Duplicate customers exist in a Microsoft Excel workbook. You create a Data Quality Services (DQS) knowledge base and matching policy to identify these duplicate customers.
You need to identify the duplicate customers.
Which option should you use? (To answer, select the appropriate option in the answer area.)
Answer:
Q66. 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.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: M
Q67. You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012.
Package developers in your company must have permission to perform the following tasks only on their own projects:
View projects and packages View Environments Validate packages Execute packages
You need to grant rights to the developers without assigning unnecessary privileges.
What should you do? (Each correct answer presents part of a solution. Choose all that apply.)
A. Add developer logins to the db_ssisltduser role in the msdb database.
B. Add developer logins to the db_ssisoperator role in the msdb database.
C. Grant Execute permission in the projects for the developer logins.
D. Grant Read permission in the SSIS catalog folder, the projects, and the Environments.
E. Add developer logins to the ssis_admin role in the SSISDB database.
F. Grant Modify permission in the projects for the developer logins.
Answer: B,D
Explanation: B: db_ssisoperator
* Read actions Enumerate all packages. View all packages. Execute all packages. Export all packages.
Execute all packages in SQL Server Agent.
* Write actions None
D: Need read permissions on the Environments in order to be able to view them.
Incorrect:
Not A: db_ssisltduser
* Read actions
Enumerate own packages.
Enumerate all packages.
View own packages.
Execute own packages.
Export own packages.
* Write Actions
Import packages.
Delete own packages.
Change own package roles.
Not E: db_ssisadmin
Too many permissions (such as delete all packages).
Q68. You are developing a SQL Server Integration Services (SSIS) package. The package contains a user-defined variable named .Queue which has an initial value of 10.
The package control flow contains many tasks that must repeat execution until the .Queue variable equals 0.
You need to enable the tasks to be grouped together for repeat execution.
Which item should you add to the package? (To answer, select the appropriate item in the answer area.)
Answer:
Q69. 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:
Q70. 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:
