Question 360
A design review identifies: A SQL Server architecture uses several on-prem SQL databases with transactional coupling and wants predictable cutover to Azure SQL Managed Instance. The failure is: Each database is migrated in isolation and dependent cross-database workflows fail in production. 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.
- Design a compatibility-tested migration with appropriate instance sizing, connectivity, application dependencies and rollback plan.
- Use Azure SQL Managed Instance where SQL Server instance compatibility requirements exceed Azure SQL Database capabilities.
- Use Azure Database Migration Service with supported online/offline workflow after assessing compatibility and prerequisites.
- Maintain inventory of SQL Agent jobs, linked server needs and service endpoint changes.
- Reassess database compatibility and PaaS feature availability before expanding server fleets.
Explanation
Correct Answers
A:The targeted implementation is: Design a compatibility-tested migration with appropriate instance sizing, connectivity, application dependencies and rollback plan. The problem is not generic resource availability: Migration scope ignores instance-level dependencies and target service compatibility. Verify the result by: Run a cutover rehearsal including cross-database queries, jobs and external connection strings.
D:The key follow-up control is: Maintain inventory of SQL Agent jobs, linked server needs and service endpoint changes. It avoids recurrence of the scenario in which: Each database is migrated in isolation and dependent cross-database workflows fail in production. It addresses: Migration scope ignores instance-level dependencies and target service compatibility.
Incorrect Answers
B:That design instead addresses another observed condition: A migration to Azure SQL Database fails due to unsupported instance-level application dependencies. Its technical cause is: A single managed database model was selected despite the application's SQL Server instance feature requirements. The current workload exhibits: Each database is migrated in isolation and dependent cross-database workflows fail in production. Its targeted remedy is: Design a compatibility-tested migration with appropriate instance sizing, connectivity, application dependencies and rollback plan.
C:This choice mitigates an alternative scenario, where: A large database cutover exceeds downtime when operators use one manual full backup restore. The underlying issue there is: The migration process lacks supported continuous data movement or planned downtime strategy. Here the root issue is: Migration scope ignores instance-level dependencies and target service compatibility. Choose the corresponding action: Design a compatibility-tested migration with appropriate instance sizing, connectivity, application dependencies and rollback plan.
E:That safeguard manages another risk: An IaaS SQL VM was selected even though no host-level SQL Server feature requires it. Its scenario is: The company continues to patch an entire Windows Server VM for a small database workload. The present recurring risk is: Migration scope ignores instance-level dependencies and target service compatibility. The proper ongoing control is: Maintain inventory of SQL Agent jobs, linked server needs and service endpoint changes.
Question 361
A design workshop has this requirement: A customer application stores millions of images and videos as unstructured objects, with no requirement for SMB file semantics. Operators currently observe: The application stores huge media files in the transactional SQL database and exhausts database capacity. Select the ONE design remedy that best addresses the root cause.
- Define Blob lifecycle management rules to move blobs between supported access tiers by age or last access conditions.
- Apply an appropriate Blob archive access tier for eligible blob objects, accounting for rehydration time.
- Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column.
- Select Azure Cosmos DB for NoSQL with an appropriate partition key and RU/s model when its APIs meet the workload.
Explanation
Correct Answer
C:The targeted implementation is: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column. The problem is not generic resource availability: Object storage's independent capacity and access tiers were not used for unstructured media. Verify the result by: Upload a sample object and verify HTTP object retrieval, metadata and lifecycle behavior.
Incorrect Answers
A:That design instead addresses another observed condition: Old data remains in hot tier indefinitely despite rarely being accessed. Its technical cause is: No automated lifecycle rules govern predictable age-based storage transitions. The current workload exhibits: The application stores huge media files in the transactional SQL database and exhausts database capacity. Its targeted remedy is: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column.
B:This choice mitigates an alternative scenario, where: Audit retrieval fails when an app expects instant downloads from archived objects. The underlying issue there is: Archive access tier requires rehydration and is not an online hot object endpoint. Here the root issue is: Object storage's independent capacity and access tiers were not used for unstructured media. Choose the corresponding action: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column.
D: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: The application stores huge media files in the transactional SQL database and exhausts database capacity. Its targeted remedy is: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column.
Question 362
The planned architecture is: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column. Workload context: A customer application stores millions of images and videos as unstructured objects, with no requirement for SMB file semantics. Which acceptance test demonstrates that the required behavior works?
- Rehydrate a test archive blob and confirm retrieval follows the supported priority and completion behavior.
- Insert heterogeneous JSON documents and measure point reads using full partition-key and item-ID values.
- Create a test blob and inspect lifecycle action results and object tier transitions.
- Upload a sample object and verify HTTP object retrieval, metadata and lifecycle behavior.
Explanation
Correct Answer
D:This observation directly verifies the intended design: Upload a sample object and verify HTTP object retrieval, metadata and lifecycle behavior. The architecture being tested is: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column. The original symptom was: The application stores huge media files in the transactional SQL database and exhausts database capacity.
Incorrect Answers
A:This check validates a different workload: Rehydrate a test archive blob and confirm retrieval follows the supported priority and completion behavior. Its associated design is: Apply an appropriate Blob archive access tier for eligible blob objects, accounting for rehydration time. The required acceptance test here is: Upload a sample object and verify HTTP object retrieval, metadata and lifecycle behavior.
B:That observation pertains to a separate failure: A relational design requires repeated schema migration for evolving JSON and globally dispersed reads. Its cause is: The datastore was chosen without matching the flexible document and multi-region serving requirements. It does not confirm the result of this design. The direct proof would be: Upload a sample object and verify HTTP object retrieval, metadata and lifecycle behavior.
C:The alternative test targets: Define Blob lifecycle management rules to move blobs between supported access tiers by age or last access conditions. The scenario's actual proposed remedy is: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column. Verify that one by: Upload a sample object and verify HTTP object retrieval, metadata and lifecycle behavior.
Question 363
The customer states: A customer application stores millions of images and videos as unstructured objects, with no requirement for SMB file semantics. An incident reveals: The application stores huge media files in the transactional SQL database and exhausts database capacity. What cause best accounts for this evidence?
- Object storage's independent capacity and access tiers were not used for unstructured media.
- Archive access tier requires rehydration and is not an online hot object endpoint.
- The datastore was chosen without matching the flexible document and multi-region serving requirements.
- No automated lifecycle rules govern predictable age-based storage transitions.
Explanation
Correct Answer
A:The incident is explained by: Object storage's independent capacity and access tiers were not used for unstructured media. The reported symptom is: The application stores huge media files in the transactional SQL database and exhausts database capacity. The corresponding design fix is: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column.
Incorrect Answers
B:The proposed diagnosis fits another scenario: Archive access tier requires rehydration and is not an online hot object endpoint. It would typically be reflected by: Audit retrieval fails when an app expects instant downloads from archived objects. The current evidence instead supports: Object storage's independent capacity and access tiers were not used for unstructured media.
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: The application stores huge media files in the transactional SQL database and exhausts database capacity. The direct cause here is: Object storage's independent capacity and access tiers were not used for unstructured media.
D:This cause would explain a different symptom: Old data remains in hot tier indefinitely despite rarely being accessed. The mechanism for that event is: No automated lifecycle rules govern predictable age-based storage transitions. Here the stated symptom is: The application stores huge media files in the transactional SQL database and exhausts database capacity. Its cause is: Object storage's independent capacity and access tiers were not used for unstructured media.
Question 364
Workload context: A customer application stores millions of images and videos as unstructured objects, with no requirement for SMB file semantics. The implemented remedy is: Choose Azure Blob Storage with suitable access tier and lifecycle rules rather than a relational database BLOB column. Which ongoing practice most specifically prevents recurrence of this failure: The application stores huge media files in the transactional SQL database and exhausts database capacity.?
- Review retrieval SLAs, early deletion charges and redundancy compatibility for archive storage.
- Review blob lifecycle and access policies when data temperature changes.
- Monitor partition key distribution and provisioned/request-unit usage before scaling.
- Review lifecycle rules when retention, tier pricing or blob tags change.
Explanation
Correct Answer
B:This is an ongoing protection specific to the fault: Review blob lifecycle and access policies when data temperature changes. The recurrence risk is: Object storage's independent capacity and access tiers were not used for unstructured media. It should be checked using: Upload a sample object and verify HTTP object retrieval, metadata and lifecycle behavior.
Incorrect Answers
A:That safeguard manages another risk: Archive access tier requires rehydration and is not an online hot object endpoint. Its scenario is: Audit retrieval fails when an app expects instant downloads from archived objects. The present recurring risk is: Object storage's independent capacity and access tiers were not used for unstructured media. The proper ongoing control is: Review blob lifecycle and access policies when data temperature changes.
C:The proposed control focuses on: The datastore was chosen without matching the flexible document and multi-region serving requirements. For the design in the question, recurrence comes from: Object storage's independent capacity and access tiers were not used for unstructured media. A precise prevention step is: Review blob lifecycle and access policies when data temperature changes.
D:That safeguard manages another risk: No automated lifecycle rules govern predictable age-based storage transitions. Its scenario is: Old data remains in hot tier indefinitely despite rarely being accessed. The present recurring risk is: Object storage's independent capacity and access tiers were not used for unstructured media. The proper ongoing control is: Review blob lifecycle and access policies when data temperature changes.
Question 365
A solution architect is reviewing a workload: A data lake requires directory-level analytics ACLs, atomic directory operations and POSIX-like permissions for Spark jobs. The observed incident is: Analytics jobs cannot apply directory ACLs to datasets stored as flat object paths. Which architecture choice most directly removes the identified weakness?
- Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region.
- Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account.
- Use Azure Event Grid BlobCreated events and a supported consumer endpoint, accounting for event delivery semantics.
- Choose Azure NetApp Files with supported NFS volumes and suitable service levels and network placement.
Explanation
Correct Answer
B:The targeted implementation is: Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account. The problem is not generic resource availability: A standard blob namespace was chosen without the hierarchical features required by the lake workload. Verify the result by: Create nested directories, apply ACLs and validate intended Spark/read behavior under group identities.
Incorrect Answers
A:This choice mitigates an alternative scenario, where: A single datacenter failure makes locally redundant blob data temporarily unavailable. The underlying issue there is: Local redundancy did not distribute synchronous copies across availability zones. Here the root issue is: A standard blob namespace was chosen without the hierarchical features required by the lake workload. Choose the corresponding action: Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account.
C:That design instead addresses another observed condition: A polling job misses new objects between long scan intervals. Its technical cause is: No event subscription connects blob lifecycle notifications to the processing consumer. The current workload exhibits: Analytics jobs cannot apply directory ACLs to datasets stored as flat object paths. Its targeted remedy is: Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account.
D:This choice mitigates an alternative scenario, where: Standard object requests cannot satisfy POSIX filesystem and low-latency shared file requirements. The underlying issue there is: Object/blob storage was mistaken for a managed high-throughput POSIX shared filesystem. Here the root issue is: A standard blob namespace was chosen without the hierarchical features required by the lake workload. Choose the corresponding action: Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account.
Question 366
An architect proposes this change: Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account. The workload context is: A data lake requires directory-level analytics ACLs, atomic directory operations and POSIX-like permissions for Spark jobs. Which evidence would most directly validate the change?
- Create nested directories, apply ACLs and validate intended Spark/read behavior under group identities.
- Simulate zonal failure conditions and verify primary-region access remains available as designed.
- Mount NFS from several compute nodes and benchmark concurrent file IO against workload demand.
- Upload a test blob and confirm the event payload reaches the subscriber and triggers processing.
Explanation
Correct Answer
A:The acceptance test is specific: Create nested directories, apply ACLs and validate intended Spark/read behavior under group identities. Its purpose is to establish that the proposed architecture works: Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account.
Incorrect Answers
B:The alternative test targets: Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region. The scenario's actual proposed remedy is: Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account. Verify that one by: Create nested directories, apply ACLs and validate intended Spark/read behavior under group identities.
C:This check validates a different workload: Mount NFS from several compute nodes and benchmark concurrent file IO against workload demand. Its associated design is: Choose Azure NetApp Files with supported NFS volumes and suitable service levels and network placement. The required acceptance test here is: Create nested directories, apply ACLs and validate intended Spark/read behavior under group identities.
D:That observation pertains to a separate failure: A polling job misses new objects between long scan intervals. Its cause is: No event subscription connects blob lifecycle notifications to the processing consumer. It does not confirm the result of this design. The direct proof would be: Create nested directories, apply ACLs and validate intended Spark/read behavior under group identities.
Question 367
During architecture troubleshooting, a team reports: Analytics jobs cannot apply directory ACLs to datasets stored as flat object paths. Context: A data lake requires directory-level analytics ACLs, atomic directory operations and POSIX-like permissions for Spark jobs. Which underlying design mistake explains the observed behavior most precisely?
- No event subscription connects blob lifecycle notifications to the processing consumer.
- Local redundancy did not distribute synchronous copies across availability zones.
- A standard blob namespace was chosen without the hierarchical features required by the lake workload.
- Object/blob storage was mistaken for a managed high-throughput POSIX shared filesystem.
Explanation
Correct Answer
C:The incident is explained by: A standard blob namespace was chosen without the hierarchical features required by the lake workload. The reported symptom is: Analytics jobs cannot apply directory ACLs to datasets stored as flat object paths. The corresponding design fix is: Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account.
Incorrect Answers
A:The proposed diagnosis fits another scenario: No event subscription connects blob lifecycle notifications to the processing consumer. It would typically be reflected by: A polling job misses new objects between long scan intervals. The current evidence instead supports: A standard blob namespace was chosen without the hierarchical features required by the lake workload.
B:The alternative weakness is: Local redundancy did not distribute synchronous copies across availability zones. Its associated failure is: A single datacenter failure makes locally redundant blob data temporarily unavailable. Neither explains the present observation: Analytics jobs cannot apply directory ACLs to datasets stored as flat object paths. The direct cause here is: A standard blob namespace was chosen without the hierarchical features required by the lake workload.
D:The proposed diagnosis fits another scenario: Object/blob storage was mistaken for a managed high-throughput POSIX shared filesystem. It would typically be reflected by: Standard object requests cannot satisfy POSIX filesystem and low-latency shared file requirements. The current evidence instead supports: A standard blob namespace was chosen without the hierarchical features required by the lake workload.
Question 368
The design change is: Use Azure Data Lake Storage Gen2 by enabling hierarchical namespace on a supported storage account. The original failure was: Analytics jobs cannot apply directory ACLs to datasets stored as flat object paths. Which ongoing control best prevents recurrence of the same root cause?
- Reassess volume capacity, throughput and snapshot policy as parallel job size grows.
- Design idempotent handlers and monitor retries/dead letters for at-least-once event delivery.
- Audit filesystem and ACL inheritance rules as lake zones grow.
- Check regional ZRS support and workload availability after storage configuration changes.
Explanation
Correct Answer
C:The preventive control is: Audit filesystem and ACL inheritance rules as lake zones grow. It targets the earlier cause: A standard blob namespace was chosen without the hierarchical features required by the lake workload. Confirm ongoing effectiveness by: Create nested directories, apply ACLs and validate intended Spark/read behavior under group identities.
Incorrect Answers
A:This is a reasonable safeguard for a different fault: Standard object requests cannot satisfy POSIX filesystem and low-latency shared file requirements. That different mechanism is: Object/blob storage was mistaken for a managed high-throughput POSIX shared filesystem. The original incident here instead arises from: A standard blob namespace was chosen without the hierarchical features required by the lake workload. The directly relevant safeguard is: Audit filesystem and ACL inheritance rules as lake zones grow.
B:The proposed control focuses on: No event subscription connects blob lifecycle notifications to the processing consumer. For the design in the question, recurrence comes from: A standard blob namespace was chosen without the hierarchical features required by the lake workload. A precise prevention step is: Audit filesystem and ACL inheritance rules as lake zones grow.
D:This is a reasonable safeguard for a different fault: A single datacenter failure makes locally redundant blob data temporarily unavailable. That different mechanism is: Local redundancy did not distribute synchronous copies across availability zones. The original incident here instead arises from: A standard blob namespace was chosen without the hierarchical features required by the lake workload. The directly relevant safeguard is: Audit filesystem and ACL inheritance rules as lake zones grow.
Question 369
A design workshop has this requirement: A storage account must survive a single availability-zone outage while data continues serving reads and writes within the primary region. Operators currently observe: A single datacenter failure makes locally redundant blob data temporarily unavailable. Select the ONE design remedy that best addresses the root cause.
- Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region.
- Use read-access geo-redundant storage (RA-GRS or RA-GZRS) when supported, with app logic for the secondary endpoint.
- Select geo-zone-redundant storage (GZRS) for eligible blob accounts and define regional failover expectations.
- Configure supported blob soft delete with a sufficient retention interval and validate recoverability.
Explanation
Correct Answer
A:The targeted implementation is: Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region. The problem is not generic resource availability: Local redundancy did not distribute synchronous copies across availability zones. Verify the result by: Simulate zonal failure conditions and verify primary-region access remains available as designed.
Incorrect Answers
B:That design instead addresses another observed condition: Secondary-region clients cannot read replicas from a standard GRS account during primary-region disruption. Its technical cause is: Geo-redundancy alone does not expose a read-enabled secondary endpoint. The current workload exhibits: A single datacenter failure makes locally redundant blob data temporarily unavailable. Its targeted remedy is: Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region.
C:This choice mitigates an alternative scenario, where: Zone-resilient storage lacks any copy outside the primary region. The underlying issue there is: ZRS was selected without the needed geographical disaster-recovery replica. Here the root issue is: Local redundancy did not distribute synchronous copies across availability zones. Choose the corresponding action: Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region.
D:The option belongs to a different failure mechanism: Soft delete retention was not enabled or its interval was too short. That situation exhibits: A developer's accidental deletion destroys the only live blob immediately. For the stated case, the remedy is: Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region.
Question 370
The planned architecture is: Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region. Workload context: A storage account must survive a single availability-zone outage while data continues serving reads and writes within the primary region. Which acceptance test demonstrates that the required behavior works?
- Verify redundancy setting, secondary-region replication status and a documented storage failover test.
- Simulate zonal failure conditions and verify primary-region access remains available as designed.
- Delete a test blob and restore it during the permitted soft-delete interval.
- Read a test object from the secondary endpoint and confirm writes remain limited to the primary.
Explanation
Correct Answer
B:This observation directly verifies the intended design: Simulate zonal failure conditions and verify primary-region access remains available as designed. The architecture being tested is: Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region. The original symptom was: A single datacenter failure makes locally redundant blob data temporarily unavailable.
Incorrect Answers
A:The alternative test targets: Select geo-zone-redundant storage (GZRS) for eligible blob accounts and define regional failover expectations. The scenario's actual proposed remedy is: Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region. Verify that one by: Simulate zonal failure conditions and verify primary-region access remains available as designed.
C:That observation pertains to a separate failure: A developer's accidental deletion destroys the only live blob immediately. Its cause is: Soft delete retention was not enabled or its interval was too short. It does not confirm the result of this design. The direct proof would be: Simulate zonal failure conditions and verify primary-region access remains available as designed.
D:The alternative test targets: Use read-access geo-redundant storage (RA-GRS or RA-GZRS) when supported, with app logic for the secondary endpoint. The scenario's actual proposed remedy is: Select zone-redundant storage (ZRS) for supported blob workloads in a suitable region. Verify that one by: Simulate zonal failure conditions and verify primary-region access remains available as designed.
Designing Microsoft Azure Infrastructure Solutions (AZ-305) Practice Tests