070-463日本語 by Microsoft Valid Free Exam Practice Test

Question 1

Correct Answer:

Explanation

Question 2

Correct Answer:

Explanation

Question 3

A. Add an ADO.NET project connection manager. B. Add a SQLMOBILE project connection manager. C. Add a SQLMOBILE connection manager to each package. D. Add an ADO.NET connection manager to each data flow task. E. Add a SQLMOBILE connection manager to each data flow task. F. Add an ADO.NET connection manager to each package.

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

A. Option B B. Option A C. Option D D. Option C

Correct Answer: C

Question 5

A. Option B B. Option A C. Option D D. Option C

Correct Answer: B

Question 6

Correct Answer:

Explanation

References:
http://msdn.microsoft.com/en-us/library/ms162802.aspx
http://msdn.microsoft.com/en-us/library/ms188365.aspx
http://msdn.microsoft.com/en-us/library/ms175937.aspx
http://msdn.microsoft.com/en-us/library/aa337544.aspx

Question 7

Correct Answer:

Explanation

Question 8

A. OnPostExecute B. Onlnformation C. OnProgress D. OnComplete

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 9

A. Option B B. Option A C. Option D D. Option C

Correct Answer: A

Question 10

A. Script component configured as a transformation B. Script component configured as a source C. Script component configured as a destination D. Script task

Correct Answer: B

Question 11

A. dtexec /d "C:\File System\myPackage.dtsx" B. dtexec /com "myPackage.dtsx" C. dtexec /f "C:\myPackage.dtsx" D. dtexec /sql myPackage

Correct Answer: C

Question 12

Question 13

A. Pivot B. DQS Cleansing C. CDC Splitter D. Audit

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 14

Correct Answer:

Explanation

Records that have no match in the destination are new records and so should be inserted.
Any errors should be recorded in the flat file.
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/bb895366.aspx
https://www.simple-talk.com/sql/ssis/implementing-lookup-logic-in-sql-server-integration-services/

Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 (070-463日本語版) - 070-463日本語 Exam Practice Test