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 83

Question 820

At Oakfield Utilities analysts frequently report one month of meter usage. Which shortcut most directly threatens the intended data outcome?

  1. Treat an Event Hubs namespace as a permanent SQL warehouse with relational joins.
  2. Store a decade of evenly used time-series data in one undifferentiated daily-export file.
  3. Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions.
  4. Assume DirectQuery has no dependency on the source system's availability or latency.

Answer & Explanations

Correct answer: B

A.

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 Oakfield Utilities analysts frequently report one month of meter usage—reject: Store a decade of evenly used time-series data in one undifferentiated daily-export file. The safer response is: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

B.

Store a decade of evenly used time-series data in one undifferentiated daily-export file. The scenario is: At Oakfield Utilities analysts frequently report one month of meter usage. This undermines the mechanism: Partition pruning lets engines skip unrelated date segments instead of scanning all years of data. Instead: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

C.

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 Oakfield Utilities analysts frequently report one month of meter usage—reject: Store a decade of evenly used time-series data in one undifferentiated daily-export file. The safer response is: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

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 Oakfield Utilities analysts frequently report one month of meter usage—reject: Store a decade of evenly used time-series data in one undifferentiated daily-export file. The safer response is: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

Question 821

At Pinebridge Commerce marketing queries recent campaign performance by date. Which design or Azure data approach best fits this requirement?

  1. Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
  2. Distinguish continuous streaming ingestion from scheduled batch imports by how promptly records must be processed.
  3. Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.
  4. Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

Answer & Explanations

Correct answer: C

A.

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 Pinebridge Commerce marketing queries recent campaign performance by date. The relevant action here is: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

B.

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 Pinebridge Commerce marketing queries recent campaign performance by date. The relevant action here is: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

C.

Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it. This works because: Partition pruning lets engines skip unrelated date segments instead of scanning all years of data. The scenario is: At Pinebridge Commerce marketing queries recent campaign performance by date. Verify the outcome by: Query one synthetic month from several years of data and inspect which partitions were read.

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 Pinebridge Commerce marketing queries recent campaign performance by date. The relevant action here is: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

Question 822

At Pinebridge Commerce marketing queries recent campaign performance by date. The team proposes this approach: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it. Which technical principle explains the choice?

  1. Fabric Data Factory integrates pipeline and dataflow experiences with the platform's analytical assets and workspaces.
  2. Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.
  3. Partition pruning lets engines skip unrelated date segments instead of scanning all years of data.
  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.

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 Pinebridge Commerce marketing queries recent campaign performance by date. The actual mechanism is: Partition pruning lets engines skip unrelated date segments instead of scanning all years of data.

B.

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 Pinebridge Commerce marketing queries recent campaign performance by date. The actual mechanism is: Partition pruning lets engines skip unrelated date segments instead of scanning all years of data.

C.

Partition pruning lets engines skip unrelated date segments instead of scanning all years of data. This principle supports the intervention: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it. The relevant scenario is: At Pinebridge Commerce marketing queries recent campaign performance by date. Verify the result by: Query one synthetic month from several years of data and inspect which partitions were read.

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 Pinebridge Commerce marketing queries recent campaign performance by date. The actual mechanism is: Partition pruning lets engines skip unrelated date segments instead of scanning all years of data.

Question 823

At Pinebridge Commerce marketing queries recent campaign performance by date. After implementing this approach—Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it—which result would most directly confirm success?

  1. Update a synthetic source record and verify the report reflects it after a configured refresh.
  2. Query one synthetic month from several years of data and inspect which partitions were read.
  3. Transform a fictional multi-file dataset in a test Spark job and confirm partitioned output counts.
  4. Send synthetic device readings and compare event-to-dashboard delay under both processing designs.

Answer & Explanations

Correct answer: B

A.

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 Pinebridge Commerce marketing queries recent campaign performance by date. Use this acceptance check instead: Query one synthetic month from several years of data and inspect which partitions were read.

B.

Query one synthetic month from several years of data and inspect which partitions were read. This tests the targeted action: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it. The reason is: Partition pruning lets engines skip unrelated date segments instead of scanning all years of data. The reported case is: At Pinebridge Commerce marketing queries recent campaign performance by date.

C.

Transform a fictional multi-file dataset in a test Spark job and confirm partitioned output counts. This tests a separate situation: At Harborland Energy billions of sensor readings require transformation. The observed case is: At Pinebridge Commerce marketing queries recent campaign performance by date. Use this acceptance check instead: Query one synthetic month from several years of data and inspect which partitions were read.

D.

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 Pinebridge Commerce marketing queries recent campaign performance by date. Use this acceptance check instead: Query one synthetic month from several years of data and inspect which partitions were read.

Question 824

At Pinebridge Commerce marketing queries recent campaign performance by date. Which shortcut most directly threatens the intended data outcome?

  1. Store a decade of evenly used time-series data in one undifferentiated daily-export file.
  2. Share one destructive manual cursor between unrelated alerting and archival applications.
  3. Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row.
  4. Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted.

Answer & Explanations

Correct answer: A

A.

Store a decade of evenly used time-series data in one undifferentiated daily-export file. The scenario is: At Pinebridge Commerce marketing queries recent campaign performance by date. This undermines the mechanism: Partition pruning lets engines skip unrelated date segments instead of scanning all years of data. Instead: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

B.

Share one destructive manual cursor between unrelated alerting and archival applications. This concerns another issue: At Oakcrest Mobility live tracking and reporting consume the same event source. In the stated case—At Pinebridge Commerce marketing queries recent campaign performance by date—reject: Store a decade of evenly used time-series data in one undifferentiated daily-export file. The safer response is: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

C.

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 Pinebridge Commerce marketing queries recent campaign performance by date—reject: Store a decade of evenly used time-series data in one undifferentiated daily-export file. The safer response is: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

D.

Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. This concerns another issue: At Cedarcrest Finance regional managers should see only their branch transactions. In the stated case—At Pinebridge Commerce marketing queries recent campaign performance by date—reject: Store a decade of evenly used time-series data in one undifferentiated daily-export file. The safer response is: Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.

Question 825

At Cedarcrest Banking financial metrics require stable audit evidence. Which design or Azure data approach best fits this requirement?

  1. Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.
  2. Build an incremental ingestion path based on reliable watermarks or source change tracking.
  3. Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.
  4. Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

Answer & Explanations

Correct answer: A

A.

Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. This works because: Version and lineage records connect an analytical result to its source and processing logic at a point in time. The scenario is: At Cedarcrest Banking financial metrics require stable audit evidence. Verify the outcome by: Recompute a fictional quarter's metric using the documented dataset version and compare totals.

B.

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 Cedarcrest Banking financial metrics require stable audit evidence. The relevant action here is: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

C.

Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. This addresses a different situation: At Pinebrook Facilities sensors send readings to an event hub. The present case is: At Cedarcrest Banking financial metrics require stable audit evidence. The relevant action here is: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

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 Cedarcrest Banking financial metrics require stable audit evidence. The relevant action here is: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

Question 826

At Cedarcrest Banking financial metrics require stable audit evidence. The team proposes this approach: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. Which technical principle explains the choice?

  1. Import caches data in the Power BI model and requires refresh to reflect changed source rows.
  2. A hot streaming path reacts promptly while the cold path can consolidate history for deeper analysis.
  3. Separating bad records protects curated datasets while retaining evidence for correction and replay.
  4. Version and lineage records connect an analytical result to its source and processing logic at a point in time.

Answer & Explanations

Correct answer: D

A.

Import caches data in the Power BI model and requires refresh to reflect changed source rows. That explains a separate situation: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The current case is: At Cedarcrest Banking financial metrics require stable audit evidence. The actual mechanism is: Version and lineage records connect an analytical result to its source and processing logic at a point in time.

B.

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 Cedarcrest Banking financial metrics require stable audit evidence. The actual mechanism is: Version and lineage records connect an analytical result to its source and processing logic at a point in time.

C.

Separating bad records protects curated datasets while retaining evidence for correction and replay. That explains a separate situation: At Meadowfield Retail some supplier feeds contain negative quantities. The current case is: At Cedarcrest Banking financial metrics require stable audit evidence. The actual mechanism is: Version and lineage records connect an analytical result to its source and processing logic at a point in time.

D.

Version and lineage records connect an analytical result to its source and processing logic at a point in time. This principle supports the intervention: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. The relevant scenario is: At Cedarcrest Banking financial metrics require stable audit evidence. Verify the result by: Recompute a fictional quarter's metric using the documented dataset version and compare totals.

Question 827

At Cedarcrest Banking financial metrics require stable audit evidence. After implementing this approach—Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports—which result would most directly confirm success?

  1. Publish synthetic events, consume them through a test consumer group and verify offsets advance.
  2. Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
  3. Recompute a fictional quarter's metric using the documented dataset version and compare totals.
  4. Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

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 Cedarcrest Banking financial metrics require stable audit evidence. Use this acceptance check instead: Recompute a fictional quarter's metric using the documented dataset version and compare totals.

B.

Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table. This tests a separate situation: At Cedarfield Finance external invoices need standard currency codes before reporting. The observed case is: At Cedarcrest Banking financial metrics require stable audit evidence. Use this acceptance check instead: Recompute a fictional quarter's metric using the documented dataset version and compare totals.

C.

Recompute a fictional quarter's metric using the documented dataset version and compare totals. This tests the targeted action: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. The reason is: Version and lineage records connect an analytical result to its source and processing logic at a point in time. The reported case is: At Cedarcrest Banking financial metrics require stable audit evidence.

D.

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 Cedarcrest Banking financial metrics require stable audit evidence. Use this acceptance check instead: Recompute a fictional quarter's metric using the documented dataset version and compare totals.

Question 828

At Cedarcrest Banking financial metrics require stable audit evidence. Which shortcut most directly threatens the intended data outcome?

  1. Overwrite transformations without a change record while claiming prior KPI totals are reproducible.
  2. Expect a static imported dataset to show each operational write instantly without refresh.
  3. Treat each retransmission as a brand-new purchase.
  4. Assume creating a Power BI chart automatically ingests all missing source history into Fabric.

Answer & Explanations

Correct answer: A

A.

Overwrite transformations without a change record while claiming prior KPI totals are reproducible. The scenario is: At Cedarcrest Banking financial metrics require stable audit evidence. This undermines the mechanism: Version and lineage records connect an analytical result to its source and processing logic at a point in time. Instead: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

B.

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 Cedarcrest Banking financial metrics require stable audit evidence—reject: Overwrite transformations without a change record while claiming prior KPI totals are reproducible. The safer response is: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

C.

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 Cedarcrest Banking financial metrics require stable audit evidence—reject: Overwrite transformations without a change record while claiming prior KPI totals are reproducible. The safer response is: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

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 Cedarcrest Banking financial metrics require stable audit evidence—reject: Overwrite transformations without a change record while claiming prior KPI totals are reproducible. The safer response is: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

Question 829

At Silverfield Healthcare approved clinical reports need documented data provenance. Which design or Azure data approach best fits this requirement?

  1. Choose event partitions and consumer groups to scale ingestion and allow independent downstream applications.
  2. Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.
  3. Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.
  4. Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

Answer & Explanations

Correct answer: D

A.

Choose event partitions and consumer groups to scale ingestion and allow independent downstream applications. This addresses a different situation: At Oakcrest Mobility live tracking and reporting consume the same event source. The present case is: At Silverfield Healthcare approved clinical reports need documented data provenance. The relevant action here is: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

B.

Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable. This addresses a different situation: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The present case is: At Silverfield Healthcare approved clinical reports need documented data provenance. The relevant action here is: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

C.

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 Silverfield Healthcare approved clinical reports need documented data provenance. The relevant action here is: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

D.

Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. This works because: Version and lineage records connect an analytical result to its source and processing logic at a point in time. The scenario is: At Silverfield Healthcare approved clinical reports need documented data provenance. Verify the outcome by: Recompute a fictional quarter's metric using the documented dataset version and compare totals.

Question 830

At Silverfield Healthcare approved clinical reports need documented data provenance. The team proposes this approach: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. Which technical principle explains the choice?

  1. Larger batch jobs can be efficient but delay availability, so cadence must match business SLAs.
  2. A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.
  3. Windowed streaming computations aggregate events over bounded time intervals as new data arrives.
  4. Version and lineage records connect an analytical result to its source and processing logic at a point in time.

Answer & Explanations

Correct answer: D

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 Silverfield Healthcare approved clinical reports need documented data provenance. The actual mechanism is: Version and lineage records connect an analytical result to its source and processing logic at a point in time.

B.

A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh. That explains a separate situation: At Silverlake Services managers compare revenue by selected region. The current case is: At Silverfield Healthcare approved clinical reports need documented data provenance. The actual mechanism is: Version and lineage records connect an analytical result to its source and processing logic at a point in time.

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 Silverfield Healthcare approved clinical reports need documented data provenance. The actual mechanism is: Version and lineage records connect an analytical result to its source and processing logic at a point in time.

D.

Version and lineage records connect an analytical result to its source and processing logic at a point in time. This principle supports the intervention: Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. The relevant scenario is: At Silverfield Healthcare approved clinical reports need documented data provenance. Verify the result by: Recompute a fictional quarter's metric using the documented dataset version and compare totals.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests