Note: This question is part of a series of questions that present the same scenario. Each question i
n the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to
return to it. As a result, these questions will not appear in the review screen.
You have the following line-of-business solutions:
ERP system
Online WebStore
Partner extranet
One or more Microsoft SQL Server instances support each solution. Each solutio
n has its own product catalog. You have an additional server that hosts SQL Server Integration Services (SSIS) and a data warehouse. You populate the data warehouse with data from each of the line-of-business solutions. The data warehouse does not store pr
imary key values from the individual source tables.
The database for each solution has a table named
Products
that stored product information. The
Products
table in each database uses a separate and unique key for product records. Each table shares a colu
mn named
ReferenceNr
between the databases. This column is used to create queries that involve more than once solution.
You need to load data from the individual solutions into the data warehouse nightly. The following requirements must be met:
If a chang
e is made to the
ReferenceNr
column in any of the sources, set the value of
IsDisabled
to
True
and create a new row in the
Products
table.
If a row is deleted in any of the sources, set the value of
IsDisabled
to
True
in the data warehouse.
Solution: Perf
orm the following actions:
Enable the
Change Tracking
for the
Product
table in the source databases.
Query the
CHANGETABLE
function from the sources for the updated rows.
Set the
IsDisabled
column to
True
for the listed rows that have the old
ReferenceNr
value.
Create a new row in the data warehouse
Products
table with the new
ReferenceNr
value.
Does the solution meet the goal?
A. Yes
B. No
Explanation:
We must check for deleted rows, not just updates rows.
References: