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 96

Question 950

At Silverbridge HR headcount charts tolerate scheduled daily updates. The team proposes this approach: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable. Which technical principle explains the choice?

  1. DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.
  2. OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.
  3. Partitioned event ingestion supports parallel consumers while independent groups track their own reading positions.
  4. Import caches data in the Power BI model and requires refresh to reflect changed source rows.

Answer & Explanations

Correct answer: D

A.

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 Silverbridge HR headcount charts tolerate scheduled daily updates. The actual mechanism is: Import caches data in the Power BI model and requires refresh to reflect changed source rows.

B.

OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. That explains a separate situation: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The current case is: At Silverbridge HR headcount charts tolerate scheduled daily updates. The actual mechanism is: Import caches data in the Power BI model and requires refresh to reflect changed source rows.

C.

Partitioned event ingestion supports parallel consumers while independent groups track their own reading positions. That explains a separate situation: At Oakcrest Mobility live tracking and reporting consume the same event source. The current case is: At Silverbridge HR headcount charts tolerate scheduled daily updates. The actual mechanism is: Import caches data in the Power BI model and requires refresh to reflect changed source rows.

D.

Import caches data in the Power BI model and requires refresh to reflect changed source rows. This principle supports the intervention: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable. The relevant scenario is: At Silverbridge HR headcount charts tolerate scheduled daily updates. Verify the result by: Update a synthetic source record and verify the report reflects it after a configured refresh.

Question 951

At Silverbridge HR headcount charts tolerate scheduled daily updates. After implementing this approach—Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable—which result would most directly confirm success?

  1. Plot fictional shipments by region and verify the largest and smallest categories are apparent.
  2. Send synthetic device readings and compare event-to-dashboard delay under both processing designs.
  3. Update a synthetic source record and verify the report reflects it after a configured refresh.
  4. Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination.

Answer & Explanations

Correct answer: C

A.

Plot fictional shipments by region and verify the largest and smallest categories are apparent. This tests a separate situation: At Cedarbank Logistics supervisors compare delivery counts among depots. The observed case is: At Silverbridge HR headcount charts tolerate scheduled daily updates. Use this acceptance check instead: Update a synthetic source record and verify the report reflects it after a configured refresh.

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 Silverbridge HR headcount charts tolerate scheduled daily updates. Use this acceptance check instead: Update a synthetic source record and verify the report reflects it after a configured refresh.

C.

Update a synthetic source record and verify the report reflects it after a configured refresh. This tests the targeted action: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable. The reason is: Import caches data in the Power BI model and requires refresh to reflect changed source rows. The reported case is: At Silverbridge HR headcount charts tolerate scheduled daily updates.

D.

Run a synthetic workspace pipeline and confirm it lands approved data in the intended Fabric destination. This tests a separate situation: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The observed case is: At Silverbridge HR headcount charts tolerate scheduled daily updates. Use this acceptance check instead: Update a synthetic source record and verify the report reflects it after a configured refresh.

Question 952

At Silverbridge HR headcount charts tolerate scheduled daily updates. Which shortcut most directly threatens the intended data outcome?

  1. Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row.
  2. Expect a static imported dataset to show each operational write instantly without refresh.
  3. Treat each retransmission as a brand-new purchase.
  4. Paste a fixed grand total into every transaction row and expect slicers to recalculate it.

Answer & Explanations

Correct answer: B

A.

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 Silverbridge HR headcount charts tolerate scheduled daily updates—reject: Expect a static imported dataset to show each operational write instantly without refresh. The safer response is: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

B.

Expect a static imported dataset to show each operational write instantly without refresh. The scenario is: At Silverbridge HR headcount charts tolerate scheduled daily updates. This undermines the mechanism: Import caches data in the Power BI model and requires refresh to reflect changed source rows. Instead: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

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 Silverbridge HR headcount charts tolerate scheduled daily updates—reject: Expect a static imported dataset to show each operational write instantly without refresh. The safer response is: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

D.

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 Silverbridge HR headcount charts tolerate scheduled daily updates—reject: Expect a static imported dataset to show each operational write instantly without refresh. The safer response is: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

Question 953

At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. Which design or Azure data approach best fits this requirement?

  1. Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.
  2. Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.
  3. Use ELT when raw records can first land in a scalable analytical store and transformations run there.
  4. Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

Answer & Explanations

Correct answer: B

A.

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 Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The relevant action here is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

B.

Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data. This works because: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important. The scenario is: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. Verify the outcome by: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

C.

Use ELT when raw records can first land in a scalable analytical store and transformations run there. This addresses a different situation: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The present case is: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The relevant action here is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

D.

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 Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The relevant action here is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

Question 954

At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The team proposes this approach: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data. Which technical principle explains the choice?

  1. Import caches data in the Power BI model and requires refresh to reflect changed source rows.
  2. DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.
  3. Larger batch jobs can be efficient but delay availability, so cadence must match business SLAs.
  4. Windowed streaming computations aggregate events over bounded time intervals as new data arrives.

Answer & Explanations

Correct answer: B

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 Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The actual mechanism is: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.

B.

DirectQuery issues supported queries to the source during interactions, making performance and connectivity important. This principle supports the intervention: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data. The relevant scenario is: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. Verify the result by: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

C.

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 Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The actual mechanism is: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.

D.

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 Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. The actual mechanism is: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.

Question 955

At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. After implementing this approach—Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data—which result would most directly confirm success?

  1. Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.
  2. Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.
  3. Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.
  4. Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.

Answer & Explanations

Correct answer: A

A.

Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions. This tests the targeted action: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data. The reason is: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important. The reported case is: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries.

B.

Add a fictional revenue measure and confirm it changes when the product slicer is adjusted. This tests a separate situation: At Silverlake Services managers compare revenue by selected region. The observed case is: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. Use this acceptance check instead: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

C.

Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table. This tests a separate situation: At Meadowfield Retail some supplier feeds contain negative quantities. The observed case is: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. Use this acceptance check instead: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

D.

Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed. This tests a separate situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The observed case is: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. Use this acceptance check instead: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

Question 956

At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. Which shortcut most directly threatens the intended data outcome?

  1. Calculate a 'last five minutes' alert from a table refreshed once per day.
  2. Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted.
  3. Assume DirectQuery has no dependency on the source system's availability or latency.
  4. Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake.

Answer & Explanations

Correct answer: C

A.

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 Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries—reject: Assume DirectQuery has no dependency on the source system's availability or latency. The safer response is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

B.

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 Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries—reject: Assume DirectQuery has no dependency on the source system's availability or latency. The safer response is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

C.

Assume DirectQuery has no dependency on the source system's availability or latency. The scenario is: At Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries. This undermines the mechanism: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important. Instead: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

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 Cedarfield Operations a governed warehouse remains the authority for interactive dashboard queries—reject: Assume DirectQuery has no dependency on the source system's availability or latency. The safer response is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

Question 957

At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. Which design or Azure data approach best fits this requirement?

  1. Use ELT when raw records can first land in a scalable analytical store and transformations run there.
  2. Separate real-time alert processing from slower historical archival so urgent actions do not wait for nightly warehousing.
  3. Choose a bar chart for comparing distinct categories with a common quantitative scale.
  4. Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

Answer & Explanations

Correct answer: D

A.

Use ELT when raw records can first land in a scalable analytical store and transformations run there. This addresses a different situation: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The present case is: At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. The relevant action here is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

B.

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 Harborview Retail a frequently changing inventory summary is queried through a supported source connection. The relevant action here is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

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 Harborview Retail a frequently changing inventory summary is queried through a supported source connection. The relevant action here is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

D.

Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data. This works because: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important. The scenario is: At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. Verify the outcome by: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

Question 958

At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. The team proposes this approach: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data. Which technical principle explains the choice?

  1. Windowed streaming computations aggregate events over bounded time intervals as new data arrives.
  2. OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.
  3. A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.
  4. DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.

Answer & Explanations

Correct answer: D

A.

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 Harborview Retail a frequently changing inventory summary is queried through a supported source connection. The actual mechanism is: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.

B.

OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. That explains a separate situation: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The current case is: At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. The actual mechanism is: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.

C.

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 Harborview Retail a frequently changing inventory summary is queried through a supported source connection. The actual mechanism is: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.

D.

DirectQuery issues supported queries to the source during interactions, making performance and connectivity important. This principle supports the intervention: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data. The relevant scenario is: At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. Verify the result by: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

Question 959

At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. After implementing this approach—Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data—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. Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.
  3. Relate fictional sales facts to products and dates and verify filters affect the intended totals.
  4. Emit a synthetic threshold event and verify an immediate alert and a later analytical archive record.

Answer & Explanations

Correct answer: B

A.

Load a fictional raw dataset into a restricted landing zone and run a documented transformation to a curated table. This tests a separate situation: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The observed case is: At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. Use this acceptance check instead: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

B.

Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions. This tests the targeted action: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data. The reason is: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important. The reported case is: At Harborview Retail a frequently changing inventory summary is queried through a supported source connection.

C.

Relate fictional sales facts to products and dates and verify filters affect the intended totals. This tests a separate situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The observed case is: At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. Use this acceptance check instead: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

D.

Emit a synthetic threshold event and verify an immediate alert and a later analytical archive record. This tests a separate situation: At Pineport Healthcare medical equipment signals abnormal temperatures. The observed case is: At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. Use this acceptance check instead: Open a sample filtered visual and confirm the corresponding source query executes under the designed permissions.

Question 960

At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. Which shortcut most directly threatens the intended data outcome?

  1. Assume DirectQuery has no dependency on the source system's availability or latency.
  2. Discard raw source files before checking whether transformations are repeatable.
  3. Treat each retransmission as a brand-new purchase.
  4. Expect a static imported dataset to show each operational write instantly without refresh.

Answer & Explanations

Correct answer: A

A.

Assume DirectQuery has no dependency on the source system's availability or latency. The scenario is: At Harborview Retail a frequently changing inventory summary is queried through a supported source connection. This undermines the mechanism: DirectQuery issues supported queries to the source during interactions, making performance and connectivity important. Instead: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

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 Harborview Retail a frequently changing inventory summary is queried through a supported source connection—reject: Assume DirectQuery has no dependency on the source system's availability or latency. The safer response is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

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 Harborview Retail a frequently changing inventory summary is queried through a supported source connection—reject: Assume DirectQuery has no dependency on the source system's availability or latency. The safer response is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

D.

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 Harborview Retail a frequently changing inventory summary is queried through a supported source connection—reject: Assume DirectQuery has no dependency on the source system's availability or latency. The safer response is: Evaluate DirectQuery when Power BI must query a supported external source rather than importing all its data.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests