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 73

Question 720

At Harborcrest Health claim data must have validated dates before warehouse ingestion. Which shortcut most directly threatens the intended data outcome?

  1. Label an unvalidated raw copy as a finished ETL process without a transformation step.
  2. Treat each retransmission as a brand-new purchase.
  3. Present categories as an unlabeled geographic heatmap with no location meaning.
  4. Assume creating a Power BI chart automatically ingests all missing source history into Fabric.

Answer & Explanations

Correct answer: A

A.

Label an unvalidated raw copy as a finished ETL process without a transformation step. The scenario is: At Harborcrest Health claim data must have validated dates before warehouse ingestion. This undermines the mechanism: Extract-transform-load performs transformations before storing the final warehouse-ready form. Instead: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.

B.

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 Harborcrest Health claim data must have validated dates before warehouse ingestion—reject: Label an unvalidated raw copy as a finished ETL process without a transformation step. The safer response is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.

C.

Present categories as an unlabeled geographic heatmap with no location meaning. This concerns another issue: At Cedarbank Logistics supervisors compare delivery counts among depots. In the stated case—At Harborcrest Health claim data must have validated dates before warehouse ingestion—reject: Label an unvalidated raw copy as a finished ETL process without a transformation step. The safer response is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.

D.

Assume creating a Power BI chart automatically ingests all missing source history into Fabric. This concerns another issue: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. In the stated case—At Harborcrest Health claim data must have validated dates before warehouse ingestion—reject: Label an unvalidated raw copy as a finished ETL process without a transformation step. The safer response is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.

Question 721

At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. Which design or Azure data approach best fits this requirement?

  1. Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.
  2. Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.
  3. Use Azure Data Factory for managed movement and orchestration between supported source and destination systems.
  4. Use ELT when raw records can first land in a scalable analytical store and transformations run there.

Answer & Explanations

Correct answer: D

A.

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 Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The relevant action here is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

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 Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The relevant action here is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

C.

Use Azure Data Factory for managed movement and orchestration between supported source and destination systems. This addresses a different situation: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The present case is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The relevant action here is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

D.

Use ELT when raw records can first land in a scalable analytical store and transformations run there. This works because: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data. The scenario is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. Verify the outcome by: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

Question 722

At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The team proposes this approach: Use ELT when raw records can first land in a scalable analytical store and transformations run there. Which technical principle explains the choice?

  1. Extract-load-transform separates landing from later compute in a target platform capable of processing raw data.
  2. Each point shows paired numeric values and can reveal patterns or outliers without implying causation.
  3. Windowed streaming computations aggregate events over bounded time intervals as new data arrives.
  4. Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces.

Answer & Explanations

Correct answer: A

A.

Extract-load-transform separates landing from later compute in a target platform capable of processing raw data. This principle supports the intervention: Use ELT when raw records can first land in a scalable analytical store and transformations run there. The relevant scenario is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. Verify the result by: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

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 Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The actual mechanism is: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data.

C.

Windowed streaming computations aggregate events over bounded time intervals as new data arrives. That explains a separate situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The current case is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The actual mechanism is: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data.

D.

Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces. That explains a separate situation: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The current case is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The actual mechanism is: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data.

Question 723

At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. After implementing this approach—Use ELT when raw records can first land in a scalable analytical store and transformations run there—which result would most directly confirm success?

  1. Recompute a fictional quarter's metric using the documented dataset version and compare totals.
  2. Send synthetic device readings and compare event-to-dashboard delay under both processing designs.
  3. Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.
  4. Update a synthetic source record and verify the report reflects it after a configured refresh.

Answer & Explanations

Correct answer: C

A.

Recompute a fictional quarter's metric using the documented dataset version and compare totals. This tests a separate situation: At Cedarcrest Banking financial metrics require stable audit evidence. The observed case is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. Use this acceptance check instead: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

B.

Send synthetic device readings and compare event-to-dashboard delay under both processing designs. This tests a separate situation: At Cedarpoint Manufacturing equipment overheating requires prompt detection. The observed case is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. Use this acceptance check instead: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

C.

Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table. This tests the targeted action: Use ELT when raw records can first land in a scalable analytical store and transformations run there. The reason is: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data. The reported case is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion.

D.

Update a synthetic source record and verify the report reflects it after a configured refresh. This tests a separate situation: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The observed case is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. Use this acceptance check instead: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

Question 724

At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. Which shortcut most directly threatens the intended data outcome?

  1. Paste a fixed grand total into every transaction row and expect slicers to recalculate it.
  2. Add an empty Fabric workspace and assume external live events start arriving without connectors.
  3. Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake.
  4. Discard raw source files before checking whether transformations are repeatable.

Answer & Explanations

Correct answer: D

A.

Paste a fixed grand total into every transaction row and expect slicers to recalculate it. This concerns another issue: At Silverlake Services managers compare revenue by selected region. In the stated case—At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion—reject: Discard raw source files before checking whether transformations are repeatable. The safer response is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

B.

Add an empty Fabric workspace and assume external live events start arriving without connectors. This concerns another issue: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. In the stated case—At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion—reject: Discard raw source files before checking whether transformations are repeatable. The safer response is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

C.

Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. This concerns another issue: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. In the stated case—At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion—reject: Discard raw source files before checking whether transformations are repeatable. The safer response is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

D.

