Free 70-463 Braindumps


  • Exam Number: 70-463
  • Provider: Microsoft
  • Questions: 237
  • Updated On: 16-May-2018

QUESTION: 1
You work as a senior database administrator at Company. The Company network consists of a
single domain named Company. Company makes use of Microsoft SQL Server 2012 in their
environment.
You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are
currently discussing the Fuzzy Lookup transformation.
Which of the following is TRUE with regards to the Fuzzy Lookup similarity threshold setting?
(Choose all that apply.)

A. Increasing the threshold can improve the speed of matching.
B. Increasing the threshold can deteriorate the speed of matching.
C. The nearer the value is to 1, the nearer the resemblance of the lookup value to the source
value must be to qualify as a match.
D. The nearer the value is to 1, the further the resemblance of the lookup value to the source
value must be to qualify as a match.

Answer(s): A, C
QUESTION: 2
You work as a senior database administrator at Company. The Company network consists of a
single domain named Company.
You have recently installed Microsoft SQL Server 2012, with SQL Server Integration Services
(SSIS), in Company's environment. You are preparing to install the SSISDB catalog on the
SSIS server.
Which of the following is TRUE with regards to the SSISDB catalog? (Choose all that apply.)

A. You can make use of SQL Server Management Studio to create the SSISDB catalog.
B. You can make use of SQL Server Data Tools to create the SSISDB catalog.
C. You can make use of Solution Explorer to create the SSISDB catalog.
D. You can make use of Windows PowerShell to create the SSISDB catalog programmatical y.

Answer(s): A, D
QUESTION: 3
You work as a senior database administrator at Company. The Company network consists of a
single domain named Company. Company makes use of Microsoft SQL Server 2012 in their
environment.
Company has a SQL Server Integration Services (SSIS) package that is currently deployed on
the file system. The package is configured to interact work together with an outside vendor data
feed.
It has been reported that the outside vendor data feed is erratic as a result of network failures
and slow response times. You have been instructed to investigate the problem. Your solution
must include information about the Start Time, End Time, Execution Result, and Execution
Duration of the package.
You start by creating a new project and adding the package to it. You then deployed the
package to the msdb database.
Which of the following actions should you take NEXT?

A. You should consider querying the ExecutionlLog table.

Get The Premium Version

Allbraindumps.com
 Test Questions PDF from Myitguides.com

 Test Questions PDF from Myitguides.com