Which three actions should you perform in sequence?

DRAG DROP A Data Flow task in a SQL Server Integration Services (SSIS) package produces run-time errors. You need to edit the package to log specific error messages. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer...

March 6, 2019 No Comments READ MORE +

What should you do?

To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology. The methodology has the following requirements: - Centralized logging in SQL Server - Simple deployment - Availability of log information through reports or T-SQL - Automatic purge of older log entries - Configurable...

March 5, 2019 No Comments READ 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...

March 1, 2019 No Comments READ MORE +

Which hierarchy type should you use?

You are creating a SQL Server Master Data Services (MDS) model for a company. The source data for the company is stored in a single table that contains the manager-to-subordinate relationships. You need to create a hierarchy representing the organizational structure of the company. Which hierarchy type should you use?A...

February 28, 2019 No Comments READ MORE +

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

February 27, 2019 No Comments READ MORE +

What should you select from the SSIS Toolbox?

DRAG DROP You are developing a SQL Server Integration Services (SSIS) package. The package uses custom functionality that accesses a SQL Server database. The custom functionality must be implemented by using Language Integrated Query (LINQ). You need to ensure that the LINQ code can be debugged at design time. What...

February 24, 2019 No Comments READ MORE +

What should you do?

You 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 Supported. You need to ensure that if any of the Execute SQL tasks fail, all three...

February 24, 2019 No Comments READ 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...

February 21, 2019 No Comments READ MORE +

What should you do?

You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day. Referential integrity must be enforced declaratively. You need to design a solution that can join a single time dimension to both fact tables. What should...

February 21, 2019 No Comments READ MORE +

What should you do?

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain....

February 20, 2019 No Comments READ MORE +