Free Microsoft DP-700 Exam Dumps Questions & Answers

You need to resolve the sales data issue. The solution must minimize the amount of data transferred.
What should you do?

• A.  Spilt the dataflow into two dataflows.
• B.  Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Year.
• C.  Configure scheduled refresh for the dataflow.
• D.  Configure incremental refresh for the dataflow. Set Store rows from the past to 1 Month.
• E.  Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Month.

You need to recommend a solution for handling old files. The solution must meet the technical requirements.
What should you include in the recommendation?

• A.  a notebook that runs the VACUUM command
• B.  a notebook that runs the OPTIMIZE command
• C.  a data pipeline that includes a Copy data activity
• D.  a data pipeline that includes a Delete data activity

You have two Fabric workspaces named Workspace1 and Workspace2.
You have a Fabric deployment pipeline named deployPipeline1 that deploys items from Workspace1 to Workspace2. DeployPipeline1 contains all the items in Workspace1.
You recently modified the items in Workspaces1.
The workspaces currently contain the items shown in the following table.

Items in Workspace1 that have the same name as items in Workspace2 are currently paired.
You need to ensure that the items in Workspace1 overwrite the corresponding items in Workspace2. The solution must minimize effort.
What should you do?

• A.  Back up the items in Workspace2, and then run deployPipeline1.
• B.  Delete all the items in Workspace2, and then run deployPipeline1.
• C.  Run deployPipeline1 without modifying the items in Workspace2.
• D.  Rename each item in Workspace2 to have the same name as the items in Workspace1.

You have a Fabric warehouse named DW1 that contains a Type 2 slowly changing dimension (SCD) dimension table named DimCustomer. DimCustomer contains 100 columns and 20 million rows. The columns are of various data types, including int, varchar, date, and varbinary.
You need to identify incoming changes to the table and update the records when there is a change. The solution must minimize resource consumption.
What should you use to identify changes to attributes?

• A.  a hash function to compare the attributes in the source table.
• B.  a hash function to compare the attributes in the DimCustomer table.
• C.  a direct attributes comparison for the attributes in the source table.
• D.  a direct attributes comparison across the attributes in the DimCustomer table.

You have a Fabric workspace named WS1 that is connected to the main branch of an Azure DevOps Git repository. WS1 contains a lakehouse a notebook and a pipeline.
Two data engineer must update the notebook and people concurrently for separate features.
You need to configure version control to support isolated feature development and controlled integration into the main branch.
The solution must meet the following requirements:
Prevent one engineer's reviewed workspace changes from affecting the other engineer workspace.
Support a review before changes are integrated into the main branch.
Track changes to the Fabric items in Git.
How should you configure the development workflow? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation: