AZ-900 Practice Test 4 — 10 Questions

Question 1

Which Azure networking service provides a distributed, highly available, and scalable DNS service for routing users to the best-performing endpoint?

Accepted Answer

Azure Traffic Manager. Azure Traffic Manager is a DNS-based traffic load balancer that distributes traffic to the best-performing endpoint across global Azure regions. It uses DNS responses to direct users to the endpoint with the lowest latency or highest priority, providing high availability and scalability without proxying traffic.

Answer

Azure Front Door

Answer

Azure Load Balancer

Answer

Azure Application Gateway

Question 2

A company is designing a disaster recovery solution for a multi-tier application hosted in Azure. They need to ensure that if an entire Azure region becomes unavailable, the application can fail over to another region. The application uses Azure SQL Database. Which Azure feature should they use to replicate the database across regions?

Accepted Answer

B) Azure SQL Database automatic failover groups. Azure SQL Database automatic failover groups (Option B) are the correct choice because they provide automated, orchestrated failover of a group of databases across regions, ensuring the entire multi-tier application can fail over when an Azure region becomes unavailable. Unlike geo-replication, which only replicates data, failover groups manage the entire logical server and its databases, including updating the connection string endpoint to the secondary region, which is essential for application continuity.

Answer

A) Azure SQL Database geo-replication

Answer

C) Azure Traffic Manager

Answer

D) Azure Site Recovery

Question 3

Which of the following is an example of a SaaS (Software as a Service) offering from Microsoft?

Accepted Answer

Microsoft 365. Microsoft 365 is a SaaS offering because it provides ready-to-use productivity applications (e.g., Word, Excel, Teams) accessed via a web browser or client, with Microsoft managing the underlying infrastructure, operating system, and application updates. The customer simply consumes the software without needing to install or maintain servers or runtime environments.

Answer

Azure Virtual Machines

Answer

Azure App Service

Answer

Azure SQL Database

Question 4

A company's CTO asks why Azure can offer services at lower costs than building an equivalent on-premises solution. Which cloud principle BEST explains this?

Accepted Answer

Economies of scale. Economies of scale is the correct answer because cloud providers like Azure operate massive, standardized data centers that serve millions of customers simultaneously. This allows them to negotiate bulk discounts on hardware, power, and cooling, and to spread fixed operational costs across a vast customer base, resulting in per-unit costs far lower than what a single company would pay for an equivalent on-premises deployment.

Answer

Elasticity

Answer

High availability

Answer

Geo-distribution

Question 5

A manufacturing company runs its proprietary production scheduling software on on-premises servers. The IT team also manages on-premises file servers. The company decides to move its email system to Microsoft 365 but keeps all other systems on-premises. Which cloud deployment model does this scenario best describe?

Accepted Answer

Hybrid cloud. This scenario describes a hybrid cloud because the company uses a mix of on-premises infrastructure (production scheduling servers and file servers) and a public cloud service (Microsoft 365 for email). In a hybrid cloud model, organizations integrate on-premises resources with public cloud services, allowing data and applications to be shared between them. Here, the email system runs in Microsoft's public cloud while all other systems remain on-premises, creating a hybrid deployment.

Answer

Private cloud

Answer

Public cloud

Answer

Community cloud

Question 6

Match each Azure database service to its type.

Accepted Answer

Azure SQL Database: Relational. In this matching exercise, the correct pairs are: Azure SQL Database (Relational), Azure Cosmos DB (NoSQL), Azure Database for MySQL (Relational), Azure Database for PostgreSQL (Relational). The distractors swap the types, incorrectly labeling Cosmos DB as relational and SQL Database as NoSQL.

Answer

Azure Cosmos DB: Relational

Answer

Azure SQL Database: NoSQL

Question 7

Which Azure feature provides a way to audit and track access to sensitive resources using detailed logs?

Accepted Answer

Azure Activity Log and Diagnostic Logs. Azure Activity Log and Diagnostic Logs together provide a comprehensive auditing and tracking mechanism for sensitive resources. The Activity Log records control-plane events (e.g., who created or deleted a resource), while Diagnostic Logs capture data-plane events (e.g., read/write operations on a storage account or key vault). This combination allows administrators to trace every access attempt, including successful and failed operations, with detailed timestamps, caller identities, and request payloads.

Answer

Azure AD Sign-in logs

Answer

Azure Network Security Group flow logs

Answer

Azure Advisor audit recommendations

Question 8

A US-based financial services company must ensure that all customer data remains within the United States at all times to comply with regulatory requirements. The company plans to replicate its Azure SQL database between two Azure regions for disaster recovery. The solution must guarantee that if a region experiences a major outage, the paired region is prioritized for recovery. Additionally, the solution should ensure that during planned maintenance, only one region in the pair is updated at a time. Which Azure architecture feature should the company use?

Accepted Answer

Region Pairs. Region Pairs are the correct choice because Azure guarantees that each region is paired with another region within the same geography (e.g., East US with West US) to provide physical isolation, prioritized disaster recovery, and sequential planned maintenance updates. This ensures that during an outage, recovery is directed to the paired region, and during maintenance, only one region in the pair is updated at a time, meeting the company's regulatory and availability requirements.

Answer

Availability Zones

Answer

Resource Groups

Answer

Azure Policy

Question 9

Which Azure service provides a managed, serverless SQL database that scales automatically and pauses when not in use?

Accepted Answer

Azure SQL Database Serverless. Azure SQL Database Serverless is the correct answer because it is a compute tier for single databases that automatically scales compute resources based on workload demand and pauses the database during periods of inactivity, charging only for storage when paused. This aligns directly with the question's requirement for a managed, serverless SQL database that scales automatically and pauses when not in use.

Answer

Azure SQL Database General Purpose tier

Answer

Azure Cosmos DB Serverless

Answer

Azure SQL Managed Instance

Question 10

A company uses Azure for multiple projects. The IT governance team wants to ensure that every new Azure resource within a subscription is automatically assigned a 'CostCenter' tag based on the resource group it is created in. The team does not want to rely on users manually applying the tag. They need a built-in Azure solution that enforces this rule without custom scripts. Which Azure feature should they use?

Accepted Answer

Azure Policy with the 'Inherit a tag from the resource group if missing' effect. Azure Policy with the 'Inherit a tag from the resource group if missing' effect is correct because it automatically applies the 'CostCenter' tag from the resource group to any new resource created within that resource group, without requiring manual intervention or custom scripts. This built-in policy effect enforces governance rules at scale, ensuring compliance across the subscription.

Answer

Azure Resource Graph

Answer

Azure Management Groups

Answer

Azure Tags (manual tagging feature)