Practice Exams:

Microsoft DP-900 Dumps

EXAM: Microsoft Azure Data Fundamentals
Verified By Experts
Premium Bundle
$40.00
$59.97 $99.97

DP-900 Premium Bundle


  • Premium File 332 Questions & Answers
  • Training Course 32 Lectures
  • Study Guide 672 Pages

Microsoft DP-900 Practice Test 77

Question 760

At Cedarpoint Retail clickstream data is cleansed and joined at large scale. Which shortcut most directly threatens the intended data outcome?

  1. Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream.
  2. Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row.
  3. Run every massive distributed join as a manual desktop spreadsheet formula.
  4. Assume DirectQuery has no dependency on the source system's availability or latency.

Answer & Explanations

Correct answer: C

A.

Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream. This concerns another issue: At Pinebrook Facilities sensors send readings to an event hub. In the stated case—At Cedarpoint Retail clickstream data is cleansed and joined at large scale—reject: Run every massive distributed join as a manual desktop spreadsheet formula. The safer response is: Use Azure Databricks for distributed Spark-based processing of large or complex transformation workloads.

B.

Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. This concerns another issue: At Cedarbridge Media analysts combine raw events and curated advertising tables. In the stated case—At Cedarpoint Retail clickstream data is cleansed and joined at large scale—reject: Run every massive distributed join as a manual desktop spreadsheet formula. The safer response is: Use Azure Databricks for distributed Spark-based processing of large or complex transformation workloads.

C.

Run every massive distributed join as a manual desktop spreadsheet formula. The scenario is: At Cedarpoint Retail clickstream data is cleansed and joined at large scale. This undermines the mechanism: Databricks supplies managed Apache Spark data processing capable of parallel transformations and notebook workflows. Instead: Use Azure Databricks for distributed Spark-based processing of large or complex transformation workloads.

D.

Assume DirectQuery has no dependency on the source system's availability or latency. This concerns another issue: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. In the stated case—At Cedarpoint Retail clickstream data is cleansed and joined at large scale—reject: Run every massive distributed join as a manual desktop spreadsheet formula. The safer response is: Use Azure Databricks for distributed Spark-based processing of large or complex transformation workloads.

Question 761

At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. Which design or Azure data approach best fits this requirement?

  1. Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.
  2. Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.
  3. Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.
  4. Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.

Answer & Explanations

Correct answer: A

A.

Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. This works because: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. The scenario is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. Verify the outcome by: Create a test lakehouse table and verify only approved workspace identities can read the source files.

B.

Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. This addresses a different situation: At Silverpoint Banking an event publisher retries after a brief timeout. The present case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The relevant action here is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

C.

Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. This addresses a different situation: At Meadowport Media analysts inspect daily subscription signups. The present case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The relevant action here is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

D.

Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration. This addresses a different situation: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The present case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The relevant action here is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

Question 762

At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The team proposes this approach: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. Which technical principle explains the choice?

  1. Larger batch jobs can be efficient but delay availability, so cadence must match business SLAs.
  2. OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.
  3. The semantic model defines shared data types, relationships and measures so reports interpret business figures consistently.
  4. A hot streaming path reacts promptly while the cold path can consolidate history for deeper analysis.

Answer & Explanations

Correct answer: B

A.

Larger batch jobs can be efficient but delay availability, so cadence must match business SLAs. That explains a separate situation: At Harborland Retail nightly inventory analytics satisfy finance but not emergency stock alerts. The current case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The actual mechanism is: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.

B.

OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. This principle supports the intervention: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. The relevant scenario is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. Verify the result by: Create a test lakehouse table and verify only approved workspace identities can read the source files.

C.

The semantic model defines shared data types, relationships and measures so reports interpret business figures consistently. That explains a separate situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The current case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The actual mechanism is: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.

D.

A hot streaming path reacts promptly while the cold path can consolidate history for deeper analysis. That explains a separate situation: At Pineport Healthcare medical equipment signals abnormal temperatures. The current case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The actual mechanism is: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.

Question 763

At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. After implementing this approach—Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads—which result would most directly confirm success?

  1. Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.
  2. Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.
  3. Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.
  4. Create a test lakehouse table and verify only approved workspace identities can read the source files.

Answer & Explanations

Correct answer: D

A.

Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed. This tests a separate situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The observed case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. Use this acceptance check instead: Create a test lakehouse table and verify only approved workspace identities can read the source files.

B.

Add a fictional revenue measure and confirm it changes when the product slicer is adjusted. This tests a separate situation: At Silverlake Services managers compare revenue by selected region. The observed case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. Use this acceptance check instead: Create a test lakehouse table and verify only approved workspace identities can read the source files.

C.

Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading. This tests a separate situation: At Westport Manufacturing factory transactions feed an overnight analytics store. The observed case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. Use this acceptance check instead: Create a test lakehouse table and verify only approved workspace identities can read the source files.

D.

Create a test lakehouse table and verify only approved workspace identities can read the source files. This tests the targeted action: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. The reason is: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. The reported case is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation.

Question 764

At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. Which shortcut most directly threatens the intended data outcome?

  1. Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions.
  2. Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream.
  3. Use a pie chart to prove one numeric factor causes another.
  4. Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake.

Answer & Explanations

Correct answer: D

A.

Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. This concerns another issue: At Silvercrest Commerce executives compare sales performance across regions. In the stated case—At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation—reject: Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. The safer response is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

B.

Deploy a static SQL query in a disconnected relational database and assume it automatically subscribes to the sensor stream. This concerns another issue: At Pinebrook Facilities sensors send readings to an event hub. In the stated case—At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation—reject: Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. The safer response is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

C.

Use a pie chart to prove one numeric factor causes another. This concerns another issue: At Pinewood Retail analysts compare campaign spend with customer acquisitions. In the stated case—At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation—reject: Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. The safer response is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

D.

Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. The scenario is: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The likely failure is: Consumers either lose access or see information outside their authorization. Instead: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

Question 765

At Oakcrest Logistics approved departments share curated lakehouse datasets. Which design or Azure data approach best fits this requirement?

  1. Choose event-time windows when late-arriving sensor measurements must be attributed to their occurrence time rather than receipt time.
  2. Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.
  3. Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
  4. Use a scatter plot when exploring whether two quantitative variables have an association.

Answer & Explanations

Correct answer: B

A.

Choose event-time windows when late-arriving sensor measurements must be attributed to their occurrence time rather than receipt time. This addresses a different situation: At Meadowport Transit buses upload buffered GPS events after reconnecting. The present case is: At Oakcrest Logistics approved departments share curated lakehouse datasets. The relevant action here is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

B.

Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. This works because: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. The scenario is: At Oakcrest Logistics approved departments share curated lakehouse datasets. Verify the outcome by: Create a test lakehouse table and verify only approved workspace identities can read the source files.

C.

Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. This addresses a different situation: At Cedarfield Finance external invoices need standard currency codes before reporting. The present case is: At Oakcrest Logistics approved departments share curated lakehouse datasets. The relevant action here is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

D.

Use a scatter plot when exploring whether two quantitative variables have an association. This addresses a different situation: At Pinewood Retail analysts compare campaign spend with customer acquisitions. The present case is: At Oakcrest Logistics approved departments share curated lakehouse datasets. The relevant action here is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

Question 766

At Oakcrest Logistics approved departments share curated lakehouse datasets. The team proposes this approach: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. Which technical principle explains the choice?

  1. A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.
  2. Each point shows paired numeric values and can reveal patterns or outliers without implying causation.
  3. Partition pruning lets engines skip unrelated date segments instead of scanning all years of data.
  4. OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.

Answer & Explanations

Correct answer: D

A.

A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately. That explains a separate situation: At Harborcrest Logistics a tracking processor is offline during a deployment. The current case is: At Oakcrest Logistics approved departments share curated lakehouse datasets. The actual mechanism is: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.

B.

Each point shows paired numeric values and can reveal patterns or outliers without implying causation. That explains a separate situation: At Pinewood Retail analysts compare campaign spend with customer acquisitions. The current case is: At Oakcrest Logistics approved departments share curated lakehouse datasets. The actual mechanism is: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.

C.

Partition pruning lets engines skip unrelated date segments instead of scanning all years of data. That explains a separate situation: At Oakfield Utilities analysts frequently report one month of meter usage. The current case is: At Oakcrest Logistics approved departments share curated lakehouse datasets. The actual mechanism is: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.

D.

OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. This principle supports the intervention: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. The relevant scenario is: At Oakcrest Logistics approved departments share curated lakehouse datasets. Verify the result by: Create a test lakehouse table and verify only approved workspace identities can read the source files.

Question 767

At Oakcrest Logistics approved departments share curated lakehouse datasets. After implementing this approach—Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads—which result would most directly confirm success?

  1. Publish synthetic events, consume them through a test consumer group and verify offsets advance.
  2. Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.
  3. Create a test lakehouse table and verify only approved workspace identities can read the source files.
  4. Update two fictional source records and confirm the second pipeline run imports only eligible changes.

