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 74

Question 730

At Westport Manufacturing factory transactions feed an overnight analytics store. The team proposes this approach: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports. Which technical principle explains the choice?

  1. Incremental loads process changed records instead of copying all historical data on each run.
  2. DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.
  3. Orchestration triggers data movement, records failures and coordinates dependent processing stages.
  4. A hot streaming path reacts promptly while the cold path can consolidate history for deeper analysis.

Answer & Explanations

Correct answer: C

A.

Incremental loads process changed records instead of copying all historical data on each run. That explains a separate situation: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. The current case is: At Westport Manufacturing factory transactions feed an overnight analytics store. The actual mechanism is: Orchestration triggers data movement, records failures and coordinates dependent processing stages.

B.

DirectQuery issues supported queries to the source during interactions, making performance and connectivity important. That explains a separate situation: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The current case is: At Westport Manufacturing factory transactions feed an overnight analytics store. The actual mechanism is: Orchestration triggers data movement, records failures and coordinates dependent processing stages.

C.

Orchestration triggers data movement, records failures and coordinates dependent processing stages. This principle supports the intervention: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports. The relevant scenario is: At Westport Manufacturing factory transactions feed an overnight analytics store. Verify the result by: Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.

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 Westport Manufacturing factory transactions feed an overnight analytics store. The actual mechanism is: Orchestration triggers data movement, records failures and coordinates dependent processing stages.

Question 731

At Westport Manufacturing factory transactions feed an overnight analytics store. After implementing this approach—Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports—which result would most directly confirm success?

  1. Select a fictional product category and verify only related sales transactions contribute to the visual.
  2. Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.
  3. Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.
  4. Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

Answer & Explanations

Correct answer: B

A.

Select a fictional product category and verify only related sales transactions contribute to the visual. This tests a separate situation: At Harborfield Commerce sales facts reference a product dimension. The observed case is: At Westport Manufacturing factory transactions feed an overnight analytics store. Use this acceptance check instead: Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.

B.

Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading. This tests the targeted action: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports. The reason is: Orchestration triggers data movement, records failures and coordinates dependent processing stages. The reported case is: At Westport Manufacturing factory transactions feed an overnight analytics store.

C.

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 Westport Manufacturing factory transactions feed an overnight analytics store. Use this acceptance check instead: Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.

D.

Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table. This tests a separate situation: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The observed case is: At Westport Manufacturing factory transactions feed an overnight analytics store. Use this acceptance check instead: Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.

Question 732

At Westport Manufacturing factory transactions feed an overnight analytics store. Which shortcut most directly threatens the intended data outcome?

  1. Silently drop errors while still reporting the source batch as complete.
  2. Assume a consumer can recover messages that have already aged out of the event stream.
  3. Assume DirectQuery has no dependency on the source system's availability or latency.
  4. Depend on a worker to upload an uncontrolled CSV file once every morning.

Answer & Explanations

Correct answer: D

A.

Silently drop errors while still reporting the source batch as complete. This concerns another issue: At Meadowfield Retail some supplier feeds contain negative quantities. In the stated case—At Westport Manufacturing factory transactions feed an overnight analytics store—reject: Depend on a worker to upload an uncontrolled CSV file once every morning. The safer response is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

B.

Assume a consumer can recover messages that have already aged out of the event stream. This concerns another issue: At Harborcrest Logistics a tracking processor is offline during a deployment. In the stated case—At Westport Manufacturing factory transactions feed an overnight analytics store—reject: Depend on a worker to upload an uncontrolled CSV file once every morning. The safer response is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

C.

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 Westport Manufacturing factory transactions feed an overnight analytics store—reject: Depend on a worker to upload an uncontrolled CSV file once every morning. The safer response is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

D.

Depend on a worker to upload an uncontrolled CSV file once every morning. The scenario is: At Westport Manufacturing factory transactions feed an overnight analytics store. The likely failure is: Missing or duplicated extracts silently distort reports. Instead: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

Question 733

At Silvergate Logistics daily shipment data must arrive before business opening. Which design or Azure data approach best fits this requirement?

  1. Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.
  2. Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
  3. Use a scatter plot when exploring whether two quantitative variables have an association.
  4. Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

Answer & Explanations

Correct answer: A

