Microsoft DP-900 Dumps
Microsoft DP-900 Practice Test 72
Question 710
At Cedarport Retail a document catalog filters a small set of product attributes. The team proposes this approach: Use controlled Cosmos DB indexing policies to match query paths while accounting for write costs. Which technical principle explains the choice?
Answer & Explanations
Correct answer: A
Cosmos DB automatically indexes data under its policy; excluding unnecessary paths can reduce index maintenance for writes. This principle supports the intervention: Use controlled Cosmos DB indexing policies to match query paths while accounting for write costs. The relevant scenario is: At Cedarport Retail a document catalog filters a small set of product attributes. Verify the result by: Compare a representative query and insert workload before and after adjusting a test indexing policy.
Cooler online tiers reduce capacity cost when data is seldom read, subject to minimum duration and access charges. That explains a separate situation: At Silverbridge Insurance last year's claim attachments are accessed only occasionally. The current case is: At Cedarport Retail a document catalog filters a small set of product attributes. The actual mechanism is: Cosmos DB automatically indexes data under its policy; excluding unnecessary paths can reduce index maintenance for writes.
The NoSQL API addresses JSON items through containers, partition keys and the service's own query model. That explains a separate situation: At Cedarfield Apps developers build a new JSON-first profile service. The current case is: At Cedarport Retail a document catalog filters a small set of product attributes. The actual mechanism is: Cosmos DB automatically indexes data under its policy; excluding unnecessary paths can reduce index maintenance for writes.
A point read targets one item directly and commonly consumes fewer request units than an equivalent broad query. That explains a separate situation: At Cedarbrook Finance an application looks up one invoice document by known keys. The current case is: At Cedarport Retail a document catalog filters a small set of product attributes. The actual mechanism is: Cosmos DB automatically indexes data under its policy; excluding unnecessary paths can reduce index maintenance for writes.
Question 711
At Cedarport Retail a document catalog filters a small set of product attributes. After implementing this approach—Use controlled Cosmos DB indexing policies to match query paths while accounting for write costs—which result would most directly confirm success?
Answer & Explanations
Correct answer: D
Open a fictional blob with an allowed test SAS and verify a nonallowed operation or expired token is rejected. This tests a separate situation: At Silverlake Media a partner needs temporary read access to one approved asset. The observed case is: At Cedarport Retail a document catalog filters a small set of product attributes. Use this acceptance check instead: Compare a representative query and insert workload before and after adjusting a test indexing policy.
Write a synthetic value and test subsequent reads across configured clients and regions. This tests a separate situation: At Silverline Events a newly reserved seat must have a carefully defined visibility guarantee. The observed case is: At Cedarport Retail a document catalog filters a small set of product attributes. Use this acceptance check instead: Compare a representative query and insert workload before and after adjusting a test indexing policy.
Fetch a fictional profile by its ID and partition key and compare its request-unit charge with a query scan. This tests a separate situation: At Cedarbrook Finance an application looks up one invoice document by known keys. The observed case is: At Cedarport Retail a document catalog filters a small set of product attributes. Use this acceptance check instead: Compare a representative query and insert workload before and after adjusting a test indexing policy.
Compare a representative query and insert workload before and after adjusting a test indexing policy. This tests the targeted action: Use controlled Cosmos DB indexing policies to match query paths while accounting for write costs. The reason is: Cosmos DB automatically indexes data under its policy; excluding unnecessary paths can reduce index maintenance for writes. The reported case is: At Cedarport Retail a document catalog filters a small set of product attributes.
Question 712
At Cedarport Retail a document catalog filters a small set of product attributes. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: A
Remove every indexed path even though the production app filters on nested document fields. The scenario is: At Cedarport Retail a document catalog filters a small set of product attributes. This undermines the mechanism: Cosmos DB automatically indexes data under its policy; excluding unnecessary paths can reduce index maintenance for writes. Instead: Use controlled Cosmos DB indexing policies to match query paths while accounting for write costs.
Assume a relational T-SQL stored procedure runs unchanged against every Cosmos DB API. This concerns another issue: At Cedarfield Apps developers build a new JSON-first profile service. In the stated case—At Cedarport Retail a document catalog filters a small set of product attributes—reject: Remove every indexed path even though the production app filters on nested document fields. The safer response is: Use controlled Cosmos DB indexing policies to match query paths while accounting for write costs.
Grant subscription-wide owner access solely to read a single blob. This concerns another issue: At Meadowcrest Banking one analytics service reads a restricted statements container. In the stated case—At Cedarport Retail a document catalog filters a small set of product attributes—reject: Remove every indexed path even though the production app filters on nested document fields. The safer response is: Use controlled Cosmos DB indexing policies to match query paths while accounting for write costs.
Rename the database endpoint without evaluating driver and operator support. This concerns another issue: At Harborpoint Software an existing document app uses MongoDB clients. In the stated case—At Cedarport Retail a document catalog filters a small set of product attributes—reject: Remove every indexed path even though the production app filters on nested document fields. The safer response is: Use controlled Cosmos DB indexing policies to match query paths while accounting for write costs.
Question 713
At Cedarfield Finance external invoices need standard currency codes before reporting. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: C
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 Cedarfield Finance external invoices need standard currency codes before reporting. The relevant action here is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
Distinguish a Power BI report with interactive multiple-page exploration from a dashboard that presents pinned monitoring tiles. This addresses a different situation: At Harborland Banking executives monitor headline risk indicators and analysts need detail pages. The present case is: At Cedarfield Finance external invoices need standard currency codes before reporting. The relevant action here is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. This works because: Extract-transform-load performs transformations before storing the final warehouse-ready form. The scenario is: At Cedarfield Finance external invoices need standard currency codes before reporting. Verify the outcome by: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
Use versioned curated datasets and lineage metadata so analysts can trace transformations and reproduce reports. This addresses a different situation: At Cedarcrest Banking financial metrics require stable audit evidence. The present case is: At Cedarfield Finance external invoices need standard currency codes before reporting. The relevant action here is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
Question 714
At Cedarfield Finance external invoices need standard currency codes before reporting. The team proposes this approach: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. Which technical principle explains the choice?
Answer & Explanations
Correct answer: C
A warehouse supports curated structured models and analytic queries over integrated business entities. That explains a separate situation: At Silvercrest Commerce executives compare sales performance across regions. The current case is: At Cedarfield Finance external invoices need standard currency codes before reporting. The actual mechanism is: Extract-transform-load performs transformations before storing the final warehouse-ready form.
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 Cedarfield Finance external invoices need standard currency codes before reporting. The actual mechanism is: Extract-transform-load performs transformations before storing the final warehouse-ready form.
Extract-transform-load performs transformations before storing the final warehouse-ready form. This principle supports the intervention: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. The relevant scenario is: At Cedarfield Finance external invoices need standard currency codes before reporting. Verify the result by: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
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 Cedarfield Finance external invoices need standard currency codes before reporting. The actual mechanism is: Extract-transform-load performs transformations before storing the final warehouse-ready form.
Question 715
At Cedarfield Finance external invoices need standard currency codes before reporting. After implementing this approach—Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination—which result would most directly confirm success?
Answer & Explanations
Correct answer: B
Publish synthetic events, consume them through a test consumer group and verify offsets advance. This tests a separate situation: At Harborcrest Transport thousands of vehicles emit location updates. The observed case is: At Cedarfield Finance external invoices need standard currency codes before reporting. Use this acceptance check instead: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table. This tests the targeted action: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. The reason is: Extract-transform-load performs transformations before storing the final warehouse-ready form. The reported case is: At Cedarfield Finance external invoices need standard currency codes before reporting.
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 Cedarfield Finance external invoices need standard currency codes before reporting. Use this acceptance check instead: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
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 Cedarfield Finance external invoices need standard currency codes before reporting. Use this acceptance check instead: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
Question 716
At Cedarfield Finance external invoices need standard currency codes before reporting. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: 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 Cedarfield Finance external invoices need standard currency codes before reporting—reject: Label an unvalidated raw copy as a finished ETL process without a transformation step. The safer response is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
Treat a lakehouse as a requirement to convert every audio file directly into a relational transaction row. This concerns another issue: At Cedarbridge Media analysts combine raw events and curated advertising tables. In the stated case—At Cedarfield Finance external invoices need standard currency codes before reporting—reject: Label an unvalidated raw copy as a finished ETL process without a transformation step. The safer response is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
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 Cedarfield Finance external invoices need standard currency codes before reporting—reject: Label an unvalidated raw copy as a finished ETL process without a transformation step. The safer response is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
Label an unvalidated raw copy as a finished ETL process without a transformation step. The scenario is: At Cedarfield Finance external invoices need standard currency codes before reporting. The likely failure is: Reports inherit invalid source values and inconsistent types. Instead: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
Question 717
At Harborcrest Health claim data must have validated dates before warehouse ingestion. Which design or Azure data approach best fits this requirement?
Answer & Explanations
Correct answer: D
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 Harborcrest Health claim data must have validated dates before warehouse ingestion. The relevant action here is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
Use ELT when raw records can first land in a scalable analytical store and transformations run there. This addresses a different situation: At Meadowview Retail a cloud warehouse performs its own SQL cleaning after ingestion. The present case is: At Harborcrest Health claim data must have validated dates before warehouse ingestion. The relevant action here is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
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 Harborcrest Health claim data must have validated dates before warehouse ingestion. The relevant action here is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. This works because: Extract-transform-load performs transformations before storing the final warehouse-ready form. The scenario is: At Harborcrest Health claim data must have validated dates before warehouse ingestion. Verify the outcome by: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
Question 718
At Harborcrest Health claim data must have validated dates before warehouse ingestion. The team proposes this approach: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. Which technical principle explains the choice?
Answer & Explanations
Correct answer: D
OneLake provides shared storage for Fabric experiences, while workspace and item permissions still govern access. That explains a separate situation: At Meadowbank Insurance several Fabric teams need a centrally governed analytical foundation. The current case is: At Harborcrest Health claim data must have validated dates before warehouse ingestion. The actual mechanism is: Extract-transform-load performs transformations before storing the final warehouse-ready form.
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 Harborcrest Health claim data must have validated dates before warehouse ingestion. The actual mechanism is: Extract-transform-load performs transformations before storing the final warehouse-ready form.
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 Harborcrest Health claim data must have validated dates before warehouse ingestion. The actual mechanism is: Extract-transform-load performs transformations before storing the final warehouse-ready form.
Extract-transform-load performs transformations before storing the final warehouse-ready form. This principle supports the intervention: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. The relevant scenario is: At Harborcrest Health claim data must have validated dates before warehouse ingestion. Verify the result by: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
Question 719
At Harborcrest Health claim data must have validated dates before warehouse ingestion. After implementing this approach—Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination—which result would most directly confirm success?
Answer & Explanations
Correct answer: B
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 Harborcrest Health claim data must have validated dates before warehouse ingestion. Use this acceptance check instead: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table. This tests the targeted action: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination. The reason is: Extract-transform-load performs transformations before storing the final warehouse-ready form. The reported case is: At Harborcrest Health claim data must have validated dates before warehouse ingestion.
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 Harborcrest Health claim data must have validated dates before warehouse ingestion. Use this acceptance check instead: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
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 Harborcrest Health claim data must have validated dates before warehouse ingestion. Use this acceptance check instead: Import three synthetic source rows containing malformed dates and verify only validated clean records reach the reporting table.
Question 720
At Harborcrest Health claim data must have validated dates before warehouse ingestion. Which shortcut most directly threatens the intended data outcome?
Answer & Explanations
Correct answer: A
Label an unvalidated raw copy as a finished ETL process without a transformation step. The scenario is: At Harborcrest Health claim data must have validated dates before warehouse ingestion. This undermines the mechanism: Extract-transform-load performs transformations before storing the final warehouse-ready form. Instead: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
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 Harborcrest Health claim data must have validated dates before warehouse ingestion—reject: Label an unvalidated raw copy as a finished ETL process without a transformation step. The safer response is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
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 Harborcrest Health claim data must have validated dates before warehouse ingestion—reject: Label an unvalidated raw copy as a finished ETL process without a transformation step. The safer response is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
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 Harborcrest Health claim data must have validated dates before warehouse ingestion—reject: Label an unvalidated raw copy as a finished ETL process without a transformation step. The safer response is: Use an ETL pipeline when data must be cleansed and reshaped before loading the governed analytical destination.
Microsoft Azure Data Fundamentals (DP-900) Practice Tests
- Microsoft DP-900 Practice Test 70 - 10 Questions (Last Reviewed 06-Nov-2026)
- Microsoft DP-900 Practice Test 71 - 10 Questions (Last Reviewed 05-Nov-2026)
- Microsoft DP-900 Practice Test 72 - 10 Questions (Last Reviewed 04-Nov-2026)
- Microsoft DP-900 Practice Test 73 - 10 Questions (Last Reviewed 03-Nov-2026)
- Microsoft DP-900 Practice Test 74 - 10 Questions (Last Reviewed 02-Nov-2026)