Microsoft AZ-305 Practice Test 30
Question 290
An architecture proposal for azure sql elastic pools relies on the following approach: Overprovision every single database for the sum of all hypothetical peaks. Which specific failure or mismatch should the design reviewer identify?
- Dedicated maximum capacity per tenant can waste substantial compute.
- Shared resources without governance cannot assure independent maxima.
- Tenant databases retain separate data and recovery concerns.
- Ownership expands privileges and error logs are not a complete audited access stream.
Explanation
Correct Answer
A:Overprovision every single database for the sum of all hypothetical peaks. Dedicated maximum capacity per tenant can waste substantial compute.
Incorrect Answers
B:That assessment refers to the separate proposal 'Remove all limits and promise guaranteed performance to every database.' not to the recommendation under review. Here, Dedicated maximum capacity per tenant can waste substantial compute.
C:That assessment refers to the separate proposal 'Treat the whole elastic pool as one database requiring one common restore point.' not to the recommendation under review. Here, Dedicated maximum capacity per tenant can waste substantial compute.
D:This concern applies to Make auditors database owners and rely only on SQL server errors. in another design data storage solutions for relational data design. The current proposal specifically fails because dedicated maximum capacity per tenant can waste substantial compute.
Question 291
Acceptance testing must establish the following operational result: Consumption evidence validates the statistical sharing benefit. Which verification action most directly establishes that outcome?
- Restore one nonproduction tenant database without changing neighbors.
- Monitor pool utilization and per-database resource consumption over a cycle.
- Execute a controlled audited query and locate the audit record.
- Stress a noisy test database and observe other tenants' latency.
Explanation
Correct Answer
B:Consumption evidence validates the statistical sharing benefit.
Incorrect Answers
A:That verification addresses the different requirement: A customer requires independently managed restore and retention even though its database is in a pool. It does not directly establish consumption evidence validates the statistical sharing benefit.
C:This is a test for Security needs SQL audit events centralized without giving auditors table modification privileges. The requirement here is instead demonstrated by monitor pool utilization and per-database resource consumption over a cycle.
D:That verification addresses the different requirement: A few tenants consume most pool CPU and starve many low-usage tenants. It does not directly establish consumption evidence validates the statistical sharing benefit.
Question 292
A few tenants consume most pool CPU and starve many low-usage tenants. Which Azure architecture choice best meets this requirement?
- Configure suitable per-database limits or isolate noisy tenants to another pool.
- Remove all limits and promise guaranteed performance to every database.
- Overprovision every single database for the sum of all hypothetical peaks.
- Treat the whole elastic pool as one database requiring one common restore point.
Explanation
Correct Answer
A:Pool-level and database-level constraints can reduce noisy-neighbor effects.
Incorrect Answers
B:Shared resources without governance cannot assure independent maxima. This proposal contradicts the stated architecture constraint.
C:Dedicated maximum capacity per tenant can waste substantial compute. In the present requirement, a few tenants consume most pool CPU and starve many low-usage tenants. The needed design instead works because pool-level and database-level constraints can reduce noisy-neighbor effects.
D:Tenant databases retain separate data and recovery concerns. In the present requirement, a few tenants consume most pool CPU and starve many low-usage tenants. The needed design instead works because pool-level and database-level constraints can reduce noisy-neighbor effects.
Question 293
An architecture proposal for azure sql elastic pools relies on the following approach: Remove all limits and promise guaranteed performance to every database. Which specific failure or mismatch should the design reviewer identify?
- Dedicated maximum capacity per tenant can waste substantial compute.
- Shared resources without governance cannot assure independent maxima.
- Tenant databases retain separate data and recovery concerns.
- Always-on provisioned compute can waste idle capacity in this scenario.
Explanation
Correct Answer
B:Remove all limits and promise guaranteed performance to every database. Shared resources without governance cannot assure independent maxima.
Incorrect Answers
A:That assessment refers to the separate proposal 'Overprovision every single database for the sum of all hypothetical peaks.' not to the recommendation under review. Here, Shared resources without governance cannot assure independent maxima.
C:That assessment refers to the separate proposal 'Treat the whole elastic pool as one database requiring one common restore point.' not to the recommendation under review. Here, Shared resources without governance cannot assure independent maxima.
D:This concern applies to Keep a large provisioned database running continuously despite the idle workload. in another design data storage solutions for relational data design. The current proposal specifically fails because shared resources without governance cannot assure independent maxima.
Question 294
Acceptance testing must establish the following operational result: Cross-tenant load testing verifies isolation thresholds. Which verification action most directly establishes that outcome?
- Review pause/resume history and effective compute billing.
- Monitor pool utilization and per-database resource consumption over a cycle.
- Stress a noisy test database and observe other tenants' latency.
- Restore one nonproduction tenant database without changing neighbors.
Explanation
Correct Answer
C:Cross-tenant load testing verifies isolation thresholds.
Incorrect Answers
A:This is a test for A development database receives traffic twice daily and is idle overnight, with tolerance for wake-up latency. The requirement here is instead demonstrated by stress a noisy test database and observe other tenants' latency.
B:That verification addresses the different requirement: A software vendor hosts 60 small customer databases with staggered peak usage. It does not directly establish cross-tenant load testing verifies isolation thresholds.
D:That verification addresses the different requirement: A customer requires independently managed restore and retention even though its database is in a pool. It does not directly establish cross-tenant load testing verifies isolation thresholds.
Question 295
A customer requires independently managed restore and retention even though its database is in a pool. Which Azure architecture choice best meets this requirement?
- Keep database-level backup and restore planning distinct from pooled compute.
- Overprovision every single database for the sum of all hypothetical peaks.
- Treat the whole elastic pool as one database requiring one common restore point.
- Remove all limits and promise guaranteed performance to every database.
Explanation
Correct Answer
A:Elastic pooling shares compute but does not merge tenant databases into one logical database.
Incorrect Answers
B:Dedicated maximum capacity per tenant can waste substantial compute. In the present requirement, a customer requires independently managed restore and retention even though its database is in a pool. The needed design instead works because elastic pooling shares compute but does not merge tenant databases into one logical database.
C:Tenant databases retain separate data and recovery concerns. This proposal contradicts the stated architecture constraint.
D:Shared resources without governance cannot assure independent maxima. In the present requirement, a customer requires independently managed restore and retention even though its database is in a pool. The needed design instead works because elastic pooling shares compute but does not merge tenant databases into one logical database.
Question 296
An architecture proposal for azure sql elastic pools relies on the following approach: Treat the whole elastic pool as one database requiring one common restore point. Which specific failure or mismatch should the design reviewer identify?
- Shared resources without governance cannot assure independent maxima.
- Tenant databases retain separate data and recovery concerns.
- TDE does not hide decrypted column values from authorized SQL queries.
- Dedicated maximum capacity per tenant can waste substantial compute.
Explanation
Correct Answer
B:Treat the whole elastic pool as one database requiring one common restore point. Tenant databases retain separate data and recovery concerns.
Incorrect Answers
A:That assessment refers to the separate proposal 'Remove all limits and promise guaranteed performance to every database.' not to the recommendation under review. Here, Tenant databases retain separate data and recovery concerns.
C:This concern applies to Use TDE alone and claim privileged database users cannot read sensitive columns. in another design data storage solutions for relational data design. The current proposal specifically fails because tenant databases retain separate data and recovery concerns.
D:That assessment refers to the separate proposal 'Overprovision every single database for the sum of all hypothetical peaks.' not to the recommendation under review. Here, Tenant databases retain separate data and recovery concerns.
Question 297
Acceptance testing must establish the following operational result: Targeted recovery demonstrates logical database independence. Which verification action most directly establishes that outcome?
- Restore one nonproduction tenant database without changing neighbors.
- Stress a noisy test database and observe other tenants' latency.
- Monitor pool utilization and per-database resource consumption over a cycle.
- Run an authorized query without the client encryption key.
Explanation
Correct Answer
A:Targeted recovery demonstrates logical database independence.
Incorrect Answers
B:That verification addresses the different requirement: A few tenants consume most pool CPU and starve many low-usage tenants. It does not directly establish targeted recovery demonstrates logical database independence.
C:That verification addresses the different requirement: A software vendor hosts 60 small customer databases with staggered peak usage. It does not directly establish targeted recovery demonstrates logical database independence.
D:This is a test for Developers must not see highly sensitive values even when operating the SQL server. The requirement here is instead demonstrated by restore one nonproduction tenant database without changing neighbors.
Question 298
A globally used SQL Database needs regional failover and reporting reads from its secondary. Which TWO capabilities should architects evaluate? (Select TWO.)
- Promise zero RPO from asynchronous geo replication without tests.
- Direct ordinary updates to the read-only geo secondary.
- Use a supported Azure SQL failover group and stable listener for application connections.
- Hardcode every application to the primary server DNS name indefinitely.
- Route eligible reporting reads to a geo-secondary read endpoint with explicit lag tolerance.
Explanation
Correct Answers
C:The listener abstracts the active regional endpoint.
E:Asynchronous replicas can offload reports but may be stale.
Incorrect Answers
A:Async propagation permits some acknowledged write loss on abrupt disaster.
B:Geo secondaries are not automatically independent write masters.
D:Fixed regional endpoints complicate failover.
Question 299
An architecture proposal for sql geo failover and readable replicas relies on the following approach: Hardcode the primary database region hostname in every microservice with no failover logic. Which specific failure or mismatch should the design reviewer identify?
- Fixed regional names can break clients after disaster recovery.
- Automatic routing is not the same as zero-loss replication.
- Geo-replication is asynchronous and cannot guarantee zero RPO.
- Basic tiers do not provide Hyperscale's scale characteristics.
Explanation
Correct Answer
A:Hardcode the primary database region hostname in every microservice with no failover logic. Fixed regional names can break clients after disaster recovery.
Incorrect Answers
B: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, Fixed regional names can break clients after disaster recovery.
C:That assessment refers to the separate proposal 'Promise the secondary contains every committed primary transaction synchronously.' not to the recommendation under review. Here, Fixed regional names can break clients after disaster recovery.
D:This concern applies to Assume a small Basic tier supports the same high-volume storage model. in another design data storage solutions for relational data design. The current proposal specifically fails because fixed regional names can break clients after disaster recovery.
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.