DP-700.pdf
Q: 1
You need to develop an orchestration solution in fabric that will load each item one after the other.
The solution must be scheduled to run every 15 minutes. Which type of item should you use?
Options
Q: 2
You are implementing a medallion architecture in a Fabric lakehouse.
You plan to create a dimension table that will contain the following columns:
• ID
• CustomerCode
• CustomerName
• CustomerAddress
• CustomerLocation
• ValidFrom
• ValidTo
You need to ensure that the table supports the analysis of historical sales data by customer location
at the time of each sale Which type of slowly changing dimension (SCD) should you use?
Options
Q: 3
You have a Fabric workspace that contains a takehouse and a semantic model named Model1.
You use a notebook named Notebook1 to ingest and transform data from an external data source.
You need to execute Notebook1 as part of a data pipeline named Pipeline1. The process must meet
the following requirements:
• Run daily at 07:00 AM UTC.
• Attempt to retry Notebook1 twice if the notebook fails.
• After Notebook1 executes successfully, refresh Model1.
Which three actions should you perform? Each correct answer presents part of the solution. NOTE:
Each correct selection is worth one point.
Options
Q: 4
You have a Fabric workspace that contains a warehouse named DW1. DW1 is loaded by using a
notebook named Notebook1.
You need to identify which version of Delta was used when Notebook1 was executed.
What should you use?
Options
Q: 5
You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse
named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the
past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year
values.
Users report that the performance of some of the reports has degraded over time and some visuals
show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?
Options
Q: 6
You need to schedule the population of the medallion layers to meet the technical requirements.
What should you do?
Options
Q: 7
You have a Fabric workspace that contains a warehouse named Warehouse1.
While monitoring Warehouse1, you discover that query performance has degraded during the last 60
minutes.
You need to isolate all the queries that were run during the last 60 minutes. The results must include
the username of the users that submitted the queries and the query statements. What should you
use?
Options
Q: 8
You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.
Users report that from OneLake file explorer, they cannot see the data from the eventhouse.
You enable OneLake availability for the eventhouse.
What will be copied to OneLake?
Options
Q: 9
You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1
outputs events to a table in a lakehouse.
You need to remove files that are older than seven days and are no longer in use.
Which command should you run?
Options
Q: 10
HOTSPOT You have an Azure Event Hubs data source that contains weather data. You ingest the data from the data source by using an eventstream named Eventstream1. Eventstream1 uses a lakehouse as the destination. You need to batch ingest only rows from the data source where the City attribute has a value of Kansas. The filter must be added before the destination. The solution must minimize development effort. What should you use for the data processor and filtering? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 
Your Answer
Question 1 of 10
