Pass with professional DP-700 actual quiz materials

Correct Answer: C,E  🗳️

Correct Answer: D  🗳️

Correct Answer: B  🗳️

Correct Answer:

Explanation:
First selection: JobType == ' Pipeline '
Second selection: SecondsAgo < = 540
Completed KQL query:
ItemJobEventLogs
| where JobType == ' Pipeline ' and JobStatus == ' Failed '
| extend SecondsAgo = datetime_diff( ' second ' , now(), ingestion_time())
| where SecondsAgo < = 540
| order by Timestamp desc
| project Timestamp, ItemName, WorkspaceName, JobStartTime, JobEndTime, JobStatus The correct selections are JobType == ' Pipeline ' and SecondsAgo < = 540 . Microsoft Fabric workspace monitoring writes item-level execution information to the ItemJobEventLogs table in the monitoring Eventhouse. Microsoft provides this specific KQL pattern for detecting recent pipeline failures , using JobType == ' Pipeline ' together with JobStatus == ' Failed ' .
The query then calculates:
datetime_diff( ' second ' , now(), ingestion_time())
This produces the approximate number of seconds elapsed since each monitoring record was ingested.
Because nine minutes = 540 seconds , the predicate SecondsAgo < = 540 retains records ingested during the preceding nine-minute window. SecondsAgo > = 540 would do the opposite by retaining records at least nine minutes old.
JobEndTime > = ago(9m) is not the correct selection because the query explicitly derives ingestion recency through ingestion_time(). Microsoft's documented workspace-monitoring example uses the same SecondsAgo < = 540 pattern.
Finally, project limits the result to the operational fields required for troubleshooting: timestamp, pipeline name, workspace, start/end times, and failure status.
Study Guide reference: Monitor and optimize an analytics solution # workspace monitoring # Eventhouse monitoring logs # KQL analysis of pipeline execution and failures.

Correct Answer:

Explanation:
A screenshot of a computer Description automatically generated

Bronze Layer: A pipeline Copy activity
The bronze layer is used to store raw, unprocessed data. The requirements specify that no transformations should be applied before landing the data in this layer. Using a pipeline Copy activity ensures minimal development effort, built-in connectors, and the ability to ingest the data directly into the Delta format in the bronze layer.
Silver Layer: A notebook
The silver layer involves extensive data cleansing (deduplication, handling missing values, and standardizing capitalization). A notebook provides the flexibility to implement complex transformations and is well-suited for this task.