Microsoft DP-900 Practice Test 52
Question 510
A loader wrongly splits a company name containing commas into extra columns. Which principle BEST explains the correct CSV delimited text schema design decision?
- Batch work processes bounded collections at selected times.
- CSV is a delimited flat-text format not a hierarchical JSON object.
- Semi structured data has organizational markers without requiring identical columns in every record.
- DBAs tune database performance as well as maintaining access and reliability.
Explanation
Correct Answer
B:CSV is a delimited flat-text format not a hierarchical JSON object. In this case the applicable decision is to parse CSV with configured delimiter quote escaping and column type rules.
Incorrect Answers
A:Batch work processes bounded collections at selected times. That concept explains Batch scheduled processing; the situation instead concerns CSV delimited text schema. Naively splitting on every comma corrupts quoted field values.
C:Semi structured data has organizational markers without requiring identical columns in every record. That concept explains Semi structured JSON documents; the situation instead concerns CSV delimited text schema. Naively splitting on every comma corrupts quoted field values.
D:DBAs tune database performance as well as maintaining access and reliability. That concept explains DBA performance tuning and indexing; the situation instead concerns CSV delimited text schema. Naively splitting on every comma corrupts quoted field values.
Question 511
An outage plan requires clearly documented region failover behavior. During testing, the team observes this specific failure: Adding a region does not remove all replication lag or application-level conflicts. Which corrective check should be performed FIRST?
- Rename the database WorldWide and assume it replicates globally.
- Rehearse selected failover scenario and measure client routing.
- Consider Cosmos DB for Apache Cassandra with reviewed compatibility.
- Use Blob versioning where supported and protect earlier object versions.
Explanation
Correct Answer
B:Rehearse selected failover scenario and measure client routing. A successful correction should demonstrate that region-aware clients continue within documented replication and failover behavior.
Incorrect Answers
A:Rename the database WorldWide and assume it replicates globally. This reinforces the error rather than addressing the Cosmos DB multi-region distribution failure. Global distribution can reduce distance but replicas and failover require explicit choices.
C:Consider Cosmos DB for Apache Cassandra with reviewed compatibility. It serves Cosmos DB API for Apache Cassandra, not the diagnosed Cosmos DB multi-region distribution problem. Adding a region does not remove all replication lag or application-level conflicts.
D:Use Blob versioning where supported and protect earlier object versions. It serves Blob versioning on overwrite, not the diagnosed Cosmos DB multi-region distribution problem. Adding a region does not remove all replication lag or application-level conflicts.
Question 512
A report uses a map with ambiguous city names shared by several countries. Select TWO statements that correctly describe the Map visual geographic measures implementation and how it can be verified.
- Locations resolve to intended regions and values match actual places.
- Use an appropriate map visual with geographic fields and data category metadata.
- Assume every text field named Location always geocodes accurately.
- Store appropriate analytical data in Parquet columnar files.
- Establish valid one-to-many relationships with unique dimension keys.
Explanation
Correct Answers
A:Locations resolve to intended regions and values match actual places. This is directly observable success evidence for Map visual geographic measures.
B:Use an appropriate map visual with geographic fields and data category metadata. This is an appropriate action for the Map visual geographic measures case. Geographic visuals require accurate location encoding and appropriate map granularity.
Incorrect Answers
C:Assume every text field named Location always geocodes accurately. This is not a safe or appropriate Map visual geographic measures implementation. Missing country context can place a city on the wrong continent.
D:Store appropriate analytical data in Parquet columnar files. This implements Parquet compressed columnar analytics instead of the required Map visual geographic measures function. Geographic visuals require accurate location encoding and appropriate map granularity.
E:Establish valid one-to-many relationships with unique dimension keys. This implements One-to-many semantic relationships instead of the required Map visual geographic measures function. Geographic visuals require accurate location encoding and appropriate map granularity.
Question 513
SQL returns fewer results than expected when comparing NULL with equals. What is the MOST appropriate next validation or correction?
- Inspect pages with identical timestamps and stable IDs.
- Store string 'NULL' everywhere and claim it is identical to SQL NULL.
- Test true false and unknown predicate cases.
- Test connectivity from allowed and denied network locations.
Explanation
Correct Answer
C:Test true false and unknown predicate cases. This tests the intended result: missing values are included or excluded as business rules specify.
Incorrect Answers
A:Inspect pages with identical timestamps and stable IDs. It tests SQL ORDER BY pagination stability rather than the critical NULL and three-valued logic behavior. SQL NULL represents absent or unknown values and ordinary equality does not match it.
B:Store string 'NULL' everywhere and claim it is identical to SQL NULL. This unsafe shortcut leaves the NULL and three-valued logic problem unresolved. Comparing = NULL can silently yield no rows.
D:Test connectivity from allowed and denied network locations. It tests Azure SQL firewall and private endpoint rather than the critical NULL and three-valued logic behavior. SQL NULL represents absent or unknown values and ordinary equality does not match it.
Question 514
Client logic retries instantly in a tight loop during RU saturation. Select THREE statements that correctly describe the Cosmos DB 429 throttling retries implementation and how it can be verified.
- Treat every 429 as proof that the user password is invalid.
- Use a supported retry-after/backoff strategy and scale throughput if justified.
- Throttled operations eventually succeed without uncontrolled retry storms.
- Request-rate limits protect provisioned throughput and require graceful client handling.
- Evaluate multi-region writes with a deliberate conflict resolution policy.
- Select an appropriate redundancy option based on local zone and regional failure requirements.
Explanation
Correct Answers
B:Use a supported retry-after/backoff strategy and scale throughput if justified. This is an appropriate action for the Cosmos DB 429 throttling retries case. Request-rate limits protect provisioned throughput and require graceful client handling.
C:Throttled operations eventually succeed without uncontrolled retry storms. This is directly observable success evidence for Cosmos DB 429 throttling retries.
D:Request-rate limits protect provisioned throughput and require graceful client handling. This supports why the action and evidence together address Cosmos DB 429 throttling retries.
Incorrect Answers
A:Treat every 429 as proof that the user password is invalid. This is not a safe or appropriate Cosmos DB 429 throttling retries implementation. Immediate unbounded retries can increase pressure and latency.
E:Evaluate multi-region writes with a deliberate conflict resolution policy. This implements Cosmos DB multi-region writes conflict handling instead of the required Cosmos DB 429 throttling retries function. Request-rate limits protect provisioned throughput and require graceful client handling.
F:Select an appropriate redundancy option based on local zone and regional failure requirements. This implements Azure Storage LRS ZRS GRS distinctions instead of the required Cosmos DB 429 throttling retries function. Request-rate limits protect provisioned throughput and require graceful client handling.
Question 515
A vendor delete would leave orphaned purchase records. What is the MOST appropriate next validation or correction?
- Add a column called ProductID and assume referential integrity is automatically enforced.
- Test allowed reads denied writes and resulting audit records.
- Test missing-parent inserts and deletion cases under the actual constraint.
- Test parameter validation and execution permissions.
Explanation
Correct Answer
C:Test missing-parent inserts and deletion cases under the actual constraint. This tests the intended result: invalid references are rejected and approved relationship changes follow the constraint.
Incorrect Answers
A:Add a column called ProductID and assume referential integrity is automatically enforced. This unsafe shortcut leaves the Foreign key referential integrity problem unresolved. Ignoring foreign keys can leave purchases referring to missing products.
B:Test allowed reads denied writes and resulting audit records. It tests Azure SQL auditing and least privilege rather than the critical Foreign key referential integrity behavior. Foreign keys protect cross-table references to parent keys.
D:Test parameter validation and execution permissions. It tests Stored procedure reusable server operation rather than the critical Foreign key referential integrity behavior. Foreign keys protect cross-table references to parent keys.
Question 516
An operator must inspect the previous version after a mistaken upload. Which principle BEST explains the correct Blob versioning on overwrite design decision?
- Versioning retains historical object states independently of overwriting current contents.
- Cosmos DB measures resource consumption in request units rather than only raw data size.
- Cosmos DB consumption and reserved throughput models suit different demand patterns.
- Lifecycle management automates object policy based on supported filters and timing.
Explanation
Correct Answer
A:Versioning retains historical object states independently of overwriting current contents. In this case the applicable decision is to use Blob versioning where supported and protect earlier object versions.
Incorrect Answers
B:Cosmos DB measures resource consumption in request units rather than only raw data size. That concept explains Cosmos DB Request Unit RU accounting; the situation instead concerns Blob versioning on overwrite. Assuming replication alone creates object history can leave no recoverable version.
C:Cosmos DB consumption and reserved throughput models suit different demand patterns. That concept explains Cosmos DB serverless versus provisioned throughput; the situation instead concerns Blob versioning on overwrite. Assuming replication alone creates object history can leave no recoverable version.
D:Lifecycle management automates object policy based on supported filters and timing. That concept explains Blob lifecycle management rules; the situation instead concerns Blob versioning on overwrite. Assuming replication alone creates object history can leave no recoverable version.
Question 517
A retailer processes thousands of individual cart updates while running annual category reports. After selecting the proper OLTP relational versus OLAP analytical store approach, which observation gives the clearest evidence of success?
- Checkout remains responsive while historical scans execute on suitable analytical storage.
- Images are retrieved without pretending their visual content is already tabular data.
- A controlled restoration meets stated RPO and RTO objectives.
- Records are efficiently looked up by intended PartitionKey and RowKey.
Explanation
Correct Answer
A:Checkout remains responsive while historical scans execute on suitable analytical storage. This is the directly observable result for OLTP relational versus OLAP analytical store; oLTP emphasizes short consistent transactions whereas OLAP emphasizes aggregated analytical reads.
Incorrect Answers
B:Images are retrieved without pretending their visual content is already tabular data. This supports Unstructured image binary files, not confirmation of OLTP relational versus OLAP analytical store. The relevant evidence is that checkout remains responsive while historical scans execute on suitable analytical storage.
C:A controlled restoration meets stated RPO and RTO objectives. This supports DBA backup and recovery responsibility, not confirmation of OLTP relational versus OLAP analytical store. The relevant evidence is that checkout remains responsive while historical scans execute on suitable analytical storage.
D:Records are efficiently looked up by intended PartitionKey and RowKey. This supports Azure Table Storage key-value entities, not confirmation of OLTP relational versus OLAP analytical store. The relevant evidence is that checkout remains responsive while historical scans execute on suitable analytical storage.
Question 518
A startup assumes a single locally hosted SQL VM provides the same resilience as managed PaaS. During testing, the team observes this specific failure: Ignoring transient failover errors can disrupt applications. Which corrective check should be performed FIRST?
- Exercise retry logic and inspect tier redundancy capabilities.
- Use GROUP BY then HAVING to filter aggregate group results.
- Assume highly available means no connection ever drops during maintenance.
- Assess scale-up and supported database partitioning based on transaction needs.
Explanation
Correct Answer
A:Exercise retry logic and inspect tier redundancy capabilities. A successful correction should demonstrate that a supported failover maintains service within documented expectations.
Incorrect Answers
B:Use GROUP BY then HAVING to filter aggregate group results. It serves SQL HAVING after grouping, not the diagnosed Azure SQL high availability and zone resiliency problem. Ignoring transient failover errors can disrupt applications.
C:Assume highly available means no connection ever drops during maintenance. This reinforces the error rather than addressing the Azure SQL high availability and zone resiliency failure. Managed availability still has chosen tiers and failover behavior.
D:Assess scale-up and supported database partitioning based on transaction needs. It serves Relational scaling vertical versus horizontal, not the diagnosed Azure SQL high availability and zone resiliency problem. Ignoring transient failover errors can disrupt applications.
Question 519
Finance and marketing use incompatible definitions of active customer. After selecting the proper Data analyst metric definition approach, which observation gives the clearest evidence of success?
- Users can answer agreed questions from accurate accessible visuals.
- Images are retrieved without pretending their visual content is already tabular data.
- Reports calculate the same measure under the same filters.
- Both service response and bulk movement meet their distinct targets.
Explanation
Correct Answer
C:Reports calculate the same measure under the same filters. This is the directly observable result for Data analyst metric definition; data analysts define and test business measures rather than only placing visuals.
Incorrect Answers
A:Users can answer agreed questions from accurate accessible visuals. This supports Data analyst report design, not confirmation of Data analyst metric definition. The relevant evidence is that reports calculate the same measure under the same filters.
B:Images are retrieved without pretending their visual content is already tabular data. This supports Unstructured image binary files, not confirmation of Data analyst metric definition. The relevant evidence is that reports calculate the same measure under the same filters.
D:Both service response and bulk movement meet their distinct targets. This supports Operational SLA latency versus throughput, not confirmation of Data analyst metric definition. The relevant evidence is that reports calculate the same measure under the same filters.
Question 520
An import must reject an order row with an invalid required date type. What is the MOST appropriate next validation or correction?
- Rename a spreadsheet header and assume all values now meet the database data type.
- Compare grouped totals with known source periods.
- Verify sample Unicode characters and known numeric totals after parsing.
- Inspect schema definitions and sample failed inserts against business requirements.
Explanation
Correct Answer
D:Inspect schema definitions and sample failed inserts against business requirements. This tests the intended result: valid records fit the specified columns while malformed field types are caught.
Incorrect Answers
A:Rename a spreadsheet header and assume all values now meet the database data type. This unsafe shortcut leaves the Structured records in a customer table problem unresolved. Treating a typed column as arbitrary free text undermines comparison and validation.
B:Compare grouped totals with known source periods. It tests OLAP aggregation over history rather than the critical Structured records in a customer table behavior. Structured data follows an explicit schema that makes consistent queries and validation practical.
C:Verify sample Unicode characters and known numeric totals after parsing. It tests Text encoding and numeric parsing rather than the critical Structured records in a customer table behavior. Structured data follows an explicit schema that makes consistent queries and validation practical.
