70-463 무료 덤프문제 온라인 액세스

You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database.
The SSIS package has the following requirements:
* Every night, a very large amount of data is imported into the staging database.
* Package processing time must be minimized.
* The package must run on its own dedicated server when it is deployed to production.
* Transaction log activity when data is imported must be minimized.
You need to design the package to meet the requirements.
Which destination component should you use?

• A.ADO.NET
• B.DataReader
• C.SQL Server
• D.OLE DB

You have a data warehouse.
You need to create a SQL Server Integration Services (SSIS) package to meet the following requirements:
-The package must be deployed.
-The package must be parameterized.
-The package execution must be automated.
In which sequence should you perform the actions? To answer, move all of the actions from the list of actions to the answer area and arrange them in the correct order.

정답:

Explanation

You are installing SQL Server Data Quality Services (DQS).
You need to give specific users access to the Data Quality Server.
Which SQL Server application should you use?

• A.SQL Server Management Studio
• B.Data Quality Client
• C.SQL Server Configuration Manager
• D.SQL Server Data Tools

You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data.
You need to use DQS profiling to obtain the required statistics.
Which DQS activity should you use?

• A.Knowledge Discovery
• B.Cleansing
• C.Matching Policy
• D.Matching

You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been transferred.
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?

• A.Configure the SSIS solution to use the Project Deployment Model.
• B.Create a reusable custom logging component and use it in the SSIS project.
• C.Open a command prompt and run the dtexec /dumperror /conn command.
• D.Open a command prompt and run the dtexec /rep /conn command.
• E.Open a command prompt and run the dtutil /copy command.
• F.Configure the output of a component in the package data flow to use a data tap.
• G.Use an msi file to deploy the package on the server.
• H.Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
• I.Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
• J.Add an OnError event handler to the SSIS project.
• K.Open a command prompt and run the gacutil command.