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 95

Question 940

At Harborfield Commerce sales facts reference a product dimension. Which shortcut most directly threatens the intended data outcome?

  1. Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted.
  2. Connect unrelated tables by matching display names that are not stable unique keys.
  3. Run every massive distributed join as a manual desktop spreadsheet formula.
  4. Run only a nightly file import for a stated subminute safety alert requirement.

Answer & Explanations

Correct answer: B

A.

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 Harborfield Commerce sales facts reference a product dimension—reject: Connect unrelated tables by matching display names that are not stable unique keys. The safer response is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

B.

Connect unrelated tables by matching display names that are not stable unique keys. The scenario is: At Harborfield Commerce sales facts reference a product dimension. This undermines the mechanism: Model relationships propagate filter context between related tables according to direction and cardinality. Instead: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

C.

Run every massive distributed join as a manual desktop spreadsheet formula. This concerns another issue: At Harborland Energy billions of sensor readings require transformation. In the stated case—At Harborfield Commerce sales facts reference a product dimension—reject: Connect unrelated tables by matching display names that are not stable unique keys. The safer response is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

D.

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 Harborfield Commerce sales facts reference a product dimension—reject: Connect unrelated tables by matching display names that are not stable unique keys. The safer response is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

Question 941

At Meadowridge Insurance claim facts must filter by a stable branch identifier. Which design or Azure data approach best fits this requirement?

  1. Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.
  2. Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.
  3. Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.
  4. Build an incremental ingestion path based on reliable watermarks or source change tracking.

Answer & Explanations

Correct answer: A

A.

Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering. This works because: Model relationships propagate filter context between related tables according to direction and cardinality. The scenario is: At Meadowridge Insurance claim facts must filter by a stable branch identifier. Verify the outcome by: Select a fictional product category and verify only related sales transactions contribute to the visual.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier. The relevant action here is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

C.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier. The relevant action here is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

D.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier. The relevant action here is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

Question 942

At Meadowridge Insurance claim facts must filter by a stable branch identifier. The team proposes this approach: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering. Which technical principle explains the choice?

  1. Model relationships propagate filter context between related tables according to direction and cardinality.
  2. Event time reflects when the source event happened; processing time reflects when the system saw it.
  3. OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access.
  4. Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.

Answer & Explanations

Correct answer: A

A.

Model relationships propagate filter context between related tables according to direction and cardinality. This principle supports the intervention: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering. The relevant scenario is: At Meadowridge Insurance claim facts must filter by a stable branch identifier. Verify the result by: Select a fictional product category and verify only related sales transactions contribute to the visual.

B.

Event time reflects when the source event happened; processing time reflects when the system saw it. That explains a separate situation: At Meadowport Transit buses upload buffered GPS events after reconnecting. The current case is: At Meadowridge Insurance claim facts must filter by a stable branch identifier. The actual mechanism is: Model relationships propagate filter context between related tables according to direction and cardinality.

C.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier. The actual mechanism is: Model relationships propagate filter context between related tables according to direction and cardinality.

D.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier. The actual mechanism is: Model relationships propagate filter context between related tables according to direction and cardinality.

Question 943

At Meadowridge Insurance claim facts must filter by a stable branch identifier. After implementing this approach—Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering—which result would most directly confirm success?

  1. Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.
  2. Select a fictional product category and verify only related sales transactions contribute to the visual.
  3. Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.
  4. Relate fictional sales facts to products and dates and verify filters affect the intended totals.

Answer & Explanations

Correct answer: B

A.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier. Use this acceptance check instead: Select a fictional product category and verify only related sales transactions contribute to the visual.

B.

Select a fictional product category and verify only related sales transactions contribute to the visual. This tests the targeted action: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering. The reason is: Model relationships propagate filter context between related tables according to direction and cardinality. The reported case is: At Meadowridge Insurance claim facts must filter by a stable branch identifier.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier. Use this acceptance check instead: Select a fictional product category and verify only related sales transactions contribute to the visual.

D.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier. Use this acceptance check instead: Select a fictional product category and verify only related sales transactions contribute to the visual.

Question 944

At Meadowridge Insurance claim facts must filter by a stable branch identifier. Which shortcut most directly threatens the intended data outcome?

  1. Connect unrelated tables by matching display names that are not stable unique keys.
  2. Run every massive distributed join as a manual desktop spreadsheet formula.
  3. Use a pie chart to prove one numeric factor causes another.
  4. Run only a nightly file import for a stated subminute safety alert requirement.

Answer & Explanations

Correct answer: A

A.

Connect unrelated tables by matching display names that are not stable unique keys. The scenario is: At Meadowridge Insurance claim facts must filter by a stable branch identifier. This undermines the mechanism: Model relationships propagate filter context between related tables according to direction and cardinality. Instead: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

B.

Run every massive distributed join as a manual desktop spreadsheet formula. This concerns another issue: At Harborland Energy billions of sensor readings require transformation. In the stated case—At Meadowridge Insurance claim facts must filter by a stable branch identifier—reject: Connect unrelated tables by matching display names that are not stable unique keys. The safer response is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier—reject: Connect unrelated tables by matching display names that are not stable unique keys. The safer response is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

