Note: This question is part of a series of questions that use the same

or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You have a

database named

DB1

that has change data capture enabled.

A Microsoft SQL Server Integration Services (SSIS) job runs once weekly. The job loads changes from

DB1

to a data warehouse by querying the change data capture tables.

You discover that the job lo

ads changes from the previous three days only.

You need to ensure that the job loads changes from the previous week.

Which stored procedure should you execute?

A.

catalog.deploy_project

B.

catalog.restore_project

C.

catalog.stop_operation

D.

sys.sp_cdc_

add_job

E.

sys.sp_cdc_change_job

F.

sys.sp_cdc_disable_db

G.

sys.sp_cdc_enable_db

H.

sys.sp_cdc_stop_job

Explanation:

catalog.deploy_project deploys a project to a folder in the Integration Services catalog or updates an existing project that

has been deployed previously.

References: https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-deploy-project-ssisdb-database

Note: This question is part of a series of questions that use the same o

r similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You are loa

ding data from an OLTP database to a data warehouse.

The OLTP database includes a table for sales data and a table for refund data.

The data warehouse contains a single table for all the sales and refund data.

Which component should you use to load the

data to the data warehouse?

A. the Slowly Changing Dimension transformation

B. the Conditional Split transformation

C. the Merge transformation

D. the Data Conversion transformation

E. an Execute SQL task

F. the Aggregate transformation

G. the Lookup

transformation

Explanation:

The Merge transformation combines two sorted datasets into a single dataset. The rows from each dataset are inserted into the output based on values in their key columns.

By including the Merge transformation in a

data flow, you can merge data from two data sources, such as tables and files.

References: https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/merge-transformation?view=sql-server-2017