cert
cert-1
cert-2

Pass Microsoft DP-900 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
DP-900 Exam - Verified By Experts
DP-900 Premium Bundle
$29.98

DP-900 Premium Bundle

$79.99
$109.97
  • Premium File 332 Questions & Answers. Last update: Nov 13, 2026
  • Training Course 32 Video Lectures
  • Study Guide 672 Pages
 
$109.97
$79.99
accept 21 downloads in last 7 days
block-screenshots
Purchase Microsoft DP-900 Exam Training Products Individually
Microsoft DP-900 Premium File
Premium File 332 Q&A
$76.99$69.99
Microsoft DP-900 Video Training Course
Training Course 32 Lectures
$21.99 $19.99
Microsoft DP-900 PDF Study Guide
Study Guide 672 Pages
$21.99 $19.99
Microsoft DP-900 Practice Test 61

Question 600

An on-premises SQL source must feed a cloud-hosted Power BI semantic model. If the relevant Power BI scheduled refresh and gateway safeguard is skipped, which failure is MOST directly associated with that omission?

  1. Publishing a report does not guarantee the local source is reachable.
  2. Untracked library updates can make a previous transformation nonreproducible.
  3. Treating dates as unordered labels can scramble a trend.
  4. Expecting Event Hubs alone to run joins and produce Power BI measures is incorrect.

Explanation

Correct Answer

A:

Publishing a report does not guarantee the local source is reachable. Gateways bridge supported private sources for managed cloud refresh workflows. A suitable check is to inspect gateway connection refresh history and credential state.

Incorrect Answers

B:

Untracked library updates can make a previous transformation nonreproducible. This failure is associated with Databricks collaborative notebooks; it is not the primary failure in the stated Power BI scheduled refresh and gateway scenario. Gateways bridge supported private sources for managed cloud refresh workflows.

C:

Treating dates as unordered labels can scramble a trend. This failure is associated with Line chart time-series selection; it is not the primary failure in the stated Power BI scheduled refresh and gateway scenario. Gateways bridge supported private sources for managed cloud refresh workflows.

D:

Expecting Event Hubs alone to run joins and produce Power BI measures is incorrect. This failure is associated with Azure Event Hubs event ingestion; it is not the primary failure in the stated Power BI scheduled refresh and gateway scenario. Gateways bridge supported private sources for managed cloud refresh workflows.

Question 601

An event stream includes sensor spikes caused by occasional faulty readings. Which principle BEST explains the correct Streaming anomaly detection and false positives design decision?

  1. Power BI Desktop is an authoring tool for data modeling and reports.
  2. Event Hubs is a streaming ingestion service not a relational analytics database.
  3. Measures express aggregations in a shared semantic context.
  4. Real-time anomalies require context quality and sensitivity tuning.

Explanation

Correct Answer

D:

Real-time anomalies require context quality and sensitivity tuning. In this case the applicable decision is to apply a justified real-time anomaly rule with quality checks and alert thresholds.

Incorrect Answers

A:

Power BI Desktop is an authoring tool for data modeling and reports. That concept explains Power BI Desktop data import; the situation instead concerns Streaming anomaly detection and false positives. Triggering on every raw outlier can overwhelm incident responders.

B:

Event Hubs is a streaming ingestion service not a relational analytics database. That concept explains Azure Event Hubs event ingestion; the situation instead concerns Streaming anomaly detection and false positives. Triggering on every raw outlier can overwhelm incident responders.

C:

Measures express aggregations in a shared semantic context. That concept explains Power BI semantic model measures; the situation instead concerns Streaming anomaly detection and false positives. Triggering on every raw outlier can overwhelm incident responders.

Question 602

A small team wants managed MySQL hosting instead of patching a VM database. Which principle BEST explains the correct Azure MySQL versus PostgreSQL service-model selection design decision?

  1. ELT shifts transformation to the destination processing platform.
  2. Predictive analytics estimates likely future outcomes from patterns.
  3. Managed open-source database services retain engine-specific behavior.
  4. ADLS Gen2 adds data-lake semantics on Azure Blob storage.

Explanation

Correct Answer

C:

Managed open-source database services retain engine-specific behavior. In this case the applicable decision is to choose Azure Database for MySQL Flexible Server for supported MySQL workloads.

Incorrect Answers

A:

ELT shifts transformation to the destination processing platform. That concept explains ELT load then transform in engine; the situation instead concerns Azure MySQL versus PostgreSQL service-model selection. Moving directly to a different engine without migration assessment risks SQL incompatibility.

B:

Predictive analytics estimates likely future outcomes from patterns. That concept explains Predictive analytics forecasts; the situation instead concerns Azure MySQL versus PostgreSQL service-model selection. Moving directly to a different engine without migration assessment risks SQL incompatibility.

D:

ADLS Gen2 adds data-lake semantics on Azure Blob storage. That concept explains Azure Data Lake Storage Gen2 analytics landing; the situation instead concerns Azure MySQL versus PostgreSQL service-model selection. Moving directly to a different engine without migration assessment risks SQL incompatibility.

Question 603

A budget has four mutually exclusive spending categories totaling 100 percent. Which choice BEST meets this requirement?

  1. Use OneLake as the shared logical data-lake foundation for supported Fabric workloads.
  2. Use a pie chart to display overlapping groups that together exceed the whole.
  3. Use a slicer configured with the intended field and report interactions.
  4. Use a pie or donut only when meaningful proportions have few categories.

Explanation

Correct Answer

D:

Use a pie or donut only when meaningful proportions have few categories. Pie-like charts express part-to-whole composition. In the stated case, verification should show that slices sum to the intended whole and readers can compare shares.

Incorrect Answers

A:

Use OneLake as the shared logical data-lake foundation for supported Fabric workloads. That action primarily handles Microsoft Fabric OneLake unified storage; the given requirement is Pie donut chart proportion caution. Pie-like charts express part-to-whole composition.

B:

Use a pie chart to display overlapping groups that together exceed the whole. It does not implement Pie donut chart proportion caution. Many similar tiny slices make comparisons difficult.

C:

Use a slicer configured with the intended field and report interactions. That action primarily handles Slicer interactive filter; the given requirement is Pie donut chart proportion caution. Pie-like charts express part-to-whole composition.

Question 604

Analysts want data accessible to lakehouse warehouse and BI experiences. What is the MOST appropriate next validation or correction?

  1. Check workspace and OneLake access from representative users.
  2. Test unique keys and count fact matches per dimension row.
  3. Rename an Azure Files share OneLake and claim it automatically joins Fabric.
  4. Reconcile moved byte counts and source query rows.

Explanation

Correct Answer

A:

Check workspace and OneLake access from representative users. This tests the intended result: authorized experiences reach governed data without arbitrary independent file copies.

Incorrect Answers

B:

Test unique keys and count fact matches per dimension row. It tests One-to-many semantic relationships rather than the critical Microsoft Fabric OneLake unified storage behavior. OneLake unifies data access across Fabric but permissions and organization still matter.

C:

Rename an Azure Files share OneLake and claim it automatically joins Fabric. This unsafe shortcut leaves the Microsoft Fabric OneLake unified storage problem unresolved. Assuming one lake makes every file publicly readable risks information exposure.

D:

Reconcile moved byte counts and source query rows. It tests Azure Data Factory Copy Activity rather than the critical Microsoft Fabric OneLake unified storage behavior. OneLake unifies data access across Fabric but permissions and organization still matter.

Question 605

An API payload contains a customer object with an array of delivery addresses. After selecting the proper JSON arrays and nested objects approach, which observation gives the clearest evidence of success?

  1. Nested lookups return the right address and amount without misreading sibling values.
  2. Downstream stages start only after successful prerequisites.
  3. Data can be queried through compatible lakehouse engines while source files remain accessible.
  4. Images are retrieved without pretending their visual content is already tabular data.

Explanation

Correct Answer

A:

Nested lookups return the right address and amount without misreading sibling values. This is the directly observable result for JSON arrays and nested objects; jSON arrays hold ordered elements whereas objects group named properties.

Incorrect Answers

B:

Downstream stages start only after successful prerequisites. This supports Data engineer orchestration dependencies, not confirmation of JSON arrays and nested objects. The relevant evidence is that nested lookups return the right address and amount without misreading sibling values.

C:

Data can be queried through compatible lakehouse engines while source files remain accessible. This supports Lakehouse for files plus SQL analytics, not confirmation of JSON arrays and nested objects. The relevant evidence is that nested lookups return the right address and amount without misreading sibling values.

D:

Images are retrieved without pretending their visual content is already tabular data. This supports Unstructured image binary files, not confirmation of JSON arrays and nested objects. The relevant evidence is that nested lookups return the right address and amount without misreading sibling values.

Question 606

A payment API must respond within 100 milliseconds while a loader moves terabytes nightly. After selecting the proper Operational SLA latency versus throughput approach, which observation gives the clearest evidence of success?

  1. New readings trigger timely results within defined event latency.
  2. Both service response and bulk movement meet their distinct targets.
  3. Both old and new clients work during the agreed transition period.
  4. PDF retrieval and metadata filtering both meet functional requirements.

Explanation

Correct Answer

B:

Both service response and bulk movement meet their distinct targets. This is the directly observable result for Operational SLA latency versus throughput; latency measures time per operation; throughput measures completed work rate.

Incorrect Answers

A:

New readings trigger timely results within defined event latency. This supports Event streaming continual processing, not confirmation of Operational SLA latency versus throughput. The relevant evidence is that both service response and bulk movement meet their distinct targets.

C:

Both old and new clients work during the agreed transition period. This supports DBA schema migration oversight, not confirmation of Operational SLA latency versus throughput. The relevant evidence is that both service response and bulk movement meet their distinct targets.

D:

PDF retrieval and metadata filtering both meet functional requirements. This supports File store versus database selection, not confirmation of Operational SLA latency versus throughput. The relevant evidence is that both service response and bulk movement meet their distinct targets.

Question 607

A dashboard shows conflicting net revenue totals across reports. Which principle BEST explains the correct Data analyst metric definition design decision?

  1. Data engineers maintain resilient transformations when source structures change.
  2. File storage and searchable record databases serve different access patterns.
  3. Columnar formats can reduce I/O for analytical scans over selected fields.
  4. Data analysts define and test business measures rather than only placing visuals.

Explanation

Correct Answer

D:

Data analysts define and test business measures rather than only placing visuals. In this case the applicable decision is to establish shared metric definitions and validate semantic calculations.

Incorrect Answers

A:

Data engineers maintain resilient transformations when source structures change. That concept explains Data engineer schema and format changes; the situation instead concerns Data analyst metric definition. Uncontrolled measure definitions create contradictory dashboards.

B:

File storage and searchable record databases serve different access patterns. That concept explains File store versus database selection; the situation instead concerns Data analyst metric definition. Uncontrolled measure definitions create contradictory dashboards.

C:

Columnar formats can reduce I/O for analytical scans over selected fields. That concept explains Parquet columnar analytical file; the situation instead concerns Data analyst metric definition. Uncontrolled measure definitions create contradictory dashboards.

Question 608

A manager asks whether stockouts or slower checkout caused the drop. What is the MOST appropriate next validation or correction?

  1. Assume a bar chart proves the causal effect of every category label.
  2. Test quoting newline and header handling using sample records.
  3. Check cohort data and alternative explanations for the decline.
  4. Validate raw-versus-curated reconciliation and transformation lineage.

Explanation

Correct Answer

C:

Check cohort data and alternative explanations for the decline. This tests the intended result: one report states what happened while another tests why.

Incorrect Answers

A:

Assume a bar chart proves the causal effect of every category label. This unsafe shortcut leaves the Descriptive versus diagnostic analytics problem unresolved. Calling a trend description a proven cause can mislead decisions.

B:

Test quoting newline and header handling using sample records. It tests CSV delimited text schema rather than the critical Descriptive versus diagnostic analytics behavior. Descriptive analytics summarizes history; diagnostic analytics explores causes.

D:

Validate raw-versus-curated reconciliation and transformation lineage. It tests ELT load then transform in engine rather than the critical Descriptive versus diagnostic analytics behavior. Descriptive analytics summarizes history; diagnostic analytics explores causes.

Question 609

A regulator asks how a report total was derived. What is the MOST appropriate next validation or correction?

  1. Trace a sample metric through source files and transformation jobs.
  2. Test SQL queries transaction rollback and service configuration.
  3. Assume naming a column Certified automatically records its provenance.
  4. Compare target counts and rejected records with source files.

Explanation

Correct Answer

A:

Trace a sample metric through source files and transformation jobs. This tests the intended result: reviewers trace a reported measure back to approved inputs and rules.

Incorrect Answers

B:

Test SQL queries transaction rollback and service configuration. It tests Azure SQL Database managed relational app rather than the critical Data lineage from source to report behavior. Lineage makes analytical values accountable across processing stages.

C:

Assume naming a column Certified automatically records its provenance. This unsafe shortcut leaves the Data lineage from source to report problem unresolved. Lacking transform history prevents root-cause analysis of bad metrics.

D:

Compare target counts and rejected records with source files. It tests ETL data transformation before loading rather than the critical Data lineage from source to report behavior. Lineage makes analytical values accountable across processing stages.

Question 610

A collection frequently filters by nested order status. If the relevant Cosmos DB NoSQL indexing and queries safeguard is skipped, which failure is MOST directly associated with that omission?

  1. Replacing SMB mounts with blob URLs without application changes breaks path expectations.
  2. Excessive indexing or scans may inflate RU consumption.
  3. Assuming replication alone creates object history can leave no recoverable version.
  4. One hot key can throttle even when account capacity is increased.

Explanation

Correct Answer

B:

Excessive indexing or scans may inflate RU consumption. Indexed document properties support queries while policy affects write/read cost. A suitable check is to compare query metrics and representative documents before tuning.

Incorrect Answers

A:

Replacing SMB mounts with blob URLs without application changes breaks path expectations. This failure is associated with Azure Files SMB application migration; it is not the primary failure in the stated Cosmos DB NoSQL indexing and queries scenario. Indexed document properties support queries while policy affects write/read cost.

C:

Assuming replication alone creates object history can leave no recoverable version. This failure is associated with Blob versioning on overwrite; it is not the primary failure in the stated Cosmos DB NoSQL indexing and queries scenario. Indexed document properties support queries while policy affects write/read cost.

D:

One hot key can throttle even when account capacity is increased. This failure is associated with Cosmos DB logical partition key; it is not the primary failure in the stated Cosmos DB NoSQL indexing and queries scenario. Indexed document properties support queries while policy affects write/read cost.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests