Microsoft DP-900 Practice Test 102
Question 1010
An alert should consider recent traffic repeatedly as time advances. What is the MOST appropriate next validation or correction?
- Test click streams with gaps shorter and longer than timeout.
- Test known event timestamps against expected overlapping windows.
- Check selected locations against known coordinates and category labels.
- Set the hop equal to two hours and assume a ten-minute window updates every minute.
Explanation
Correct Answer
B:Test known event timestamps against expected overlapping windows. This tests the intended result: a single event can contribute to overlapping eligible windows.
Incorrect Answers
A:Test click streams with gaps shorter and longer than timeout. It tests Session windows of event activity rather than the critical Hopping sliding analytic windows behavior. Hopping windows allow overlapping periodic aggregation.
C:Check selected locations against known coordinates and category labels. It tests Map visual geographic measures rather than the critical Hopping sliding analytic windows behavior. Hopping windows allow overlapping periodic aggregation.
D:Set the hop equal to two hours and assume a ten-minute window updates every minute. This unsafe shortcut leaves the Hopping sliding analytic windows problem unresolved. Treating overlapping counts as disjoint totals can double-count dashboard sums.
Question 1011
A clinic must store diagnostic photographs without assuming pixels are relational columns. After selecting the proper Unstructured image binary files approach, which observation gives the clearest evidence of success?
- Content is retrieved by object name using approved credentials or signed access.
- Queries access intended documents efficiently under the chosen API and partition design.
- Images are retrieved without pretending their visual content is already tabular data.
- Consumers can read core fields and safely handle absent optional keys.
Explanation
Correct Answer
C:Images are retrieved without pretending their visual content is already tabular data. This is the directly observable result for Unstructured image binary files; unstructured images lack a predefined row-column model even when their metadata is structured.
Incorrect Answers
A:Content is retrieved by object name using approved credentials or signed access. This supports Azure Blob Storage for object data, not confirmation of Unstructured image binary files. The relevant evidence is that images are retrieved without pretending their visual content is already tabular data.
B:Queries access intended documents efficiently under the chosen API and partition design. This supports Cosmos DB for distributed JSON apps, not confirmation of Unstructured image binary files. The relevant evidence is that images are retrieved without pretending their visual content is already tabular data.
D:Consumers can read core fields and safely handle absent optional keys. This supports Semi structured JSON documents, not confirmation of Unstructured image binary files. The relevant evidence is that images are retrieved without pretending their visual content is already tabular data.
Question 1012
An import pipeline must reject malformed data before it enters the target mart. Which principle BEST explains the correct ETL data transformation before loading design decision?
- Structured relational and semi-structured document models solve different shape and access needs.
- Data quality requires explicit rules tied to business meaning.
- Schema enforcement timing differs between flexible raw storage and strongly typed operational stores.
- ETL transforms data before loading into its final analytical store.
Explanation
Correct Answer
D:ETL transforms data before loading into its final analytical store. In this case the applicable decision is to extract clean and transform upstream then load only validated results.
Incorrect Answers
A:Structured relational and semi-structured document models solve different shape and access needs. That concept explains Relational rows versus document attributes; the situation instead concerns ETL data transformation before loading. Skipping input validation contaminates downstream metrics.
B:Data quality requires explicit rules tied to business meaning. That concept explains Data quality completeness and accuracy; the situation instead concerns ETL data transformation before loading. Skipping input validation contaminates downstream metrics.
C:Schema enforcement timing differs between flexible raw storage and strongly typed operational stores. That concept explains Schema-on-read versus schema-on-write; the situation instead concerns ETL data transformation before loading. Skipping input validation contaminates downstream metrics.
Question 1013
A team wants a reusable projection without copying all underlying table data. Which principle BEST explains the correct SQL view virtual query object design decision?
- Managed Instance has deployment/networking characteristics that differ from a single SQL Database.
- SQL authentication and network reachability are separate gates.
- A standard relational view stores a query definition not necessarily physical copies.
- A table can enforce uniqueness on nonprimary attributes.
Explanation
Correct Answer
C:A standard relational view stores a query definition not necessarily physical copies. In this case the applicable decision is to create a view exposing the approved query and grant access appropriately.
Incorrect Answers
A:Managed Instance has deployment/networking characteristics that differ from a single SQL Database. That concept explains SQL Managed Instance virtual network; the situation instead concerns SQL view virtual query object. Assuming views automatically encrypt their base tables misstates access protection.
B:SQL authentication and network reachability are separate gates. That concept explains Azure SQL firewall and private endpoint; the situation instead concerns SQL view virtual query object. Assuming views automatically encrypt their base tables misstates access protection.
D:A table can enforce uniqueness on nonprimary attributes. That concept explains Unique index versus primary key; the situation instead concerns SQL view virtual query object. Assuming views automatically encrypt their base tables misstates access protection.
Question 1014
A report shows annual totals but cannot explain a specific month. Which principle BEST explains the correct Drill-down hierarchy for time design decision?
- Activator turns detected data conditions into governed actions.
- OneLake unifies data access across Fabric but permissions and organization still matter.
- Geographic visuals require accurate location encoding and appropriate map granularity.
- Hierarchies let users navigate aggregation levels.
Explanation
Correct Answer
D:Hierarchies let users navigate aggregation levels. In this case the applicable decision is to build an appropriate date hierarchy and enable drill-down interactions.
Incorrect Answers
A:Activator turns detected data conditions into governed actions. That concept explains Fabric Activator rule-triggered action; the situation instead concerns Drill-down hierarchy for time. Using a text-sorted MonthName without year context can misorder periods.
B:OneLake unifies data access across Fabric but permissions and organization still matter. That concept explains Microsoft Fabric OneLake unified storage; the situation instead concerns Drill-down hierarchy for time. Using a text-sorted MonthName without year context can misorder periods.
C:Geographic visuals require accurate location encoding and appropriate map granularity. That concept explains Map visual geographic measures; the situation instead concerns Drill-down hierarchy for time. Using a text-sorted MonthName without year context can misorder periods.
Question 1015
A commerce application depends on MySQL client drivers and SQL dialect. After selecting the proper Azure MySQL versus PostgreSQL service-model selection approach, which observation gives the clearest evidence of success?
- Consumers can read core fields and safely handle absent optional keys.
- Sample accents and amounts survive round-trip without becoming different values.
- Existing MySQL queries and connections work with a managed service.
- Failure tests and recovery objectives align with documented copy and recovery mechanisms.
Explanation
Correct Answer
C:Existing MySQL queries and connections work with a managed service. This is the directly observable result for Azure MySQL versus PostgreSQL service-model selection; managed open-source database services retain engine-specific behavior.
Incorrect Answers
A:Consumers can read core fields and safely handle absent optional keys. This supports Semi structured JSON documents, not confirmation of Azure MySQL versus PostgreSQL service-model selection. The relevant evidence is that existing MySQL queries and connections work with a managed service.
B:Sample accents and amounts survive round-trip without becoming different values. This supports Text encoding and numeric parsing, not confirmation of Azure MySQL versus PostgreSQL service-model selection. The relevant evidence is that existing MySQL queries and connections work with a managed service.
D:Failure tests and recovery objectives align with documented copy and recovery mechanisms. This supports Storage resiliency and replicas, not confirmation of Azure MySQL versus PostgreSQL service-model selection. The relevant evidence is that existing MySQL queries and connections work with a managed service.
Question 1016
A design team incorrectly treats event broker retention as a permanent warehouse. Select THREE statements that correctly describe the Stream retention and historical analytics implementation and how it can be verified.
- Treat a 24-hour Event Hubs retention policy as a ten-year audit archive.
- Choose Fabric Lakehouse with controlled table metadata and files.
- Stream brokers and analytical stores have different persistence and replay roles.
- Historical queries remain possible after the broker retention period expires.
- Create supported Fabric Eventstreams transformations and destination routing.
- Land required events into suitable persistent analytics storage while using stream retention for replay.
Explanation
Correct Answers
C:Stream brokers and analytical stores have different persistence and replay roles. This supports why the action and evidence together address Stream retention and historical analytics.
D:Historical queries remain possible after the broker retention period expires. This is directly observable success evidence for Stream retention and historical analytics.
F:Land required events into suitable persistent analytics storage while using stream retention for replay. This is an appropriate action for the Stream retention and historical analytics case. Stream brokers and analytical stores have different persistence and replay roles.
Incorrect Answers
A:Treat a 24-hour Event Hubs retention policy as a ten-year audit archive. This is not a safe or appropriate Stream retention and historical analytics implementation. Failing to archive selected events loses history after retention.
B:Choose Fabric Lakehouse with controlled table metadata and files. This implements Fabric Lakehouse managed tables and files instead of the required Stream retention and historical analytics function. Stream brokers and analytical stores have different persistence and replay roles.
E:Create supported Fabric Eventstreams transformations and destination routing. This implements Fabric Eventstreams real-time routing instead of the required Stream retention and historical analytics function. Stream brokers and analytical stores have different persistence and replay roles.
Question 1017
A global app needs data accessible near European and Asian customers. After selecting the proper Cosmos DB multi-region distribution approach, which observation gives the clearest evidence of success?
- Supported clients mount the share and read or write approved paths.
- Region-aware clients continue within documented replication and failover behavior.
- Load tests avoid concentrating throughput on one logical partition.
- Content assembles correctly and clients retrieve the intended object version.
Explanation
Correct Answer
B:Region-aware clients continue within documented replication and failover behavior. This is the directly observable result for Cosmos DB multi-region distribution; global distribution can reduce distance but replicas and failover require explicit choices.
Incorrect Answers
A:Supported clients mount the share and read or write approved paths. This supports Azure Files SMB application migration, not confirmation of Cosmos DB multi-region distribution. The relevant evidence is that region-aware clients continue within documented replication and failover behavior.
C:Load tests avoid concentrating throughput on one logical partition. This supports Cosmos DB logical partition key, not confirmation of Cosmos DB multi-region distribution. The relevant evidence is that region-aware clients continue within documented replication and failover behavior.
D:Content assembles correctly and clients retrieve the intended object version. This supports Block blob file uploads, not confirmation of Cosmos DB multi-region distribution. The relevant evidence is that region-aware clients continue within documented replication and failover behavior.
Question 1018
Sensor readings arrive continuously rather than as one daily archive. Select TWO statements that correctly describe the Event streaming continual processing implementation and how it can be verified.
- New readings trigger timely results within defined event latency.
- Ingest and evaluate events as they arrive with a streaming pipeline.
- Define quality checks for missing invalid and duplicate business records.
- Evaluate latency concurrency query style and update volume before choosing a store.
- Run one report at midnight and label it a continuous stream.
Explanation
Correct Answers
A:New readings trigger timely results within defined event latency. This is directly observable success evidence for Event streaming continual processing.
B:Ingest and evaluate events as they arrive with a streaming pipeline. This is an appropriate action for the Event streaming continual processing case. Streaming processes ongoing events instead of waiting for a full batch.
Incorrect Answers
C:Define quality checks for missing invalid and duplicate business records. This implements Data quality completeness and accuracy instead of the required Event streaming continual processing function. Streaming processes ongoing events instead of waiting for a full batch.
D:Evaluate latency concurrency query style and update volume before choosing a store. This implements Data platform read and write profiles instead of the required Event streaming continual processing function. Streaming processes ongoing events instead of waiting for a full batch.
E:Run one report at midnight and label it a continuous stream. This is not a safe or appropriate Event streaming continual processing implementation. Treating a high-rate stream as an hourly CSV export delays detection.
Question 1019
A cache service wants an incremental stream instead of rereading every item. Select TWO statements that correctly describe the Cosmos DB change feed updates implementation and how it can be verified.
- Downstream reflects expected eligible changes without repeated full scans.
- Use a monthly screenshot as a real-time document change feed.
- Distinguish Cosmos DB for NoSQL query language from relational T-SQL.
- Consider append blobs for append-based writes with appropriate access and retention controls.
- Consume a supported Cosmos DB change feed with checkpointed processing.
Explanation
Correct Answers
A:Downstream reflects expected eligible changes without repeated full scans. This is directly observable success evidence for Cosmos DB change feed updates.
E:Consume a supported Cosmos DB change feed with checkpointed processing. This is an appropriate action for the Cosmos DB change feed updates case. Change feeds support incremental change-driven processing with defined change semantics.
Incorrect Answers
B:Use a monthly screenshot as a real-time document change feed. This is not a safe or appropriate Cosmos DB change feed updates implementation. Ignoring checkpoints may duplicate downstream actions on retries.
C:Distinguish Cosmos DB for NoSQL query language from relational T-SQL. This implements Cosmos DB API for NoSQL versus SQL text instead of the required Cosmos DB change feed updates function. Change feeds support incremental change-driven processing with defined change semantics.
D:Consider append blobs for append-based writes with appropriate access and retention controls. This implements Append blob sequential logging instead of the required Cosmos DB change feed updates function. Change feeds support incremental change-driven processing with defined change semantics.
Question 1020
A data engineer wants to quarantine malformed rows before the BI layer. What is the MOST appropriate next validation or correction?
- Rename one raw folder Gold and assume quality checks have executed.
- Trace sample errors through each refinement layer.
- Check workspace and OneLake access from representative users.
- Test one authorized and one revoked device connection.
Explanation
Correct Answer
B:Trace sample errors through each refinement layer. This tests the intended result: gold measures reconcile to corrected silver and source bronze records.
Incorrect Answers
A:Rename one raw folder Gold and assume quality checks have executed. This unsafe shortcut leaves the Bronze silver gold medallion design problem unresolved. Letting reports query unvalidated raw events can create misleading metrics.
C:Check workspace and OneLake access from representative users. It tests Microsoft Fabric OneLake unified storage rather than the critical Bronze silver gold medallion design behavior. Medallion layers make data refinement and reuse explicit.
D:Test one authorized and one revoked device connection. It tests Azure IoT Hub device messaging rather than the critical Bronze silver gold medallion design behavior. Medallion layers make data refinement and reuse explicit.