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 18, 2019 No Comments READ MORE +

Which three steps should you perform in sequence?

DRAG DROP You are building a SQL Server Integration Services (SSIS) package to load data from all files that are automatically copied to a directory each night through an external FTP process. You need to load data from all copied files to a destination table in SQL Server. Which three...

March 18, 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...

March 17, 2019 No Comments READ MORE +

Which four actions should you perform in sequence?

DRAG DROP You are designing an extract, transform, load (ETL) process with SQL Server Integration Services (SSIS). Two packages, Package A and Package B, will be designed. Package A will execute Package B. Both packages must reference a file path corresponding to an input folder where files will be located...

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

March 13, 2019 No Comments READ MORE +

Which three steps should you perform in sequence?

DRAG DROP You are building a SQL Server Integration Services (SSIS) package to load product data sourced from a SQL Azure database to a data warehouse. Before the product data is loaded, you create a batch record by using an Execute SQL task named Create Batch. After successfully loading the...

March 12, 2019 No Comments READ MORE +

What should you do?

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). You need to complete the post-installation configuration. What should you do?A . Make the data available for DQS operations.B . Install adomd.NETC . Run the dqsinstaller.exe commandD . run the configuration commant...

March 11, 2019 No Comments READ MORE +

Which three stored procedures should you execute in sequence?

DRAG DROP A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog. To troubleshoot some data issues, you must output the data streaming through several data flows into text files for further analysis. You have the list of data flow package paths and identification strings of...

March 10, 2019 No Comments READ MORE +

Which SQL Server application should you use?

You 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 . SQL Server Data ToolsC . SQL Server Management StudioD . Data Quality ClientView AnswerAnswer: C

March 9, 2019 No Comments READ MORE +