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

January 22, 2019No CommentsREAD MORE +

What should you do?

You are reviewing the design of a student dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historical changes to student attributes such as ParentOccupation. You need to redesign the dimension to enable the full historical reporting of...

January 21, 2019No CommentsREAD MORE +

What should you do?

You are implementing the indexing strategy for a fact table in a data warehouse. The fact table is named Quotes. The table has no indexes and consists of seven columns: - [ID] - [QuoteDate] - [Open] - [Close] - [High] - [Low] - [Volume] Each of the following queries must...

January 20, 2019No CommentsREAD MORE +

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

January 19, 2019No CommentsREAD MORE +

Which event handler should you use?

You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database. The company's auditing policies have the following requirements: - An entry must be written to a dedicated SQL Server log table named OrderLog. - The entry...

January 18, 2019No CommentsREAD MORE +

What should you use to execute the package?

You develop and deploy a SQL Server Integration Services (SSIS) package. The package is stored in the file system. You need to execute the package without importing it to the SSIS server. What should you use to execute the package? (Each correct answer presents a complete solution. Choose all that...

January 16, 2019No CommentsREAD MORE +

Which SQL statement should you use?

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You add an Execute SQL task to the control flow. The task must execute a simple INSERT statement. The task has the following requirements: - The INSERT statement must use the value of...

January 14, 2019No CommentsREAD MORE +

What should you do?

You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database. The project uses the Package Deployment Model. This project is deployed to SQL Server on a test server. You need to ensure that the project is deployed to...

January 9, 2019No CommentsREAD MORE +

What should you do?

You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. The reference data to be used in the transformation does not change. You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance. What should you do?A . Select the...

January 7, 2019No CommentsREAD MORE +

Which SQL statement should you use?

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You add an Execute SQL task to the control flow. The task must execute a simple INSERT statement. The task has the following requirements: - The INSERT statement must use the value of...

January 6, 2019No CommentsREAD MORE +