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 91

Question 900

An external-facing consumer application requires local and social identity sign-in separate from workforce identities. The acceptance test is: The consumer completes the intended registration journey without receiving workforce resource roles. Which design recommendation best satisfies both?

  1. Assign a suitable Key Vault data-plane RBAC role at a supported minimal scope
  2. Create appropriately scoped administrative units and assign suitable delegated Entra administrative roles
  3. Use an appropriate Microsoft Entra External ID customer identity design
  4. Add an appropriate CanNotDelete lock while maintaining suitable RBAC permissions

Explanation

Correct Answer

C:

External ID consumer capabilities support customer journeys distinct from employee workforce governance. The selected architecture is use an appropriate Microsoft Entra External ID customer identity design; confirm the result by checking that the consumer completes the intended registration journey without receiving workforce resource roles.

Incorrect Answers

A:

Key Vault RBAC data permissions differ from vault resource-management permissions. The current need is: An external-facing consumer application requires local and social identity sign-in separate from workforce identities.

B:

Administrative units scope eligible directory management roles to selected objects, not data visibility. It does not solve the specified Consumer sign-in condition.

D:

Management locks guard against accidental resource deletes and operate separately from authorization roles. The relevant requirement is: An external-facing consumer application requires local and social identity sign-in separate from workforce identities.

Question 901

An architect must sign off on SQL database PITR. The business problem is: A deployment accidentally truncates a transaction table and the database must be recovered before the change. What observed test result provides valid evidence?

  1. A controlled failback returns traffic and state to the primary without unplanned data loss
  2. An earlier version of an overwritten spreadsheet is recovered from a share snapshot
  3. A region-loss exercise recovers a database from the latest supported geo backup
  4. A restored database contains transactions immediately preceding the truncation

Explanation

Correct Answer

D:

Azure SQL automatic full differential and log backups support restoring database state at a selected time. Confirm using the measurable result: A restored database contains transactions immediately preceding the truncation.

Incorrect Answers

A:

Failback is a separate operational sequence after workloads run in the recovery site. The distinguishing check is: A restored database contains transactions immediately preceding the truncation.

B:

Share snapshots preserve file-share point-in-time state for supported restoration. The Azure Files snapshots test checks an earlier version of an overwritten spreadsheet is recovered from a share snapshot; the relevant outcome is A restored database contains transactions immediately preceding the truncation.

C:

Geo-restore is backup-based recovery with different RTO/RPO than active geo-replication. The offered observation would demonstrate SQL geo-restore: A region-loss exercise recovers a database from the latest supported geo backup. The current validation is different: A restored database contains transactions immediately preceding the truncation.

Question 902

A proposed solution for SQL schema isolation is: Use one managed database per tenant when isolation and lifecycle needs outweigh extra operations. Select the strongest statement supporting the recommendation.

  1. Database-per-tenant provides a distinct security and backup boundary versus one shared schema
  2. Flexible Server provides managed MySQL compute storage and backups
  3. Dynamic data masking limits exposure in query results but is not a substitute for database access control
  4. Active geo-replication creates readable asynchronously updated secondary databases while primary remains writable

Explanation

Correct Answer

A:

Database-per-tenant provides a distinct security and backup boundary versus one shared schema. It is material here because a multitenant app needs strong tenant-level database isolation and easy tenant backup/restore.

Incorrect Answers

B:

Flexible Server provides managed MySQL compute storage and backups. Database-per-tenant provides a distinct security and backup boundary versus one shared schema.

C:

Dynamic data masking limits exposure in query results but is not a substitute for database access control. Database-per-tenant provides a distinct security and backup boundary versus one shared schema.

D:

Active geo-replication creates readable asynchronously updated secondary databases while primary remains writable. It belongs to SQL geo-replication reporting. The stated architecture instead relies on: Database-per-tenant provides a distinct security and backup boundary versus one shared schema.

Question 903

Architecture rationale review—SQL database monitoring: Use Azure SQL query performance insight and Azure Monitor metrics/diagnostics. Which explanation accurately distinguishes this capability?

  1. Hyperscale decouples storage scale from compute and supports large database sizes
  2. Query and resource telemetry helps distinguish costly queries from insufficient database compute
  3. Dynamic data masking limits exposure in query results but is not a substitute for database access control
  4. Ledger records cryptographically verifiable tamper-evidence for supported relational tables

Explanation

Correct Answer

B:

Query and resource telemetry helps distinguish costly queries from insufficient database compute. It is material here because dBAs need CPU, DTU/vCore, wait and query performance evidence before changing the tier.

Incorrect Answers

A:

Hyperscale decouples storage scale from compute and supports large database sizes. Query and resource telemetry helps distinguish costly queries from insufficient database compute.

C:

Dynamic data masking limits exposure in query results but is not a substitute for database access control. It belongs to SQL dynamic data masking. The stated architecture instead relies on: Query and resource telemetry helps distinguish costly queries from insufficient database compute.

D:

Ledger records cryptographically verifiable tamper-evidence for supported relational tables. That statement describes SQL ledger immutability, while the question asks how SQL database monitoring works: Query and resource telemetry helps distinguish costly queries from insufficient database compute.

Question 904

Architecture rationale review—Storage bulk offline transfer: Use an appropriate Azure Data Box physical transfer service. Which explanation accurately distinguishes this capability?

  1. Offline migration can simplify cutover when application downtime is acceptable
  2. PostgreSQL migration requires extension, version and connectivity compatibility checks
  3. Physical data transfer can shorten initial bulk migration when network transfer is impractical
  4. Hidden dependencies can break after migration even when VM replication succeeds

Explanation

Correct Answer

C:

Physical data transfer can shorten initial bulk migration when network transfer is impractical. It is material here because a remote facility must move 500 TB to Azure but WAN bandwidth is too slow for the deadline.

Incorrect Answers

A:

Offline migration can simplify cutover when application downtime is acceptable. Physical data transfer can shorten initial bulk migration when network transfer is impractical.

B:

PostgreSQL migration requires extension, version and connectivity compatibility checks. It belongs to PostgreSQL migration. The stated architecture instead relies on: Physical data transfer can shorten initial bulk migration when network transfer is impractical.

D:

Hidden dependencies can break after migration even when VM replication succeeds. Physical data transfer can shorten initial bulk migration when network transfer is impractical.

Question 905

An application depends on PostgreSQL extensions and wants managed PostgreSQL without a VM. Which Azure architecture would most directly achieve the required result: The required extension is available and the app connects without an OS-managed database host?

  1. Configure SQL dynamic data masking for selected columns and test permission bypass behavior
  2. Enable Azure SQL auditing to an approved storage or monitoring destination
  3. Select Azure Database for PostgreSQL Flexible Server and verify extension availability
  4. Place eligible Azure SQL databases in an elastic pool with shared compute

Explanation

Correct Answer

C:

Flexible Server offers managed open-source PostgreSQL with supported extensions and deployment options. The selected architecture is select Azure Database for PostgreSQL Flexible Server and verify extension availability; confirm the result by checking that the required extension is available and the app connects without an OS-managed database host.

Incorrect Answers

A:

Dynamic data masking limits exposure in query results but is not a substitute for database access control. It does not solve the specified PostgreSQL flexible server condition.

B:

SQL auditing captures database events as configured separately from application request telemetry. Its design target is SQL auditing. The stated requirement instead concerns: An application depends on PostgreSQL extensions and wants managed PostgreSQL without a VM.

D:

Elastic pools share resources across independent databases with non-synchronized demand. The current need is: An application depends on PostgreSQL extensions and wants managed PostgreSQL without a VM.

Question 906

The acceptance criterion for AKS container diagnosis comes from this issue: An AKS deployment repeatedly restarts and the team needs pod-level logs and cluster health. Which measured outcome is the strongest proof?

  1. SQL diagnostic records appear in the target workspace and can be filtered by database name
  2. A PromQL dashboard graphs the selected container metric with the expected Kubernetes labels
  3. An hourly chart returns grouped failure counts and identifies the affected service
  4. The restarting pod and its container events are visible with node and namespace context

Explanation

Correct Answer

D:

Container insights exposes Kubernetes workload health and container logs beyond generic virtual-machine statistics. Confirm using the measurable result: The restarting pod and its container events are visible with node and namespace context.

Incorrect Answers

A:

Resource diagnostic settings forward selected resource logs whereas subscription Activity Log tracks management operations. The Database resource diagnostics test checks sQL diagnostic records appear in the target workspace and can be filtered by database name; the relevant outcome is The restarting pod and its container events are visible with node and namespace context.

B:

Managed Prometheus collects Prometheus-format metrics separately from traditional container log collection. The offered observation would demonstrate Managed Prometheus: A PromQL dashboard graphs the selected container metric with the expected Kubernetes labels. The current validation is different: The restarting pod and its container events are visible with node and namespace context.

C:

KQL summarizes timestamped structured log data across dimensions such as operation and cloud role. Those observations validate Error trend queries. They do not establish the required AKS container diagnosis result: The restarting pod and its container events are visible with node and namespace context.

Question 907

A large transaction table suffers scans on historical data and needs time-based management. Identify the most suitable implementation for an outcome where execution plans prune irrelevant historical partitions for the test query.

  1. Enable Azure SQL auditing to an approved storage or monitoring destination
  2. Design appropriate table partitioning and indexing for workload query patterns
  3. Use SQL Always Encrypted with appropriate key management and compatible client drivers
  4. Add supported PostgreSQL Flexible Server read replicas with suitable replication-lag expectations

Explanation

Correct Answer

B:

Partition elimination and aligned indexes can reduce scans when predicates match partition keys. The selected architecture is design appropriate table partitioning and indexing for workload query patterns; confirm the result by checking that execution plans prune irrelevant historical partitions for the test query.

Incorrect Answers

A:

SQL auditing captures database events as configured separately from application request telemetry. The relevant requirement is: A large transaction table suffers scans on historical data and needs time-based management.

C:

Always Encrypted supports encryption and decryption in capable clients to reduce exposure to the database engine. It does not solve the specified SQL database partitioning condition.

D:

Read replicas offload eligible read-only queries but are asynchronously updated from the writer. Its design target is PostgreSQL read replica. The stated requirement instead concerns: A large transaction table suffers scans on historical data and needs time-based management.

Question 908

A solution must address both Key Vault secrets and Key Vault cryptographic signing. First requirement: A service depends on a vendor API password that rotates frequently. Second requirement: An application must sign payloads with a centrally controlled key without exporting its private material. Select TWO recommendations that meet these independent needs.

  1. Assign a user-assigned managed identity to both apps and scope its data permissions
  2. Grant a suitable storage data role at the narrow supported resource scope
  3. Create appropriately scoped administrative units and assign suitable delegated Entra administrative roles
  4. Use Azure Key Vault key operations with a suitable key type and access permissions
  5. Store the password as a versioned Key Vault secret and retrieve it with authorized identity

Explanation

Correct Answers

D:

For the Key Vault cryptographic signing half of this design, Key Vault keys can perform cryptographic operations while restricting private key exposure. Check: The application receives a valid signature but cannot export the private key material. The other half concerns Key Vault secrets.

E:

For the Key Vault secrets half of this two-part design, Key Vault secrets support controlled retrieval and rotation separate from packaged application code. Verify: The service uses the new secret version without an embedded password in deployment artifacts. The other half concerns Key Vault cryptographic signing.

Incorrect Answers

A:

A user-assigned identity has a lifecycle separate from each consuming Azure resource. The corresponding task is Shared workload identity: Two Functions apps need the same persistent workload identity even when one app is recreated. It is not one of the two requested controls (Key Vault secrets and Key Vault cryptographic signing).

B:

Data-plane roles control access to blob content and least-scope assignment reduces unnecessary privileges. That plan is appropriate for Managed-identity scope. The two controls sought here are Key Vault secrets and Key Vault cryptographic signing.

C:

Administrative units scope eligible directory management roles to selected objects, not data visibility. Its own validation would be: The regional admin can reset an assigned user's password but cannot administer an out-of-scope user. The current paired requirement is Key Vault secrets and Key Vault cryptographic signing.

Question 909

Cost reporting is missing the billing cost center tag on newly created resources. A deployment must satisfy this operational criterion: An untagged deployment is denied or audited as configured and tagged deployment succeeds. Which plan is appropriate?

  1. Use Azure Bicep modules and deployment pipelines with approval gates
  2. Use Microsoft Defender for Cloud regulatory compliance and security posture assessments
  3. Check subscription and regional service quotas before architecture signoff and request increases
  4. Use an Azure Policy require-tag rule at the appropriate scope

Explanation

Correct Answer

D:

Policy deny or audit effects can enforce required metadata at supported resource scopes. The selected architecture is use an Azure Policy require-tag rule at the appropriate scope; confirm the result by checking that an untagged deployment is denied or audited as configured and tagged deployment succeeds.

Incorrect Answers

A:

Infrastructure as code declares desired resources and allows review and repeat deployment. That is useful for Standardized IaC (Operations wants reproducible Azure environment deployments from version-controlled definitions). It does not meet the current Required tag policy requirement: Cost reporting is missing the billing cost center tag on newly created resources.

B:

Defender for Cloud aggregates recommendations and compliance state for supported frameworks. It does not solve the specified Required tag policy condition.

C:

Azure service quotas are often scoped by subscription and region and can constrain deployability. The relevant requirement is: Cost reporting is missing the billing cost center tag on newly created resources.

Question 910

Architecture review: Physical server migration and Azure File Sync. Requirement A: A legacy application runs on a physical Windows server and needs an IaaS move. Requirement B: A branch file server should retain local caching while most data moves to Azure Files. Which complete two-part proposal satisfies both constraints?

  1. (A) evaluate replatforming to Azure SQL Managed Instance or Database after compatibility tests; (B) use Azure File Sync with suitable cloud tiering and server endpoints
  2. (A) use an Azure Migrate-supported physical-server or agent-based migration approach; (B) perform schema and compatibility assessment before choosing Azure SQL Database or Managed Instance
  3. (A) evaluate replatforming to Azure SQL Managed Instance or Database after compatibility tests; (B) perform schema and compatibility assessment before choosing Azure SQL Database or Managed Instance
  4. (A) use an Azure Migrate-supported physical-server or agent-based migration approach; (B) use Azure File Sync with suitable cloud tiering and server endpoints

Explanation

Correct Answer

D:

For requirement A, physical migration requires source capture and replication methods different from VMware agentless VM migration. For requirement B, file Sync preserves local namespace access while synchronizing with Azure file shares. Verify both independently: A cutover VM starts in Azure with its application settings preserved; Frequently used files remain locally available and cold files tier to cloud.

Incorrect Answers

A:

File Sync preserves local namespace access while synchronizing with Azure file shares. The other proposed action (evaluate replatforming to Azure SQL Managed Instance or Database after compatibility tests) does not implement the first control. Physical migration requires source capture and replication methods different from VMware agentless VM migration.

B:

Physical migration requires source capture and replication methods different from VMware agentless VM migration. The other proposed action (perform schema and compatibility assessment before choosing Azure SQL Database or Managed Instance) addresses a different operation. File Sync preserves local namespace access while synchronizing with Azure file shares.

C:

Both proposed halves address other use cases: Replatform database and Database schema assessment. The requested pair is Physical server migration and Azure File Sync.

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