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 99

Question 980

At Pinewood Retail analysts compare campaign spend with customer acquisitions. Which shortcut most directly threatens the intended data outcome?

  1. Use a pie chart to prove one numeric factor causes another.
  2. Calculate a 'last five minutes' alert from a table refreshed once per day.
  3. Present categories as an unlabeled geographic heatmap with no location meaning.
  4. Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake.

Answer & Explanations

Correct answer: A

A.

Use a pie chart to prove one numeric factor causes another. The scenario is: At Pinewood Retail analysts compare campaign spend with customer acquisitions. This undermines the mechanism: Each point shows paired numeric values and can reveal patterns or outliers without implying causation. Instead: Use a scatter plot when exploring whether two quantitative variables have an association.

B.

Calculate a 'last five minutes' alert from a table refreshed once per day. This concerns another issue: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. In the stated case—At Pinewood Retail analysts compare campaign spend with customer acquisitions—reject: Use a pie chart to prove one numeric factor causes another. The safer response is: Use a scatter plot when exploring whether two quantitative variables have an association.

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 Pinewood Retail analysts compare campaign spend with customer acquisitions—reject: Use a pie chart to prove one numeric factor causes another. The safer response is: Use a scatter plot when exploring whether two quantitative variables have an association.

D.

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 Pinewood Retail analysts compare campaign spend with customer acquisitions—reject: Use a pie chart to prove one numeric factor causes another. The safer response is: Use a scatter plot when exploring whether two quantitative variables have an association.

Question 981

At Silverlake Science researchers examine temperature versus energy consumption. Which design or Azure data approach best fits this requirement?

  1. Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.
  2. Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.
  3. Use a scatter plot when exploring whether two quantitative variables have an association.
  4. Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports.

Answer & Explanations

Correct answer: C

A.

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 Silverlake Science researchers examine temperature versus energy consumption. The relevant action here is: Use a scatter plot when exploring whether two quantitative variables have an association.

B.

Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. This addresses a different situation: At Meadowport Media analysts inspect daily subscription signups. The present case is: At Silverlake Science researchers examine temperature versus energy consumption. The relevant action here is: Use a scatter plot when exploring whether two quantitative variables have an association.

C.

Use a scatter plot when exploring whether two quantitative variables have an association. This works because: Each point shows paired numeric values and can reveal patterns or outliers without implying causation. The scenario is: At Silverlake Science researchers examine temperature versus energy consumption. Verify the outcome by: Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims.

D.

Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. This addresses a different situation: At Cedarcrest Banking financial metrics require stable audit evidence. The present case is: At Silverlake Science researchers examine temperature versus energy consumption. The relevant action here is: Use a scatter plot when exploring whether two quantitative variables have an association.

Question 982

At Silverlake Science researchers examine temperature versus energy consumption. The team proposes this approach: Use a scatter plot when exploring whether two quantitative variables have an association. Which technical principle explains the choice?

  1. Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.
  2. Separating bad records protects curated datasets while retaining evidence for correction and replay.
  3. A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.
  4. Each point shows paired numeric values and can reveal patterns or outliers without implying causation.

Answer & Explanations

Correct answer: D

A.

Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. That explains a separate situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The current case is: At Silverlake Science researchers examine temperature versus energy consumption. The actual mechanism is: Each point shows paired numeric values and can reveal patterns or outliers without implying causation.

B.

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 Silverlake Science researchers examine temperature versus energy consumption. The actual mechanism is: Each point shows paired numeric values and can reveal patterns or outliers without implying causation.

C.

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 Silverlake Science researchers examine temperature versus energy consumption. The actual mechanism is: Each point shows paired numeric values and can reveal patterns or outliers without implying causation.

D.

Each point shows paired numeric values and can reveal patterns or outliers without implying causation. This principle supports the intervention: Use a scatter plot when exploring whether two quantitative variables have an association. The relevant scenario is: At Silverlake Science researchers examine temperature versus energy consumption. Verify the result by: Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims.

Question 983

At Silverlake Science researchers examine temperature versus energy consumption. After implementing this approach—Use a scatter plot when exploring whether two quantitative variables have an association—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. Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims.
  4. Run two test consumer groups and confirm each sees the intended events without resetting the other's offset.

Answer & Explanations

Correct answer: C

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 Silverlake Science researchers examine temperature versus energy consumption. Use this acceptance check instead: Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims.

B.

Query one synthetic month from several years of data and inspect which partitions were read. This tests a separate situation: At Oakfield Utilities analysts frequently report one month of meter usage. The observed case is: At Silverlake Science researchers examine temperature versus energy consumption. Use this acceptance check instead: Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims.

C.

Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims. This tests the targeted action: Use a scatter plot when exploring whether two quantitative variables have an association. The reason is: Each point shows paired numeric values and can reveal patterns or outliers without implying causation. The reported case is: At Silverlake Science researchers examine temperature versus energy consumption.

