Microsoft DP-900 Practice Test 97
Question 960
Architects choose one storage option only because both workloads contain integers. Which principle BEST explains the correct Data platform read and write profiles design decision?
- Data analysts define and test business measures rather than only placing visuals.
- Table Storage is a key-attribute NoSQL store not a relational SQL engine.
- Data store suitability depends on workload access patterns not only data types.
- Data engineers maintain resilient transformations when source structures change.
Explanation
Correct Answer
C:Data store suitability depends on workload access patterns not only data types. In this case the applicable decision is to evaluate latency concurrency query style and update volume before choosing a store.
Incorrect Answers
A:Data analysts define and test business measures rather than only placing visuals. That concept explains Data analyst metric definition; the situation instead concerns Data platform read and write profiles. Confusing high-throughput ingestion with low-latency point transactions causes poor performance.
B:Table Storage is a key-attribute NoSQL store not a relational SQL engine. That concept explains Azure Table Storage key-value entities; the situation instead concerns Data platform read and write profiles. Confusing high-throughput ingestion with low-latency point transactions causes poor performance.
D:Data engineers maintain resilient transformations when source structures change. That concept explains Data engineer schema and format changes; the situation instead concerns Data platform read and write profiles. Confusing high-throughput ingestion with low-latency point transactions causes poor performance.
Question 961
A processing service restarts while many events are buffered. After selecting the proper Streaming checkpoints and replay approach, which observation gives the clearest evidence of success?
- Report filters produce consistent business calculations.
- The engine scans relevant partitions rather than every archive folder.
- After restart the intended unread events are processed without uncontrolled duplication.
- Fraud alerts arrive promptly while daily reports complete within their SLA.
Explanation
Correct Answer
C:After restart the intended unread events are processed without uncontrolled duplication. This is the directly observable result for Streaming checkpoints and replay; checkpointing records stream progress; retries may still deliver records more than once.
Incorrect Answers
A:Report filters produce consistent business calculations. This supports Power BI semantic model measures, not confirmation of Streaming checkpoints and replay. The relevant evidence is that after restart the intended unread events are processed without uncontrolled duplication.
B:The engine scans relevant partitions rather than every archive folder. This supports Data lake partition pruning, not confirmation of Streaming checkpoints and replay. The relevant evidence is that after restart the intended unread events are processed without uncontrolled duplication.
D:Fraud alerts arrive promptly while daily reports complete within their SLA. This supports Streaming versus batch latency choice, not confirmation of Streaming checkpoints and replay. The relevant evidence is that after restart the intended unread events are processed without uncontrolled duplication.
Question 962
A user assumes its query language means Azure SQL server tables and joins. What is the MOST appropriate next validation or correction?
- Test nested JSON access versus relational join constraints.
- Test overwrites and restoration from the recorded version.
- Inspect key cardinality and request unit consumption per partition.
- Assume every service supporting SELECT enforces SQL Server foreign keys.
Explanation
Correct Answer
A:Test nested JSON access versus relational join constraints. This tests the intended result: document queries behave under partition and JSON item semantics.
Incorrect Answers
B:Test overwrites and restoration from the recorded version. It tests Blob versioning on overwrite rather than the critical Cosmos DB API for NoSQL versus SQL text behavior. Similar keyword syntax does not make NoSQL document storage a SQL Server database.
C:Inspect key cardinality and request unit consumption per partition. It tests Cosmos DB logical partition key rather than the critical Cosmos DB API for NoSQL versus SQL text behavior. Similar keyword syntax does not make NoSQL document storage a SQL Server database.
D:Assume every service supporting SELECT enforces SQL Server foreign keys. This unsafe shortcut leaves the Cosmos DB API for NoSQL versus SQL text problem unresolved. Expecting cross-table foreign keys in the NoSQL API can break designs.
Question 963
A web application must serve stored image assets with controlled access. What is the MOST appropriate next validation or correction?
- Validate object upload download and authorization from representative clients.
- Compare exact-ID lookups with text-search queries and relevance.
- Mount a blob container as an ordinary Windows SMB share without a compatible file service.
- Compare query scan and file counts across layouts.
Explanation
Correct Answer
A:Validate object upload download and authorization from representative clients. This tests the intended result: content is retrieved by object name using approved credentials or signed access.
Incorrect Answers
B:Compare exact-ID lookups with text-search queries and relevance. It tests Document indexing versus full-text search rather than the critical Azure Blob Storage for object data behavior. Blob is object storage rather than a shared SMB file system.
C:Mount a blob container as an ordinary Windows SMB share without a compatible file service. This unsafe shortcut leaves the Azure Blob Storage for object data problem unresolved. Choosing a database table purely to store vast image binaries complicates content delivery.
D:Compare query scan and file counts across layouts. It tests Data engineer partition and file layout rather than the critical Azure Blob Storage for object data behavior. Blob is object storage rather than a shared SMB file system.
Question 964
Several Fabric workspaces need to share governed analytical assets. Which choice BEST meets this requirement?
- Rename an Azure Files share OneLake and claim it automatically joins Fabric.
- Use event timestamps and supported late-event policies when analyzing event time.
- Use OneLake as the shared logical data-lake foundation for supported Fabric workloads.
- Partition files or tables using a suitable commonly filtered date key.
Explanation
Correct Answer
C:OneLake unifies data access across Fabric but permissions and organization still matter.
Incorrect Answers
A:Rename an Azure Files share OneLake and claim it automatically joins Fabric. It does not implement Microsoft Fabric OneLake unified storage. Assuming one lake makes every file publicly readable risks information exposure.
B:Use event timestamps and supported late-event policies when analyzing event time. That action primarily handles Event time versus processing time; the given requirement is Microsoft Fabric OneLake unified storage. OneLake unifies data access across Fabric but permissions and organization still matter.
D:Partition files or tables using a suitable commonly filtered date key. That action primarily handles Data lake partition pruning; the given requirement is Microsoft Fabric OneLake unified storage. OneLake unifies data access across Fabric but permissions and organization still matter.
Question 965
A Spark workload performs directory rename and partition discovery operations. Which principle BEST explains the correct ADLS Gen2 hierarchical namespace design decision?
- ADLS Gen2 layers hierarchical file namespace capabilities onto Blob storage.
- The Table API can support Table-style entity access within Cosmos DB.
- Cassandra API exposes a compatible wide-column model distinct from document NoSQL.
- Lifecycle management automates object policy based on supported filters and timing.
Explanation
Correct Answer
A:ADLS Gen2 layers hierarchical file namespace capabilities onto Blob storage. In this case the applicable decision is to use a hierarchical-namespace-enabled storage account for suitable lake needs.
Incorrect Answers
B:The Table API can support Table-style entity access within Cosmos DB. That concept explains Cosmos DB API for Table compatibility; the situation instead concerns ADLS Gen2 hierarchical namespace. Treating virtual folder name prefixes as identical to hierarchical directory ACLs can fail.
C:Cassandra API exposes a compatible wide-column model distinct from document NoSQL. That concept explains Cosmos DB API for Apache Cassandra; the situation instead concerns ADLS Gen2 hierarchical namespace. Treating virtual folder name prefixes as identical to hierarchical directory ACLs can fail.
D:Lifecycle management automates object policy based on supported filters and timing. That concept explains Blob lifecycle management rules; the situation instead concerns ADLS Gen2 hierarchical namespace. Treating virtual folder name prefixes as identical to hierarchical directory ACLs can fail.
Question 966
A web application must serve stored image assets with controlled access. Which principle BEST explains the correct Azure Blob Storage for object data design decision?
- A warehouse organizes integrated analytical tables optimized for reporting.
- Semi structured data has organizational markers without requiring identical columns in every record.
- Blob is object storage rather than a shared SMB file system.
- DBAs tune database performance as well as maintaining access and reliability.
Explanation
Correct Answer
C:Blob is object storage rather than a shared SMB file system. In this case the applicable decision is to select Azure Blob Storage for object-oriented binary and file-like content.
Incorrect Answers
A:A warehouse organizes integrated analytical tables optimized for reporting. That concept explains Analytical warehouse for structured reporting; the situation instead concerns Azure Blob Storage for object data. Choosing a database table purely to store vast image binaries complicates content delivery.
B:Semi structured data has organizational markers without requiring identical columns in every record. That concept explains Semi structured JSON documents; the situation instead concerns Azure Blob Storage for object data. Choosing a database table purely to store vast image binaries complicates content delivery.
D:DBAs tune database performance as well as maintaining access and reliability. That concept explains DBA performance tuning and indexing; the situation instead concerns Azure Blob Storage for object data. Choosing a database table purely to store vast image binaries complicates content delivery.
Question 967
A pipeline needs to load only records updated since its last successful run. Select TWO statements that correctly describe the Incremental ingestion with watermark implementation and how it can be verified.
- Consume supported change data capture events with reconciliation and delete semantics.
- Set the watermark to tomorrow to reduce data volume.
- Use Power Query transformations with explicit type conversion and reusable steps.
- Every eligible change since prior success appears exactly as required downstream.
- Maintain a reliable watermark or change tracking checkpoint for incremental loads.
Explanation
Correct Answers
D:Every eligible change since prior success appears exactly as required downstream. This is directly observable success evidence for Incremental ingestion with watermark.
E:Maintain a reliable watermark or change tracking checkpoint for incremental loads. This is an appropriate action for the Incremental ingestion with watermark case. Incremental load avoids repeated full snapshots while demanding consistent checkpoints.
Incorrect Answers
A:Consume supported change data capture events with reconciliation and delete semantics. This implements CDC propagation to analytics instead of the required Incremental ingestion with watermark function. Incremental load avoids repeated full snapshots while demanding consistent checkpoints.
B:Set the watermark to tomorrow to reduce data volume. This is not a safe or appropriate Incremental ingestion with watermark implementation. Advancing the watermark before successful commit may skip data.
C:Use Power Query transformations with explicit type conversion and reusable steps. This implements Power Query shaping transformation instead of the required Incremental ingestion with watermark function. Incremental load avoids repeated full snapshots while demanding consistent checkpoints.
Question 968
A team wants a reusable projection without copying all underlying table data. Select TWO statements that correctly describe the SQL view virtual query object implementation and how it can be verified.
- Use the supported Azure SQL point-in-time restore mechanism and validate recovery.
- Use a stored procedure or supported routine with parameters and controlled grants.
- Create a view exposing the approved query and grant access appropriately.
- Rename a SELECT query View without creating a database object.
- View queries return intended permitted columns without creating unmanaged duplicates.
Explanation
Correct Answers
C:Create a view exposing the approved query and grant access appropriately. This is an appropriate action for the SQL view virtual query object case. A standard relational view stores a query definition not necessarily physical copies.
E:View queries return intended permitted columns without creating unmanaged duplicates. This is directly observable success evidence for SQL view virtual query object.
Incorrect Answers
A:Use the supported Azure SQL point-in-time restore mechanism and validate recovery. This implements Azure SQL Database backup PITR instead of the required SQL view virtual query object function. A standard relational view stores a query definition not necessarily physical copies.
B:Use a stored procedure or supported routine with parameters and controlled grants. This implements Stored procedure reusable server operation instead of the required SQL view virtual query object function. A standard relational view stores a query definition not necessarily physical copies.
D:Rename a SELECT query View without creating a database object. This is not a safe or appropriate SQL view virtual query object implementation. Assuming views automatically encrypt their base tables misstates access protection.
Question 969
An import must reject an order row with an invalid required date type. Which principle BEST explains the correct Structured records in a customer table design decision?
- Structured data follows an explicit schema that makes consistent queries and validation practical.
- Unstructured images lack a predefined row-column model even when their metadata is structured.
- Database operations require health monitoring and capacity planning.
- Drill-down and slicing reveal patterns across levels of analysis.
Explanation
Correct Answer
A:Structured data follows an explicit schema that makes consistent queries and validation practical. In this case the applicable decision is to use typed relational columns with defined constraints for consistently shaped entities.
Incorrect Answers
B:Unstructured images lack a predefined row-column model even when their metadata is structured. That concept explains Unstructured image binary files; the situation instead concerns Structured records in a customer table. Treating a typed column as arbitrary free text undermines comparison and validation.
C:Database operations require health monitoring and capacity planning. That concept explains DBA monitoring capacity and alerts; the situation instead concerns Structured records in a customer table. Treating a typed column as arbitrary free text undermines comparison and validation.
D:Drill-down and slicing reveal patterns across levels of analysis. That concept explains Data analyst slicing and drill-down; the situation instead concerns Structured records in a customer table. Treating a typed column as arbitrary free text undermines comparison and validation.
Question 970
A sales director wants to filter a report by region interactively. Which choice BEST meets this requirement?
- Edit a visual title to Europe and assume it filters source data.
- Use Power Query transformations with explicit type conversion and reusable steps.
- Use a slicer configured with the intended field and report interactions.
- Use OneLake as the shared logical data-lake foundation for supported Fabric workloads.
Explanation
Correct Answer
C:Slicers provide user-driven data filtering rather than changing source rows.
Incorrect Answers
A:Edit a visual title to Europe and assume it filters source data. It does not implement Slicer interactive filter. Incorrect interactions can leave some visuals unaffected.
B:Use Power Query transformations with explicit type conversion and reusable steps. That action primarily handles Power Query shaping transformation; the given requirement is Slicer interactive filter. Slicers provide user-driven data filtering rather than changing source rows.
D:Use OneLake as the shared logical data-lake foundation for supported Fabric workloads. That action primarily handles Microsoft Fabric OneLake unified storage; the given requirement is Slicer interactive filter. Slicers provide user-driven data filtering rather than changing source rows.