Online Access Free DP-700 Exam Questions

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Data is ingested into Lakehouse1 as one flat table. The table contains the following columns.

You plan to load the data into a dimensional model and implement a star schema. From the original flat table, you create two tables named FactSales and DimProduct. You will track changes in DimProduct.
You need to prepare the data.
Which three columns should you include in the DimProduct table? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.ProductName
• B.ProductColor
• C.TransactionID
• D.SalesAmount
• E.Date
• F.ProductID

You have a Fabric tenant that is linked to a Microsoft Entra tenant. The Microsoft [intra tenant contains a user named User1 and two groups named Group! and Groups.
The Fabric tenant contains the workspaces shown in the following table.

You need to meet the following access requirements:
* User1 must have read access to the following:
* The operations department reports
* The HR department warehouse and reports
* The legal department warehouse and reports
* User1 must be able to create new items in Workspace
* Group1 must have access to the finance department warehouse and reports.
* Group1 must be able to add new users to the finance department workspace.
* Group2 must have access to only the HR warehouse and the legal warehouse.
The solution must follow the principle of least privilege.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

You have a Fabric workspace that contains a lakehouse named Lakehouse1.
In an external data source, you have data files that are 500 GB each. A new file is added every day.
You need to ingest the data into Lakehouse1 without applying any transformations. The solution must meet the following requirements Trigger the process when a new file is added.
Provide the highest throughput.
Which type of item should you use to ingest the data?

• A.Data pipeline
• B.Streaming dataset
• C.Dataflow Gen2
• D.Event stream

You have a Fabric warehouse named DW1 that loads data by using a data pipeline named Pipeline1. Pipeline1 uses a Copy data activity with a dynamic SQL source. Pipeline1 is scheduled to run every 15 minutes.
You discover that Pipeline1 keeps failing.
You need to identify which SQL query was executed when the pipeline failed.
What should you do?

• A.From Real-time hub, select Fabric events, and then review the details of Microsoft. Fabric.
  ItemUpdateFailed.
• B.From Monitoring hub, select the latest failed run of Pipeline1, and then view the output JSON.
• C.From Real-time hub, select Fabric events, and then review the details of Microsoft.Fabric.
  ItemReadFailed.
• D.From Monitoring hub, select the latest failed run of Pipeline1, and then view the input JSON.

You need to ensure that WorkspaceA can be configured for source control. Which two actions should you perform?
Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A.From Tenant setting, set Users can synchronize workspace items with their Git repositories to Enabled
• B.Assign WorkspaceA to Capl.
• C.Configure WorkspaceA to use a Premium Per User (PPU) license
• D.From Tenant setting, set Users can sync workspace items with GitHub repositories to Enabled