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 24

Question 230

Architecture review: SQL connection pooling and SQL serverless idle cost. Requirement A: A serverless API makes many short SQL connections and exhausts available database sessions. Requirement B: A dev/test SQL database is idle for long periods but bursts during a short daily test window. Which complete two-part proposal satisfies both constraints?

  1. (A) select Azure SQL Database for the managed individual database; (B) run Azure SQL migration assessment and remediate feature compatibility findings
  2. (A) use appropriate application-side connection pooling with database tier capacity planning; (B) run Azure SQL migration assessment and remediate feature compatibility findings
  3. (A) select Azure SQL Database for the managed individual database; (B) consider Azure SQL Database serverless compute with auto-pause eligibility checks
  4. (A) use appropriate application-side connection pooling with database tier capacity planning; (B) consider Azure SQL Database serverless compute with auto-pause eligibility checks

Explanation

Correct Answer

D:

For requirement A, pooling reuses connections and reduces setup overhead relative to per-request creation. For requirement B, serverless compute can scale usage and pause eligible databases to reduce idle cost. Verify both independently: Connection counts stabilize while expected API throughput is maintained; Compute charges drop during idle periods and the test workload resumes within tolerated delay.

Incorrect Answers

A:

Pooling reuses connections and reduces setup overhead relative to per-request creation. Serverless compute can scale usage and pause eligible databases to reduce idle cost. The proposed steps (select Azure SQL Database for the managed individual database; run Azure SQL migration assessment and remediate feature compatibility findings) address other capabilities instead of this required pair.

B:

Pooling reuses connections and reduces setup overhead relative to per-request creation. The other proposed action (run Azure SQL migration assessment and remediate feature compatibility findings) addresses a different operation. Serverless compute can scale usage and pause eligible databases to reduce idle cost.

C:

The option covers one requirement but substitutes Azure SQL Database single database for SQL connection pooling. The missing acceptance result is: Connection counts stabilize while expected API throughput is maintained.

Question 231

A rollout addressing Deployment drift has reached acceptance testing. The original problem was: A production app's manually changed resource settings diverge from the approved IaC template. Which finding verifies its resolution?

  1. A public IP create is denied while a private subnet deployment proceeds
  2. Compliance reporting shows the member controls under the assigned initiative
  3. A test deletion is denied while approved read and update actions remain available
  4. The change report identifies manual drift and approved deployment restores the intended state

Explanation

Correct Answer

D:

Azure deployment what-if previews resource changes before applying a template. Confirm using the measurable result: The change report identifies manual drift and approved deployment restores the intended state.

Incorrect Answers

A:

Azure Policy can deny targeted resource types without revoking all contributor operations. The offered observation would demonstrate Resource type restriction: A public IP create is denied while a private subnet deployment proceeds. The current validation is different: The change report identifies manual drift and approved deployment restores the intended state.

B:

Initiatives bundle related policy rules and support shared compliance reporting. Those observations validate Policy initiative. They do not establish the required Deployment drift result: The change report identifies manual drift and approved deployment restores the intended state.

C:

Locks prevent specified management operations even for users with broad Azure RBAC roles. The distinguishing check is: The change report identifies manual drift and approved deployment restores the intended state.

Question 232

A fleet needs consistent hardened VM images recreated every week from an approved source. An engineer must deliver the following acceptance evidence: New VMs deploy from the approved version and report the expected security baseline. What design choice is defensible?

  1. Use Virtual Machine Scale Sets with metric-based autoscale and stateless instances
  2. Publish governed VM images through Azure Compute Gallery with a versioning strategy
  3. Use Azure Functions with an event trigger and compatible hosting plan
  4. Use Durable Functions orchestration with proper idempotent activity design

Explanation

Correct Answer

B:

Compute Gallery distributes managed image versions for repeatable VM deployments. The selected architecture is publish governed VM images through Azure Compute Gallery with a versioning strategy; confirm the result by checking that new VMs deploy from the approved version and report the expected security baseline.

Incorrect Answers

A:

VMSS automates management and scaling of similar VMs in the same workload. The current need is: A fleet needs consistent hardened VM images recreated every week from an approved source.

C:

Functions supplies event-driven serverless execution with plan-specific scale and timeout limits. It does not solve the specified Azure VM image standard condition.

D:

Durable Functions manages stateful workflows over serverless function executions. The relevant requirement is: A fleet needs consistent hardened VM images recreated every week from an approved source.

Question 233

A Spark job has storage RBAC access at container level but must isolate sensitive folders. Identify the most suitable implementation for an outcome where a test identity reads its assigned folder but is denied a sibling folder.

  1. Issue a scoped user-delegation SAS with the minimum permissions and expiry
  2. Choose Azure Cosmos DB for NoSQL with suitable partition and consistency design
  3. Evaluate Azure NetApp Files capacity pools and volume service levels
  4. Configure suitable POSIX-style data lake ACLs and scope broader RBAC intentionally

Explanation

Correct Answer

D:

Directory ACLs provide path-level data authorization when hierarchical namespace is enabled. The selected architecture is configure suitable POSIX-style data lake ACLs and scope broader RBAC intentionally; confirm the result by checking that a test identity reads its assigned folder but is denied a sibling folder.

Incorrect Answers

A:

A user-delegation SAS is authorized through Entra credentials and avoids distributing account keys. That is useful for Blob user-delegation SAS (A partner needs time-limited upload permission to a particular blob without sharing the storage account key). It does not meet the current ADLS ACLs requirement: A Spark job has storage RBAC access at container level but must isolate sensitive folders.

B:

Cosmos DB provides a distributed document database with configurable consistency and throughput. Its design target is Cosmos DB NoSQL. The stated requirement instead concerns: A Spark job has storage RBAC access at container level but must isolate sensitive folders.

C:

NetApp Files offers enterprise file protocols and performance controls for supported workloads. It does not solve the specified ADLS ACLs condition.

Question 234

Build pipelines need a private managed Docker image repository with vulnerability scanning and managed identity access. Identify the most suitable implementation for an outcome where a pipeline pushes a signed image and production pulls it without shared registry passwords.

  1. Use an Azure GPU-capable VM family compatible with the model runtime
  2. Use Azure Container Registry with controlled image push and pull access
  3. Distribute redundant VMs across appropriate zones or fault domains and use health-probed load balancing
  4. Use Durable Functions orchestration with proper idempotent activity design

Explanation

Correct Answer

B:

ACR stores OCI images and supports Azure identity-based authorization to the registry. The selected architecture is use Azure Container Registry with controlled image push and pull access; confirm the result by checking that a pipeline pushes a signed image and production pulls it without shared registry passwords.

Incorrect Answers

A:

GPU instances provide accelerators not present on standard CPU-only VMs. Its design target is GPU VM. The stated requirement instead concerns: Build pipelines need a private managed Docker image repository with vulnerability scanning and managed identity access.

C:

Redundancy prevents a single host maintenance event from removing the only serving instance. The current need is: Build pipelines need a private managed Docker image repository with vulnerability scanning and managed identity access.

D:

Durable Functions manages stateful workflows over serverless function executions. It does not solve the specified Container Registry condition.

Question 235

Architecture review: Vault network boundary and Key Vault cryptographic signing. Requirement A: A vault must be reachable only from approved private Azure networks and not from arbitrary internet clients. 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) assign a user-assigned managed identity to both apps and scope its data permissions; (B) use Azure Key Vault key operations with a suitable key type and access permissions
  2. (A) assign a user-assigned managed identity to both apps and scope its data permissions; (B) define exposed API permissions in the app registration and require consent as appropriate
  3. (A) use a Key Vault private endpoint and correctly configured private DNS and firewall policy; (B) define exposed API permissions in the app registration and require consent as appropriate
  4. (A) use a Key Vault private endpoint and correctly configured private DNS and firewall policy; (B) use Azure Key Vault key operations with a suitable key type and access permissions

Explanation

Correct Answer

D:

For requirement A, private Link gives a private address path to supported vault endpoints when DNS resolves accordingly. For requirement B, Key Vault keys can perform cryptographic operations while restricting private key exposure. Verify both independently: A workload resolves the private vault endpoint and a public-network test cannot use the forbidden path; The application receives a valid signature but cannot export the private key material.

Incorrect Answers

A:

The first step implements Shared workload identity instead of Vault network boundary. The necessary change is to use a Key Vault private endpoint and correctly configured private DNS and firewall policy.

B:

Both proposed halves address other use cases: Shared workload identity and App registration API scopes. The requested pair is Vault network boundary and Key Vault cryptographic signing.

C:

One action is correct. The other targets App registration API scopes, leaving Key Vault cryptographic signing unsolved. Its necessary action is: Use Azure Key Vault key operations with a suitable key type and access permissions.

Question 236

Node pool capacity becomes insufficient for pending pods during daily traffic peaks. An engineer must deliver the following acceptance evidence: Pending pods move to new nodes before the measured capacity deadline. What design choice is defensible?

  1. Implement connection draining, termination grace periods and readiness controls as supported
  2. Enable zone-redundant HA on eligible Azure PostgreSQL Flexible Server
  3. Deploy redundant VMs across availability zones behind an appropriate load balancer
  4. Enable AKS cluster autoscaler within approved node pool bounds

Explanation

Correct Answer

D:

Cluster autoscaler adjusts nodes to schedule eligible pending pods. The selected architecture is enable AKS cluster autoscaler within approved node pool bounds; confirm the result by checking that pending pods move to new nodes before the measured capacity deadline.

Incorrect Answers

A:

Graceful scale-in lets existing requests finish while the removed instance stops taking new traffic. The current need is: Node pool capacity becomes insufficient for pending pods during daily traffic peaks.

B:

A zone-separated standby supports automated failover where offered. It does not solve the specified AKS cluster autoscaler condition.

C:

Availability zones isolate infrastructure failure domains within an enabled region. Its design target is Availability zones for VM tier. The stated requirement instead concerns: Node pool capacity becomes insufficient for pending pods during daily traffic peaks.

Question 237

The target environment adopts this approach for ADF pipeline dependency: Chain ADF pipeline activities with success/failure dependencies. What property makes it suitable?

  1. Data Explorer is designed for large-scale append-oriented telemetry exploration with KQL
  2. Service Bus is an enterprise message broker with delivery and dead-letter semantics
  3. Pipeline control flow can orchestrate dependent stages instead of independent schedules
  4. Self-hosted integration runtime initiates supported outbound communications to access private sources

Explanation

Correct Answer

C:

Pipeline control flow can orchestrate dependent stages instead of independent schedules. It is material here because three data tasks must run in sequence and stop downstream operations after upstream failure.

Incorrect Answers

A:

Data Explorer is designed for large-scale append-oriented telemetry exploration with KQL. It belongs to Azure Data Explorer telemetry. The stated architecture instead relies on: Pipeline control flow can orchestrate dependent stages instead of independent schedules.

B:

Service Bus is an enterprise message broker with delivery and dead-letter semantics. That statement describes Service Bus ordering, while the question asks how ADF pipeline dependency works: Pipeline control flow can orchestrate dependent stages instead of independent schedules.

D:

Self-hosted integration runtime initiates supported outbound communications to access private sources. Pipeline control flow can orchestrate dependent stages instead of independent schedules.

Question 238

Architecture review: Synapse dedicated SQL and Synapse serverless SQL. Requirement A: A large enterprise data warehouse requires predictable reserved compute for repeatable analytic SQL workloads. Requirement B: Data analysts must run ad hoc SQL queries over Parquet files in a data lake without provisioning a cluster. Which complete two-part proposal satisfies both constraints?

  1. (A) use Data Factory tumbling-window triggers with dependency and retry design; (B) use supported serverless SQL capabilities over files in Azure Synapse Analytics
  2. (A) evaluate a dedicated SQL pool with appropriate distributions and workload management; (B) use supported serverless SQL capabilities over files in Azure Synapse Analytics
  3. (A) evaluate a dedicated SQL pool with appropriate distributions and workload management; (B) implement watermark-based incremental ingestion with persisted checkpoints
  4. (A) use Data Factory tumbling-window triggers with dependency and retry design; (B) implement watermark-based incremental ingestion with persisted checkpoints

Explanation

Correct Answer

B:

For requirement A, dedicated pools supply reserved MPP compute suited for managed warehouse workloads. For requirement B, serverless SQL queries external lake files with consumption-based query compute. Verify both independently: The fact-table join finishes within measured performance goals under the planned workload; A SELECT reads the Parquet dataset with no dedicated SQL pool running.

Incorrect Answers

A:

Serverless SQL queries external lake files with consumption-based query compute. The other proposed action (use Data Factory tumbling-window triggers with dependency and retry design) does not implement the first control. Dedicated pools supply reserved MPP compute suited for managed warehouse workloads.

C:

The option covers one requirement but substitutes ADF incremental copy for Synapse serverless SQL. The missing acceptance result is: A SELECT reads the Parquet dataset with no dedicated SQL pool running.

D:

Dedicated pools supply reserved MPP compute suited for managed warehouse workloads. Serverless SQL queries external lake files with consumption-based query compute. The proposed steps (use Data Factory tumbling-window triggers with dependency and retry design; implement watermark-based incremental ingestion with persisted checkpoints) address other capabilities instead of this required pair.

Question 239

The acceptance criterion for Modernization cost assessment comes from this issue: A migration project chooses premium PaaS services without considering steady-state usage and license rights. Which measured outcome is the strongest proof?

  1. Clients resolve the new endpoint and the rollback procedure returns traffic if needed
  2. The approved target design includes measured compute, storage, network and license costs
  3. The assessment reports blocking SQL features and chosen remediation before migration
  4. Frequently used files remain locally available and cold files tier to cloud

Explanation

Correct Answer

B:

Sizing, licensing and consumption assumptions materially affect target economics. Confirm using the measurable result: The approved target design includes measured compute, storage, network and license costs.

Incorrect Answers

A:

DNS cutover requires propagation and dependency planning independent of VM replication. The offered observation would demonstrate Networking cutover DNS: Clients resolve the new endpoint and the rollback procedure returns traffic if needed. The current validation is different: The approved target design includes measured compute, storage, network and license costs.

C:

Target compatibility determines whether code changes or a different managed target are required. The distinguishing check is: The approved target design includes measured compute, storage, network and license costs.

D:

File Sync preserves local namespace access while synchronizing with Azure file shares. The Azure File Sync test checks frequently used files remain locally available and cold files tier to cloud; the relevant outcome is The approved target design includes measured compute, storage, network and license costs.

Question 240

For Dedicated host, operations are closing a change that addressed: A regulated app requires a physically dedicated server host for VM placement and host-level isolation. Which post-change signal belongs in the acceptance record?

  1. Guest attestation and encryption state meet the confidential VM policy
  2. The app operates in the required isolated hosting boundary and passes private connectivity tests
  3. The workload runs its required driver within the provisioned compute budget
  4. The deployed VMs are listed on the reserved dedicated host

Explanation

Correct Answer

D:

Dedicated Host provides physical host isolation with separate placement and pricing controls. Confirm using the measurable result: The deployed VMs are listed on the reserved dedicated host.

Incorrect Answers

A:

Confidential VMs use hardware-backed protection for sensitive guest execution environments. Those observations validate Confidential VM. They do not establish the required Dedicated host result: The deployed VMs are listed on the reserved dedicated host.

B:

ASE provides dedicated App Service hosting in a customer virtual-network environment. The distinguishing check is: The deployed VMs are listed on the reserved dedicated host.

C:

General-purpose VMs balance CPU and memory while retaining OS-level control. The General purpose VM test checks the workload runs its required driver within the provisioned compute budget; the relevant outcome is The deployed VMs are listed on the reserved dedicated host.

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