Pass Microsoft AZ-305 Exam in First Attempt Easily
Real Microsoft AZ-305 Exam Questions, Accurate & Verified Answers As Experienced in the Actual Test!

Verified by experts
3 products

You save $69.98

AZ-305 Premium Bundle

  • Premium File 382 Questions & Answers
  • Last Update: Nov 20, 2026
  • Training Course 87 Lectures
  • Study Guide 933 Pages
$79.99 $149.97

Purchase Individually

  • Premium File

    382 Questions & Answers
    Last Update: Nov 20, 2026

    $76.99
    $69.99
  • Training Course

    87 Lectures

    $43.99
    $39.99
  • Study Guide

    933 Pages

    $43.99
    $39.99

Designing Microsoft Azure Infrastructure Solutions AZ-305 Practice Test 15

Question 140

To validate the SQL ledger immutability deployment, reviewers revisit this operational need: Auditors require cryptographic evidence that transaction history was not tampered with after posting. What result confirms it was met?

  1. Connection counts stabilize while expected API throughput is maintained
  2. The vendor driver runs on the VM while maintenance responsibilities are explicitly assigned
  3. A tenant restore does not overwrite another tenant's data
  4. Verification detects an altered historical ledger record during an audit

Explanation

Correct Answer

D:

Ledger records cryptographically verifiable tamper-evidence for supported relational tables. Confirm using the measurable result: Verification detects an altered historical ledger record during an audit.

Incorrect Answers

A:

Pooling reuses connections and reduces setup overhead relative to per-request creation. Those observations validate SQL connection pooling. They do not establish the required SQL ledger immutability result: Verification detects an altered historical ledger record during an audit.

B:

IaaS retains operating-system and SQL instance control that PaaS databases do not provide. The distinguishing check is: Verification detects an altered historical ledger record during an audit.

C:

Database-per-tenant provides a distinct security and backup boundary versus one shared schema. The SQL schema isolation test checks a tenant restore does not overwrite another tenant's data; the relevant outcome is Verification detects an altered historical ledger record during an audit.

Question 141

Architecture review: Vault RBAC least privilege and Key Vault cryptographic signing. Requirement A: A team member needs read-only access to selected vault secrets but should not grant access policies. Requirement B: An application must sign payloads with a centrally controlled key without exporting its private material. Which complete two-part proposal satisfies both constraints?

  1. (A) design supported AD DS-based Azure Files authentication and share/file permission mapping; (B) use Azure Key Vault key operations with a suitable key type and access permissions
  2. (A) assign a suitable Key Vault data-plane RBAC role at a supported minimal scope; (B) enable a managed identity and grant it Storage Blob Data Reader at the smallest needed scope
  3. (A) design supported AD DS-based Azure Files authentication and share/file permission mapping; (B) enable a managed identity and grant it Storage Blob Data Reader at the smallest needed scope
  4. (A) assign a suitable Key Vault data-plane RBAC role at a supported minimal scope; (B) use Azure Key Vault key operations with a suitable key type and access permissions

Explanation

Correct Answer

D:

For requirement A, Key Vault RBAC data permissions differ from vault resource-management permissions. For requirement B, Key Vault keys can perform cryptographic operations while restricting private key exposure. Verify both independently: The user retrieves authorized secret values but cannot alter vault access configuration; The application receives a valid signature but cannot export the private key material.

Incorrect Answers

A:

One action is correct. The other targets Azure Files identity access, leaving Vault RBAC least privilege unsolved. Its necessary action is: Assign a suitable Key Vault data-plane RBAC role at a supported minimal scope.

B:

The mismatched half is Managed identity for App Service; Key Vault cryptographic signing instead needs: Use Azure Key Vault key operations with a suitable key type and access permissions.

C:

This combines Azure Files identity access and Managed identity for App Service, which do not satisfy the distinct requirements for Vault RBAC least privilege and Key Vault cryptographic signing.

Question 142

Architecture review: SQL offline migration and Database schema assessment. Requirement A: A small SQL database can tolerate a planned maintenance outage for cutover. Requirement B: An on-prem SQL app calls deprecated features that Azure SQL Database may not support. Which complete two-part proposal satisfies both constraints?

  1. (A) use an appropriate offline Azure Database Migration Service path after compatibility review; (B) perform schema and compatibility assessment before choosing Azure SQL Database or Managed Instance
  2. (A) check BGP advertised routes, gateway transit, NSGs and UDRs for the hybrid path; (B) create an Azure landing zone before migration waves using CAF guidance
  3. (A) use an appropriate offline Azure Database Migration Service path after compatibility review; (B) create an Azure landing zone before migration waves using CAF guidance
  4. (A) check BGP advertised routes, gateway transit, NSGs and UDRs for the hybrid path; (B) perform schema and compatibility assessment before choosing Azure SQL Database or Managed Instance

Explanation

Correct Answer

A:

For requirement A, offline migration can simplify cutover when application downtime is acceptable. For requirement B, target compatibility determines whether code changes or a different managed target are required. Verify both independently: The migrated database passes consistency checks before reopening writes; The assessment reports blocking SQL features and chosen remediation before migration.

Incorrect Answers

B:

This combines Hybrid route validation and Migration landing zone, which do not satisfy the distinct requirements for SQL offline migration and Database schema assessment.

C:

The option covers one requirement but substitutes Migration landing zone for Database schema assessment. The missing acceptance result is: The assessment reports blocking SQL features and chosen remediation before migration.

D:

One action is correct. The other targets Hybrid route validation, leaving SQL offline migration unsolved. Its necessary action is: Use an appropriate offline Azure Database Migration Service path after compatibility review.

Question 143

A proposed solution for Resource type restriction is: Assign a policy that disallows specified resource types or properties at the unit scope. Select the strongest statement supporting the recommendation.

  1. Policy evaluates resource deployment properties and rejects noncompliant regions
  2. Defender for Cloud aggregates recommendations and compliance state for supported frameworks
  3. Azure Policy can deny targeted resource types without revoking all contributor operations
  4. Resource groups provide a deployment and management boundary and facilitate cohesive cleanup

Explanation

Correct Answer

C:

Azure Policy can deny targeted resource types without revoking all contributor operations. It is material here because a business unit must prevent unapproved public IP resources but permit private network components.

Incorrect Answers

A:

Policy evaluates resource deployment properties and rejects noncompliant regions. Azure Policy can deny targeted resource types without revoking all contributor operations.

B:

Defender for Cloud aggregates recommendations and compliance state for supported frameworks. Azure Policy can deny targeted resource types without revoking all contributor operations.

D:

Resource groups provide a deployment and management boundary and facilitate cohesive cleanup. That statement describes Resource group lifecycle, while the question asks how Resource type restriction works: Azure Policy can deny targeted resource types without revoking all contributor operations.

Question 144

A solution must address both Resource locks and Resource type restriction. First requirement: A business-critical vault should not be deleted during routine administration by contributors. Second requirement: A business unit must prevent unapproved public IP resources but permit private network components. Select TWO recommendations that meet these independent needs.

  1. Remove broad role inheritance and grant least-scope RBAC at the resource-group boundary
  2. Apply a CanNotDelete resource lock where operational impacts are understood
  3. Check subscription and regional service quotas before architecture signoff and request increases
  4. Assign a policy that disallows specified resource types or properties at the unit scope
  5. Create a least-privilege custom Azure RBAC role and assign it at minimal scope

Explanation

Correct Answers

B:

For the Resource locks half of this two-part design, locks prevent specified management operations even for users with broad Azure RBAC roles. Verify: A test deletion is denied while approved read and update actions remain available. The other half concerns Resource type restriction.

D:

For the Resource type restriction half of this design, Azure Policy can deny targeted resource types without revoking all contributor operations. Check: A public IP create is denied while a private subnet deployment proceeds. The other half concerns Resource locks.

Incorrect Answers

A:

RBAC assignments inherit downward so narrower scope reduces unintended changes. The corresponding task is Role assignment scope: An engineer only operates one network resource group but has Contributor for the whole subscription. It is not one of the two requested controls (Resource locks and Resource type restriction).

C:

Azure service quotas are often scoped by subscription and region and can constrain deployability. Its own validation would be: A capacity forecast and quota decision support the planned deployment without surprise allocation errors. The current paired requirement is Resource locks and Resource type restriction.

E:

Custom role actions can grant specific management operations without broad Contributor rights. The corresponding task is RBAC custom role: A service team needs a narrow set of resource restart and read operations absent from built-in roles. It is not one of the two requested controls (Resource locks and Resource type restriction).

Question 145

Before approving PostgreSQL read replica, the reviewer assesses this requirement: An application uses PostgreSQL for writes but analysts overload the writer with complex read-only reports. Which of the reported outcomes is decisive?

  1. Execution plans prune irrelevant historical partitions for the test query
  2. The reports run on a replica while primary transaction performance improves
  3. Verification detects an altered historical ledger record during an audit
  4. The required extension is available and the app connects without an OS-managed database host

Explanation

Correct Answer

B:

Read replicas offload eligible read-only queries but are asynchronously updated from the writer. Confirm using the measurable result: The reports run on a replica while primary transaction performance improves.

Incorrect Answers

A:

Partition elimination and aligned indexes can reduce scans when predicates match partition keys. The distinguishing check is: The reports run on a replica while primary transaction performance improves.

C:

Ledger records cryptographically verifiable tamper-evidence for supported relational tables. The offered observation would demonstrate SQL ledger immutability: Verification detects an altered historical ledger record during an audit. The current validation is different: The reports run on a replica while primary transaction performance improves.

D:

Flexible Server offers managed open-source PostgreSQL with supported extensions and deployment options. Those observations validate PostgreSQL flexible server. They do not establish the required PostgreSQL read replica result: The reports run on a replica while primary transaction performance improves.

Question 146

Architecture review: Networking cutover DNS and Parallel-run cutover. Requirement A: A migrated app uses a new Azure IP but clients have a hardcoded old DNS endpoint. Requirement B: A financial application requires consistent outputs during migration before stopping the old deployment. Which complete two-part proposal satisfies both constraints?

  1. (A) plan DNS TTL reduction, cutover updates and rollback before service migration; (B) run old and new environments in a controlled parallel validation phase with consistency checks
  2. (A) validate dependencies then retire confirmed redundant workloads from the migration plan; (B) run old and new environments in a controlled parallel validation phase with consistency checks
  3. (A) plan DNS TTL reduction, cutover updates and rollback before service migration; (B) use a supported online migration approach with initial load and continuous changes
  4. (A) validate dependencies then retire confirmed redundant workloads from the migration plan; (B) use a supported online migration approach with initial load and continuous changes

Explanation

Correct Answer

A:

For requirement A, DNS cutover requires propagation and dependency planning independent of VM replication. For requirement B, parallel operation compares business outputs before committing the cutover. Verify both independently: Clients resolve the new endpoint and the rollback procedure returns traffic if needed; The reconciled reports match while controlled rollback remains available.

Incorrect Answers

B:

The first step implements Retire unused services instead of Networking cutover DNS. The necessary change is to plan DNS TTL reduction, cutover updates and rollback before service migration.

C:

The option covers one requirement but substitutes SQL online migration for Parallel-run cutover. The missing acceptance result is: The reconciled reports match while controlled rollback remains available.

D:

DNS cutover requires propagation and dependency planning independent of VM replication. Parallel operation compares business outputs before committing the cutover. The proposed steps (validate dependencies then retire confirmed redundant workloads from the migration plan; use a supported online migration approach with initial load and continuous changes) address other capabilities instead of this required pair.

Question 147

Architecture review: Azure Batch scheduling and Azure Functions durable workflow. Requirement A: Research jobs run thousands of independent parameter simulations and require queued pool-based compute. Requirement B: A workflow waits hours between steps while retaining orchestration state through restarts. Which complete two-part proposal satisfies both constraints?

  1. (A) use Azure Batch pools, tasks and job orchestration; (B) use Durable Functions orchestration with proper idempotent activity design
  2. (A) evaluate Azure Dedicated Host with the needed VM families and capacity; (B) use Durable Functions orchestration with proper idempotent activity design
  3. (A) evaluate Azure Dedicated Host with the needed VM families and capacity; (B) select Azure Kubernetes Service with appropriate cluster management guardrails
  4. (A) use Azure Batch pools, tasks and job orchestration; (B) select Azure Kubernetes Service with appropriate cluster management guardrails

Explanation

Correct Answer

A:

For requirement A, Azure Batch schedules large-scale parallel workloads across managed compute pools. For requirement B, durable Functions manages stateful workflows over serverless function executions. Verify both independently: The submitted job fans out tasks and combines outputs after all simulations complete; A resumed orchestration continues from saved state after a worker restart.

Incorrect Answers

B:

The option covers one requirement but substitutes Dedicated host for Azure Batch scheduling. The missing acceptance result is: The submitted job fans out tasks and combines outputs after all simulations complete.

C:

Azure Batch schedules large-scale parallel workloads across managed compute pools. Durable Functions manages stateful workflows over serverless function executions. The proposed steps (evaluate Azure Dedicated Host with the needed VM families and capacity; select Azure Kubernetes Service with appropriate cluster management guardrails) address other capabilities instead of this required pair.

D:

The mismatched half is AKS full Kubernetes; Azure Functions durable workflow instead needs: Use Durable Functions orchestration with proper idempotent activity design.

Question 148

The team has justified its SQL compute scaling design with: Plan supported vertical compute scaling and evaluate tier limits and transition impacts. Which statement accurately describes why the approach works?

  1. Read-only replicas can offload reporting from the primary where the tier provides the capability
  2. Hyperscale decouples storage scale from compute and supports large database sizes
  3. Partition elimination and aligned indexes can reduce scans when predicates match partition keys
  4. Managed SQL compute tiers can scale resources but scaling may have operational consequences

Explanation

Correct Answer

D:

Managed SQL compute tiers can scale resources but scaling may have operational consequences. It is material here because a database must grow compute during a seasonal sales period but not during idle months.

Incorrect Answers

A:

Read-only replicas can offload reporting from the primary where the tier provides the capability. Managed SQL compute tiers can scale resources but scaling may have operational consequences.

B:

Hyperscale decouples storage scale from compute and supports large database sizes. It belongs to SQL Hyperscale growth. The stated architecture instead relies on: Managed SQL compute tiers can scale resources but scaling may have operational consequences.

C:

Partition elimination and aligned indexes can reduce scans when predicates match partition keys. That statement describes SQL database partitioning, while the question asks how SQL compute scaling works: Managed SQL compute tiers can scale resources but scaling may have operational consequences.

Question 149

For the Retire unused services requirement, the proposed architecture uses: Validate dependencies then retire confirmed redundant workloads from the migration plan. Why does that design fit?

  1. Physical data transfer can shorten initial bulk migration when network transfer is impractical
  2. Retiring unused assets reduces migration risk and cloud cost rather than copying unnecessary VMs
  3. Refactoring changes application structure and decouples independent workloads
  4. PostgreSQL migration requires extension, version and connectivity compatibility checks

Explanation

Correct Answer

B:

Retiring unused assets reduces migration risk and cloud cost rather than copying unnecessary VMs. It is material here because an application inventory shows unused servers with no business owner or dependent traffic.

Incorrect Answers

A:

Physical data transfer can shorten initial bulk migration when network transfer is impractical. It belongs to Storage bulk offline transfer. The stated architecture instead relies on: Retiring unused assets reduces migration risk and cloud cost rather than copying unnecessary VMs.

C:

Refactoring changes application structure and decouples independent workloads. Retiring unused assets reduces migration risk and cloud cost rather than copying unnecessary VMs.

D:

PostgreSQL migration requires extension, version and connectivity compatibility checks. Retiring unused assets reduces migration risk and cloud cost rather than copying unnecessary VMs.

Question 150

For the Blob user-delegation SAS requirement, the proposed architecture uses: Issue a scoped user-delegation SAS with the minimum permissions and expiry. Why does that design fit?

  1. Service endpoints secure selected Azure service traffic from VNets but do not create a private IP for the PaaS service
  2. Premium SSD v2 decouples some provisioned performance settings from disk capacity
  3. A user-delegation SAS is authorized through Entra credentials and avoids distributing account keys
  4. Blob Inventory produces scheduled object inventories without crawling each object individually

Explanation

Correct Answer

C:

A user-delegation SAS is authorized through Entra credentials and avoids distributing account keys. It is material here because a partner needs time-limited upload permission to a particular blob without sharing the storage account key.

Incorrect Answers

A:

Service endpoints secure selected Azure service traffic from VNets but do not create a private IP for the PaaS service. That statement describes Storage service endpoints, while the question asks how Blob user-delegation SAS works: A user-delegation SAS is authorized through Entra credentials and avoids distributing account keys.

B:

Premium SSD v2 decouples some provisioned performance settings from disk capacity. A user-delegation SAS is authorized through Entra credentials and avoids distributing account keys.

D:

Blob Inventory produces scheduled object inventories without crawling each object individually. It belongs to Blob inventory. The stated architecture instead relies on: A user-delegation SAS is authorized through Entra credentials and avoids distributing account keys.

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

Purchase Individually

  • Premium File

    382 Questions & Answers
    Last Update: Nov 20, 2026

    $76.99
    $69.99
  • Training Course

    87 Lectures

    $43.99
    $39.99
  • Study Guide

    933 Pages

    $43.99
    $39.99

SPECIAL OFFER: GET 10% OFF
This is ONE TIME OFFER

You save
10%

Enter Your Email Address to Receive Your 10% Off Discount Code

SPECIAL OFFER: GET 10% OFF

You save
10%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@examlabs.com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your email address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports