Microsoft AZ-305 Practice Test 28
Question 270
Acceptance testing must establish the following operational result: Query evidence distinguishes inefficient plans from resource saturation. Which verification action most directly establishes that outcome?
- Measure compute, IO and query latency during normal and peak load.
- Compare row counts and application transaction checks before final switch.
- Test representative transaction latency and local failover behavior.
- Review Query Store regressions and workload waits around peak periods.
Explanation
Correct Answer
D:Query evidence distinguishes inefficient plans from resource saturation.
Incorrect Answers
A:That verification addresses the different requirement: A departmental app has modest predictable throughput and no demanding low-latency SQL requirement. It does not directly establish query evidence distinguishes inefficient plans from resource saturation.
B: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 review Query Store regressions and workload waits around peak periods.
C:That verification addresses the different requirement: A banking OLTP database needs low storage latency and resilient local replicas with high transaction throughput. It does not directly establish query evidence distinguishes inefficient plans from resource saturation.
Question 271
A very large Azure SQL Database grows beyond conventional provisioning expectations and needs independent storage growth. Which Azure architecture choice best meets this requirement?
- Assess Azure SQL Database Hyperscale for large-volume storage architecture.
- Assume a small Basic tier supports the same high-volume storage model.
- Redirect every reporting query to the primary and raise the write compute tier only.
- Direct application writes to an ordinary read-only named replica.
Explanation
Correct Answer
A:Hyperscale decouples key storage and compute scaling components for large databases.
Incorrect Answers
B:Basic tiers do not provide Hyperscale's scale characteristics. This proposal contradicts the stated architecture constraint.
C:Concentrated reads can continue contending with OLTP activity. In the present requirement, a very large Azure SQL Database grows beyond conventional provisioning expectations and needs independent storage growth. The needed design instead works because hyperscale decouples key storage and compute scaling components for large databases.
D:Read replicas are not a second write authority. In the present requirement, a very large Azure SQL Database grows beyond conventional provisioning expectations and needs independent storage growth. The needed design instead works because hyperscale decouples key storage and compute scaling components for large databases.
Question 272
An architecture proposal for sql hyperscale and large database design relies on the following approach: Assume a small Basic tier supports the same high-volume storage model. Which specific failure or mismatch should the design reviewer identify?
- Concentrated reads can continue contending with OLTP activity.
- General Purpose's remote storage architecture differs from Business Critical.
- Read replicas are not a second write authority.
- Basic tiers do not provide Hyperscale's scale characteristics.
Explanation
Correct Answer
D:Assume a small Basic tier supports the same high-volume storage model. Basic tiers do not provide Hyperscale's scale characteristics.
Incorrect Answers
A:That assessment refers to the separate proposal 'Redirect every reporting query to the primary and raise the write compute tier only.' not to the recommendation under review. Here, Basic tiers do not provide Hyperscale's scale characteristics.
B:This concern applies to Use a low-cost General Purpose tier and claim the same local replica architecture by default. in another design data storage solutions for relational data design. The current proposal specifically fails because basic tiers do not provide Hyperscale's scale characteristics.
C:That assessment refers to the separate proposal 'Direct application writes to an ordinary read-only named replica.' not to the recommendation under review. Here, Basic tiers do not provide Hyperscale's scale characteristics.
Question 273
Acceptance testing must establish the following operational result: Forecasted storage and performance checks validate the scale design. Which verification action most directly establishes that outcome?
- Test representative transaction latency and local failover behavior.
- Run a data-size growth forecast and compatibility proof of concept.
- Measure replica lag and the analytic query route under load.
- Test read and write behavior against each endpoint in a nonproduction design.
Explanation
Correct Answer
B:Forecasted storage and performance checks validate the scale design.
Incorrect Answers
A:This is a test for A banking OLTP database needs low storage latency and resilient local replicas with high transaction throughput. The requirement here is instead demonstrated by run a data-size growth forecast and compatibility proof of concept.
C:That verification addresses the different requirement: A read-heavy analytic component should avoid stealing throughput from OLTP writes in a large Hyperscale database. It does not directly establish forecasted storage and performance checks validate the scale design.
D:That verification addresses the different requirement: A database architect equates Hyperscale read replicas with independent synchronous multi-region write masters. It does not directly establish forecasted storage and performance checks validate the scale design.
Question 274
A read-heavy analytic component should avoid stealing throughput from OLTP writes in a large Hyperscale database. Which Azure architecture choice best meets this requirement?
- Evaluate supported Hyperscale named/read replicas for read scale-out.
- Assume a small Basic tier supports the same high-volume storage model.
- Redirect every reporting query to the primary and raise the write compute tier only.
- Direct application writes to an ordinary read-only named replica.
Explanation
Correct Answer
A:Read replicas offload eligible reads from the primary compute path.
Incorrect Answers
B:Basic tiers do not provide Hyperscale's scale characteristics. In the present requirement, a read-heavy analytic component should avoid stealing throughput from OLTP writes in a large Hyperscale database. The needed design instead works because read replicas offload eligible reads from the primary compute path.
C:Concentrated reads can continue contending with OLTP activity. This proposal contradicts the stated architecture constraint.
D:Read replicas are not a second write authority. In the present requirement, a read-heavy analytic component should avoid stealing throughput from OLTP writes in a large Hyperscale database. The needed design instead works because read replicas offload eligible reads from the primary compute path.
Question 275
An architecture proposal for sql hyperscale and large database design relies on the following approach: Redirect every reporting query to the primary and raise the write compute tier only. Which specific failure or mismatch should the design reviewer identify?
- Concentrated reads can continue contending with OLTP activity.
- Backups are not a live standby for automatic service recovery.
- Basic tiers do not provide Hyperscale's scale characteristics.
- Read replicas are not a second write authority.
Explanation
Correct Answer
A:Redirect every reporting query to the primary and raise the write compute tier only. Concentrated reads can continue contending with OLTP activity.
Incorrect Answers
B:This concern applies to Depend solely on a single-zone VM disk snapshot for continuous HA. in another design data storage solutions for relational data design. The current proposal specifically fails because concentrated reads can continue contending with OLTP activity.
C:That assessment refers to the separate proposal 'Assume a small Basic tier supports the same high-volume storage model.' not to the recommendation under review. Here, Concentrated reads can continue contending with OLTP activity.
D:That assessment refers to the separate proposal 'Direct application writes to an ordinary read-only named replica.' not to the recommendation under review. Here, Concentrated reads can continue contending with OLTP activity.
Question 276
Acceptance testing must establish the following operational result: Observed read routing and acceptable staleness confirm offload. Which verification action most directly establishes that outcome?
- Simulate a controlled server failover and measure application reconnects.
- Run a data-size growth forecast and compatibility proof of concept.
- Measure replica lag and the analytic query route under load.
- Test read and write behavior against each endpoint in a nonproduction design.
Explanation
Correct Answer
C:Observed read routing and acceptable staleness confirm offload.
Incorrect Answers
A:This is a test for An availability-critical PostgreSQL database needs a standby in another availability zone. The requirement here is instead demonstrated by measure replica lag and the analytic query route under load.
B:That verification addresses the different requirement: A very large Azure SQL Database grows beyond conventional provisioning expectations and needs independent storage growth. It does not directly establish observed read routing and acceptable staleness confirm offload.
D:That verification addresses the different requirement: A database architect equates Hyperscale read replicas with independent synchronous multi-region write masters. It does not directly establish observed read routing and acceptable staleness confirm offload.
Question 277
A database architect equates Hyperscale read replicas with independent synchronous multi-region write masters. Which Azure architecture choice best meets this requirement?
- Direct application writes to an ordinary read-only named replica.
- Assume a small Basic tier supports the same high-volume storage model.
- Redirect every reporting query to the primary and raise the write compute tier only.
- Treat Hyperscale replicas and cross-region disaster recovery as distinct design mechanisms.
Explanation
Correct Answer
D:Read scale-out does not automatically provide multi-region writable consensus.
Incorrect Answers
A:Read replicas are not a second write authority. This proposal contradicts the stated architecture constraint.
B:Basic tiers do not provide Hyperscale's scale characteristics. In the present requirement, a database architect equates Hyperscale read replicas with independent synchronous multi-region write masters. The needed design instead works because read scale-out does not automatically provide multi-region writable consensus.
C:Concentrated reads can continue contending with OLTP activity. In the present requirement, a database architect equates Hyperscale read replicas with independent synchronous multi-region write masters. The needed design instead works because read scale-out does not automatically provide multi-region writable consensus.
Question 278
An architecture proposal for sql hyperscale and large database design relies on the following approach: Direct application writes to an ordinary read-only named replica. Which specific failure or mismatch should the design reviewer identify?
- Read replicas are not a second write authority.
- Concentrated reads can continue contending with OLTP activity.
- Basic tiers do not provide Hyperscale's scale characteristics.
- Blind capacity purchases can leave blocking and query plan problems unresolved.
Explanation
Correct Answer
A:Direct application writes to an ordinary read-only named replica. Read replicas are not a second write authority.
Incorrect Answers
B:That assessment refers to the separate proposal 'Redirect every reporting query to the primary and raise the write compute tier only.' not to the recommendation under review. Here, Read replicas are not a second write authority.
C:That assessment refers to the separate proposal 'Assume a small Basic tier supports the same high-volume storage model.' not to the recommendation under review. Here, Read replicas are not a second write authority.
D:This concern applies to Increase the database tier indefinitely without examining query statistics. in another design data storage solutions for relational data design. The current proposal specifically fails because read replicas are not a second write authority.
Question 279
Acceptance testing must establish the following operational result: Endpoint behavior reveals the replica's intended role. Which verification action most directly establishes that outcome?
- Test read and write behavior against each endpoint in a nonproduction design.
- Review Query Store regressions and workload waits around peak periods.
- Measure replica lag and the analytic query route under load.
- Run a data-size growth forecast and compatibility proof of concept.
Explanation
Correct Answer
A:Endpoint behavior reveals the replica's intended role.
Incorrect Answers
B:This is a test for A team believes increasing vCores always eliminates poorly designed transaction queries. The requirement here is instead demonstrated by test read and write behavior against each endpoint in a nonproduction design.
C:That verification addresses the different requirement: A read-heavy analytic component should avoid stealing throughput from OLTP writes in a large Hyperscale database. It does not directly establish endpoint behavior reveals the replica's intended role.
D:That verification addresses the different requirement: A very large Azure SQL Database grows beyond conventional provisioning expectations and needs independent storage growth. It does not directly establish endpoint behavior reveals the replica's intended role.
Question 280
A development SQL database is idle overnight but has an acceptable wake-up delay. Which TWO configurations belong in an economical serverless design? (Select TWO.)
- Use a supported Azure SQL Database serverless tier for variable compute demand.
- Pay for a large provisioned instance continuously regardless of the measured workload.
- Enable and size an eligible auto-pause delay after validating plan support.
- Assert Business Critical supports the identical serverless auto-pause design by default.
- Drop database backups because serverless resumes automatically.
Explanation
Correct Answers
A:Serverless scales compute and bills according to its supported model.
C:Compute can pause during inactivity where the feature is available.
Incorrect Answers
B:Always-on capacity may negate savings for a mostly idle database.
D:Serverless and pause capabilities vary across tiers.
E:Compute elasticity does not replace recovery protection.