D.

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 Silverlake Science researchers examine temperature versus energy consumption. Use this acceptance check instead: Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims.

Question 984

At Silverlake Science researchers examine temperature versus energy consumption. Which shortcut most directly threatens the intended data outcome?

  1. Run only a nightly file import for a stated subminute safety alert requirement.
  2. Use a pie chart to prove one numeric factor causes another.
  3. Reappend the entire transaction history each hour with no deduplication.
  4. Present categories as an unlabeled geographic heatmap with no location meaning.

Answer & Explanations

Correct answer: B

A.

Run only a nightly file import for a stated subminute safety alert requirement. This concerns another issue: At Cedarpoint Manufacturing equipment overheating requires prompt detection. In the stated case—At Silverlake Science researchers examine temperature versus energy consumption—reject: Use a pie chart to prove one numeric factor causes another. The safer response is: Use a scatter plot when exploring whether two quantitative variables have an association.

B.

Use a pie chart to prove one numeric factor causes another. The scenario is: At Silverlake Science researchers examine temperature versus energy consumption. This undermines the mechanism: Each point shows paired numeric values and can reveal patterns or outliers without implying causation. Instead: Use a scatter plot when exploring whether two quantitative variables have an association.

C.

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 Silverlake Science researchers examine temperature versus energy consumption—reject: Use a pie chart to prove one numeric factor causes another. The safer response is: Use a scatter plot when exploring whether two quantitative variables have an association.

D.

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 Silverlake Science researchers examine temperature versus energy consumption—reject: Use a pie chart to prove one numeric factor causes another. The safer response is: Use a scatter plot when exploring whether two quantitative variables have an association.

Question 985

At Cedarcrest Finance regional managers should see only their branch transactions. Which design or Azure data approach best fits this requirement?

  1. Make ingestion transformations idempotent by using stable business keys when retrying failed batches.
  2. Apply Power BI row-level security when different users should see only their permitted records.
  3. Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.
  4. Separate real-time alert processing from slower historical archival so urgent actions do not wait for nightly warehousing.

Answer & Explanations

Correct answer: B

A.

Make ingestion transformations idempotent by using stable business keys when retrying failed batches. This addresses a different situation: At Silverbrook Logistics pipelines reattempt delayed shipment messages. The present case is: At Cedarcrest Finance regional managers should see only their branch transactions. The relevant action here is: Apply Power BI row-level security when different users should see only their permitted records.

B.

Apply Power BI row-level security when different users should see only their permitted records. This works because: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. The scenario is: At Cedarcrest Finance regional managers should see only their branch transactions. Verify the outcome by: Test two fictional regional managers and confirm each can query only their permitted region.

C.

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 Cedarcrest Finance regional managers should see only their branch transactions. The relevant action here is: Apply Power BI row-level security when different users should see only their permitted records.

D.

Separate real-time alert processing from slower historical archival so urgent actions do not wait for nightly warehousing. This addresses a different situation: At Pineport Healthcare medical equipment signals abnormal temperatures. The present case is: At Cedarcrest Finance regional managers should see only their branch transactions. The relevant action here is: Apply Power BI row-level security when different users should see only their permitted records.

Question 986

At Cedarcrest Finance regional managers should see only their branch transactions. The team proposes this approach: Apply Power BI row-level security when different users should see only their permitted records. Which technical principle explains the choice?

  1. A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately.
  2. Model relationships propagate filter context between related tables according to direction and cardinality.
  3. RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.
  4. Larger batch jobs can be efficient but delay availability, so cadence must match business SLAs.

Answer & Explanations

Correct answer: C

A.

A bounded event retention period permits eligible consumers to resume from offsets without requiring the producer to resend immediately. That explains a separate situation: At Harborcrest Logistics a tracking processor is offline during a deployment. The current case is: At Cedarcrest Finance regional managers should see only their branch transactions. The actual mechanism is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

B.

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 Cedarcrest Finance regional managers should see only their branch transactions. The actual mechanism is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

C.

RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. This principle supports the intervention: Apply Power BI row-level security when different users should see only their permitted records. The relevant scenario is: At Cedarcrest Finance regional managers should see only their branch transactions. Verify the result by: Test two fictional regional managers and confirm each can query only their permitted region.

D.

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 Cedarcrest Finance regional managers should see only their branch transactions. The actual mechanism is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

Question 987

At Cedarcrest Finance regional managers should see only their branch transactions. After implementing this approach—Apply Power BI row-level security when different users should see only their permitted records—which result would most directly confirm success?

  1. Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims.
  2. Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading.
  3. Test two fictional regional managers and confirm each can query only their permitted region.
  4. Replay a fictional event with the same ID and confirm the sink counts it only once.

Answer & Explanations

Correct answer: C

A.

Plot fictional advertising spend against sales and identify an outlier while avoiding causal claims. This tests a separate situation: At Pinewood Retail analysts compare campaign spend with customer acquisitions. The observed case is: At Cedarcrest Finance regional managers should see only their branch transactions. Use this acceptance check instead: Test two fictional regional managers and confirm each can query only their permitted region.

B.

Run a synthetic failed source connection and confirm a retry or failure alert is recorded without double loading. This tests a separate situation: At Westport Manufacturing factory transactions feed an overnight analytics store. The observed case is: At Cedarcrest Finance regional managers should see only their branch transactions. Use this acceptance check instead: Test two fictional regional managers and confirm each can query only their permitted region.

C.

Test two fictional regional managers and confirm each can query only their permitted region. This tests the targeted action: Apply Power BI row-level security when different users should see only their permitted records. The reason is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. The reported case is: At Cedarcrest Finance regional managers should see only their branch transactions.

D.

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 Cedarcrest Finance regional managers should see only their branch transactions. Use this acceptance check instead: Test two fictional regional managers and confirm each can query only their permitted region.

Question 988

At Cedarcrest Finance regional managers should see only their branch transactions. Which shortcut most directly threatens the intended data outcome?

  1. Treat an Event Hubs namespace as a permanent SQL warehouse with relational joins.
  2. Discard raw source files before checking whether transformations are repeatable.
  3. Use a pie chart to prove one numeric factor causes another.
  4. Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted.

Answer & Explanations

Correct answer: D

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 Cedarcrest Finance regional managers should see only their branch transactions—reject: Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. The safer response is: Apply Power BI row-level security when different users should see only their permitted records.

B.

Discard raw source files before checking whether transformations are repeatable. This concerns another issue: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. In the stated case—At Cedarcrest Finance regional managers should see only their branch transactions—reject: Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. The safer response is: Apply Power BI row-level security when different users should see only their permitted records.

C.

Use a pie chart to prove one numeric factor causes another. This concerns another issue: At Pinewood Retail analysts compare campaign spend with customer acquisitions. In the stated case—At Cedarcrest Finance regional managers should see only their branch transactions—reject: Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. The safer response is: Apply Power BI row-level security when different users should see only their permitted records.

D.

Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. The scenario is: At Cedarcrest Finance regional managers should see only their branch transactions. The likely failure is: Unauthorized users may still query protected records. Instead: Apply Power BI row-level security when different users should see only their permitted records.

Question 989

At Meadowfield Healthcare clinic analysts must not access other sites' records. 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. Apply Power BI row-level security when different users should see only their permitted records.
  3. Choose a bar chart for comparing distinct categories with a common quantitative scale.
  4. Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.

Answer & Explanations

Correct answer: B

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 Meadowfield Healthcare clinic analysts must not access other sites' records. The relevant action here is: Apply Power BI row-level security when different users should see only their permitted records.

B.

Apply Power BI row-level security when different users should see only their permitted records. This works because: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. The scenario is: At Meadowfield Healthcare clinic analysts must not access other sites' records. Verify the outcome by: Test two fictional regional managers and confirm each can query only their permitted region.

C.

Choose a bar chart for comparing distinct categories with a common quantitative scale. This addresses a different situation: At Cedarbank Logistics supervisors compare delivery counts among depots. The present case is: At Meadowfield Healthcare clinic analysts must not access other sites' records. The relevant action here is: Apply Power BI row-level security when different users should see only their permitted records.

D.

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 Meadowfield Healthcare clinic analysts must not access other sites' records. The relevant action here is: Apply Power BI row-level security when different users should see only their permitted records.

Question 990

At Meadowfield Healthcare clinic analysts must not access other sites' records. The team proposes this approach: Apply Power BI row-level security when different users should see only their permitted records. Which technical principle explains the choice?

  1. The semantic model defines shared data types, relationships and measures so reports interpret business figures consistently.
  2. Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.
  3. A hot streaming path reacts promptly while the cold path can consolidate history for deeper analysis.
  4. RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

Answer & Explanations

Correct answer: D

A.

The semantic model defines shared data types, relationships and measures so reports interpret business figures consistently. That explains a separate situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The current case is: At Meadowfield Healthcare clinic analysts must not access other sites' records. The actual mechanism is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

B.

Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. That explains a separate situation: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The current case is: At Meadowfield Healthcare clinic analysts must not access other sites' records. The actual mechanism is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

C.

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 Meadowfield Healthcare clinic analysts must not access other sites' records. The actual mechanism is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

D.

RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. This principle supports the intervention: Apply Power BI row-level security when different users should see only their permitted records. The relevant scenario is: At Meadowfield Healthcare clinic analysts must not access other sites' records. Verify the result by: Test two fictional regional managers and confirm each can query only their permitted region.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests