Microsoft AZ-305 Practice Test 27
Question 260
An architecture proposal for sql deployment-model choice relies on the following approach: Force a PaaS migration without validating extension compatibility. Which specific failure or mismatch should the design reviewer identify?
- Dedicated maximum capacity per tenant can waste substantial compute.
- PaaS does not grant arbitrary guest kernel and instance customization.
- Single databases don't provide every SQL Server instance capability required by the app.
- The VM adds patching and server operations with no stated compatibility requirement.
Explanation
Correct Answer
B:Force a PaaS migration without validating extension compatibility. PaaS does not grant arbitrary guest kernel and instance customization.
Incorrect Answers
A:This concern applies to Overprovision every single database for the sum of all hypothetical peaks. in another design data storage solutions for relational data design. The current proposal specifically fails because paaS does not grant arbitrary guest kernel and instance customization.
C:That assessment refers to the separate proposal 'Replace the workload with a basic single Azure SQL Database without assessing instance features.' not to the recommendation under review. Here, PaaS does not grant arbitrary guest kernel and instance customization.
D:That assessment refers to the separate proposal 'Provision a dedicated Windows VM simply to host a small new database.' not to the recommendation under review. Here, PaaS does not grant arbitrary guest kernel and instance customization.
Question 261
Acceptance testing must establish the following operational result: A compatibility test validates the chosen control boundary. Which verification action most directly establishes that outcome?
- Test the required extension in the proposed VM image.
- Verify automatic backups and managed service connection behavior.
- Run the SQL migration assessment for unsupported instance features.
- Monitor pool utilization and per-database resource consumption over a cycle.
Explanation
Correct Answer
A:A compatibility test validates the chosen control boundary.
Incorrect Answers
B:That verification addresses the different requirement: A new cloud-native API needs one managed relational database without server-level dependencies. It does not directly establish a compatibility test validates the chosen control boundary.
C:That verification addresses the different requirement: An existing SQL Server app relies on SQL Agent jobs and cross-database server features while owners want managed patching. It does not directly establish a compatibility test validates the chosen control boundary.
D:This is a test for A software vendor hosts 60 small customer databases with staggered peak usage. The requirement here is instead demonstrated by test the required extension in the proposed VM image.
Question 262
A high-throughput transactional database requires low storage latency and local HA replicas. Which TWO architecture evaluations directly address the requirement? (Select TWO.)
- Assume a generic virtual network NSG supplies SQL transaction replicas.
- Assess Business Critical SQL Database performance against representative transactions.
- Select General Purpose solely because it has the lowest posted compute price.
- Replace Query Store review with unlimited vCore purchases.
- Validate latency and failover under a production-like workload before choosing capacity.
Explanation
Correct Answers
B:The tier targets low-latency IO and high availability.
E:Actual measurements establish the tier can meet the application's limits.
Incorrect Answers
A:Network security filtering does not create database replicas.
C:Price alone does not prove adequate IO or local replica architecture.
D:Compute alone does not fix poor query plans.
Question 263
An architecture proposal for sql general purpose versus business critical relies on the following approach: Use a low-cost General Purpose tier and claim the same local replica architecture by default. Which specific failure or mismatch should the design reviewer identify?
- Data sensitivity by itself does not establish a low-latency compute performance need.
- General Purpose's remote storage architecture differs from Business Critical.
- Blind capacity purchases can leave blocking and query plan problems unresolved.
- Offline migrations require an interruption and final transaction cutoff.
Explanation
Correct Answer
B:Use a low-cost General Purpose tier and claim the same local replica architecture by default. General Purpose's remote storage architecture differs from Business Critical.
Incorrect Answers
A:That assessment refers to the separate proposal 'Buy a large Business Critical tier solely because the app stores financial records.' not to the recommendation under review. Here, General Purpose's remote storage architecture differs from Business Critical.
C:That assessment refers to the separate proposal 'Increase the database tier indefinitely without examining query statistics.' not to the recommendation under review. Here, General Purpose's remote storage architecture differs from Business Critical.
D:This concern applies to Promise zero downtime from a tool whose selected path is offline-only. in another design data storage solutions for relational data design. The current proposal specifically fails because general Purpose's remote storage architecture differs from Business Critical.
Question 264
Acceptance testing must establish the following operational result: Workload measurements confirm that the higher tier addresses the business requirement. Which verification action most directly establishes that outcome?
- Review Query Store regressions and workload waits around peak periods.
- Measure compute, IO and query latency during normal and peak load.
- Test representative transaction latency and local failover behavior.
- Time a nonproduction dress rehearsal and record cutover steps.
Explanation
Correct Answer
C:Workload measurements confirm that the higher tier addresses the business requirement.
Incorrect Answers
A:That verification addresses the different requirement: A team believes increasing vCores always eliminates poorly designed transaction queries. It does not directly establish workload measurements confirm that the higher tier addresses the business requirement.
B: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 workload measurements confirm that the higher tier addresses the business requirement.
D:This is a test for A mission-critical database migration seeks near-zero downtime but the target option lacks required online support. The requirement here is instead demonstrated by test representative transaction latency and local failover behavior.
Question 265
A departmental app has modest predictable throughput and no demanding low-latency SQL requirement. Which Azure architecture choice best meets this requirement?
- Increase the database tier indefinitely without examining query statistics.
- Use a low-cost General Purpose tier and claim the same local replica architecture by default.
- Buy a large Business Critical tier solely because the app stores financial records.
- Select an appropriately sized Azure SQL Database General Purpose tier.
Explanation
Correct Answer
D:General Purpose balances price and managed SQL features for typical applications.
Incorrect Answers
A:Blind capacity purchases can leave blocking and query plan problems unresolved. In the present requirement, a departmental app has modest predictable throughput and no demanding low-latency SQL requirement. The needed design instead works because general Purpose balances price and managed SQL features for typical applications.
B:General Purpose's remote storage architecture differs from Business Critical. In the present requirement, a departmental app has modest predictable throughput and no demanding low-latency SQL requirement. The needed design instead works because general Purpose balances price and managed SQL features for typical applications.
C:Data sensitivity by itself does not establish a low-latency compute performance need. This proposal contradicts the stated architecture constraint.
Question 266
An architecture proposal for sql general purpose versus business critical relies on the following approach: Buy a large Business Critical tier solely because the app stores financial records. Which specific failure or mismatch should the design reviewer identify?
- Data sensitivity by itself does not establish a low-latency compute performance need.
- Blind capacity purchases can leave blocking and query plan problems unresolved.
- Always-on provisioned compute can waste idle capacity in this scenario.
- General Purpose's remote storage architecture differs from Business Critical.
Explanation
Correct Answer
A:Buy a large Business Critical tier solely because the app stores financial records. Data sensitivity by itself does not establish a low-latency compute performance need.
Incorrect Answers
B:That assessment refers to the separate proposal 'Increase the database tier indefinitely without examining query statistics.' not to the recommendation under review. Here, Data sensitivity by itself does not establish a low-latency compute performance need.
C: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 data sensitivity by itself does not establish a low-latency compute performance need.
D:That assessment refers to the separate proposal 'Use a low-cost General Purpose tier and claim the same local replica architecture by default.' not to the recommendation under review. Here, Data sensitivity by itself does not establish a low-latency compute performance need.
Question 267
Acceptance testing must establish the following operational result: Sizing evidence supports a right-sized service tier. Which verification action most directly establishes that outcome?
- Test representative transaction latency and local failover behavior.
- Review pause/resume history and effective compute billing.
- Measure compute, IO and query latency during normal and peak load.
- Review Query Store regressions and workload waits around peak periods.
Explanation
Correct Answer
C:Sizing evidence supports a right-sized service tier.
Incorrect Answers
A: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 sizing evidence supports a right-sized service tier.
B: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 measure compute, IO and query latency during normal and peak load.
D:That verification addresses the different requirement: A team believes increasing vCores always eliminates poorly designed transaction queries. It does not directly establish sizing evidence supports a right-sized service tier.
Question 268
A team believes increasing vCores always eliminates poorly designed transaction queries. Which Azure architecture choice best meets this requirement?
- Increase the database tier indefinitely without examining query statistics.
- Use a low-cost General Purpose tier and claim the same local replica architecture by default.
- Optimize query plans and indexes before changing the SQL compute tier.
- Buy a large Business Critical tier solely because the app stores financial records.
Explanation
Correct Answer
C:Workload design bottlenecks can persist despite expensive compute scaling.
Incorrect Answers
A:Blind capacity purchases can leave blocking and query plan problems unresolved. This proposal contradicts the stated architecture constraint.
B:General Purpose's remote storage architecture differs from Business Critical. In the present requirement, a team believes increasing vCores always eliminates poorly designed transaction queries. The needed design instead works because workload design bottlenecks can persist despite expensive compute scaling.
D:Data sensitivity by itself does not establish a low-latency compute performance need. In the present requirement, a team believes increasing vCores always eliminates poorly designed transaction queries. The needed design instead works because workload design bottlenecks can persist despite expensive compute scaling.
Question 269
An architecture proposal for sql general purpose versus business critical relies on the following approach: Increase the database tier indefinitely without examining query statistics. Which specific failure or mismatch should the design reviewer identify?
- General Purpose's remote storage architecture differs from Business Critical.
- Premature deletion destroys rollback options and verification sources.
- Data sensitivity by itself does not establish a low-latency compute performance need.
- Blind capacity purchases can leave blocking and query plan problems unresolved.
Explanation
Correct Answer
D:Increase the database tier indefinitely without examining query statistics. Blind capacity purchases can leave blocking and query plan problems unresolved.
Incorrect Answers
A:That assessment refers to the separate proposal 'Use a low-cost General Purpose tier and claim the same local replica architecture by default.' not to the recommendation under review. Here, Blind capacity purchases can leave blocking and query plan problems unresolved.
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 blind capacity purchases can leave blocking and query plan problems unresolved.
C:That assessment refers to the separate proposal 'Buy a large Business Critical tier solely because the app stores financial records.' not to the recommendation under review. Here, Blind capacity purchases can leave blocking and query plan problems unresolved.
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.