cert
cert-1
cert-2

Pass Microsoft AZ-305 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
AZ-305 Exam - Verified By Experts
AZ-305 Premium Bundle
$29.98

AZ-305 Premium Bundle

$79.99
$109.97
  • Premium File 382 Questions & Answers. Last update: Nov 02, 2026
  • Training Course 87 Video Lectures
  • Study Guide 933 Pages
 
$109.97
$79.99
accept 174 downloads in last 7 days
block-screenshots
Purchase Microsoft AZ-305 Exam Training Products Individually
Microsoft AZ-305 Premium File
Premium File 382 Q&A
$76.99$69.99
Microsoft AZ-305 Video Training Course
Training Course 87 Lectures
$21.99 $19.99
Microsoft AZ-305 PDF Study Guide
Study Guide 933 Pages
$21.99 $19.99
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?

  1. Dedicated maximum capacity per tenant can waste substantial compute.
  2. PaaS does not grant arbitrary guest kernel and instance customization.
  3. Single databases don't provide every SQL Server instance capability required by the app.
  4. 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?

  1. Test the required extension in the proposed VM image.
  2. Verify automatic backups and managed service connection behavior.
  3. Run the SQL migration assessment for unsupported instance features.
  4. 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.)

  1. Assume a generic virtual network NSG supplies SQL transaction replicas.
  2. Assess Business Critical SQL Database performance against representative transactions.
  3. Select General Purpose solely because it has the lowest posted compute price.
  4. Replace Query Store review with unlimited vCore purchases.
  5. 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?

  1. Data sensitivity by itself does not establish a low-latency compute performance need.
  2. General Purpose's remote storage architecture differs from Business Critical.
  3. Blind capacity purchases can leave blocking and query plan problems unresolved.
  4. 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?

  1. Review Query Store regressions and workload waits around peak periods.
  2. Measure compute, IO and query latency during normal and peak load.
  3. Test representative transaction latency and local failover behavior.
  4. 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?

  1. Increase the database tier indefinitely without examining query statistics.
  2. Use a low-cost General Purpose tier and claim the same local replica architecture by default.
  3. Buy a large Business Critical tier solely because the app stores financial records.
  4. 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?

  1. Data sensitivity by itself does not establish a low-latency compute performance need.
  2. Blind capacity purchases can leave blocking and query plan problems unresolved.
  3. Always-on provisioned compute can waste idle capacity in this scenario.
  4. 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?

  1. Test representative transaction latency and local failover behavior.
  2. Review pause/resume history and effective compute billing.
  3. Measure compute, IO and query latency during normal and peak load.
  4. 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?

  1. Increase the database tier indefinitely without examining query statistics.
  2. Use a low-cost General Purpose tier and claim the same local replica architecture by default.
  3. Optimize query plans and indexes before changing the SQL compute tier.
  4. 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?

  1. General Purpose's remote storage architecture differs from Business Critical.
  2. Premature deletion destroys rollback options and verification sources.
  3. Data sensitivity by itself does not establish a low-latency compute performance need.
  4. 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?

  1. Measure compute, IO and query latency during normal and peak load.
  2. Compare row counts and application transaction checks before final switch.
  3. Test representative transaction latency and local failover behavior.
  4. 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.

Designing Microsoft Azure Infrastructure Solutions (AZ-305) Practice Tests