D.

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 Meadowridge Insurance claim facts must filter by a stable branch identifier—reject: Connect unrelated tables by matching display names that are not stable unique keys. The safer response is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

Question 945

At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. Which design or Azure data approach best fits this requirement?

  1. Apply Power BI row-level security when different users should see only their permitted records.
  2. Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.
  3. Build an incremental ingestion path based on reliable watermarks or source change tracking.
  4. Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

Answer & Explanations

Correct answer: D

A.

Apply Power BI row-level security when different users should see only their permitted records. This addresses a different situation: At Cedarcrest Finance regional managers should see only their branch transactions. The present case is: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The relevant action here is: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

B.

Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery. This addresses a different situation: At Silverpoint Banking an event publisher retries after a brief timeout. The present case is: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The relevant action here is: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

C.

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 Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The relevant action here is: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

D.

Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable. This works because: Import caches data in the Power BI model and requires refresh to reflect changed source rows. The scenario is: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. Verify the outcome by: Update a synthetic source record and verify the report reflects it after a configured refresh.

Question 946

At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. 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. Stream Analytics applies SQL-like continuous queries to configured inputs and outputs.
  2. Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.
  3. Import caches data in the Power BI model and requires refresh to reflect changed source rows.
  4. Each point shows paired numeric values and can reveal patterns or outliers without implying causation.

Answer & Explanations

Correct answer: C

A.

Stream Analytics applies SQL-like continuous queries to configured inputs and outputs. That explains a separate situation: At Pinebrook Facilities sensors send readings to an event hub. The current case is: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The actual mechanism is: Import caches data in the Power BI model and requires refresh to reflect changed source rows.

B.

Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them. That explains a separate situation: At Pinecrest Retail product-category reporting relies on many transactions. The current case is: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The actual mechanism is: Import caches data in the Power BI model and requires refresh to reflect changed source rows.

C.

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 Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. Verify the result by: Update a synthetic source record and verify the report reflects it after a configured refresh.

D.

Each point shows paired numeric values and can reveal patterns or outliers without implying causation. That explains a separate situation: At Pinewood Retail analysts compare campaign spend with customer acquisitions. The current case is: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The actual mechanism is: Import caches data in the Power BI model and requires refresh to reflect changed source rows.

Question 947

At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. 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. Test two fictional regional managers and confirm each can query only their permitted region.
  2. Update a synthetic source record and verify the report reflects it after a configured refresh.
  3. Run two test consumer groups and confirm each sees the intended events without resetting the other's offset.
  4. Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.

Answer & Explanations

Correct answer: B

A.

Test two fictional regional managers and confirm each can query only their permitted region. This tests a separate situation: At Cedarcrest Finance regional managers should see only their branch transactions. The observed case is: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. Use this acceptance check instead: Update a synthetic source record and verify the report reflects it after a configured refresh.

B.

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 Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals.

C.

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 Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. Use this acceptance check instead: Update a synthetic source record and verify the report reflects it after a configured refresh.

D.

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 Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. Use this acceptance check instead: Update a synthetic source record and verify the report reflects it after a configured refresh.

Question 948

At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. Which shortcut most directly threatens the intended data outcome?

  1. Run only a nightly file import for a stated subminute safety alert requirement.
  2. Schedule a single weekly batch while promising a dashboard accurate every ten minutes.
  3. Expect a static imported dataset to show each operational write instantly without refresh.
  4. Build separate disconnected charts each using a different definition of sales.

Answer & Explanations

Correct answer: C

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 Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals—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.

Schedule a single weekly batch while promising a dashboard accurate every ten minutes. This concerns another issue: At Harborland Retail nightly inventory analytics satisfy finance but not emergency stock alerts. In the stated case—At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals—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.

C.

Expect a static imported dataset to show each operational write instantly without refresh. The scenario is: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. 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.

D.

Build separate disconnected charts each using a different definition of sales. This concerns another issue: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. In the stated case—At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals—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 949

At Silverbridge HR headcount charts tolerate scheduled daily updates. Which design or Azure data approach best fits this requirement?

  1. Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.
  2. Use Azure Event Hubs to ingest high-volume event streams from supported producers before downstream processing.
  3. Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.
  4. Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads.

Answer & Explanations

Correct answer: C

A.

Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. This addresses a different situation: At Silverlake Services managers compare revenue by selected region. The present case is: At Silverbridge HR headcount charts tolerate scheduled daily updates. The relevant action here is: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

B.

Use Azure Event Hubs to ingest high-volume event streams from supported producers before downstream processing. This addresses a different situation: At Harborcrest Transport thousands of vehicles emit location updates. The present case is: At Silverbridge HR headcount charts tolerate scheduled daily updates. The relevant action here is: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

C.

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

D.

Use Microsoft Fabric OneLake as a governed shared logical lake for permitted analytics workloads. This addresses a different situation: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The present case is: At Silverbridge HR headcount charts tolerate scheduled daily updates. The relevant action here is: Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

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.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests