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

You are developing a SQL Server Integration Services (SSIS) package.
You create a script task in the package.
You need to dynamically set the file name of a connection object named File1 by using the script task Which line of code should you add to the script task?

• A.Me.Dts.Connections("File1").AcquireConnection("C:\temp\temp.txt")
• B.Me.Dts.Connections("File1").Variables.Item["FileName"].value = "C:\temp\temp.txt"
• C.Me.Dts.Connections("File1").ConnectionString = "C:\temp\temp.txt"
• D.Me.Dts.Connections("File1").Properties.Item["FileName"].Setvalue = "C:\temp\temp.txt"

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.)

정답:

Explanation
Box 1:

Box 2:

Box 3:

You are developing a SQL Server Integration Services (SSIS) package that loads data from a source transactional tables in a data warehouse.
You discover that one of the data flows loads incorrect data to one of the destination tables.
You need to identify the cause of the incorrect data flow. Which tool should you use?

• A.a breakpoint
• B.the locals window.
• C.a data viewer
• D.SSIS logging.

You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012.
Quality Assurance (QA) testers in the company must have permission to perform the following tasks on specific projects:
* View and validate projects and packages
* View Environments and Environment variables
* Execute packages
You need to grant the minimum possible privileges to the QA testers.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Grant Modify permission in the projects to the QA Tester logons.
• B.Grant Execute permission in the projects to the QA Tester logons.
• C.In the msdb database, add QA Tester logons to the db_ssisoperator role.
• D.Grant Read permission in the SSIS catalog folder, the projects, and the Environments to the QA Tester logons.
• E.In the SSISDB database, add QA Tester logons to the ssis_admin role.
• F.In the msdb database, add QA Tester logons to the db_ssisItduser role.

You have a data warehouse that contains all of the sales data for your company. The data warehouse contains several SQL Server Integration Services (SSIS) packages.
You need to create a custom report that contains the total number of rows processed in the package and the time required for each package to execute.
Which view should you include in the report?

• A.catalog.event_messages
• B.catalog.executable_statistics
• C.catalog.execution_data_taps
• D.catalog.execution_data_statistics