Discard raw source files before checking whether transformations are repeatable. The scenario is: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The likely failure is: Engineers cannot reprocess records after discovering an error. Instead: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

Question 725

At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. Which design or Azure data approach best fits this requirement?

  1. Build an incremental ingestion path based on reliable watermarks or source change tracking.
  2. Use ELT when raw records can first land in a scalable analytical store and transformations run there.
  3. Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.
  4. Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

Answer & Explanations

Correct answer: B

A.

Build an incremental ingestion path based on reliable watermarks or source change tracking. This addresses a different situation: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. The present case is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. The relevant action here is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

B.

Use ELT when raw records can first land in a scalable analytical store and transformations run there. This works because: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data. The scenario is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. Verify the outcome by: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

C.

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 Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. The relevant action here is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

D.

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 Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. The relevant action here is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

Question 726

At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. The team proposes this approach: Use ELT when raw records can first land in a scalable analytical store and transformations run there. Which technical principle explains the choice?

  1. Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.
  2. Extract-transform-load performs transformations before storing the final warehouse-ready form.
  3. Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.
  4. Extract-load-transform separates landing from later compute in a target platform capable of processing raw data.

Answer & Explanations

Correct answer: D

A.

Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols. That explains a separate situation: At Cedarbank Logistics supervisors compare delivery counts among depots. The current case is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. The actual mechanism is: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data.

B.

Extract-transform-load performs transformations before storing the final warehouse-ready form. That explains a separate situation: At Cedarfield Finance external invoices need standard currency codes before reporting. The current case is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. The actual mechanism is: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data.

C.

Stream Analytics applies SQL-like continuous queries to configured inputs and outputs. That explains a separate situation: At Pinebrook Facilities sensors send readings to an event hub. The current case is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. The actual mechanism is: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data.

D.

Extract-load-transform separates landing from later compute in a target platform capable of processing raw data. This principle supports the intervention: Use ELT when raw records can first land in a scalable analytical store and transformations run there. The relevant scenario is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. Verify the result by: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

Question 727

At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. After implementing this approach—Use ELT when raw records can first land in a scalable analytical store and transformations run there—which result would most directly confirm success?

  1. Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.
  2. Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination.
  3. Test two fictional regional managers and confirm each can query only their permitted region.
  4. Land sample JSON files and create a queryable curated table without discarding the original files.

Answer & Explanations

Correct answer: A

A.

Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table. This tests the targeted action: Use ELT when raw records can first land in a scalable analytical store and transformations run there. The reason is: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data. The reported case is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics.

B.

Ingest a synthetic click event and confirm it appears in the designated Fabric analytics destination. This tests a separate situation: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The observed case is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. Use this acceptance check instead: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

C.

Test two fictional regional managers and confirm each can query only their permitted region. This tests a separate situation: At Cedarcrest Finance regional managers should see only their branch transactions. The observed case is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. Use this acceptance check instead: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

D.

Land sample JSON files and create a queryable curated table without discarding the original files. This tests a separate situation: At Cedarbridge Media analysts combine raw events and curated advertising tables. The observed case is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. Use this acceptance check instead: Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table.

Question 728

At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. Which shortcut most directly threatens the intended data outcome?

  1. Add an empty Fabric workspace and assume external live events start arriving without connectors.
  2. Reappend the entire transaction history each hour with no deduplication.
  3. Discard raw source files before checking whether transformations are repeatable.
  4. Assume DirectQuery has no dependency on the source system's availability or latency.

Answer & Explanations

Correct answer: C

A.

Add an empty Fabric workspace and assume external live events start arriving without connectors. This concerns another issue: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. In the stated case—At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics—reject: Discard raw source files before checking whether transformations are repeatable. The safer response is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

B.

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 Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics—reject: Discard raw source files before checking whether transformations are repeatable. The safer response is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

C.

Discard raw source files before checking whether transformations are repeatable. The scenario is: At Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics. This undermines the mechanism: Extract-load-transform separates landing from later compute in a target platform capable of processing raw data. Instead: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

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 Pinebrook Telecom data scientists retain raw usage exports before producing curated metrics—reject: Discard raw source files before checking whether transformations are repeatable. The safer response is: Use ELT when raw records can first land in a scalable analytical store and transformations run there.

Question 729

At Westport Manufacturing factory transactions feed an overnight analytics store. Which design or Azure data approach best fits this requirement?

  1. Create a Power BI semantic model with clear tables and relationships before writing executive visualizations.
  2. Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.
  3. Distinguish continuous streaming ingestion from scheduled batch imports by how promptly records must be processed.
  4. Use a star schema with fact and dimension tables for understandable report filters and aggregations.

Answer & Explanations

Correct answer: B

A.

Create a Power BI semantic model with clear tables and relationships before writing executive visualizations. This addresses a different situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The present case is: At Westport Manufacturing factory transactions feed an overnight analytics store. The relevant action here is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

B.

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

C.

Distinguish continuous streaming ingestion from scheduled batch imports by how promptly records must be processed. This addresses a different situation: At Cedarpoint Manufacturing equipment overheating requires prompt detection. The present case is: At Westport Manufacturing factory transactions feed an overnight analytics store. The relevant action here is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

D.

Use a star schema with fact and dimension tables for understandable report filters and aggregations. This addresses a different situation: At Pinecrest Retail product-category reporting relies on many transactions. The present case is: At Westport Manufacturing factory transactions feed an overnight analytics store. The relevant action here is: Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

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.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests