최신 070-463 무료덤프 - Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
You plan to deploy a package to a server that has SQL Server installed. The server contains a SQL Server Integration Services (SSIS) catalog.
You need to ensure that the package credentials are encrypted.
Which protection level should you set for the package?
You need to ensure that the package credentials are encrypted.
Which protection level should you set for the package?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You are the data steward for a Business Intelligence project.
You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project.
You need to produce the CSV file with the least amount of development effort.
What should you do?
You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project.
You need to produce the CSV file with the least amount of development effort.
What should you do?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You are developing a SQL Server Integration Services (SSIS) package.
You need to design a package to change a variable value during package execution by using the least amount of development effort.
What should you use?
You need to design a package to change a variable value during package execution by using the least amount of development effort.
What should you use?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
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?
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?
정답: G
설명: (DumpTOP 회원만 볼 수 있음)
You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS) project.
The first package that you create in this project contains a package connection that accesses a Microsoft Excel file. Additional packages in the project must also access this file.
You need to define and reuse the Excel file connection in all project packages.
What should you do?
The first package that you create in this project contains a package connection that accesses a Microsoft Excel file. Additional packages in the project must also access this file.
You need to define and reuse the Excel file connection in all project packages.
What should you do?
정답: D
NO: 207
You need to extract data from a table in a SQL Server 2012 database.
What connection manager types can you use? (Choose all that apply.)
You need to extract data from a table in a SQL Server 2012 database.
What connection manager types can you use? (Choose all that apply.)
정답: A,B,C
설명: (DumpTOP 회원만 볼 수 있음)
You are developing a SQL Server Integration Services (SSIS) package.
The package contains an ADO object source variable that holds a result set that was returned by a stored procedure execution.
You need to add and configure a container that will execute several tasks for each row in the ADO object source variable.
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,)
The package contains an ADO object source variable that holds a result set that was returned by a stored procedure execution.
You need to add and configure a container that will execute several tasks for each row in the ADO object source variable.
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: Open the Control Flow designer of the package.
Box 2: Add and edit a Foreach Loop container.
Box 3: Set the enumerator property to Foreach ADO Enumerator and select the variable that contains the ADO object source.
Note:
Example:
You are designing an extract, transform, load (ETL) process with SQL Server Integration Services (SSIS).
Two packages, Package A and Package B will execute Package B.
Both packages must reference a file path corresponding to an input folder where files will be located for further processing.
You need to design a solution so that the file path can be easily configured with the least administrative and development effort.
Which four 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.)
Two packages, Package A and Package B will execute Package B.
Both packages must reference a file path corresponding to an input folder where files will be located for further processing.
You need to design a solution so that the file path can be easily configured with the least administrative and development effort.
Which four 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:
Box 4:
Reference:
http://msdn.microsoft.com/en-us/library/hh479588.aspx
http://msdn.microsoft.com/en-us/library/hh213290.aspx
http://msdn.microsoft.com/en-us/library/hh213373.aspx
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model.
You need to monitor control flow tasks to determine whether any of them are running longer than usual.
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.)
You need to monitor control flow tasks to determine whether any of them are running longer than usual.
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
1. Connect to SSISDB.
2. Query against execution_component_phases and executions.
3. Execute query
Ref:
http://msdn.microsoft.com/en-us/library/hh230981.aspx
http://msdn.microsoft.com/en-us/library/ff878089.aspx