What should you do?
You install a SQL Server 2012 database engine instance on a production server. A month later, you install SQL Server 2012 Integration Services (SSIS). You must develop an SSIS project and deploy it to...
What should you do?
Pdfprep2020-12-08T01:12:07+00:00You are developing a data flow transformation to merge two data sources. One source contains product data and the other source contains data about the country in which the product was manufactured. Both data...
How should you use a MERGE T-SQL statement to accomplish this goal?
Pdfprep2020-12-07T04:19:08+00:00DRAG DROP You are creating a sales data warehouse. When a product exists in the product dimension, you update the product name. When a product does not exist, you insert a new record. In...
Which three actions should you perform in sequence?
Pdfprep2020-12-07T00:21:12+00:00DRAG DROP A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project Connection Manager to connect to the data warehouse. The SSIS catalog includes two...
Which settings should you select?
Pdfprep2020-12-06T17:25:41+00:00DRAG DROP You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You are developing the part of the SSIS package that populates the ProjectDates dimension table....
What should you do?
Pdfprep2020-12-06T16:29:24+00:00You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The package and all three Execute SQL tasks have their TransactionOption property set to...
Which package configuration should you use?
Pdfprep2020-12-06T11:14:00+00:00Topic 2, Volume B You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure. The package uses a Foreach container to process text...
Which query should you use as the data source?
Pdfprep2020-12-06T04:32:48+00:00You are developing a SQL Server Integration Services (SSIS) package that imports data from a relational database to a data warehouse. You are importing data from a relational table named Projects. The table has...
How should you design the control flow for the package?
Pdfprep2020-12-06T02:39:04+00:00DRAG DROP You are designing a SQL Server Integration Services (SSIS) package. The package moves order-related data to a staging table named Order. Every night the staging data is truncated and then all the...
Which SQL Server application should you use?
Pdfprep2020-12-05T20:26:37+00:00You 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 Configuration ManagerB ....