Answer & Explanations

Correct answer: C

A.

Publish synthetic events, consume them through a test consumer group and verify offsets advance. This tests a separate situation: At Harborcrest Transport thousands of vehicles emit location updates. The observed case is: At Oakcrest Logistics approved departments share curated lakehouse datasets. Use this acceptance check instead: Create a test lakehouse table and verify only approved workspace identities can read the source files.

B.

Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report. This tests a separate situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The observed case is: At Oakcrest Logistics approved departments share curated lakehouse datasets. Use this acceptance check instead: Create a test lakehouse table and verify only approved workspace identities can read the source files.

C.

Create a test lakehouse table and verify only approved workspace identities can read the source files. This tests the targeted action: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. The reason is: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. The reported case is: At Oakcrest Logistics approved departments share curated lakehouse datasets.

D.

Update two fictional source records and confirm the second pipeline run imports only eligible changes. This tests a separate situation: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. The observed case is: At Oakcrest Logistics approved departments share curated lakehouse datasets. Use this acceptance check instead: Create a test lakehouse table and verify only approved workspace identities can read the source files.

Question 768

At Oakcrest Logistics approved departments share curated lakehouse datasets. Which shortcut most directly threatens the intended data outcome?

  1. Calculate a 'last five minutes' alert from a table refreshed once per day.
  2. Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake.
  3. Append duplicate transactions on every network retry without comparing event IDs.
  4. Expect a static imported dataset to show each operational write instantly without refresh.

Answer & Explanations

Correct answer: B

A.

Calculate a 'last five minutes' alert from a table refreshed once per day. This concerns another issue: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. In the stated case—At Oakcrest Logistics approved departments share curated lakehouse datasets—reject: Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. The safer response is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

B.

Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. The scenario is: At Oakcrest Logistics approved departments share curated lakehouse datasets. This undermines the mechanism: OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. Instead: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

C.

Append duplicate transactions on every network retry without comparing event IDs. This concerns another issue: At Silverbrook Logistics pipelines reattempt delayed shipment messages. In the stated case—At Oakcrest Logistics approved departments share curated lakehouse datasets—reject: Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. The safer response is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

D.

Expect a static imported dataset to show each operational write instantly without refresh. This concerns another issue: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. In the stated case—At Oakcrest Logistics approved departments share curated lakehouse datasets—reject: Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. The safer response is: Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

Question 769

At Cedarbridge Media analysts combine raw events and curated advertising tables. Which design or Azure data approach best fits this requirement?

  1. Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.
  2. Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.
  3. Add validation and a quarantine destination for records failing an agreed data quality rule.
  4. Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

Answer & Explanations

Correct answer: A

A.

Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. This works because: A lakehouse combines lake-style file storage with table organization and analytical query access. The scenario is: At Cedarbridge Media analysts combine raw events and curated advertising tables. Verify the outcome by: Land sample JSON files and create a queryable curated table without discarding the original files.

B.

Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. This addresses a different situation: At Silverpoint Banking an event publisher retries after a brief timeout. The present case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. The relevant action here is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.

C.

Add validation and a quarantine destination for records failing an agreed data quality rule. This addresses a different situation: At Meadowfield Retail some supplier feeds contain negative quantities. The present case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. The relevant action here is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.

D.

Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data. This addresses a different situation: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The present case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. The relevant action here is: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads.

Question 770

At Cedarbridge Media analysts combine raw events and curated advertising tables. The team proposes this approach: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. Which technical principle explains the choice?

  1. A lakehouse combines lake-style file storage with table organization and analytical query access.
  2. Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.
  3. Idempotent processing produces the same final state after repeated delivery of an identical event.
  4. Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks.

Answer & Explanations

Correct answer: A

A.

A lakehouse combines lake-style file storage with table organization and analytical query access. This principle supports the intervention: Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. The relevant scenario is: At Cedarbridge Media analysts combine raw events and curated advertising tables. Verify the result by: Land sample JSON files and create a queryable curated table without discarding the original files.

B.

Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. That explains a separate situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The current case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. The actual mechanism is: A lakehouse combines lake-style file storage with table organization and analytical query access.

C.

Idempotent processing produces the same final state after repeated delivery of an identical event. That explains a separate situation: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The current case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. The actual mechanism is: A lakehouse combines lake-style file storage with table organization and analytical query access.

D.

Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. That explains a separate situation: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The current case is: At Cedarbridge Media analysts combine raw events and curated advertising tables. The actual mechanism is: A lakehouse combines lake-style file storage with table organization and analytical query access.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests