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 94

Question 930

At Silverlake Services managers compare revenue by selected region. The team proposes this approach: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. Which technical principle explains the choice?

  1. Each point shows paired numeric values and can reveal patterns or outliers without implying causation.
  2. Partition pruning lets engines skip unrelated date segments instead of scanning all years of data.
  3. Streaming handles events as they arrive while batch processing groups bounded input sets at intervals.
  4. A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.

Answer & Explanations

Correct answer: D

A.

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 Silverlake Services managers compare revenue by selected region. The actual mechanism is: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.

B.

Partition pruning lets engines skip unrelated date segments instead of scanning all years of data. That explains a separate situation: At Oakfield Utilities analysts frequently report one month of meter usage. The current case is: At Silverlake Services managers compare revenue by selected region. The actual mechanism is: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.

C.

Streaming handles events as they arrive while batch processing groups bounded input sets at intervals. That explains a separate situation: At Cedarpoint Manufacturing equipment overheating requires prompt detection. The current case is: At Silverlake Services managers compare revenue by selected region. The actual mechanism is: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.

D.

A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh. This principle supports the intervention: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. The relevant scenario is: At Silverlake Services managers compare revenue by selected region. Verify the result by: Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.

Question 931

At Silverlake Services managers compare revenue by selected region. After implementing this approach—Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row—which result would most directly confirm success?

  1. Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.
  2. Send one valid and one invalid synthetic record and confirm only the valid record reaches the curated table.
  3. Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint.
  4. Test two fictional regional managers and confirm each can query only their permitted region.

Answer & Explanations

Correct answer: A

A.

Add a fictional revenue measure and confirm it changes when the product slicer is adjusted. This tests the targeted action: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. The reason is: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh. The reported case is: At Silverlake Services managers compare revenue by selected region.

B.

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 Silverlake Services managers compare revenue by selected region. Use this acceptance check instead: Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.

C.

Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint. This tests a separate situation: At Harborcrest Logistics a tracking processor is offline during a deployment. The observed case is: At Silverlake Services managers compare revenue by selected region. Use this acceptance check instead: Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.

D.

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 Silverlake Services managers compare revenue by selected region. Use this acceptance check instead: Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.

Question 932

At Silverlake Services managers compare revenue by selected region. Which shortcut most directly threatens the intended data outcome?

  1. Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions.
  2. Schedule a single weekly batch while promising a dashboard accurate every ten minutes.
  3. Paste a fixed grand total into every transaction row and expect slicers to recalculate it.
  4. Assign every delayed event to the moment it reached the processor with no policy.

Answer & Explanations

Correct answer: C

A.

Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. This concerns another issue: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. In the stated case—At Silverlake Services managers compare revenue by selected region—reject: Paste a fixed grand total into every transaction row and expect slicers to recalculate it. The safer response is: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

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 Silverlake Services managers compare revenue by selected region—reject: Paste a fixed grand total into every transaction row and expect slicers to recalculate it. The safer response is: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

C.

Paste a fixed grand total into every transaction row and expect slicers to recalculate it. The scenario is: At Silverlake Services managers compare revenue by selected region. This undermines the mechanism: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh. Instead: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

D.

Assign every delayed event to the moment it reached the processor with no policy. This concerns another issue: At Meadowport Transit buses upload buffered GPS events after reconnecting. In the stated case—At Silverlake Services managers compare revenue by selected region—reject: Paste a fixed grand total into every transaction row and expect slicers to recalculate it. The safer response is: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

Question 933

At Cedarwood Travel analysts want a dynamically filtered average booking value. Which design or Azure data approach best fits this requirement?

  1. Use Azure Databricks for distributed Spark-based processing of large or complex transformation workloads.
  2. Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
  3. Apply Power BI row-level security when different users should see only their permitted records.
  4. Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

Answer & Explanations

Correct answer: D

A.

Use Azure Databricks for distributed Spark-based processing of large or complex transformation workloads. This addresses a different situation: At Harborland Energy billions of sensor readings require transformation. The present case is: At Cedarwood Travel analysts want a dynamically filtered average booking value. The relevant action here is: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

B.

Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations. This addresses a different situation: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The present case is: At Cedarwood Travel analysts want a dynamically filtered average booking value. The relevant action here is: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

C.

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 Cedarwood Travel analysts want a dynamically filtered average booking value. The relevant action here is: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

D.

Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. This works because: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh. The scenario is: At Cedarwood Travel analysts want a dynamically filtered average booking value. Verify the outcome by: Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.

Question 934

At Cedarwood Travel analysts want a dynamically filtered average booking value. The team proposes this approach: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. Which technical principle explains the choice?

  1. A lakehouse combines lake-style file storage with table organization and analytical query access.
  2. A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.
  3. Event time reflects when the source event happened; processing time reflects when the system saw it.
  4. DirectQuery issues supported queries to the source during interactions, making performance and connectivity important.

Answer & Explanations

Correct answer: B

A.

A lakehouse combines lake-style file storage with table organization and analytical query access. That explains a separate situation: At Cedarbridge Media analysts combine raw events and curated advertising tables. The current case is: At Cedarwood Travel analysts want a dynamically filtered average booking value. The actual mechanism is: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.

B.

A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh. This principle supports the intervention: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. The relevant scenario is: At Cedarwood Travel analysts want a dynamically filtered average booking value. Verify the result by: Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.

C.

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 Cedarwood Travel analysts want a dynamically filtered average booking value. The actual mechanism is: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.

D.

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 Cedarwood Travel analysts want a dynamically filtered average booking value. The actual mechanism is: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.

Question 935

At Cedarwood Travel analysts want a dynamically filtered average booking value. After implementing this approach—Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row—which result would most directly confirm success?

  1. Build a small sales fact table and product dimension then verify a category-filtered revenue total.
  2. Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.
  3. Plot fictional daily traffic for three months and verify the audience can follow growth and declines.
  4. Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint.

Answer & Explanations

Correct answer: B

A.

Build a small sales fact table and product dimension then verify a category-filtered revenue total. This tests a separate situation: At Pinecrest Retail product-category reporting relies on many transactions. The observed case is: At Cedarwood Travel analysts want a dynamically filtered average booking value. Use this acceptance check instead: Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.

B.

Add a fictional revenue measure and confirm it changes when the product slicer is adjusted. This tests the targeted action: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row. The reason is: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh. The reported case is: At Cedarwood Travel analysts want a dynamically filtered average booking value.

C.

Plot fictional daily traffic for three months and verify the audience can follow growth and declines. This tests a separate situation: At Meadowport Media analysts inspect daily subscription signups. The observed case is: At Cedarwood Travel analysts want a dynamically filtered average booking value. Use this acceptance check instead: Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.

D.

Pause a synthetic consumer, resume within retention and verify it catches up from a saved checkpoint. This tests a separate situation: At Harborcrest Logistics a tracking processor is offline during a deployment. The observed case is: At Cedarwood Travel analysts want a dynamically filtered average booking value. Use this acceptance check instead: Add a fictional revenue measure and confirm it changes when the product slicer is adjusted.

Question 936

At Cedarwood Travel analysts want a dynamically filtered average booking value. Which shortcut most directly threatens the intended data outcome?

  1. Assume a consumer can recover messages that have already aged out of the event stream.
  2. Paste a fixed grand total into every transaction row and expect slicers to recalculate it.
  3. Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions.
  4. Overwrite transformations without a change record while claiming prior KPI totals are reproducible.

Answer & Explanations

Correct answer: B

A.

Assume a consumer can recover messages that have already aged out of the event stream. This concerns another issue: At Harborcrest Logistics a tracking processor is offline during a deployment. In the stated case—At Cedarwood Travel analysts want a dynamically filtered average booking value—reject: Paste a fixed grand total into every transaction row and expect slicers to recalculate it. The safer response is: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

B.

Paste a fixed grand total into every transaction row and expect slicers to recalculate it. The scenario is: At Cedarwood Travel analysts want a dynamically filtered average booking value. This undermines the mechanism: A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh. Instead: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

C.

Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. This concerns another issue: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. In the stated case—At Cedarwood Travel analysts want a dynamically filtered average booking value—reject: Paste a fixed grand total into every transaction row and expect slicers to recalculate it. The safer response is: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

D.

Overwrite transformations without a change record while claiming prior KPI totals are reproducible. This concerns another issue: At Cedarcrest Banking financial metrics require stable audit evidence. In the stated case—At Cedarwood Travel analysts want a dynamically filtered average booking value—reject: Paste a fixed grand total into every transaction row and expect slicers to recalculate it. The safer response is: Use a DAX measure for a filter-context-dependent aggregate rather than storing the same changing total in every fact row.

Question 937

At Harborfield Commerce sales facts reference a product dimension. 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. Select appropriate batch processing windows and compute scale based on data freshness requirements and job cost.
  3. Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.
  4. Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.

Answer & Explanations

Correct answer: C

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 Harborfield Commerce sales facts reference a product dimension. The relevant action here is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

B.

Select appropriate batch processing windows and compute scale based on data freshness requirements and job cost. This addresses a different situation: At Harborland Retail nightly inventory analytics satisfy finance but not emergency stock alerts. The present case is: At Harborfield Commerce sales facts reference a product dimension. The relevant action here is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

C.

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 Harborfield Commerce sales facts reference a product dimension. Verify the outcome by: Select a fictional product category and verify only related sales transactions contribute to the visual.

D.

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 Harborfield Commerce sales facts reference a product dimension. The relevant action here is: Configure an active relationship between compatible dimension keys and fact foreign keys for expected report filtering.

Question 938

At Harborfield Commerce sales facts reference a product dimension. 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. Databricks supplies managed Apache Spark data processing capable of parallel transformations and notebook workflows.
  2. Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.
  3. Event Hubs receives and partitions event streams for independent consumers without itself being a transactional relational database.
  4. Model relationships propagate filter context between related tables according to direction and cardinality.

Answer & Explanations

Correct answer: D

A.

Databricks supplies managed Apache Spark data processing capable of parallel transformations and notebook workflows. That explains a separate situation: At Harborland Energy billions of sensor readings require transformation. The current case is: At Harborfield Commerce sales facts reference a product dimension. The actual mechanism is: Model relationships propagate filter context between related tables according to direction and cardinality.

B.

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 Harborfield Commerce sales facts reference a product dimension. The actual mechanism is: Model relationships propagate filter context between related tables according to direction and cardinality.

C.

Event Hubs receives and partitions event streams for independent consumers without itself being a transactional relational database. That explains a separate situation: At Harborcrest Transport thousands of vehicles emit location updates. The current case is: At Harborfield Commerce sales facts reference a product dimension. The actual mechanism is: Model relationships propagate filter context between related tables according to direction and cardinality.

D.

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 Harborfield Commerce sales facts reference a product dimension. Verify the result by: Select a fictional product category and verify only related sales transactions contribute to the visual.

Question 939

At Harborfield Commerce sales facts reference a product dimension. 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. Delay a fictional event by two minutes and verify the configured lateness rule places it in the correct time window.
  2. Relate fictional sales facts to products and dates and verify filters affect the intended totals.
  3. Build a small sales fact table and product dimension then verify a category-filtered revenue total.
  4. Select a fictional product category and verify only related sales transactions contribute to the visual.

Answer & Explanations

Correct answer: D

A.

Delay a fictional event by two minutes and verify the configured lateness rule places it in the correct time window. This tests a separate situation: At Meadowport Transit buses upload buffered GPS events after reconnecting. The observed case is: At Harborfield Commerce sales facts reference a product dimension. Use this acceptance check instead: Select a fictional product category and verify only related sales transactions contribute to the visual.

B.

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 Harborfield Commerce sales facts reference a product dimension. Use this acceptance check instead: Select a fictional product category and verify only related sales transactions contribute to the visual.

C.

Build a small sales fact table and product dimension then verify a category-filtered revenue total. This tests a separate situation: At Pinecrest Retail product-category reporting relies on many transactions. The observed case is: At Harborfield Commerce sales facts reference a product dimension. Use this acceptance check instead: Select a fictional product category and verify only related sales transactions contribute to the visual.

D.

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 Harborfield Commerce sales facts reference a product dimension.

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.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests