- All Exams Instant Download
Which three actions should you perform in sequence?
DRAG 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 Environments: - Development - QA Each Environment defines a single Environment Variable named Connection String of...
Which components must be present to meet this goal?
You are installing the Data Quality Client on user desktops. You need to ensure that the prerequisite software components are installed. Which components must be present to meet this goal? (Each correct answer presents part of the solution. Choose all that apply.)A . SQL Server Management StudioB . Internet Explorer...
What should you do?
You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure. Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart. You need to...
Which package configuration should you use?
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 files found in a folder. The package must be deployed to a single server by using the Project Deployment model....
Which package configuration should you use?
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 files found in a folder. The package must be deployed to a single server by using the Project Deployment model....
Which query should you use as the data source?
You 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 change data capture enabled on all columns. You need to process only the most recent values...
Which query should you use as the data source?
You 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 change data capture enabled on all columns. You need to process only the most recent values...
Which settings should you select?
DRAG 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. The business key of the ProjectDates table is the ProjectName column. The business user has given...
What should you do?
You have a table with a column store index in place. Some of the data has changed and you need to update it. What should you do?A . Drop column store indexB . Create clustered column store indexC . Pause column store indexD . Change to bulk-loggedView AnswerAnswer: A
Which three steps should you perform in sequence?
DRAG DROP You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive property. You need to create a project parameter and configure it so that its value is encrypted when it is deployed to the SSIS catalog. Which three steps should you perform...
