Microsoft Implementing Analytics Solutions Using Microsoft Fabric DP-600 Question # 7 Topic 1 Discussion
DP-600 Exam Topic 1 Question 7 Discussion:
Question #: 7
Topic #: 1
You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?
A.
an Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderlD column in the destination lakehouse
B.
an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of the OrderlD column in the destination lakehouse
C.
an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderlD column in the destination lakehouse
D.
an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the minimum value of the OrderiD column m the
Requirement: “The number of rows added to the Orders table during refreshes must be minimized.”
The Orders table has a sequential OrderID.
To minimize refresh size, you must only import new rows, not the entire table.
This requires retrieving the maximum OrderID currently loaded, then only loading rows with a greater OrderID.
So, the correct solution is to use a pipeline (ADF) with a dataflow to retrieve the maximum OrderID.
Answer: C. an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderID column in the destination lakehouse
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit