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 100

Question 990

At Meadowfield Healthcare clinic analysts must not access other sites' records. The team proposes this approach: Apply Power BI row-level security when different users should see only their permitted records. Which technical principle explains the choice?

  1. The semantic model defines shared data types, relationships and measures so reports interpret business figures consistently.
  2. Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services.
  3. A hot streaming path reacts promptly while the cold path can consolidate history for deeper analysis.
  4. RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

Answer & Explanations

Correct answer: D

A.

The semantic model defines shared data types, relationships and measures so reports interpret business figures consistently. That explains a separate situation: At Harborbank Retail executives need sales dashboards sharing one definition of revenue. The current case is: At Meadowfield Healthcare clinic analysts must not access other sites' records. The actual mechanism is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

B.

Data Factory pipelines coordinate copy activities, triggers, transformations and operational monitoring across services. That explains a separate situation: At Harborpoint Education SQL and file extracts feed a shared Azure reporting lake. The current case is: At Meadowfield Healthcare clinic analysts must not access other sites' records. The actual mechanism is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

C.

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 Meadowfield Healthcare clinic analysts must not access other sites' records. The actual mechanism is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals.

D.

RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. This principle supports the intervention: Apply Power BI row-level security when different users should see only their permitted records. The relevant scenario is: At Meadowfield Healthcare clinic analysts must not access other sites' records. Verify the result by: Test two fictional regional managers and confirm each can query only their permitted region.

Question 991

At Meadowfield Healthcare clinic analysts must not access other sites' records. After implementing this approach—Apply Power BI row-level security when different users should see only their permitted records—which result would most directly confirm success?

  1. Test two fictional regional managers and confirm each can query only their permitted region.
  2. Select a fictional product category and verify only related sales transactions contribute to the visual.
  3. Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination.
  4. Build a small sales fact table and product dimension then verify a category-filtered revenue total.

Answer & Explanations

Correct answer: A

A.

Test two fictional regional managers and confirm each can query only their permitted region. This tests the targeted action: Apply Power BI row-level security when different users should see only their permitted records. The reason is: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. The reported case is: At Meadowfield Healthcare clinic analysts must not access other sites' records.

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 Meadowfield Healthcare clinic analysts must not access other sites' records. Use this acceptance check instead: Test two fictional regional managers and confirm each can query only their permitted region.

C.

Stream sample temperature events, filter values above a threshold and verify only matching output reaches the destination. This tests a separate situation: At Pinebrook Facilities sensors send readings to an event hub. The observed case is: At Meadowfield Healthcare clinic analysts must not access other sites' records. Use this acceptance check instead: Test two fictional regional managers and confirm each can query only their permitted region.

D.

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 Meadowfield Healthcare clinic analysts must not access other sites' records. Use this acceptance check instead: Test two fictional regional managers and confirm each can query only their permitted region.

Question 992

At Meadowfield Healthcare clinic analysts must not access other sites' records. Which shortcut most directly threatens the intended data outcome?

  1. Treat an Event Hubs namespace as a permanent SQL warehouse with relational joins.
  2. Display hundreds of daily values as separate indistinguishable pie slices.
  3. Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted.
  4. Reappend the entire transaction history each hour with no deduplication.

Answer & Explanations

Correct answer: C

A.

Treat an Event Hubs namespace as a permanent SQL warehouse with relational joins. This concerns another issue: At Harborcrest Transport thousands of vehicles emit location updates. In the stated case—At Meadowfield Healthcare clinic analysts must not access other sites' records—reject: Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. The safer response is: Apply Power BI row-level security when different users should see only their permitted records.

B.

Display hundreds of daily values as separate indistinguishable pie slices. This concerns another issue: At Meadowport Media analysts inspect daily subscription signups. In the stated case—At Meadowfield Healthcare clinic analysts must not access other sites' records—reject: Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. The safer response is: Apply Power BI row-level security when different users should see only their permitted records.

C.

Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. The scenario is: At Meadowfield Healthcare clinic analysts must not access other sites' records. This undermines the mechanism: RLS filters model rows according to configured role rules and identity mapping rather than merely hiding visuals. Instead: Apply Power BI row-level security when different users should see only their permitted records.

D.

Reappend the entire transaction history each hour with no deduplication. This concerns another issue: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. In the stated case—At Meadowfield Healthcare clinic analysts must not access other sites' records—reject: Hide a confidential table on the report canvas while leaving its underlying dataset unrestricted. The safer response is: Apply Power BI row-level security when different users should see only their permitted records.

Question 993

At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. Which design or Azure data approach best fits this requirement?

  1. Use Microsoft Fabric Data Factory pipelines where a Fabric analytics workspace needs governed ingestion and transformation orchestration.
  2. Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.
  3. Choose Import mode for a Power BI model when in-memory interaction is desired and scheduled freshness is acceptable.
  4. Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events.

Answer & Explanations

Correct answer: B

A.

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 Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The relevant action here is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

B.

Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. This works because: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. The scenario is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. Verify the outcome by: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

C.

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 Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The relevant action here is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

D.

Use Azure Stream Analytics for a supported continuous stream query that filters and aggregates incoming events. This addresses a different situation: At Pinebrook Facilities sensors send readings to an event hub. The present case is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The relevant action here is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

Question 994

At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The team proposes this approach: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. Which technical principle explains the choice?

  1. Extract-transform-load performs transformations before storing the final warehouse-ready form.
  2. Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks.
  3. Model relationships propagate filter context between related tables according to direction and cardinality.
  4. Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.

Answer & Explanations

Correct answer: D

A.

Extract-transform-load performs transformations before storing the final warehouse-ready form. That explains a separate situation: At Cedarfield Finance external invoices need standard currency codes before reporting. The current case is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The actual mechanism is: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.

B.

Eventstreams can connect event sources to Fabric's real-time processing experiences and selected sinks. That explains a separate situation: At Cedarcrest Media live audience actions feed a Fabric real-time dashboard. The current case is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The actual mechanism is: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.

C.

Model relationships propagate filter context between related tables according to direction and cardinality. That explains a separate situation: At Harborfield Commerce sales facts reference a product dimension. The current case is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The actual mechanism is: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.

D.

Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. This principle supports the intervention: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. The relevant scenario is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. Verify the result by: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

Question 995

At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. After implementing this approach—Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles—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. Plot fictional shipments by region and verify the largest and smallest categories are apparent.
  3. Update two fictional source records and confirm the second pipeline run imports only eligible changes.
  4. Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

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 Harborland Banking executives monitor headline risk indicators and analysts need detail pages. Use this acceptance check instead: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

B.

Plot fictional shipments by region and verify the largest and smallest categories are apparent. This tests a separate situation: At Cedarbank Logistics supervisors compare delivery counts among depots. The observed case is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. Use this acceptance check instead: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

C.

Update two fictional source records and confirm the second pipeline run imports only eligible changes. This tests a separate situation: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. The observed case is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. Use this acceptance check instead: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

D.

Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report. This tests the targeted action: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. The reason is: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. The reported case is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages.

Question 996

At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. Which shortcut most directly threatens the intended data outcome?

  1. Use a pie chart to prove one numeric factor causes another.
  2. Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions.
  3. Place every descriptive product attribute into repeated transaction rows without a governed dimension model.
  4. Treat each retransmission as a brand-new purchase.

Answer & Explanations

Correct answer: B

A.

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 Harborland Banking executives monitor headline risk indicators and analysts need detail pages—reject: Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. The safer response is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

B.

Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. The scenario is: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. This undermines the mechanism: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. Instead: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

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 Harborland Banking executives monitor headline risk indicators and analysts need detail pages—reject: Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. The safer response is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

D.

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 Harborland Banking executives monitor headline risk indicators and analysts need detail pages—reject: Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. The safer response is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

Question 997

At Pinecrest Logistics an operations wallboard links to interactive shipment reports. Which design or Azure data approach best fits this requirement?

  1. Choose a bar chart for comparing distinct categories with a common quantitative scale.
  2. Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.
  3. Use Microsoft Fabric Real-Time Intelligence eventstream capabilities when live events must feed governed Fabric analytics destinations.
  4. Configure a scheduled ingestion pipeline with monitoring and retries instead of manually copying reports.

Answer & Explanations

Correct answer: B

A.

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 Pinecrest Logistics an operations wallboard links to interactive shipment reports. The relevant action here is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

B.

Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. This works because: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. The scenario is: At Pinecrest Logistics an operations wallboard links to interactive shipment reports. Verify the outcome by: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

C.

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 Pinecrest Logistics an operations wallboard links to interactive shipment reports. The relevant action here is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

D.

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 Pinecrest Logistics an operations wallboard links to interactive shipment reports. The relevant action here is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

Question 998

At Pinecrest Logistics an operations wallboard links to interactive shipment reports. The team proposes this approach: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. Which technical principle explains the choice?

  1. Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.
  2. Larger batch jobs can be efficient but delay availability, so cadence must match business SLAs.
  3. A measure is evaluated under the report's current filter context while a calculated column is stored per row after refresh.
  4. Event time reflects when the source event happened; processing time reflects when the system saw it.

Answer & Explanations

Correct answer: A

A.

Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. This principle supports the intervention: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. The relevant scenario is: At Pinecrest Logistics an operations wallboard links to interactive shipment reports. Verify the result by: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

B.

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 Pinecrest Logistics an operations wallboard links to interactive shipment reports. The actual mechanism is: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.

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 Pinecrest Logistics an operations wallboard links to interactive shipment reports. The actual mechanism is: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.

D.

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 Pinecrest Logistics an operations wallboard links to interactive shipment reports. The actual mechanism is: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics.

Question 999

At Pinecrest Logistics an operations wallboard links to interactive shipment reports. After implementing this approach—Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles—which result would most directly confirm success?

  1. Update two fictional source records and confirm the second pipeline run imports only eligible changes.
  2. Send synthetic purchases across a five-minute interval and verify the window aggregate resets as designed.
  3. Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.
  4. Test two fictional regional managers and confirm each can query only their permitted region.

Answer & Explanations

Correct answer: C

A.

Update two fictional source records and confirm the second pipeline run imports only eligible changes. This tests a separate situation: At Cedarbank Payments the warehouse must refresh recent settlements without reloading years of history. The observed case is: At Pinecrest Logistics an operations wallboard links to interactive shipment reports. Use this acceptance check instead: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

B.

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 Pinecrest Logistics an operations wallboard links to interactive shipment reports. Use this acceptance check instead: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

C.

Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report. This tests the targeted action: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. The reason is: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. The reported case is: At Pinecrest Logistics an operations wallboard links to interactive shipment reports.

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 Pinecrest Logistics an operations wallboard links to interactive shipment reports. Use this acceptance check instead: Build a fictional multi-page sales report and pin a selected KPI to a dashboard without losing the source report.

Question 1000

At Pinecrest Logistics an operations wallboard links to interactive shipment reports. Which shortcut most directly threatens the intended data outcome?

  1. Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake.
  2. Treat each retransmission as a brand-new purchase.
  3. Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions.
  4. Connect unrelated tables by matching display names that are not stable unique keys.

Answer & Explanations

Correct answer: C

A.

Assume data becomes publicly visible or correctly permissioned simply because it was placed into OneLake. This concerns another issue: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. In the stated case—At Pinecrest Logistics an operations wallboard links to interactive shipment reports—reject: Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. The safer response is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

B.

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 Pinecrest Logistics an operations wallboard links to interactive shipment reports—reject: Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. The safer response is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

C.

Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. The scenario is: At Pinecrest Logistics an operations wallboard links to interactive shipment reports. This undermines the mechanism: Reports support detailed interactive visuals and filters while dashboards provide a consolidated surface for monitoring selected metrics. Instead: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

D.

Connect unrelated tables by matching display names that are not stable unique keys. This concerns another issue: At Harborfield Commerce sales facts reference a product dimension. In the stated case—At Pinecrest Logistics an operations wallboard links to interactive shipment reports—reject: Assume a pinned dashboard tile automatically replaces all report-level exploration and model definitions. The safer response is: Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests