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 remove the Integration Services job.

You need to stop tracking changes to the database temporarily. The solution must ensure that tracking changes can be restored quickly in a few weeks.

Whi

ch 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.stop_operation stops a validation or instance of execution in the Integration Services catalog.

Incorrect Answers:

H: sys.sp_cdc_stop_job stops a change data capture cleanup or capture job for the current database.

References:

https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-stop-operation-ssisdb-database?view=sql-server-2017

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 are designing a data warehouse and the load process for the data warehouse.

You have a source system that contains two tables named

Table1

and

Table2

. All the rows in each table have a corresponding row in the

other table.

The primary key for

Table1

is named

Key1

. The primary key for

Table2

is named

Key2

.

You need to combine both tables into a single table named

Table3

in the data warehouse. The solution must ensure that all the nonkey columns in

Table1

and

T

able2

exist in

Table3

.

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 Lookup transformation performs lookups by joining data in input columns with columns in a reference dataset. You use the lookup to access additional

information in a related table that is based on values in common columns.

You can configure the Lookup transformation in the following ways:

Specify joins between the input and the reference dataset.

Add columns from the reference dataset to the Lookup tr

ansformation output.

Etc.

Incorrect Answers:

F: The Aggregate transformation applies aggregate functions, such as Average, to column values and copies the results to the transformation output. Besides aggregate functions, the transformation provides the G

ROUP BY clause, which you can use to specify groups to aggregate across.

References: https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/lookup-transformation