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 32

Question 310

An availability-critical PostgreSQL database needs a standby in another availability zone. Which Azure architecture choice best meets this requirement?

  1. Route all writes to a replica and treat it as multi-writer by default.
  2. Configure supported zone-redundant high availability on PostgreSQL Flexible Server.
  3. Depend solely on a single-zone VM disk snapshot for continuous HA.
  4. 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.

Question 311

An architecture proposal for azure postgresql flexible server relies on the following approach: Depend solely on a single-zone VM disk snapshot for continuous HA. Which specific failure or mismatch should the design reviewer identify?

  1. SQL Managed Instance is not a PostgreSQL database service.
  2. Backups are not a live standby for automatic service recovery.
  3. Ordinary PostgreSQL read replicas are not independent writable masters.
  4. Blind capacity purchases can leave blocking and query plan problems unresolved.

Explanation

Correct Answer

B:

Depend solely on a single-zone VM disk snapshot for continuous HA. Backups are not a live standby for automatic service recovery.

Incorrect Answers

A:

That assessment refers to the separate proposal 'Deploy SQL Server Managed Instance to run an unchanged PostgreSQL engine.' not to the recommendation under review. Here, Backups are not a live standby for automatic service recovery.

C:

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, Backups are not a live standby for automatic service recovery.

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 backups are not a live standby for automatic service recovery.

Question 312

Acceptance testing must establish the following operational result: Failover proof validates zone architecture and client handling. Which verification action most directly establishes that outcome?

  1. Simulate a controlled server failover and measure application reconnects.
  2. Validate application extensions and connectivity on the target Flexible Server.
  3. Check replica read-only behavior and replay lag during peak load.
  4. Review Query Store regressions and workload waits around peak periods.

Explanation

Correct Answer

A:

Failover proof validates zone architecture and client handling.

Incorrect Answers

B:

That verification addresses the different requirement: An open-source application needs managed PostgreSQL without an IaaS database VM. It does not directly establish failover proof validates zone architecture and client handling.

C:

That verification addresses the different requirement: A reporting service needs read-heavy PostgreSQL queries without blocking the transactional primary. It does not directly establish failover proof validates zone architecture and client handling.

D:

This is a test for A team believes increasing vCores always eliminates poorly designed transaction queries. The requirement here is instead demonstrated by simulate a controlled server failover and measure application reconnects.

Question 313

A reporting service needs read-heavy PostgreSQL queries without blocking the transactional primary. Which Azure architecture choice best meets this requirement?

  1. Route all writes to a replica and treat it as multi-writer by default.
  2. Depend solely on a single-zone VM disk snapshot for continuous HA.
  3. Deploy SQL Server Managed Instance to run an unchanged PostgreSQL engine.
  4. Use supported PostgreSQL read replicas with an explicit staleness tolerance.

Explanation

Correct Answer

D:

Read replicas offload eligible reads while receiving primary changes asynchronously.

Incorrect Answers

A:

Ordinary PostgreSQL read replicas are not independent writable masters. This proposal contradicts the stated architecture constraint.

B:

Backups are not a live standby for automatic service recovery. In the present requirement, a reporting service needs read-heavy PostgreSQL queries without blocking the transactional primary. The needed design instead works because read replicas offload eligible reads while receiving primary changes asynchronously.

C:

SQL Managed Instance is not a PostgreSQL database service. In the present requirement, a reporting service needs read-heavy PostgreSQL queries without blocking the transactional primary. The needed design instead works because read replicas offload eligible reads while receiving primary changes asynchronously.

Question 314

An architecture proposal for azure postgresql flexible server relies on the following approach: Route all writes to a replica and treat it as multi-writer by default. Which specific failure or mismatch should the design reviewer identify?

  1. SQL Managed Instance is not a PostgreSQL database service.
  2. Ordinary PostgreSQL read replicas are not independent writable masters.
  3. Backups are not a live standby for automatic service recovery.
  4. Fixed regional names can break clients after disaster recovery.

Explanation

Correct Answer

B:

Route all writes to a replica and treat it as multi-writer by default. Ordinary PostgreSQL read replicas are not independent writable masters.

Incorrect Answers

A:

That assessment refers to the separate proposal 'Deploy SQL Server Managed Instance to run an unchanged PostgreSQL engine.' not to the recommendation under review. Here, Ordinary PostgreSQL read replicas are not independent writable masters.

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, Ordinary PostgreSQL read replicas are not independent writable masters.

D:

This concern applies to Hardcode the primary database region hostname in every microservice with no failover logic. in another design data storage solutions for relational data design. The current proposal specifically fails because ordinary PostgreSQL read replicas are not independent writable masters.

Question 315

Acceptance testing must establish the following operational result: The results define operational consistency boundaries. Which verification action most directly establishes that outcome?

  1. Simulate a controlled server failover and measure application reconnects.
  2. Validate application extensions and connectivity on the target Flexible Server.
  3. Check replica read-only behavior and replay lag during peak load.
  4. Fail over a nonproduction group and test listener connectivity.

Explanation

Correct Answer

C:

The results define operational consistency boundaries.

Incorrect Answers

A:

That verification addresses the different requirement: An availability-critical PostgreSQL database needs a standby in another availability zone. It does not directly establish the results define operational consistency boundaries.

B:

That verification addresses the different requirement: An open-source application needs managed PostgreSQL without an IaaS database VM. It does not directly establish the results define operational consistency boundaries.

D:

This is a test for A globally deployed application needs cross-region SQL failover with a stable application endpoint. The requirement here is instead demonstrated by check replica read-only behavior and replay lag during peak load.

Question 316

A company is retiring physical SQL Server hosts and must preserve SQL Agent and instance-level semantics. Which Azure architecture choice best meets this requirement?

  1. Delete the source database before measuring migration completeness.
  2. Run a compatibility assessment before selecting Azure SQL Managed Instance or SQL on Azure VM.
  3. Assume a new cloud SQL Database automatically supports every local server feature.
  4. Promise zero downtime from a tool whose selected path is offline-only.

Explanation

Correct Answer

B:

Feature assessment determines which managed model can meet workload dependencies.

Incorrect Answers

A:

Premature deletion destroys rollback options and verification sources. In the present requirement, a company is retiring physical SQL Server hosts and must preserve SQL Agent and instance-level semantics. The needed design instead works because feature assessment determines which managed model can meet workload dependencies.

C:

Unsupported instance features can block lift-and-shift. This proposal contradicts the stated architecture constraint.

D:

Offline migrations require an interruption and final transaction cutoff. In the present requirement, a company is retiring physical SQL Server hosts and must preserve SQL Agent and instance-level semantics. The needed design instead works because feature assessment determines which managed model can meet workload dependencies.

Question 317

An architecture proposal for sql migration compatibility decisions relies on the following approach: Assume a new cloud SQL Database automatically supports every local server feature. Which specific failure or mismatch should the design reviewer identify?

  1. Offline migrations require an interruption and final transaction cutoff.
  2. Unsupported instance features can block lift-and-shift.
  3. Premature deletion destroys rollback options and verification sources.
  4. PaaS does not grant arbitrary guest kernel and instance customization.

Explanation

Correct Answer

B:

Assume a new cloud SQL Database automatically supports every local server feature. Unsupported instance features can block lift-and-shift.

Incorrect Answers

A:

That assessment refers to the separate proposal 'Promise zero downtime from a tool whose selected path is offline-only.' not to the recommendation under review. Here, Unsupported instance features can block lift-and-shift.

C:

That assessment refers to the separate proposal 'Delete the source database before measuring migration completeness.' not to the recommendation under review. Here, Unsupported instance features can block lift-and-shift.

D:

This concern applies to Force a PaaS migration without validating extension compatibility. in another design data storage solutions for relational data design. The current proposal specifically fails because unsupported instance features can block lift-and-shift.

Question 318

Acceptance testing must establish the following operational result: Feature evidence prevents unsupported target selection. Which verification action most directly establishes that outcome?

  1. Compare row counts and application transaction checks before final switch.
  2. Test the required extension in the proposed VM image.
  3. Inventory Agent jobs, linked servers and engine features in the assessment output.
  4. Time a nonproduction dress rehearsal and record cutover steps.

Explanation

Correct Answer

C:

Feature evidence prevents unsupported target selection.

Incorrect Answers

A:

That verification addresses the different requirement: A legacy OLTP app can tolerate a brief cutover but requires schema and data fidelity. It does not directly establish feature evidence prevents unsupported target selection.

B:

This is a test for A legacy app uses kernel-level SQL extensions and unsupported OS customizations. The requirement here is instead demonstrated by inventory Agent jobs, linked servers and engine features in the assessment output.

D:

That verification addresses the different requirement: A mission-critical database migration seeks near-zero downtime but the target option lacks required online support. It does not directly establish feature evidence prevents unsupported target selection.

Question 319

A legacy OLTP app can tolerate a brief cutover but requires schema and data fidelity. Which Azure architecture choice best meets this requirement?

  1. Assume a new cloud SQL Database automatically supports every local server feature.
  2. Plan an assessed SQL migration with rehearsed cutover and validation.
  3. Delete the source database before measuring migration completeness.
  4. Promise zero downtime from a tool whose selected path is offline-only.

Explanation

Correct Answer

B:

Migration sequencing requires data consistency and client endpoint transition.

Incorrect Answers

A:

Unsupported instance features can block lift-and-shift. In the present requirement, a legacy OLTP app can tolerate a brief cutover but requires schema and data fidelity. The needed design instead works because migration sequencing requires data consistency and client endpoint transition.

C:

Premature deletion destroys rollback options and verification sources. This proposal contradicts the stated architecture constraint.

D:

Offline migrations require an interruption and final transaction cutoff. In the present requirement, a legacy OLTP app can tolerate a brief cutover but requires schema and data fidelity. The needed design instead works because migration sequencing requires data consistency and client endpoint transition.

Question 320

An architecture proposal for sql migration compatibility decisions relies on the following approach: Delete the source database before measuring migration completeness. Which specific failure or mismatch should the design reviewer identify?

  1. Unsupported instance features can block lift-and-shift.
  2. Offline migrations require an interruption and final transaction cutoff.
  3. Premature deletion destroys rollback options and verification sources.
  4. Dedicated maximum capacity per tenant can waste substantial compute.

Explanation

Correct Answer

C:

Delete the source database before measuring migration completeness. Premature deletion destroys rollback options and verification sources.

Incorrect Answers

A:

That assessment refers to the separate proposal 'Assume a new cloud SQL Database automatically supports every local server feature.' not to the recommendation under review. Here, Premature deletion destroys rollback options and verification sources.

B:

That assessment refers to the separate proposal 'Promise zero downtime from a tool whose selected path is offline-only.' not to the recommendation under review. Here, Premature deletion destroys rollback options and verification sources.

D:

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 premature deletion destroys rollback options and verification sources.

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