QUESTION NO: 1
You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart.
You have the following requirements:
*Ensure that the process supports the creation of an exception report that details possible duplicate key values, null ratios within columns, and column-length distributions of values.
*Ensure that users can generate the exception report in an XML format.
*Use the minimum development effort.
You need to design the SSIS solution to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart.
You have the following requirements:
*Ensure that the process supports the creation of an exception report that details possible duplicate key values, null ratios within columns, and column-length distributions of values.
*Ensure that users can generate the exception report in an XML format.
*Use the minimum development effort.
You need to design the SSIS solution to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: B
Vote an answer
QUESTION NO: 2
You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?
You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?
Correct Answer: A
Vote an answer
QUESTION NO: 3
You have a secured database that contains all of the customer data for your company.
You plan to use a project deployment model.
You need to create a SQL Server Integration Services (SSIS) package that connects to the database by using a dedicated username and password. The solution must ensure that the password used for the connection string is encrypted.
Which two actions should you perform? Each correct answer presents part of the solution.
You have a secured database that contains all of the customer data for your company.
You plan to use a project deployment model.
You need to create a SQL Server Integration Services (SSIS) package that connects to the database by using a dedicated username and password. The solution must ensure that the password used for the connection string is encrypted.
Which two actions should you perform? Each correct answer presents part of the solution.
Correct Answer: B,D
Vote an answer
QUESTION NO: 4
You are deploying a new SQL Server Integration Services (SSIS) package to several servers.
The package must meet the following requirements:
*.NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.
*The Connection Managers used in the package must be configurable without editing the package.
*The deployment procedure must be automated as much as possible.
You need to set up a deployment strategy that meets the requirements.
What should you do?
You are deploying a new SQL Server Integration Services (SSIS) package to several servers.
The package must meet the following requirements:
*.NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.
*The Connection Managers used in the package must be configurable without editing the package.
*The deployment procedure must be automated as much as possible.
You need to set up a deployment strategy that meets the requirements.
What should you do?
Correct Answer: C
Vote an answer
QUESTION NO: 5
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 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?
Correct Answer: D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 6
You are deploying a new SQL Server Integration Services (SSIS) package to five servers.
The package must meet the following requirements:
*.NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.
*The Connection Managers used in the package must be configurable without editing and redeploying the package.
*The deployment procedure must be automated as much as possible.
*Performance must be maximized.
You need to set up a deployment strategy that meets the requirements.
What should you do?
You are deploying a new SQL Server Integration Services (SSIS) package to five servers.
The package must meet the following requirements:
*.NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.
*The Connection Managers used in the package must be configurable without editing and redeploying the package.
*The deployment procedure must be automated as much as possible.
*Performance must be maximized.
You need to set up a deployment strategy that meets the requirements.
What should you do?
Correct Answer: J
Vote an answer
QUESTION NO: 7
Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed.
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?
Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed.
You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.
What should you do?
Correct Answer: E
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 8
You are designing a data warehouse that uses SQL Server 2012. You are preparing to update the contents of a fact table that contains a non-clustered columnstore index.
You need to run an update statement against the table.
What should you do first?
You are designing a data warehouse that uses SQL Server 2012. You are preparing to update the contents of a fact table that contains a non-clustered columnstore index.
You need to run an update statement against the table.
What should you do first?
Correct Answer: B
Vote an answer
QUESTION NO: 9
You are deploying a new SQL Server Integration Services (SSIS) project to the test environment.
A package in the project uses a custom task component.
You need to ensure that the custom object is deployed on the test environment correctly.
What should you do?
You are deploying a new SQL Server Integration Services (SSIS) project to the test environment.
A package in the project uses a custom task component.
You need to ensure that the custom object is deployed on the test environment correctly.
What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 10
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy.
The package reads data from a source system. Depending on the value in a source column, the package redirects rows to one of five different data flow paths.
You need to add a data flow transformation to support the package redirection.
Which data flow transformation should you use?
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy.
The package reads data from a source system. Depending on the value in a source column, the package redirects rows to one of five different data flow paths.
You need to add a data flow transformation to support the package redirection.
Which data flow transformation should you use?
Correct Answer: C
Vote an answer
QUESTION NO: 11
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project will be deployed to an SSIS catalog folder where Environments have already been created. You need to deploy the project. What should you do?
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project will be deployed to an SSIS catalog folder where Environments have already been created. You need to deploy the project. What should you do?
Correct Answer: K
Vote an answer