DP-700 mock exam

Question 1, Implement and manage an analytics solutionAnalysts in one region must see only their region's rows in a shared table. Which control fits?

• AWorkspace-level access
• BRow-level access control
• CA sensitivity label
• DItem endorsement

Question 2, Implement and manage an analytics solutionYou need to promote a Fabric solution from dev to test to prod in a controlled way. What should you use?

• AA shortcut to the dev workspace
• BExporting items by hand
• CDeployment pipelines
• DEmail approvals

Question 3, Ingest and transform dataA 2 TB table changes by about 1% a day and a full reload misses the window. What do you implement?

• AAn incremental load based on a watermark or change data
• BA copy of the table into a second lakehouse each night
• CA larger capacity with the same full reload each night
• DA weekly full reload with a daily summary table

Question 4, Ingest and transform dataYou want to query data in another team's lakehouse without copying it. What do you create?

• AA OneLake shortcut
• BA new warehouse copy
• CA semantic model refresh
• DA nightly export

Question 5, Ingest and transform dataEvents can arrive up to ten minutes late, and a five-minute count must stay accurate. What do you need in your streaming logic?

• AA windowing strategy that allows for late-arriving events
• BA larger Spark executor so events are processed sooner
• CRow-level security to hold back events from late sources
• DA warehouse index on the event timestamp column

Question 6, Ingest and transform dataCitizen developers need a low-code transformation. Engineers need complex PySpark logic. Which pairing is right?

• AT-SQL only for both groups, using stored procedures
• BNotebooks for both groups, using shared templates
• CKQL for both groups, using saved queries and functions
• DDataflow Gen2 for the first, notebooks for the second

Question 7, Monitor and optimize an analytics solutionA lakehouse table slows down after months of small incremental writes. What is the likely cause and fix?

• AA missing sensitivity label, fixed by labeling the table
• BAn expired deployment pipeline, fixed by redeploying it
• CToo many small files, fixed by table maintenance such as OPTIMIZE
• DToo few workspaces, fixed by splitting the table across more of them

Question 8, Monitor and optimize an analytics solutionYou need an alert when a scheduled semantic model refresh fails. Where does this belong?

• AIn the workspace access list, by adding the owner
• BIn the OneLake shortcut settings for that model
• CIn Fabric monitoring and alert configuration
• DIn row-level security rules on the semantic model