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 79

Question 780

At Silvercrest Commerce executives compare sales performance across regions. Which shortcut most directly threatens the intended data outcome?

  1. Treat each retransmission as a brand-new purchase.
  2. Present categories as an unlabeled geographic heatmap with no location meaning.
  3. Place every descriptive product attribute into repeated transaction rows without a governed dimension model.
  4. Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions.

Answer & Explanations

Correct answer: D

A.

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 Silvercrest Commerce executives compare sales performance across regions—reject: Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The safer response is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

B.

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 Silvercrest Commerce executives compare sales performance across regions—reject: Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The safer response is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

C.

Place every descriptive product attribute into repeated transaction rows without a governed dimension model. This concerns another issue: At Pinecrest Retail product-category reporting relies on many transactions. In the stated case—At Silvercrest Commerce executives compare sales performance across regions—reject: Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The safer response is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

D.

Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The scenario is: At Silvercrest Commerce executives compare sales performance across regions. The likely failure is: Reports disagree on basic business totals. Instead: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

Question 781

At Harborfield Finance historical ledger and invoicing data support centralized BI. Which design or Azure data approach best fits this requirement?

  1. Build an incremental ingestion path based on reliable watermarks or source change tracking.
  2. Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.
  3. Create a Power BI semantic model with clear tables and relationships before writing executive visualizations.
  4. Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

Answer & Explanations

Correct answer: D

A.

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 Harborfield Finance historical ledger and invoicing data support centralized BI. The relevant action here is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

B.

Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs. This addresses a different situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The present case is: At Harborfield Finance historical ledger and invoicing data support centralized BI. The relevant action here is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

C.

Create a Power BI semantic model with clear tables and relationships before writing executive visualizations. This addresses a different situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The present case is: At Harborfield Finance historical ledger and invoicing data support centralized BI. The relevant action here is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

D.

Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. This works because: A warehouse supports curated structured models and analytic queries over integrated business entities. The scenario is: At Harborfield Finance historical ledger and invoicing data support centralized BI. Verify the outcome by: Load fictional sales and finance facts and verify both reports share a consistent date dimension.

Question 782

At Harborfield Finance historical ledger and invoicing data support centralized BI. The team proposes this approach: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. Which technical principle explains the choice?

  1. Partitioned event ingestion supports parallel consumers while independent groups track their own reading positions.
  2. A warehouse supports curated structured models and analytic queries over integrated business entities.
  3. Version and lineage records connect an analytical result to its source and processing logic at a point in time.
  4. Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.

Answer & Explanations

Correct answer: B

A.

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 Harborfield Finance historical ledger and invoicing data support centralized BI. The actual mechanism is: A warehouse supports curated structured models and analytic queries over integrated business entities.

B.

A warehouse supports curated structured models and analytic queries over integrated business entities. This principle supports the intervention: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. The relevant scenario is: At Harborfield Finance historical ledger and invoicing data support centralized BI. Verify the result by: Load fictional sales and finance facts and verify both reports share a consistent date dimension.

C.

Version and lineage records connect an analytical result to its source and processing logic at a point in time. That explains a separate situation: At Cedarcrest Banking financial metrics require stable audit evidence. The current case is: At Harborfield Finance historical ledger and invoicing data support centralized BI. The actual mechanism is: A warehouse supports curated structured models and analytic queries over integrated business entities.

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 Harborfield Finance historical ledger and invoicing data support centralized BI. The actual mechanism is: A warehouse supports curated structured models and analytic queries over integrated business entities.

Question 783

At Harborfield Finance historical ledger and invoicing data support centralized BI. After implementing this approach—Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts—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. Load fictional sales and finance facts and verify both reports share a consistent date dimension.
  3. Select a fictional product category and verify only related sales transactions contribute to the visual.
  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.

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 Harborfield Finance historical ledger and invoicing data support centralized BI. Use this acceptance check instead: Load fictional sales and finance facts and verify both reports share a consistent date dimension.

B.

Load fictional sales and finance facts and verify both reports share a consistent date dimension. This tests the targeted action: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. The reason is: A warehouse supports curated structured models and analytic queries over integrated business entities. The reported case is: At Harborfield Finance historical ledger and invoicing data support centralized BI.

C.

Select a fictional product category and verify only related sales transactions contribute to the visual. This tests a separate situation: At Harborfield Commerce sales facts reference a product dimension. The observed case is: At Harborfield Finance historical ledger and invoicing data support centralized BI. Use this acceptance check instead: Load fictional sales and finance facts and verify both reports share a consistent date dimension.

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 Harborfield Finance historical ledger and invoicing data support centralized BI. Use this acceptance check instead: Load fictional sales and finance facts and verify both reports share a consistent date dimension.

Question 784

At Harborfield Finance historical ledger and invoicing data support centralized BI. Which shortcut most directly threatens the intended data outcome?

  1. Silently drop errors while still reporting the source batch as complete.
  2. Route emergency alerts through a slow end-of-day ETL job.
  3. Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions.
  4. Present categories as an unlabeled geographic heatmap with no location meaning.

Answer & Explanations

Correct answer: C

A.

Silently drop errors while still reporting the source batch as complete. This concerns another issue: At Meadowfield Retail some supplier feeds contain negative quantities. In the stated case—At Harborfield Finance historical ledger and invoicing data support centralized BI—reject: Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The safer response is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

B.

Route emergency alerts through a slow end-of-day ETL job. This concerns another issue: At Pineport Healthcare medical equipment signals abnormal temperatures. In the stated case—At Harborfield Finance historical ledger and invoicing data support centralized BI—reject: Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The safer response is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

C.

Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The scenario is: At Harborfield Finance historical ledger and invoicing data support centralized BI. This undermines the mechanism: A warehouse supports curated structured models and analytic queries over integrated business entities. Instead: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

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 Harborfield Finance historical ledger and invoicing data support centralized BI—reject: Have every department calculate quarterly revenue from unrelated raw CSV files with different definitions. The safer response is: Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

Question 785

At Pinecrest Retail product-category reporting relies on many transactions. Which design or Azure data approach best fits this requirement?

  1. Use a star schema with fact and dimension tables for understandable report filters and aggregations.
  2. Use a scatter plot when exploring whether two quantitative variables have an association.
  3. Define a controlled late-arrival and deduplication policy for at-least-once streaming delivery.
  4. Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts.

Answer & Explanations

Correct answer: A

A.

Use a star schema with fact and dimension tables for understandable report filters and aggregations. This works because: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them. The scenario is: At Pinecrest Retail product-category reporting relies on many transactions. Verify the outcome by: Build a small sales fact table and product dimension then verify a category-filtered revenue total.

B.

Use a scatter plot when exploring whether two quantitative variables have an association. This addresses a different situation: At Pinewood Retail analysts compare campaign spend with customer acquisitions. The present case is: At Pinecrest Retail product-category reporting relies on many transactions. The relevant action here is: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

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 Pinecrest Retail product-category reporting relies on many transactions. The relevant action here is: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

D.

Choose a warehouse-style analytical store for governed repeatable SQL reporting across conformed business facts. This addresses a different situation: At Silvercrest Commerce executives compare sales performance across regions. The present case is: At Pinecrest Retail product-category reporting relies on many transactions. The relevant action here is: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

Question 786

At Pinecrest Retail product-category reporting relies on many transactions. The team proposes this approach: Use a star schema with fact and dimension tables for understandable report filters and aggregations. Which technical principle explains the choice?

  1. A hot streaming path reacts promptly while the cold path can consolidate history for deeper analysis.
  2. Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.
  3. Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.
  4. Orchestration triggers data movement, records failures and coordinates dependent processing stages.

Answer & Explanations

Correct answer: C

A.

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 Pinecrest Retail product-category reporting relies on many transactions. The actual mechanism is: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.

B.

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 Pinecrest Retail product-category reporting relies on many transactions. The actual mechanism is: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.

C.

Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them. This principle supports the intervention: Use a star schema with fact and dimension tables for understandable report filters and aggregations. The relevant scenario is: At Pinecrest Retail product-category reporting relies on many transactions. Verify the result by: Build a small sales fact table and product dimension then verify a category-filtered revenue total.

D.

Orchestration triggers data movement, records failures and coordinates dependent processing stages. That explains a separate situation: At Westport Manufacturing factory transactions feed an overnight analytics store. The current case is: At Pinecrest Retail product-category reporting relies on many transactions. The actual mechanism is: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.

Question 787

At Pinecrest Retail product-category reporting relies on many transactions. After implementing this approach—Use a star schema with fact and dimension tables for understandable report filters and aggregations—which result would most directly confirm success?

  1. Relate fictional sales facts to products and dates and verify filters affect the intended totals.
  2. Build a small sales fact table and product dimension then verify a category-filtered revenue total.
  3. Query one synthetic month from several years of data and inspect which partitions were read.
  4. Emit a synthetic threshold event and verify an immediate alert and a later analytical archive record.

Answer & Explanations

Correct answer: B

A.

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 Pinecrest Retail product-category reporting relies on many transactions. Use this acceptance check instead: Build a small sales fact table and product dimension then verify a category-filtered revenue total.

B.

Build a small sales fact table and product dimension then verify a category-filtered revenue total. This tests the targeted action: Use a star schema with fact and dimension tables for understandable report filters and aggregations. The reason is: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them. The reported case is: At Pinecrest Retail product-category reporting relies on many transactions.

C.

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 Pinecrest Retail product-category reporting relies on many transactions. Use this acceptance check instead: Build a small sales fact table and product dimension then verify a category-filtered revenue total.

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 Pinecrest Retail product-category reporting relies on many transactions. Use this acceptance check instead: Build a small sales fact table and product dimension then verify a category-filtered revenue total.

Question 788

At Pinecrest Retail product-category reporting relies on many transactions. Which shortcut most directly threatens the intended data outcome?

  1. Place every descriptive product attribute into repeated transaction rows without a governed dimension model.
  2. Label an unvalidated raw copy as a finished ETL process without a transformation step.
  3. Route emergency alerts through a slow end-of-day ETL job.
  4. Use a pie chart to prove one numeric factor causes another.

Answer & Explanations

Correct answer: A

A.

Place every descriptive product attribute into repeated transaction rows without a governed dimension model. The scenario is: At Pinecrest Retail product-category reporting relies on many transactions. This undermines the mechanism: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them. Instead: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

B.

Label an unvalidated raw copy as a finished ETL process without a transformation step. This concerns another issue: At Cedarfield Finance external invoices need standard currency codes before reporting. In the stated case—At Pinecrest Retail product-category reporting relies on many transactions—reject: Place every descriptive product attribute into repeated transaction rows without a governed dimension model. The safer response is: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

C.

Route emergency alerts through a slow end-of-day ETL job. This concerns another issue: At Pineport Healthcare medical equipment signals abnormal temperatures. In the stated case—At Pinecrest Retail product-category reporting relies on many transactions—reject: Place every descriptive product attribute into repeated transaction rows without a governed dimension model. The safer response is: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

D.

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 Pinecrest Retail product-category reporting relies on many transactions—reject: Place every descriptive product attribute into repeated transaction rows without a governed dimension model. The safer response is: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

Question 789

At Meadowport Hotels booking facts must group by property and calendar date. 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. Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs.
  3. Use a star schema with fact and dimension tables for understandable report filters and aggregations.
  4. Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

Answer & Explanations

Correct answer: C

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 Meadowport Hotels booking facts must group by property and calendar date. The relevant action here is: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

B.

Use a supported stream-processing engine to calculate rolling event metrics instead of querying only raw immutable logs. This addresses a different situation: At Meadowview Commerce payment anomalies are monitored in rolling five-minute windows. The present case is: At Meadowport Hotels booking facts must group by property and calendar date. The relevant action here is: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

C.

Use a star schema with fact and dimension tables for understandable report filters and aggregations. This works because: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them. The scenario is: At Meadowport Hotels booking facts must group by property and calendar date. Verify the outcome by: Build a small sales fact table and product dimension then verify a category-filtered revenue total.

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 Meadowport Hotels booking facts must group by property and calendar date. The relevant action here is: Use a star schema with fact and dimension tables for understandable report filters and aggregations.

Question 790

At Meadowport Hotels booking facts must group by property and calendar date. The team proposes this approach: Use a star schema with fact and dimension tables for understandable report filters and aggregations. Which technical principle explains the choice?

  1. Larger batch jobs can be efficient but delay availability, so cadence must match business SLAs.
  2. Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.
  3. RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.
  4. Windowed streaming computations aggregate events over bounded time intervals as new data arrives.

Answer & Explanations

Correct answer: B

A.

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 Meadowport Hotels booking facts must group by property and calendar date. The actual mechanism is: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.

B.

Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them. This principle supports the intervention: Use a star schema with fact and dimension tables for understandable report filters and aggregations. The relevant scenario is: At Meadowport Hotels booking facts must group by property and calendar date. Verify the result by: Build a small sales fact table and product dimension then verify a category-filtered revenue total.

C.

RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. That explains a separate situation: At Cedarcrest Finance regional managers should see only their branch transactions. The current case is: At Meadowport Hotels booking facts must group by property and calendar date. The actual mechanism is: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.

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 Meadowport Hotels booking facts must group by property and calendar date. The actual mechanism is: Fact tables hold numeric events while dimensions describe dates, products and customers used to filter or group them.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests