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 68

Question 670

An architect must sign off on Key Vault app secrets. The business problem is: A deployed API must rotate an external vendor credential without checking a new secret into Git. What observed test result provides valid evidence?

  1. External callers only reach the backend through the controlled APIM endpoint
  2. Two deliveries of the same order ID create only one invoice
  3. Credential rotation works without modifying committed application configuration
  4. A burst beyond the quota is throttled while permitted traffic proceeds

Explanation

Correct Answer

C:

Central secret retrieval separates sensitive credentials from source and build artifacts. Confirm using the measurable result: Credential rotation works without modifying committed application configuration.

Incorrect Answers

A:

An API gateway can broker external requests to private backends without direct public backend access. The API private backends test checks external callers only reach the backend through the controlled APIM endpoint; the relevant outcome is Credential rotation works without modifying committed application configuration.

B:

At-least-once message delivery requires application logic to deduplicate business side effects. The offered observation would demonstrate Reliable exactly-once effect: Two deliveries of the same order ID create only one invoice. The current validation is different: Credential rotation works without modifying committed application configuration.

D:

APIM can enforce per-client API consumption controls before requests reach backends. The distinguishing check is: Credential rotation works without modifying committed application configuration.

Question 671

During technical sign-off for Error trend queries, the architect selects: Use Kusto Query Language against the instrumented telemetry workspace. Which underlying behavior should be documented?

  1. AMPLS provides private connectivity to supported Azure Monitor ingestion and query endpoints
  2. KQL summarizes timestamped structured log data across dimensions such as operation and cloud role
  3. Managed Prometheus collects Prometheus-format metrics separately from traditional container log collection
  4. Resource Health reports the platform-side availability history of individual Azure resources

Explanation

Correct Answer

B:

KQL summarizes timestamped structured log data across dimensions such as operation and cloud role. It is material here because operations must aggregate intermittent HTTP 500s by service and hour from application traces.

Incorrect Answers

A:

AMPLS provides private connectivity to supported Azure Monitor ingestion and query endpoints. KQL summarizes timestamped structured log data across dimensions such as operation and cloud role.

C:

Managed Prometheus collects Prometheus-format metrics separately from traditional container log collection. It belongs to Managed Prometheus. The stated architecture instead relies on: KQL summarizes timestamped structured log data across dimensions such as operation and cloud role.

D:

Resource Health reports the platform-side availability history of individual Azure resources. That statement describes VM resource health, while the question asks how Error trend queries works: KQL summarizes timestamped structured log data across dimensions such as operation and cloud role.

Question 672

During technical sign-off for SQL Server on Azure VM, the architect selects: Keep SQL Server on an Azure virtual machine with appropriate HA and backup architecture. Which underlying behavior should be documented?

  1. IaaS retains operating-system and SQL instance control that PaaS databases do not provide
  2. Flexible Server provides managed MySQL compute storage and backups
  3. Serverless compute can scale usage and pause eligible databases to reduce idle cost
  4. Read replicas offload eligible read-only queries but are asynchronously updated from the writer

Explanation

Correct Answer

A:

IaaS retains operating-system and SQL instance control that PaaS databases do not provide. It is material here because a database application depends on a third-party kernel-level driver installed alongside SQL Server.

Incorrect Answers

B:

Flexible Server provides managed MySQL compute storage and backups. It belongs to MySQL managed service. The stated architecture instead relies on: IaaS retains operating-system and SQL instance control that PaaS databases do not provide.

C:

Serverless compute can scale usage and pause eligible databases to reduce idle cost. That statement describes SQL serverless idle cost, while the question asks how SQL Server on Azure VM works: IaaS retains operating-system and SQL instance control that PaaS databases do not provide.

D:

Read replicas offload eligible read-only queries but are asynchronously updated from the writer. IaaS retains operating-system and SQL instance control that PaaS databases do not provide.

Question 673

A subnet should reach Azure Storage over Azure backbone with storage firewall scoped to that subnet. An engineer must deliver the following acceptance evidence: The approved subnet accesses storage and unauthorized internet clients are blocked. What design choice is defensible?

  1. Use Azure Standard Internal Load Balancer with probes and backend pool
  2. Enable an appropriate service endpoint and service-side VNet rule
  3. Link the appropriate Azure Private DNS zone and configure private endpoint DNS records
  4. Use Network Watcher connection troubleshoot and IP flow verify where supported

Explanation

Correct Answer

B:

Service endpoints keep the platform public endpoint while allowing VNet-based service firewall authorization. The selected architecture is enable an appropriate service endpoint and service-side VNet rule; confirm the result by checking that the approved subnet accesses storage and unauthorized internet clients are blocked.

Incorrect Answers

A:

Azure Load Balancer routes Layer 4 traffic inside a VNet without parsing HTTP URLs. That is useful for Load Balancer internal L4 (A TCP database-proxy cluster needs one private IP balancing connections to multiple healthy nodes). It does not meet the current Service endpoint requirement: A subnet should reach Azure Storage over Azure backbone with storage firewall scoped to that subnet.

C:

Private DNS zone links determine name resolution for VNets that consume private endpoints. It does not solve the specified Service endpoint condition.

D:

Network Watcher diagnostic tools identify effective network behavior and filtering decisions. The current need is: A subnet should reach Azure Storage over Azure backbone with storage firewall scoped to that subnet.

Question 674

A subnet-based worker fleet needs stable outbound public IPs without per-VM public IP addresses. An engineer must deliver the following acceptance evidence: External partners observe only the approved outbound IP during simultaneous worker sessions. What design choice is defensible?

  1. Deploy Azure VPN Gateway site-to-site tunnels with matching local/remote IPsec settings
  2. Attach a NAT Gateway to the worker subnet with the approved public IP resources
  3. Evaluate Azure Virtual WAN secured virtual hubs and routing intent
  4. Use Azure VPN Gateway point-to-site with an appropriate identity provider

Explanation

Correct Answer

B:

NAT Gateway provides outbound SNAT for supported subnet internet traffic. The selected architecture is attach a NAT Gateway to the worker subnet with the approved public IP resources; confirm the result by checking that external partners observe only the approved outbound IP during simultaneous worker sessions.

Incorrect Answers

A:

VPN Gateway can establish encrypted IPsec tunnels over public networks. Its design target is Site-to-site VPN. The stated requirement instead concerns: A subnet-based worker fleet needs stable outbound public IPs without per-VM public IP addresses.

C:

Virtual WAN provides managed global transit architecture with integrated branch connectivity. It does not solve the specified NAT Gateway outbound condition.

D:

Point-to-site VPN authenticates individual clients for private network access. That is useful for Point-to-site VPN (Remote administrators need individually authenticated encrypted connectivity to Azure private resources). It does not meet the current NAT Gateway outbound requirement: A subnet-based worker fleet needs stable outbound public IPs without per-VM public IP addresses.

Question 675

A solution must address both Business Critical SQL latency and SQL database partitioning. First requirement: A transaction-heavy database requires low latency local SSD and multiple synchronous replicas within the region. Second requirement: A large transaction table suffers scans on historical data and needs time-based management. Select TWO recommendations that meet these independent needs.

  1. Choose the SQL Business Critical service tier where the workload and availability needs justify its cost
  2. Evaluate Azure SQL Database Hyperscale with applicable workload support
  3. Use appropriate application-side connection pooling with database tier capacity planning
  4. Design appropriate table partitioning and indexing for workload query patterns
  5. Use one managed database per tenant when isolation and lifecycle needs outweigh extra operations

Explanation

Correct Answers

A:

For the Business Critical SQL latency half of this two-part design, business Critical uses a local SSD-oriented architecture with high availability replicas. Verify: Measured transactional latency and failover meet the workload's documented targets. The other half concerns SQL database partitioning.

D:

For the SQL database partitioning half of this design, partition elimination and aligned indexes can reduce scans when predicates match partition keys. Check: Execution plans prune irrelevant historical partitions for the test query. The other half concerns Business Critical SQL latency.

Incorrect Answers

B:

Hyperscale decouples storage scale from compute and supports large database sizes. The corresponding task is SQL Hyperscale growth: One operational SQL database must scale beyond the capacity limits of ordinary General Purpose storage tiers. It is not one of the two requested controls (Business Critical SQL latency and SQL database partitioning).

C:

Pooling reuses connections and reduces setup overhead relative to per-request creation. That plan is appropriate for SQL connection pooling. The two controls sought here are Business Critical SQL latency and SQL database partitioning.

E:

Database-per-tenant provides a distinct security and backup boundary versus one shared schema. This alternative solves SQL schema isolation, while the question separately requires Business Critical SQL latency and SQL database partitioning.

Question 676

An ETL architecture needs ACID updates and versioned tables over object storage for Spark workloads. Choose the architecture that can be validated by this result: A MERGE updates matching records atomically and table history contains the transaction.

  1. Use supported serverless SQL capabilities over files in Azure Synapse Analytics
  2. Evaluate Microsoft Fabric OneLake with suitable Lakehouse/Warehouse integration
  3. Use Delta Lake tables on Azure Databricks with an appropriate catalog
  4. Use approved private integration runtime and networking features for the chosen data service

Explanation

Correct Answer

C:

Delta Lake transaction logs enable reliable table updates and versioning on cloud object stores. The selected architecture is use Delta Lake tables on Azure Databricks with an appropriate catalog; confirm the result by checking that a MERGE updates matching records atomically and table history contains the transaction.

Incorrect Answers

A:

Serverless SQL queries external lake files with consumption-based query compute. The current need is: An ETL architecture needs ACID updates and versioned tables over object storage for Spark workloads.

B:

OneLake offers a common analytics data foundation for supported Fabric workloads. It does not solve the specified Databricks Delta Lake condition.

D:

Hybrid/private integration requires a reachable private network path rather than open public DB exposure. The relevant requirement is: An ETL architecture needs ACID updates and versioned tables over object storage for Spark workloads.

Question 677

For Notification routing, operations are closing a change that addressed: Critical infrastructure alerts need pager escalation while routine capacity warnings go only to email. Which post-change signal belongs in the acceptance record?

  1. A denied deployment and a successful resource deletion appear with caller and operation name
  2. A retained log blob rejects unauthorized deletion during its compliance retention window
  3. A simulated critical alert pages the incident team while a capacity warning sends email only
  4. Monitoring ingestion succeeds using private DNS resolution while public network access is restricted

Explanation

Correct Answer

C:

Action groups define notifications and automated responses and can be reused by alert rules. Confirm using the measurable result: A simulated critical alert pages the incident team while a capacity warning sends email only.

Incorrect Answers

A:

The Activity Log records Azure Resource Manager control-plane events independent of guest agents. The distinguishing check is: A simulated critical alert pages the incident team while a capacity warning sends email only.

B:

Storage-based diagnostic archives and immutability serve compliance preservation rather than interactive KQL search. The Immutable evidence archive test checks a retained log blob rejects unauthorized deletion during its compliance retention window; the relevant outcome is A simulated critical alert pages the incident team while a capacity warning sends email only.

D:

AMPLS provides private connectivity to supported Azure Monitor ingestion and query endpoints. Those observations validate Private observability. They do not establish the required Notification routing result: A simulated critical alert pages the incident team while a capacity warning sends email only.

Question 678

Recovery operators need restore rights but should not be able to delete recovery services resources. Which Azure architecture would most directly achieve the required result: A designated operator can restore an approved workload but cannot delete its vault?

  1. Evaluate continuous-backup mode if precise PITR is a firm requirement
  2. Define re-protection, replication reversal, and tested failback procedures in the DR runbook
  3. Use Flexible Server point-in-time restore within supported backup-retention limits
  4. Assign scoped backup roles with least privilege and protected operation controls

Explanation

Correct Answer

D:

Backup-specific RBAC roles separate operational restore tasks from vault administration. The selected architecture is assign scoped backup roles with least privilege and protected operation controls; confirm the result by checking that a designated operator can restore an approved workload but cannot delete its vault.

Incorrect Answers

A:

Periodic backups produce interval snapshots and are not the same as continuous point-in-time recovery. Its design target is Cosmos periodic backup. The stated requirement instead concerns: Recovery operators need restore rights but should not be able to delete recovery services resources.

B:

Failback is a separate operational sequence after workloads run in the recovery site. It does not solve the specified Backup vault access condition.

C:

Managed PostgreSQL backups support rebuilding a server at a selected valid recovery time. The current need is: Recovery operators need restore rights but should not be able to delete recovery services resources.

Question 679

A small SQL database can tolerate a planned maintenance outage for cutover. The acceptance test is: The migrated database passes consistency checks before reopening writes. Which design recommendation best satisfies both?

  1. Choose a rebuild approach where business requirements justify new architecture
  2. Use an appropriate offline Azure Database Migration Service path after compatibility review
  3. Build a dependency map and classify blockers before sequencing migration waves
  4. Evaluate replatforming to Azure SQL Managed Instance or Database after compatibility tests

Explanation

Correct Answer

B:

Offline migration can simplify cutover when application downtime is acceptable. The selected architecture is use an appropriate offline Azure Database Migration Service path after compatibility review; confirm the result by checking that the migrated database passes consistency checks before reopening writes.

Incorrect Answers

A:

Rebuild replaces the application rather than merely moving its binaries. The relevant requirement is: A small SQL database can tolerate a planned maintenance outage for cutover.

C:

Hidden dependencies can break after migration even when VM replication succeeds. It does not solve the specified SQL offline migration condition.

D:

Replatforming changes hosting characteristics while preserving most app behavior. Its design target is Replatform database. The stated requirement instead concerns: A small SQL database can tolerate a planned maintenance outage for cutover.

Question 680

A database-backed application currently stores a SQL password even though it runs on Azure infrastructure. Choose the architecture that can be validated by this result: The workload queries its database with an Entra token and rotation of the former password has no effect.

  1. Prefer supported Microsoft Entra authentication using the workload managed identity for Azure SQL
  2. Configure Privileged Identity Management for Azure resource roles with activation controls
  3. Run Microsoft Entra access reviews with suitable reviewers and removal actions
  4. Assign a suitable Key Vault data-plane RBAC role at a supported minimal scope

Explanation

Correct Answer

A:

Azure SQL supports Entra authentication and compatible managed identities can eliminate stored SQL secrets. The selected architecture is prefer supported Microsoft Entra authentication using the workload managed identity for Azure SQL; confirm the result by checking that the workload queries its database with an Entra token and rotation of the former password has no effect.

Incorrect Answers

B:

PIM can time-bound eligible role activation with approvals MFA and justification. It does not solve the specified Passwordless app connection condition.

C:

Access reviews periodically recertify assigned access and can remove access for denied reviews. Its design target is Identity lifecycle audits. The stated requirement instead concerns: A database-backed application currently stores a SQL password even though it runs on Azure infrastructure.

D:

Key Vault RBAC data permissions differ from vault resource-management permissions. The relevant requirement is: A database-backed application currently stores a SQL password even though it runs on Azure infrastructure.

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