A.

Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports. This works because: Orchestration triggers data movement, records failures and coordinates dependent processing stages. The scenario is: At Silvergate Logistics daily shipment data must arrive before business opening. Verify the outcome by: Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.

B.

Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. This addresses a different situation: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The present case is: At Silvergate Logistics daily shipment data must arrive before business opening. The relevant action here is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

C.

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 Silvergate Logistics daily shipment data must arrive before business opening. The relevant action here is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

D.

Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. This addresses a different situation: At Silvercrest Commerce executives compare sales performance across regions. The present case is: At Silvergate Logistics daily shipment data must arrive before business opening. The relevant action here is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

Question 734

At Silvergate Logistics daily shipment data must arrive before business opening. The team proposes this approach: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports. Which technical principle explains the choice?

  1. Model relationships propagate filter context between related tables according to direction and cardinality.
  2. Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks.
  3. Orchestration triggers data movement, records failures and coordinates dependent processing stages.
  4. Extract-load-transform separates landing from later compute in a target platform capable of processing raw data.

Answer & Explanations

Correct answer: C

A.

Model relationships propagate filter context between related tables according to direction and cardinality. That explains a separate situation: At Harborfield Commerce sales facts reference a product dimension. The current case is: At Silvergate Logistics daily shipment data must arrive before business opening. The actual mechanism is: Orchestration triggers data movement, records failures and coordinates dependent processing stages.

B.

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 Silvergate Logistics daily shipment data must arrive before business opening. The actual mechanism is: Orchestration triggers data movement, records failures and coordinates dependent processing stages.

C.

Orchestration triggers data movement, records failures and coordinates dependent processing stages. This principle supports the intervention: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports. The relevant scenario is: At Silvergate Logistics daily shipment data must arrive before business opening. Verify the result by: Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.

D.

Extract-load-transform separates landing from later compute in a target platform capable of processing raw data. That explains a separate situation: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The current case is: At Silvergate Logistics daily shipment data must arrive before business opening. The actual mechanism is: Orchestration triggers data movement, records failures and coordinates dependent processing stages.

Question 735

At Silvergate Logistics daily shipment data must arrive before business opening. After implementing this approach—Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports—which result would most directly confirm success?

  1. Run two test consumer groups and confirm each sees the intended events without resetting the other's offset.
  2. Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.
  3. Relate fictional sales facts to products and dates and verify filters affect the intended totals.
  4. Replay a fictional batch twice and verify its aggregate row count remains unchanged.

Answer & Explanations

Correct answer: B

A.

Run two test consumer groups and confirm each sees the intended events without resetting the other's offset. This tests a separate situation: At Oakcrest Mobility live tracking and reporting consume the same event source. The observed case is: At Silvergate Logistics daily shipment data must arrive before business opening. Use this acceptance check instead: Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.

B.

Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading. This tests the targeted action: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports. The reason is: Orchestration triggers data movement, records failures and coordinates dependent processing stages. The reported case is: At Silvergate Logistics daily shipment data must arrive before business opening.

C.

Relate fictional sales facts to products and dates and verify filters affect the intended totals. This tests a separate situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The observed case is: At Silvergate Logistics daily shipment data must arrive before business opening. Use this acceptance check instead: Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.

D.

Replay a fictional batch twice and verify its aggregate row count remains unchanged. This tests a separate situation: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The observed case is: At Silvergate Logistics daily shipment data must arrive before business opening. Use this acceptance check instead: Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.

Question 736

At Silvergate Logistics daily shipment data must arrive before business opening. Which shortcut most directly threatens the intended data outcome?

  1. Treat each retransmission as a brand-new purchase.
  2. Depend on a worker to upload an uncontrolled CSV file once every morning.
  3. Silently drop errors while still reporting the source batch as complete.
  4. Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions.

Answer & Explanations

Correct answer: B

A.

Treat each retransmission as a brand-new purchase. This concerns another issue: At Silverpoint Banking an event publisher retries after a brief timeout. In the stated case—At Silvergate Logistics daily shipment data must arrive before business opening—reject: Depend on a worker to upload an uncontrolled CSV file once every morning. The safer response is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

B.

Depend on a worker to upload an uncontrolled CSV file once every morning. The scenario is: At Silvergate Logistics daily shipment data must arrive before business opening. This undermines the mechanism: Orchestration triggers data movement, records failures and coordinates dependent processing stages. Instead: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

C.

Silently drop errors while still reporting the source batch as complete. This concerns another issue: At Meadowfield Retail some supplier feeds contain negative quantities. In the stated case—At Silvergate Logistics daily shipment data must arrive before business opening—reject: Depend on a worker to upload an uncontrolled CSV file once every morning. The safer response is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

D.

Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. This concerns another issue: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. In the stated case—At Silvergate Logistics daily shipment data must arrive before business opening—reject: Depend on a worker to upload an uncontrolled CSV file once every morning. The safer response is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

Question 737

At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. 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. Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.
  3. Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
  4. Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.

Answer & Explanations

Correct answer: C

A.

Choose a lakehouse when a project needs both raw files and managed analytical tables for mixed data engineering workloads. This addresses a different situation: At Cedarbridge Media analysts combine raw events and curated advertising tables. The present case is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The relevant action here is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.

B.

Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. This addresses a different situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The present case is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The relevant action here is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.

C.

Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. This works because: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. The scenario is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. Verify the outcome by: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.

D.

Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs. This addresses a different situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The present case is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The relevant action here is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.

Question 738

At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The team proposes this approach: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. Which technical principle explains the choice?

  1. RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.
  2. Orchestration triggers data movement, records failures and coordinates dependent processing stages.
  3. Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.
  4. A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.

Answer & Explanations

Correct answer: C

A.

RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. That explains a separate situation: At Cedarcrest Finance regional managers should see only their branch transactions. The current case is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The actual mechanism is: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.

B.

Orchestration triggers data movement, records failures and coordinates dependent processing stages. That explains a separate situation: At Westport Manufacturing factory transactions feed an overnight analytics store. The current case is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The actual mechanism is: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.

C.

Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. This principle supports the intervention: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. The relevant scenario is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. Verify the result by: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.

D.

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 Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The actual mechanism is: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.

Question 739

At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. After implementing this approach—Use Azure Data Factory for managed movement and orchestration between supported source and destination systems—which result would most directly confirm success?

  1. Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.
  2. Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination.
  3. Replay a fictional event with the same ID and confirm the sink counts it only once.
  4. Relate fictional sales facts to products and dates and verify filters affect the intended totals.

Answer & Explanations

Correct answer: A

A.

Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history. This tests the targeted action: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. The reason is: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. The reported case is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake.

B.

Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination. This tests a separate situation: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The observed case is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. Use this acceptance check instead: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.

C.

Replay a fictional event with the same ID and confirm the sink counts it only once. This tests a separate situation: At Silverpoint Banking an event publisher retries after a brief timeout. The observed case is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. Use this acceptance check instead: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.

D.

Relate fictional sales facts to products and dates and verify filters affect the intended totals. This tests a separate situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The observed case is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. Use this acceptance check instead: Execute a test copy from approved storage to an analytical sink and inspect the pipeline run history.

Question 740

At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. Which shortcut most directly threatens the intended data outcome?

  1. Assume configuring a storage account alone creates a daily ingestion workflow.
  2. Treat an Event Hubs namespace as a permanent SQL warehouse with relational joins.
  3. Display hundreds of daily values as separate indistinguishable pie slices.
  4. Reappend the entire transaction history each hour with no deduplication.

Answer & Explanations

Correct answer: A

A.

Assume configuring a storage account alone creates a daily ingestion workflow. The scenario is: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. This undermines the mechanism: Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. Instead: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.

B.

Treat an Event Hubs namespace as a permanent SQL warehouse with relational joins. This concerns another issue: At Harborcrest Transport thousands of vehicles emit location updates. In the stated case—At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake—reject: Assume configuring a storage account alone creates a daily ingestion workflow. The safer response is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.

C.

Display hundreds of daily values as separate indistinguishable pie slices. This concerns another issue: At Meadowport Media analysts inspect daily subscription signups. In the stated case—At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake—reject: Assume configuring a storage account alone creates a daily ingestion workflow. The safer response is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.

D.

Reappend the entire transaction history each hour with no deduplication. This concerns another issue: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. In the stated case—At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake—reject: Assume configuring a storage account alone creates a daily ingestion workflow. The safer response is: Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests