Question 440
A design review identifies: A Cosmos DB container contains temporary sessions that should expire automatically thirty days after creation unless renewed. The failure is: Old session JSON documents accumulate indefinitely until a manual cleanup job runs. Select TWO distinct decisions that together provide the immediate technical solution AND an ongoing prevention control. A verification-only step does not replace either responsibility.
- Configure supported Azure Cosmos DB multi-region writes with an explicit conflict resolution strategy and appropriate consistency.
- Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API.
- Monitor partition key distribution and provisioned/request-unit usage before scaling.
- Configure Cosmos DB time-to-live behavior for the container or items as appropriate.
- Monitor TTL policy and RU consumption when session expiration rates increase.
Explanation
Correct Answers
D:The evidence (Old session JSON documents accumulate indefinitely until a manual cleanup job runs.) identifies the following cause: TTL was not enabled for the required automatic item expiration lifecycle. The design that removes it is: Configure Cosmos DB time-to-live behavior for the container or items as appropriate. The acceptance check is: Create a short-lived item and confirm expiration is enforced without a separate cleanup service.
E:The key follow-up control is: Monitor TTL policy and RU consumption when session expiration rates increase. It avoids recurrence of the scenario in which: Old session JSON documents accumulate indefinitely until a manual cleanup job runs. It addresses: TTL was not enabled for the required automatic item expiration lifecycle.
Incorrect Answers
A:This choice mitigates an alternative scenario, where: An overseas region must send writes to a remote single-write region despite local performance targets. The underlying issue there is: Multi-region write capability and conflict resolution were not designed for the active-active requirement. Here the root issue is: TTL was not enabled for the required automatic item expiration lifecycle. Choose the corresponding action: Configure Cosmos DB time-to-live behavior for the container or items as appropriate.
B:The option belongs to a different failure mechanism: No change feed consumer exists for incremental document changes. That situation exhibits: A nightly full scan misses time-sensitive document updates. For the stated case, the remedy is: Configure Cosmos DB time-to-live behavior for the container or items as appropriate.
C:That safeguard manages another risk: The datastore was chosen without matching the flexible document and multi-region serving requirements. Its scenario is: A relational design requires repeated schema migration for evolving JSON and globally dispersed reads. The present recurring risk is: TTL was not enabled for the required automatic item expiration lifecycle. The proper ongoing control is: Monitor TTL policy and RU consumption when session expiration rates increase.
Question 441
A design workshop has this requirement: A customer data platform must trigger downstream work on inserts and updates in Cosmos DB without full-container scans. Operators currently observe: A nightly full scan misses time-sensitive document updates. Select the ONE design remedy that best addresses the root cause.
- Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API.
- Configure supported Azure Cosmos DB multi-region writes with an explicit conflict resolution strategy and appropriate consistency.
- Redesign the logical partition key or introduce an appropriate synthetic/hierarchical key strategy to distribute hot requests.
- Configure Cosmos DB time-to-live behavior for the container or items as appropriate.
Explanation
Correct Answer
A:The targeted implementation is: Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API. The problem is not generic resource availability: No change feed consumer exists for incremental document changes. Verify the result by: Insert and update a test document and confirm change feed processor receives it with tracked continuation state.
Incorrect Answers
B:That design instead addresses another observed condition: An overseas region must send writes to a remote single-write region despite local performance targets. Its technical cause is: Multi-region write capability and conflict resolution were not designed for the active-active requirement. The current workload exhibits: A nightly full scan misses time-sensitive document updates. Its targeted remedy is: Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API.
C:This choice mitigates an alternative scenario, where: One logical partition gets 429 throttles despite plenty of total provisioned RU/s. The underlying issue there is: The partition key concentrates high-throughput tenant traffic into a hot logical partition. Here the root issue is: No change feed consumer exists for incremental document changes. Choose the corresponding action: Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API.
D:The option belongs to a different failure mechanism: TTL was not enabled for the required automatic item expiration lifecycle. That situation exhibits: Old session JSON documents accumulate indefinitely until a manual cleanup job runs. For the stated case, the remedy is: Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API.
Question 442
The planned architecture is: Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API. Workload context: A customer data platform must trigger downstream work on inserts and updates in Cosmos DB without full-container scans. Which acceptance test demonstrates that the required behavior works?
- Insert and update a test document and confirm change feed processor receives it with tracked continuation state.
- Create a short-lived item and confirm expiration is enforced without a separate cleanup service.
- Compare request-unit throttling and logical partition distribution before and after the key design.
- Write from two configured regions and verify cross-region propagation and conflict outcomes under controlled concurrent updates.
Explanation
Correct Answer
A:The decisive evidence is: Insert and update a test document and confirm change feed processor receives it with tracked continuation state. This measures the mechanism of the planned change, not an unrelated Azure service: Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API.
Incorrect Answers
B:This check validates a different workload: Create a short-lived item and confirm expiration is enforced without a separate cleanup service. Its associated design is: Configure Cosmos DB time-to-live behavior for the container or items as appropriate. The required acceptance test here is: Insert and update a test document and confirm change feed processor receives it with tracked continuation state.
C:That observation pertains to a separate failure: One logical partition gets 429 throttles despite plenty of total provisioned RU/s. Its cause is: The partition key concentrates high-throughput tenant traffic into a hot logical partition. It does not confirm the result of this design. The direct proof would be: Insert and update a test document and confirm change feed processor receives it with tracked continuation state.
D:The alternative test targets: Configure supported Azure Cosmos DB multi-region writes with an explicit conflict resolution strategy and appropriate consistency. The scenario's actual proposed remedy is: Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API. Verify that one by: Insert and update a test document and confirm change feed processor receives it with tracked continuation state.
Question 443
The customer states: A customer data platform must trigger downstream work on inserts and updates in Cosmos DB without full-container scans. An incident reveals: A nightly full scan misses time-sensitive document updates. What cause best accounts for this evidence?
- The partition key concentrates high-throughput tenant traffic into a hot logical partition.
- No change feed consumer exists for incremental document changes.
- TTL was not enabled for the required automatic item expiration lifecycle.
- Multi-region write capability and conflict resolution were not designed for the active-active requirement.
Explanation
Correct Answer
B:The incident is explained by: No change feed consumer exists for incremental document changes. The reported symptom is: A nightly full scan misses time-sensitive document updates. The corresponding design fix is: Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API.
Incorrect Answers
A:The alternative weakness is: The partition key concentrates high-throughput tenant traffic into a hot logical partition. Its associated failure is: One logical partition gets 429 throttles despite plenty of total provisioned RU/s. Neither explains the present observation: A nightly full scan misses time-sensitive document updates. The direct cause here is: No change feed consumer exists for incremental document changes.
C:The proposed diagnosis fits another scenario: TTL was not enabled for the required automatic item expiration lifecycle. It would typically be reflected by: Old session JSON documents accumulate indefinitely until a manual cleanup job runs. The current evidence instead supports: No change feed consumer exists for incremental document changes.
D:The alternative weakness is: Multi-region write capability and conflict resolution were not designed for the active-active requirement. Its associated failure is: An overseas region must send writes to a remote single-write region despite local performance targets. Neither explains the present observation: A nightly full scan misses time-sensitive document updates. The direct cause here is: No change feed consumer exists for incremental document changes.
Question 444
Workload context: A customer data platform must trigger downstream work on inserts and updates in Cosmos DB without full-container scans. The implemented remedy is: Consume the appropriate Azure Cosmos DB change feed with a checkpointed processor for the supported API. Which ongoing practice most specifically prevents recurrence of this failure: A nightly full scan misses time-sensitive document updates.?
- Persist checkpoints and make downstream processing idempotent for retries/replays.
- Monitor replication and conflict metrics, documenting bounded consistency tradeoffs.
- Review top partition keys and request charge distribution as tenant traffic patterns change.
- Monitor TTL policy and RU consumption when session expiration rates increase.
Explanation
Correct Answer
A:The key follow-up control is: Persist checkpoints and make downstream processing idempotent for retries/replays. It avoids recurrence of the scenario in which: A nightly full scan misses time-sensitive document updates. It addresses: No change feed consumer exists for incremental document changes.
Incorrect Answers
B:That safeguard manages another risk: Multi-region write capability and conflict resolution were not designed for the active-active requirement. Its scenario is: An overseas region must send writes to a remote single-write region despite local performance targets. The present recurring risk is: No change feed consumer exists for incremental document changes. The proper ongoing control is: Persist checkpoints and make downstream processing idempotent for retries/replays.
C:This is a reasonable safeguard for a different fault: One logical partition gets 429 throttles despite plenty of total provisioned RU/s. That different mechanism is: The partition key concentrates high-throughput tenant traffic into a hot logical partition. The original incident here instead arises from: No change feed consumer exists for incremental document changes. The directly relevant safeguard is: Persist checkpoints and make downstream processing idempotent for retries/replays.
D:The proposed control focuses on: TTL was not enabled for the required automatic item expiration lifecycle. For the design in the question, recurrence comes from: No change feed consumer exists for incremental document changes. A precise prevention step is: Persist checkpoints and make downstream processing idempotent for retries/replays.
Question 445
A solution architect is reviewing a workload: A key-value application holds simple per-entity attributes with massive horizontal scale and does not need relational joins. The observed incident is: SQL JOINs are purchased for a workload that only retrieves small records by composite key. Which architecture choice most directly removes the identified weakness?
- Select Azure Cosmos DB for NoSQL with an appropriate partition key and RU/s model when its APIs meet the workload.
- Use Azure Table Storage or compatible table API with partition/row keys chosen for access patterns.
- Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column.
- Redesign the logical partition key or introduce an appropriate synthetic/hierarchical key strategy to distribute hot requests.
Explanation
Correct Answer
B:The evidence (SQL JOINs are purchased for a workload that only retrieves small records by composite key.) identifies the following cause: Relational database services were chosen despite a simple scalable key-attribute access pattern. The design that removes it is: Use Azure Table Storage or compatible table API with partition/row keys chosen for access patterns. The acceptance check is: Issue point entity queries with partition and row keys and confirm performance and scale behavior.
Incorrect Answers
A:That design instead addresses another observed condition: A relational design requires repeated schema migration for evolving JSON and globally dispersed reads. Its technical cause is: The datastore was chosen without matching the flexible document and multi-region serving requirements. The current workload exhibits: SQL JOINs are purchased for a workload that only retrieves small records by composite key. Its targeted remedy is: Use Azure Table Storage or compatible table API with partition/row keys chosen for access patterns.
C:The option belongs to a different failure mechanism: Object storage's independent capacity and access tiers were not used for unstructured media. That situation exhibits: The application stores huge media files in the transactional SQL database and exhausts database capacity. For the stated case, the remedy is: Use Azure Table Storage or compatible table API with partition/row keys chosen for access patterns.
D:That design instead addresses another observed condition: One logical partition gets 429 throttles despite plenty of total provisioned RU/s. Its technical cause is: The partition key concentrates high-throughput tenant traffic into a hot logical partition. The current workload exhibits: SQL JOINs are purchased for a workload that only retrieves small records by composite key. Its targeted remedy is: Use Azure Table Storage or compatible table API with partition/row keys chosen for access patterns.
Question 446
An architect proposes this change: Use Azure Table Storage or compatible table API with partition/row keys chosen for access patterns. The workload context is: A key-value application holds simple per-entity attributes with massive horizontal scale and does not need relational joins. Which evidence would most directly validate the change?
- Upload a sample object and verify HTTP object retrieval, metadata and lifecycle behavior.
- Compare request-unit throttling and logical partition distribution before and after the key design.
- Issue point entity queries with partition and row keys and confirm performance and scale behavior.
- Insert heterogeneous JSON documents and measure point reads using full partition-key and item-ID values.
Explanation
Correct Answer
C:The decisive evidence is: Issue point entity queries with partition and row keys and confirm performance and scale behavior. This measures the mechanism of the planned change, not an unrelated Azure service: Use Azure Table Storage or compatible table API with partition/row keys chosen for access patterns.
Incorrect Answers
A:This check validates a different workload: Upload a sample object and verify HTTP object retrieval, metadata and lifecycle behavior. Its associated design is: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column. The required acceptance test here is: Issue point entity queries with partition and row keys and confirm performance and scale behavior.
B:That observation pertains to a separate failure: One logical partition gets 429 throttles despite plenty of total provisioned RU/s. Its cause is: The partition key concentrates high-throughput tenant traffic into a hot logical partition. It does not confirm the result of this design. The direct proof would be: Issue point entity queries with partition and row keys and confirm performance and scale behavior.
D:This check validates a different workload: Insert heterogeneous JSON documents and measure point reads using full partition-key and item-ID values. Its associated design is: Select Azure Cosmos DB for NoSQL with an appropriate partition key and RU/s model when its APIs meet the workload. The required acceptance test here is: Issue point entity queries with partition and row keys and confirm performance and scale behavior.
Question 447
During architecture troubleshooting, a team reports: SQL JOINs are purchased for a workload that only retrieves small records by composite key. Context: A key-value application holds simple per-entity attributes with massive horizontal scale and does not need relational joins. Which underlying design mistake explains the observed behavior most precisely?
- The partition key concentrates high-throughput tenant traffic into a hot logical partition.
- Relational database services were chosen despite a simple scalable key-attribute access pattern.
- The datastore was chosen without matching the flexible document and multi-region serving requirements.
- Object storage's independent capacity and access tiers were not used for unstructured media.
Explanation
Correct Answer
B:This is the failure mechanism rather than an incidental symptom: Relational database services were chosen despite a simple scalable key-attribute access pattern. It accounts for: SQL JOINs are purchased for a workload that only retrieves small records by composite key. The architectural repair is: Use Azure Table Storage or compatible table API with partition/row keys chosen for access patterns.
Incorrect Answers
A:This cause would explain a different symptom: One logical partition gets 429 throttles despite plenty of total provisioned RU/s. The mechanism for that event is: The partition key concentrates high-throughput tenant traffic into a hot logical partition. Here the stated symptom is: SQL JOINs are purchased for a workload that only retrieves small records by composite key. Its cause is: Relational database services were chosen despite a simple scalable key-attribute access pattern.
C:The alternative weakness is: The datastore was chosen without matching the flexible document and multi-region serving requirements. Its associated failure is: A relational design requires repeated schema migration for evolving JSON and globally dispersed reads. Neither explains the present observation: SQL JOINs are purchased for a workload that only retrieves small records by composite key. The direct cause here is: Relational database services were chosen despite a simple scalable key-attribute access pattern.
D:This cause would explain a different symptom: The application stores huge media files in the transactional SQL database and exhausts database capacity. The mechanism for that event is: Object storage's independent capacity and access tiers were not used for unstructured media. Here the stated symptom is: SQL JOINs are purchased for a workload that only retrieves small records by composite key. Its cause is: Relational database services were chosen despite a simple scalable key-attribute access pattern.
Question 448
The design change is: Use Azure Table Storage or compatible table API with partition/row keys chosen for access patterns. The original failure was: SQL JOINs are purchased for a workload that only retrieves small records by composite key. Which ongoing control best prevents recurrence of the same root cause?
- Monitor partition key distribution and provisioned/request-unit usage before scaling.
- Review top partition keys and request charge distribution as tenant traffic patterns change.
- Validate hot partitions and query patterns as entity counts increase.
- Review blob lifecycle and access policies when data temperature changes.
Explanation
Correct Answer
C:The key follow-up control is: Validate hot partitions and query patterns as entity counts increase. It avoids recurrence of the scenario in which: SQL JOINs are purchased for a workload that only retrieves small records by composite key. It addresses: Relational database services were chosen despite a simple scalable key-attribute access pattern.
Incorrect Answers
A:That safeguard manages another risk: The datastore was chosen without matching the flexible document and multi-region serving requirements. Its scenario is: A relational design requires repeated schema migration for evolving JSON and globally dispersed reads. The present recurring risk is: Relational database services were chosen despite a simple scalable key-attribute access pattern. The proper ongoing control is: Validate hot partitions and query patterns as entity counts increase.
B:This is a reasonable safeguard for a different fault: One logical partition gets 429 throttles despite plenty of total provisioned RU/s. That different mechanism is: The partition key concentrates high-throughput tenant traffic into a hot logical partition. The original incident here instead arises from: Relational database services were chosen despite a simple scalable key-attribute access pattern. The directly relevant safeguard is: Validate hot partitions and query patterns as entity counts increase.
D:That safeguard manages another risk: Object storage's independent capacity and access tiers were not used for unstructured media. Its scenario is: The application stores huge media files in the transactional SQL database and exhausts database capacity. The present recurring risk is: Relational database services were chosen despite a simple scalable key-attribute access pattern. The proper ongoing control is: Validate hot partitions and query patterns as entity counts increase.
Question 449
A design workshop has this requirement: A retailer must copy nightly data from an on-prem SQL Server to Azure Data Lake, with parameterized pipelines and scheduled retries. Operators currently observe: The pipeline cannot access a private on-prem SQL instance using only Azure-hosted integration runtime. Select the ONE design remedy that best addresses the root cause.
- Use Azure Databricks or supported managed Spark compute with storage access through managed identities where supported.
- Use Azure Data Factory with supported linked services, self-hosted integration runtime and a scheduled copy pipeline.
- Use Data Factory managed identity and Key Vault-backed linked service secret references or identity-based access where supported.
- Use Azure Data Factory pipelines with activity dependencies, parameters and failure branches.
Explanation
Correct Answer
B:The targeted implementation is: Use Azure Data Factory with supported linked services, self-hosted integration runtime and a scheduled copy pipeline. The problem is not generic resource availability: A suitable self-hosted connectivity runtime was not provided for private data movement. Verify the result by: Run the pipeline and compare source/target counts and integration-runtime activity logs.
Incorrect Answers
A:This choice mitigates an alternative scenario, where: Analysts attempt to process terabytes of distributed data in one small VM process. The underlying issue there is: The compute framework does not match parallel data-lake transformation scale. Here the root issue is: A suitable self-hosted connectivity runtime was not provided for private data movement. Choose the corresponding action: Use Azure Data Factory with supported linked services, self-hosted integration runtime and a scheduled copy pipeline.
C:That design instead addresses another observed condition: The integration pipeline fails when a hard-coded database password expires. Its technical cause is: Credential management was not separated from pipeline definitions and access scopes. The current workload exhibits: The pipeline cannot access a private on-prem SQL instance using only Azure-hosted integration runtime. Its targeted remedy is: Use Azure Data Factory with supported linked services, self-hosted integration runtime and a scheduled copy pipeline.
D:This choice mitigates an alternative scenario, where: Downstream joins run before required source datasets are loaded. The underlying issue there is: The orchestration omitted required activity dependencies and validation guards. Here the root issue is: A suitable self-hosted connectivity runtime was not provided for private data movement. Choose the corresponding action: Use Azure Data Factory with supported linked services, self-hosted integration runtime and a scheduled copy pipeline.
Question 450
The planned architecture is: Use Azure Data Factory with supported linked services, self-hosted integration runtime and a scheduled copy pipeline. Workload context: A retailer must copy nightly data from an on-prem SQL Server to Azure Data Lake, with parameterized pipelines and scheduled retries. Which acceptance test demonstrates that the required behavior works?
- Run a controlled pipeline and verify downstream activities execute only when prerequisite steps succeed.
- Run the pipeline and compare source/target counts and integration-runtime activity logs.
- Run a Spark transformation, inspect output parquet partitions and compare row counts to input.
- Rotate a test secret and verify the pipeline continues with approved identity and network access.
Explanation
Correct Answer
B:The decisive evidence is: Run the pipeline and compare source/target counts and integration-runtime activity logs. This measures the mechanism of the planned change, not an unrelated Azure service: Use Azure Data Factory with supported linked services, self-hosted integration runtime and a scheduled copy pipeline.
Incorrect Answers
A:That observation pertains to a separate failure: Downstream joins run before required source datasets are loaded. Its cause is: The orchestration omitted required activity dependencies and validation guards. It does not confirm the result of this design. The direct proof would be: Run the pipeline and compare source/target counts and integration-runtime activity logs.
C:This check validates a different workload: Run a Spark transformation, inspect output parquet partitions and compare row counts to input. Its associated design is: Use Azure Databricks or supported managed Spark compute with storage access through managed identities where supported. The required acceptance test here is: Run the pipeline and compare source/target counts and integration-runtime activity logs.
D:That observation pertains to a separate failure: The integration pipeline fails when a hard-coded database password expires. Its cause is: Credential management was not separated from pipeline definitions and access scopes. It does not confirm the result of this design. The direct proof would be: Run the pipeline and compare source/target counts and integration-runtime activity logs.
Designing Microsoft Azure Infrastructure Solutions (AZ-305) Practice Tests