Microsoft AZ-305 Practice Test 31
Question 300
Acceptance testing must establish the following operational result: Endpoint continuity proves client redirection works. Which verification action most directly establishes that outcome?
- Run an RPO risk exercise using acknowledged writes and a regional failover drill.
- Fail over a nonproduction group and test listener connectivity.
- Compare commit timestamps and replication lag during representative load.
- Run a data-size growth forecast and compatibility proof of concept.
Explanation
Correct Answer
B:Endpoint continuity proves client redirection works.
Incorrect Answers
A:That verification addresses the different requirement: A compliance app requires zero transaction loss across distant regions during sudden failover. It does not directly establish endpoint continuity proves client redirection works.
C:That verification addresses the different requirement: A secondary region is intended for reporting but data may be delayed compared with the writer. It does not directly establish endpoint continuity proves client redirection works.
D:This is a test for A very large Azure SQL Database grows beyond conventional provisioning expectations and needs independent storage growth. The requirement here is instead demonstrated by fail over a nonproduction group and test listener connectivity.
Question 301
A secondary region is intended for reporting but data may be delayed compared with the writer. Which Azure architecture choice best meets this requirement?
- Promise the secondary contains every committed primary transaction synchronously.
- Treat an auto-failover group as proof of synchronous multi-region commits.
- Hardcode the primary database region hostname in every microservice with no failover logic.
- Design reports against geo-secondary read endpoints with explicit consistency tolerance.
Explanation
Correct Answer
D:Asynchronous replication can introduce measurable read lag.
Incorrect Answers
A:Geo-replication is asynchronous and cannot guarantee zero RPO. This proposal contradicts the stated architecture constraint.
B:Automatic routing is not the same as zero-loss replication. In the present requirement, a secondary region is intended for reporting but data may be delayed compared with the writer. The needed design instead works because asynchronous replication can introduce measurable read lag.
C:Fixed regional names can break clients after disaster recovery. In the present requirement, a secondary region is intended for reporting but data may be delayed compared with the writer. The needed design instead works because asynchronous replication can introduce measurable read lag.
Question 302
An architecture proposal for sql geo failover and readable replicas relies on the following approach: Promise the secondary contains every committed primary transaction synchronously. Which specific failure or mismatch should the design reviewer identify?
- Fixed regional names can break clients after disaster recovery.
- Premature deletion destroys rollback options and verification sources.
- Automatic routing is not the same as zero-loss replication.
- Geo-replication is asynchronous and cannot guarantee zero RPO.
Explanation
Correct Answer
D:Promise the secondary contains every committed primary transaction synchronously. Geo-replication is asynchronous and cannot guarantee zero RPO.
Incorrect Answers
A:That assessment refers to the separate proposal 'Hardcode the primary database region hostname in every microservice with no failover logic.' not to the recommendation under review. Here, Geo-replication is asynchronous and cannot guarantee zero RPO.
B:This concern applies to Delete the source database before measuring migration completeness. in another design data storage solutions for relational data design. The current proposal specifically fails because geo-replication is asynchronous and cannot guarantee zero RPO.
C:That assessment refers to the separate proposal 'Treat an auto-failover group as proof of synchronous multi-region commits.' not to the recommendation under review. Here, Geo-replication is asynchronous and cannot guarantee zero RPO.
Question 303
Acceptance testing must establish the following operational result: Measured delay informs report freshness and failover RPO. Which verification action most directly establishes that outcome?
- Compare row counts and application transaction checks before final switch.
- Compare commit timestamps and replication lag during representative load.
- Fail over a nonproduction group and test listener connectivity.
- Run an RPO risk exercise using acknowledged writes and a regional failover drill.
Explanation
Correct Answer
B:Measured delay informs report freshness and failover RPO.
Incorrect Answers
A:This is a test for A legacy OLTP app can tolerate a brief cutover but requires schema and data fidelity. The requirement here is instead demonstrated by compare commit timestamps and replication lag during representative load.
C:That verification addresses the different requirement: A globally deployed application needs cross-region SQL failover with a stable application endpoint. It does not directly establish measured delay informs report freshness and failover RPO.
D:That verification addresses the different requirement: A compliance app requires zero transaction loss across distant regions during sudden failover. It does not directly establish measured delay informs report freshness and failover RPO.
Question 304
A compliance app requires zero transaction loss across distant regions during sudden failover. Which Azure architecture choice best meets this requirement?
- Reassess the zero-RPO requirement rather than rely on asynchronous Azure SQL geo-replication alone.
- Promise the secondary contains every committed primary transaction synchronously.
- Hardcode the primary database region hostname in every microservice with no failover logic.
- Treat an auto-failover group as proof of synchronous multi-region commits.
Explanation
Correct Answer
A:Cross-region async replication cannot guarantee no committed transactions are lost.
Incorrect Answers
B:Geo-replication is asynchronous and cannot guarantee zero RPO. In the present requirement, a compliance app requires zero transaction loss across distant regions during sudden failover. The needed design instead works because cross-region async replication cannot guarantee no committed transactions are lost.
C:Fixed regional names can break clients after disaster recovery. In the present requirement, a compliance app requires zero transaction loss across distant regions during sudden failover. The needed design instead works because cross-region async replication cannot guarantee no committed transactions are lost.
D:Automatic routing is not the same as zero-loss replication. This proposal contradicts the stated architecture constraint.
Question 305
An architecture proposal for sql geo failover and readable replicas relies on the following approach: Treat an auto-failover group as proof of synchronous multi-region commits. Which specific failure or mismatch should the design reviewer identify?
- Geo-replication is asynchronous and cannot guarantee zero RPO.
- Fixed regional names can break clients after disaster recovery.
- Read replicas are not a second write authority.
- Automatic routing is not the same as zero-loss replication.
Explanation
Correct Answer
D:Treat an auto-failover group as proof of synchronous multi-region commits. Automatic routing is not the same as zero-loss replication.
Incorrect Answers
A:That assessment refers to the separate proposal 'Promise the secondary contains every committed primary transaction synchronously.' not to the recommendation under review. Here, Automatic routing is not the same as zero-loss replication.
B:That assessment refers to the separate proposal 'Hardcode the primary database region hostname in every microservice with no failover logic.' not to the recommendation under review. Here, Automatic routing is not the same as zero-loss replication.
C:This concern applies to Direct application writes to an ordinary read-only named replica. in another design data storage solutions for relational data design. The current proposal specifically fails because automatic routing is not the same as zero-loss replication.
Question 306
Acceptance testing must establish the following operational result: The measured recovery gap informs contractual feasibility. Which verification action most directly establishes that outcome?
- Fail over a nonproduction group and test listener connectivity.
- Test read and write behavior against each endpoint in a nonproduction design.
- Compare commit timestamps and replication lag during representative load.
- Run an RPO risk exercise using acknowledged writes and a regional failover drill.
Explanation
Correct Answer
D:The measured recovery gap informs contractual feasibility.
Incorrect Answers
A:That verification addresses the different requirement: A globally deployed application needs cross-region SQL failover with a stable application endpoint. It does not directly establish the measured recovery gap informs contractual feasibility.
B:This is a test for A database architect equates Hyperscale read replicas with independent synchronous multi-region write masters. The requirement here is instead demonstrated by run an RPO risk exercise using acknowledged writes and a regional failover drill.
C:That verification addresses the different requirement: A secondary region is intended for reporting but data may be delayed compared with the writer. It does not directly establish the measured recovery gap informs contractual feasibility.
Question 307
An open-source application needs managed PostgreSQL without an IaaS database VM. Which Azure architecture choice best meets this requirement?
- Route all writes to a replica and treat it as multi-writer by default.
- Depend solely on a single-zone VM disk snapshot for continuous HA.
- Deploy SQL Server Managed Instance to run an unchanged PostgreSQL engine.
- Use Azure Database for PostgreSQL Flexible Server with suitable compute.
Explanation
Correct Answer
D:Flexible Server provides managed PostgreSQL operation and maintenance capabilities.
Incorrect Answers
A:Ordinary PostgreSQL read replicas are not independent writable masters. In the present requirement, an open-source application needs managed PostgreSQL without an IaaS database VM. The needed design instead works because flexible Server provides managed PostgreSQL operation and maintenance capabilities.
B:Backups are not a live standby for automatic service recovery. In the present requirement, an open-source application needs managed PostgreSQL without an IaaS database VM. The needed design instead works because flexible Server provides managed PostgreSQL operation and maintenance capabilities.
C:SQL Managed Instance is not a PostgreSQL database service. This proposal contradicts the stated architecture constraint.
Question 308
An architecture proposal for azure postgresql flexible server relies on the following approach: Deploy SQL Server Managed Instance to run an unchanged PostgreSQL engine. Which specific failure or mismatch should the design reviewer identify?
- Geo-replication is asynchronous and cannot guarantee zero RPO.
- SQL Managed Instance is not a PostgreSQL database service.
- Backups are not a live standby for automatic service recovery.
- Ordinary PostgreSQL read replicas are not independent writable masters.
Explanation
Correct Answer
B:Deploy SQL Server Managed Instance to run an unchanged PostgreSQL engine. SQL Managed Instance is not a PostgreSQL database service.
Incorrect Answers
A:This concern applies to Promise the secondary contains every committed primary transaction synchronously. in another design data storage solutions for relational data design. The current proposal specifically fails because sQL Managed Instance is not a PostgreSQL database service.
C:That assessment refers to the separate proposal 'Depend solely on a single-zone VM disk snapshot for continuous HA.' not to the recommendation under review. Here, SQL Managed Instance is not a PostgreSQL database service.
D:That assessment refers to the separate proposal 'Route all writes to a replica and treat it as multi-writer by default.' not to the recommendation under review. Here, SQL Managed Instance is not a PostgreSQL database service.
Question 309
Acceptance testing must establish the following operational result: Compatibility tests establish correct engine support. Which verification action most directly establishes that outcome?
- Check replica read-only behavior and replay lag during peak load.
- Validate application extensions and connectivity on the target Flexible Server.
- Compare commit timestamps and replication lag during representative load.
- Simulate a controlled server failover and measure application reconnects.
Explanation
Correct Answer
B:Compatibility tests establish correct engine support.
Incorrect Answers
A:That verification addresses the different requirement: A reporting service needs read-heavy PostgreSQL queries without blocking the transactional primary. It does not directly establish compatibility tests establish correct engine support.
C:This is a test for A secondary region is intended for reporting but data may be delayed compared with the writer. The requirement here is instead demonstrated by validate application extensions and connectivity on the target Flexible Server.
D:That verification addresses the different requirement: An availability-critical PostgreSQL database needs a standby in another availability zone. It does not directly establish compatibility tests establish correct engine support.
Question 310
An availability-critical PostgreSQL database needs a standby in another availability zone. Which Azure architecture choice best meets this requirement?
- Route all writes to a replica and treat it as multi-writer by default.
- Configure supported zone-redundant high availability on PostgreSQL Flexible Server.
- Depend solely on a single-zone VM disk snapshot for continuous HA.
- Deploy SQL Server Managed Instance to run an unchanged PostgreSQL engine.
Explanation
Correct Answer
B:Zone-distributed standby protects against eligible zonal host outages.
Incorrect Answers
A:Ordinary PostgreSQL read replicas are not independent writable masters. In the present requirement, an availability-critical PostgreSQL database needs a standby in another availability zone. The needed design instead works because zone-distributed standby protects against eligible zonal host outages.
C:Backups are not a live standby for automatic service recovery. This proposal contradicts the stated architecture constraint.
D:SQL Managed Instance is not a PostgreSQL database service. In the present requirement, an availability-critical PostgreSQL database needs a standby in another availability zone. The needed design instead works because zone-distributed standby protects against eligible zonal host outages.