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 97

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.

Question 961

At Meadowport Media analysts inspect daily subscription signups. 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. Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it.
  3. Choose a bar chart for comparing distinct categories with a common quantitative scale.
  4. Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

Answer & Explanations

Correct answer: D

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 Meadowport Media analysts inspect daily subscription signups. The relevant action here is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

B.

Use partitioned analytical files or tables for large date-filtered scans when data volume and query patterns justify it. This addresses a different situation: At Oakfield Utilities analysts frequently report one month of meter usage. The present case is: At Meadowport Media analysts inspect daily subscription signups. The relevant action here is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

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 Meadowport Media analysts inspect daily subscription signups. The relevant action here is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

D.

Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. This works because: Position along a time axis makes change and seasonality easier to compare across ordered periods. The scenario is: At Meadowport Media analysts inspect daily subscription signups. Verify the outcome by: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

Question 962

At Meadowport Media analysts inspect daily subscription signups. The team proposes this approach: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. Which technical principle explains the choice?

  1. Event time reflects when the source event happened; processing time reflects when the system saw it.
  2. Position along a time axis makes change and seasonality easier to compare across ordered periods.
  3. A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.
  4. Partition pruning lets engines skip unrelated date segments instead of scanning all years of data.

Answer & Explanations

Correct answer: B

A.

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 Meadowport Media analysts inspect daily subscription signups. The actual mechanism is: Position along a time axis makes change and seasonality easier to compare across ordered periods.

B.

Position along a time axis makes change and seasonality easier to compare across ordered periods. This principle supports the intervention: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. The relevant scenario is: At Meadowport Media analysts inspect daily subscription signups. Verify the result by: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

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 Meadowport Media analysts inspect daily subscription signups. The actual mechanism is: Position along a time axis makes change and seasonality easier to compare across ordered periods.

D.

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 Meadowport Media analysts inspect daily subscription signups. The actual mechanism is: Position along a time axis makes change and seasonality easier to compare across ordered periods.

Question 963

At Meadowport Media analysts inspect daily subscription signups. After implementing this approach—Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp—which result would most directly confirm success?

  1. Update a synthetic source record and verify the report reflects it after a configured refresh.
  2. Query one synthetic month from several years of data and inspect which partitions were read.
  3. Plot fictional 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: C

A.

Update a synthetic source record and verify the report reflects it after a configured refresh. This tests a separate situation: At Pinecrest Finance a morning report refresh is sufficient for yesterday's closing totals. The observed case is: At Meadowport Media analysts inspect daily subscription signups. Use this acceptance check instead: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

B.

Query one synthetic month from several years of data and inspect which partitions were read. This tests a separate situation: At Oakfield Utilities analysts frequently report one month of meter usage. The observed case is: At Meadowport Media analysts inspect daily subscription signups. Use this acceptance check instead: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

C.

Plot fictional daily traffic for three months and verify the audience can follow growth and declines. This tests the targeted action: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. The reason is: Position along a time axis makes change and seasonality easier to compare across ordered periods. The reported case is: At Meadowport Media analysts inspect daily subscription signups.

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 Meadowport Media analysts inspect daily subscription signups. Use this acceptance check instead: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

Question 964

At Meadowport Media analysts inspect daily subscription signups. Which shortcut most directly threatens the intended data outcome?

  1. Share one destructive manual cursor between unrelated alerting and archival applications.
  2. Display hundreds of daily values as separate indistinguishable pie slices.
  3. Build separate disconnected charts each using a different definition of sales.
  4. Depend on a worker to upload an uncontrolled CSV file once every morning.

Answer & Explanations

Correct answer: B

A.

Share one destructive manual cursor between unrelated alerting and archival applications. This concerns another issue: At Oakcrest Mobility live tracking and reporting consume the same event source. In the stated case—At Meadowport Media analysts inspect daily subscription signups—reject: Display hundreds of daily values as separate indistinguishable pie slices. The safer response is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

B.

Display hundreds of daily values as separate indistinguishable pie slices. The scenario is: At Meadowport Media analysts inspect daily subscription signups. This undermines the mechanism: Position along a time axis makes change and seasonality easier to compare across ordered periods. Instead: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

C.

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 Meadowport Media analysts inspect daily subscription signups—reject: Display hundreds of daily values as separate indistinguishable pie slices. The safer response is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

D.

Depend on a worker to upload an uncontrolled CSV file once every morning. This concerns another issue: At Westport Manufacturing factory transactions feed an overnight analytics store. In the stated case—At Meadowport Media analysts inspect daily subscription signups—reject: Display hundreds of daily values as separate indistinguishable pie slices. The safer response is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

Question 965

At Silvercrest Utilities managers review monthly electricity usage changes. Which design or Azure data approach best fits this requirement?

  1. Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.
  2. Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
  3. Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.
  4. Create a Power BI semantic model with clear tables and relationships before writing executive visualizations.

Answer & Explanations

Correct answer: C

A.

Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports. This addresses a different situation: At Westport Manufacturing factory transactions feed an overnight analytics store. The present case is: At Silvercrest Utilities managers review monthly electricity usage changes. The relevant action here is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

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 Silvercrest Utilities managers review monthly electricity usage changes. The relevant action here is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

C.

Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. This works because: Position along a time axis makes change and seasonality easier to compare across ordered periods. The scenario is: At Silvercrest Utilities managers review monthly electricity usage changes. Verify the outcome by: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

D.

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 Silvercrest Utilities managers review monthly electricity usage changes. The relevant action here is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

Question 966

At Silvercrest Utilities managers review monthly electricity usage changes. The team proposes this approach: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. Which technical principle explains the choice?

  1. RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.
  2. Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.
  3. A lakehouse combines lake-style file storage with table organization and analytical query access.
  4. Position along a time axis makes change and seasonality easier to compare across ordered periods.

Answer & Explanations

Correct answer: D

A.

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 Silvercrest Utilities managers review monthly electricity usage changes. The actual mechanism is: Position along a time axis makes change and seasonality easier to compare across ordered periods.

B.

Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules. That explains a separate situation: At Silverpoint Banking an event publisher retries after a brief timeout. The current case is: At Silvercrest Utilities managers review monthly electricity usage changes. The actual mechanism is: Position along a time axis makes change and seasonality easier to compare across ordered periods.

C.

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 Silvercrest Utilities managers review monthly electricity usage changes. The actual mechanism is: Position along a time axis makes change and seasonality easier to compare across ordered periods.

D.

Position along a time axis makes change and seasonality easier to compare across ordered periods. This principle supports the intervention: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. The relevant scenario is: At Silvercrest Utilities managers review monthly electricity usage changes. Verify the result by: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

Question 967

At Silvercrest Utilities managers review monthly electricity usage changes. After implementing this approach—Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp—which result would most directly confirm success?

  1. Land sample JSON files and create a queryable curated table without discarding the original files.
  2. Select a fictional product category and verify only related sales transactions contribute to the visual.
  3. Plot fictional daily traffic for three months and verify the audience can follow growth and declines.
  4. Emit a synthetic threshold event and verify an immediate alert and a later analytical archive record.

Answer & Explanations

Correct answer: C

A.

Land sample JSON files and create a queryable curated table without discarding the original files. This tests a separate situation: At Cedarbridge Media analysts combine raw events and curated advertising tables. The observed case is: At Silvercrest Utilities managers review monthly electricity usage changes. Use this acceptance check instead: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

B.

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 Silvercrest Utilities managers review monthly electricity usage changes. Use this acceptance check instead: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

C.

Plot fictional daily traffic for three months and verify the audience can follow growth and declines. This tests the targeted action: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp. The reason is: Position along a time axis makes change and seasonality easier to compare across ordered periods. The reported case is: At Silvercrest Utilities managers review monthly electricity usage changes.

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 Silvercrest Utilities managers review monthly electricity usage changes. Use this acceptance check instead: Plot fictional daily traffic for three months and verify the audience can follow growth and declines.

Question 968

At Silvercrest Utilities managers review monthly electricity usage changes. Which shortcut most directly threatens the intended data outcome?

  1. Display hundreds of daily values as separate indistinguishable pie slices.
  2. Assign every delayed event to the moment it reached the processor with no policy.
  3. Assume creating a Power BI chart automatically ingests all missing source history into Fabric.
  4. Use a pie chart to prove one numeric factor causes another.

Answer & Explanations

Correct answer: A

A.

Display hundreds of daily values as separate indistinguishable pie slices. The scenario is: At Silvercrest Utilities managers review monthly electricity usage changes. This undermines the mechanism: Position along a time axis makes change and seasonality easier to compare across ordered periods. Instead: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

B.

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 Silvercrest Utilities managers review monthly electricity usage changes—reject: Display hundreds of daily values as separate indistinguishable pie slices. The safer response is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

C.

Assume creating a Power BI chart automatically ingests all missing source history into Fabric. This concerns another issue: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. In the stated case—At Silvercrest Utilities managers review monthly electricity usage changes—reject: Display hundreds of daily values as separate indistinguishable pie slices. The safer response is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

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 Silvercrest Utilities managers review monthly electricity usage changes—reject: Display hundreds of daily values as separate indistinguishable pie slices. The safer response is: Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.

Question 969

At Cedarbank Logistics supervisors compare delivery counts among depots. Which design or Azure data approach best fits this requirement?

  1. Choose a line chart for a continuous time trend rather than using a pie chart for every timestamp.
  2. Use Azure Event Hubs to ingest high-volume event streams from supported producers before downstream processing.
  3. Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
  4. Choose a bar chart for comparing distinct categories with a common quantitative scale.

Answer & Explanations

Correct answer: D

A.

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 Cedarbank Logistics supervisors compare delivery counts among depots. The relevant action here is: Choose a bar chart for comparing distinct categories with a common quantitative scale.

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 Cedarbank Logistics supervisors compare delivery counts among depots. The relevant action here is: Choose a bar chart for comparing distinct categories with a common quantitative scale.

C.

Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration. This addresses a different situation: At Pinecrest Finance a Fabric workspace combines ERP exports and customer support metrics. The present case is: At Cedarbank Logistics supervisors compare delivery counts among depots. The relevant action here is: Choose a bar chart for comparing distinct categories with a common quantitative scale.

D.

Choose a bar chart for comparing distinct categories with a common quantitative scale. This works because: Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols. The scenario is: At Cedarbank Logistics supervisors compare delivery counts among depots. Verify the outcome by: Plot fictional shipments by region and verify the largest and smallest categories are apparent.

Question 970

At Cedarbank Logistics supervisors compare delivery counts among depots. The team proposes this approach: Choose a bar chart for comparing distinct categories with a common quantitative scale. Which technical principle explains the choice?

  1. Each point shows paired numeric values and can reveal patterns or outliers without implying causation.
  2. Orchestration triggers data movement, records failures and coordinates dependent processing stages.
  3. Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.
  4. Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules.

Answer & Explanations

Correct answer: C

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 Cedarbank Logistics supervisors compare delivery counts among depots. The actual mechanism is: Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.

B.

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 Cedarbank Logistics supervisors compare delivery counts among depots. The actual mechanism is: Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.

C.

Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols. This principle supports the intervention: Choose a bar chart for comparing distinct categories with a common quantitative scale. The relevant scenario is: At Cedarbank Logistics supervisors compare delivery counts among depots. Verify the result by: Plot fictional shipments by region and verify the largest and smallest categories are apparent.

D.

Retries and event-time disorder can produce duplicate or tardy events that require stable IDs and window rules. That explains a separate situation: At Silverpoint Banking an event publisher retries after a brief timeout. The current case is: At Cedarbank Logistics supervisors compare delivery counts among depots. The actual mechanism is: Aligned bar lengths communicate relative magnitudes across discrete groups more clearly than unrelated symbols.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests