All practice questions

1186 questions

Question 121Question

A healthcare provider plans to automate their patient discharge notification system. The system must orchestrate a multi-step workflow that triggers whenever a patient's status changes in an Azure SQL Database. The workflow must use pre-built connectors to send SMS alerts and update external records without requiring custom orchestration code. Additionally, the workflow must run a custom Python script to sanitize and format patient data to ensure regulatory compliance before transmission. The provider requires a fully managed serverless solution where they do not manage the underlying operating systems, and billing must follow a consumption-based model (Operational Expenditure, or OpEx) where costs are incurred only when the workflow and script are executed.

Which combination of Azure services and billing plans meets all of these requirements?

Show answer & explanation

Answer: Azure Logic Apps under a Consumption plan to orchestrate the workflow, and Azure Functions under a Consumption plan to run the custom Python script.

Answer

Azure Logic Apps under a Consumption plan to orchestrate the workflow, and Azure Functions under a Consumption plan to run the custom Python script.
The correct answer combines Azure Logic Apps (Consumption plan) for designer-first, connector-driven integration workflow orchestrations with Azure Functions (Consumption plan) for code-first serverless execution of the custom Python script. Both services run in a fully managed serverless environment where Microsoft handles OS patching and scaling, and costs are billed purely on a consumption basis (OpEx).

Step-by-Step Solution

1
Identify the orchestration and connector requirements.
Azure Logic Apps is selected because it provides designer-first orchestration with pre-built connectors and zero required backend code.
The scenario specifies a requirement for orchestration and pre-built connectors with zero custom orchestration code.
2
Identify the custom script execution requirements.
Azure Functions is selected to execute the custom Python script.
Azure Functions is a code-first serverless compute service designed to host and run custom script files natively.
3
Evaluate the management and billing requirements.
Consumption-based plans are chosen for both services, which aligns with OpEx and removes OS management duties.
Both Azure Functions and Azure Logic Apps offer Consumption plans that scale automatically, bill only when executed, and require no operating system maintenance.

Key Concept

Azure Serverless Compute (Functions and Logic Apps)
Estimated Time:3m 0s
Question 122Question

An Azure administrator configures a `CanNotDelete` resource lock on an Azure subscription. Within this subscription, another administrator applies a `ReadOnly` resource lock to a resource group named `rg-finance`. Inside `rg-finance`, there is a storage account named `safinance`.

A developer who is assigned the Owner role on the subscription attempts to perform the following operations:
1. Read a blob from a container in `safinance` using a pre-existing Shared Access Signature (SAS) token.
2. Regenerate the access keys for `safinance` using the Azure portal.
3. Update the configuration of `safinance` to disable public blob access.

Which of the operations will be successful?

Show answer & explanation

Answer: Operation 1 only

Answer

Operation 1 only
The operation to read a blob from a container using a Shared Access Signature (SAS) token is successful because resource locks apply only to the management plane (control plane) of Azure. They do not block operations on the data plane, such as retrieving blob content. Regenerating access keys and modifying the storage account configuration are management-plane actions and are blocked by the ReadOnly lock inherited from the resource group.

Step-by-Step Solution

1
Determine the resource locks that apply to the storage account.
The storage account inherits the CanNotDelete lock from the subscription scope and the ReadOnly lock from the resource group scope.
Azure resource locks are transitive and automatically apply to all child resources within the locked parent scopes.
2
Determine the effective lock behavior on the storage account.
The effective lock behavior is ReadOnly.
When multiple resource locks are applied, the most restrictive lock (ReadOnly) takes precedence over the less restrictive lock (CanNotDelete).
3
Evaluate the control plane vs. data plane nature of each attempted operation.
Operation 1 is a data-plane read request. Operations 2 and 3 are management-plane (control plane) requests.
Azure resource locks apply strictly to the Azure Resource Manager control plane. They do not block operations that access the actual data stored within a resource.
4
Determine which operations are permitted under the effective ReadOnly lock.
Only Operation 1 is permitted. Operations 2 and 3 are blocked.
The ReadOnly lock blocks all configuration writes and modifications on the control plane (such as changing public access properties or regenerating keys), but does not affect data plane operations (such as reading a blob).

Key Concept

Azure resource locks only restrict management plane (control plane) operations, while data plane operations remain unaffected. A ReadOnly lock is the most restrictive lock and blocks both deletion and configuration changes, regardless of the user's role.
Estimated Time:2m 0s
Question 123Question

A resource group named rg-analytics contains a virtual machine named VM1. An administrator applies a ReadOnly resource lock to rg-analytics. Which two operations on VM1 are blocked due to the inherited lock? Select two.

Select all that apply

Show answer & explanation

Answer: Deleting VM1; Modifying the configuration settings of VM1

Answer

Deleting VM1 and modifying the configuration settings of VM1 are blocked by the inherited ReadOnly lock.
A ReadOnly resource lock applied to a resource group is inherited by all resources within it. This lock prevents users from deleting the resource and from modifying its configuration settings.

Step-by-Step Solution

1
Determine the type and inheritance of the applied lock.
A ReadOnly lock is applied at the resource group level (rg-analytics), which means all resources inside the resource group, including VM1, inherit this ReadOnly lock.
Azure resource locks are transitive and inherited by all child resources within the locked scope.
2
Identify the permissions restricted by a ReadOnly lock.
A ReadOnly lock prevents users from deleting or modifying the resource, while still allowing them to read its configuration.
This is the system behavior defined by Azure for ReadOnly locks.
3
Evaluate the operations against the lock restrictions.
Deleting VM1 and modifying its configuration are blocked. Viewing properties and reading activity logs are read-only actions and are allowed.
To select the correct options that represent blocked operations.

Key Concept

Azure Resource Locks restrict operations on resources, and their effects (such as preventing deletion and modification under a ReadOnly lock) are inherited from parent scopes like resource groups to child resources.
Question 124Question

A company plans to migrate a legacy SQL Server database to Azure. The database relies on third-party, OS-level security agents and requires custom configurations to the underlying operating system that are not supported in fully managed services. Which Azure database option should the company select to meet these requirements?

Show answer & explanation

Answer: SQL Server on Azure Virtual Machines

Answer

SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines is an Infrastructure as a Service (IaaS) offering. This model grants the customer full administrative access to the underlying operating system and database engine, which is necessary to install third-party security agents and apply custom OS configurations.

Step-by-Step Solution

1
Analyze the application requirements.
The legacy SQL Server database requires operating system-level access to host third-party security agents and apply custom configurations.
This establishes the level of control needed over the underlying infrastructure.
2
Compare Azure SQL deployment models based on administrative control.
Fully managed Platform as a Service (PaaS) offerings like Azure SQL Database and Azure SQL Managed Instance abstract the operating system, whereas Infrastructure as a Service (IaaS) via SQL Server on Azure Virtual Machines provides full OS access.
This determines which cloud service model satisfies the constraint of having OS-level access.

Key Concept

The primary differentiator between IaaS and PaaS database offerings in Azure is the level of administrative control over the operating system and database engine configurations.
Question 125Question

An energy company operates wind farms with local edge servers running Windows Server. The company wants to manage and monitor these physical servers from the Azure portal and apply standard Azure Policy definitions, without migrating the workloads to the cloud. Which Azure service enables this management?

Show answer & explanation

Answer: Azure Arc

Answer

Azure Arc
The correct answer is Azure Arc because it allows organizations to project their on-premises, edge, and multi-cloud resources into Azure Resource Manager, enabling unified management, monitoring, and policy enforcement via the Azure portal.

Step-by-Step Solution

1
Analyze the scenario requirements: the company needs to manage and apply governance policies to physical servers located outside of Azure (on-premises/edge) from the Azure portal without migrating them.
The requirement points to extending Azure Resource Manager (ARM) control plane capabilities to non-Azure infrastructure.
This rules out basic migration services and identifies the need for hybrid control plane extension.
2
Select the Azure hybrid service that projects external resources (such as servers, Kubernetes clusters, and SQL databases) into Azure as native resources.
Azure Arc is identified as the service designed to onboard and govern non-Azure resources natively.
Azure Arc maps external servers to Azure Resource Manager, allowing policies and monitoring to be applied directly.

Key Concept

Azure Arc acts as a bridge to extend the Azure Resource Manager (ARM) control plane to resources that reside outside of Azure.
Question 126Question

An organization wants to restrict its developers so they can only deploy virtual machines of a specific size. Is the statement that the administrator should assign a custom Azure Role-Based Access Control (RBAC) role to enforce this resource size restriction true or false?

Show answer & explanation

Answer: False

Answer

False
The statement is false because Azure RBAC is used to manage access permissions (who can perform actions on resources), whereas Azure Policy is used to enforce resource properties and compliance constraints (such as restricting the allowed sizes of virtual machines).

Step-by-Step Solution

1
Identify the goal: restrict developers to deploying only specific virtual machine sizes.
This is a resource configuration constraint.
Analyzing the scenario requirements determines what type of governance action is needed.
2
Evaluate Azure RBAC functionality.
Azure RBAC manages user authorization (who can perform actions like create, read, update, or delete on resources). It does not control resource properties like VM size.
Determining if the proposed tool (RBAC) can fulfill the goal.
3
Evaluate Azure Policy functionality.
Azure Policy enforces resource properties and compliance, such as restricting allowed SKU sizes during deployment.
Identifying the correct Azure service for resource-level restrictions.
4
Conclude whether the statement is true or false.
Since Azure RBAC cannot enforce VM size restrictions and Azure Policy must be used instead, the statement is false.
Determining the final answer based on service capabilities.

Key Concept

Azure RBAC vs. Azure Policy
Question 127Question

An administrator creates an Azure Resource Group named `RG-Production` and assigns a tag named `Department` with a value of `Finance`. The administrator then deploys an Azure Virtual Machine named `VM-Web` inside `RG-Production` without applying any tags directly to the Virtual Machine. Later, the administrator views Azure Cost Management and configures a Cost Analysis report filtered by the tag `Department` with the value `Finance`.

Which of the following describes how the costs associated with the virtual machine `VM-Web` will be represented in this Cost Analysis report?

Show answer & explanation

Answer: The costs of VM-Web will be excluded from the filtered Cost Analysis report because resources do not inherit tags applied to their parent resource group.

Answer

The costs of VM-Web will be excluded from the filtered Cost Analysis report because resources do not inherit tags applied to their parent resource group.
The correct option is correct because resource tags in Azure are not inherited from the containing resource group to the resources inside it. Since the virtual machine VM-Web was created without any tags, it does not possess the Department: Finance tag. Therefore, filtering the Cost Analysis report by the Department: Finance tag will exclude the costs incurred by the virtual machine.

Step-by-Step Solution

1
Analyze the hierarchy and inheritance rules of Azure resource tags.
Determine that tags applied to an Azure Resource Group do not automatically inherit down to the resources contained within that group.
This step identifies the key governance behavior of tagging in Azure.
2
Identify the tags assigned directly to VM-Web.
Confirm that VM-Web has no tags directly applied.
This step determines whether the resource possesses the tag being filtered.
3
Evaluate how Azure Cost Analysis applies filters.
Filter criteria require the tag to be present on the resource. Since VM-Web has no tags, its costs are not included in the filtered report.
This step applies the tag presence logic to the reporting criteria.

Key Concept

Resource tags applied to resource groups are not inherited by resources within those groups. Consequently, filtering cost reports by tags will only return resources that have the tags applied directly.
Estimated Time:1m 30s
Question 128Question

A company needs to grant a database administrator permission to manage Azure SQL databases within a subscription, while ensuring they cannot modify any virtual networks in the same subscription. Which Azure governance feature should you use to implement this access control?

Show answer & explanation

Answer: Azure Role-Based Access Control (RBAC)

Answer

Azure Role-Based Access Control (RBAC)
Azure Role-Based Access Control (RBAC) is the correct feature to manage who has access to Azure resources, what they can do with those resources, and what areas they have access to. By assigning the database administrator a specific role at the subscription or resource group level, you can grant them the necessary permissions to manage SQL databases while omitting permissions for virtual networks.

Step-by-Step Solution

1
Analyze the requirement to grant user-specific administrative permissions (managing SQL databases while restricting virtual network modification).
Identify that the core requirement is managing authorization and access control for a user.
This helps determine which Azure governance tool is responsible for identity and access management.
2
Compare the capabilities of Azure governance features: Azure RBAC, Azure Policy, Azure Resource Locks, and Azure Resource Tags.
Establish that Azure RBAC is the tool that assigns roles to identities (users/groups) for resource management, whereas Azure Policy enforces resource state/compliance, Resource Locks prevent deletion/modification globally, and Tags are metadata.
Correctly matching the requirement to the capability of the specific Azure feature ensures the correct solution.

Key Concept

Azure Role-Based Access Control (RBAC)
Estimated Time:45s
Question 129Question

An organization plans to establish hybrid connectivity between its on-premises headquarters and an Azure Virtual Network (VNet). The IT security policy mandates that primary production traffic must not traverse the public internet and must have dedicated, high-speed bandwidth. Additionally, a cost-effective, encrypted backup connection that runs over the public internet is required.

Which two of the following hybrid networking options should the organization implement to satisfy these requirements? (Select two).

Select all that apply

Show answer & explanation

Answer: Azure ExpressRoute to serve as the primary connection; A Site-to-Site VPN connection to serve as the backup connection

Answer

Azure ExpressRoute to serve as the primary connection, and a Site-to-Site VPN connection to serve as the backup connection
The correct options are the dedicated private connection and the encrypted public internet connection. Azure ExpressRoute meets the requirement for a primary connection because it provides dedicated, high-speed bandwidth that completely bypasses the public internet. A Site-to-Site VPN connection meets the backup requirement because it is cost-effective, encrypts traffic, and runs over the public internet.

Step-by-Step Solution

1
Identify the requirement for the primary connection.
The primary connection must bypass the public internet and provide high-speed, dedicated bandwidth. Azure ExpressRoute meets this by offering a private, dedicated connection that does not traverse the public internet.
Choosing ExpressRoute ensures the primary traffic is secure, reliable, and fast.
2
Identify the requirement for the backup connection.
The backup connection needs to be cost-effective, encrypted, and run over the public internet. A Site-to-Site VPN gateway connection encrypts traffic over the public internet at a lower cost than a second ExpressRoute circuit.
A Site-to-Site VPN satisfies the backup requirements of encryption, cost efficiency, and internet routing.

Key Concept

Azure hybrid networking services including ExpressRoute and VPN Gateway provide options for connecting on-premises networks to Azure virtual networks, varying by cost, performance, and routing paths.
Question 130Question

A financial organization is planning to host a new microservices-based application in Azure. The application architecture consists of 15 independent service components that require service-to-service discovery, internal load balancing, and dynamic scaling based on custom CPU thresholds. The security policy dictates that the cloud provider must handle all operating system patching, but the organization must retain full control over the deployment manifests and container orchestration configurations.

Which Azure service meets these requirements?

Show answer & explanation

Answer: Azure Kubernetes Service (AKS)

Answer

Azure Kubernetes Service (AKS)
The correct answer is Azure Kubernetes Service (AKS) because it provides managed container orchestration. Microsoft handles the host OS updates and control plane management, satisfying the patching requirement, while the customer retains control over orchestration settings, service discovery, and manifests.

Step-by-Step Solution

1
Identify the container orchestration requirements.
The application architecture involves 15 microservices that require service-to-service discovery, internal load balancing, and custom CPU scaling. This requires a dedicated container orchestrator.
This helps filter out basic single-container services that lack native orchestration capabilities.
2
Evaluate the operating system patching constraint against cloud models.
The security policy requires the cloud provider to manage all OS patching. This rules out Infrastructure as a Service (IaaS) offerings.
This eliminates options where the customer has OS-level management responsibility.
3
Determine the service that balances managed infrastructure with orchestration control.
Azure Kubernetes Service (AKS) manages the underlying VMs and host OS patching automatically, while granting the customer full control over container manifests and orchestration configurations.
This selects the specific hosting model that fits both the management boundaries and architectural requirements.

Key Concept

Azure Kubernetes Service (AKS) offers a managed Kubernetes platform where the cloud provider manages host OS patching and cluster infrastructure, while the customer maintains control over orchestration manifests and microservice discovery.
Estimated Time:2m 0s
Question 131Question

An organization is designing a governance and deployment strategy using Azure Resource Manager (ARM) templates to deploy web applications and database resources. The IT administrator wants to ensure that the deployment process is standardized, repeatable, and aligned with Azure best practices. Which of the following statements correctly describes how Azure Resource Manager (ARM) processes and deploys resources using templates?

Show answer & explanation

Answer: ARM templates are declarative, allowing you to define the desired final state of the infrastructure, and resources defined in the template can be deployed to different regions than the target resource group.

Answer

ARM templates are declarative, allowing you to define the desired final state of the infrastructure, and resources defined in the template can be deployed to different regions than the target resource group.
The correct option is correct because ARM templates use a declarative syntax, meaning you define what infrastructure you want to deploy without writing the sequence of programming commands to create it. Furthermore, resources inside an Azure resource group do not have to share the same location as the resource group itself; the resource group's location is primarily used for storing deployment metadata.

Step-by-Step Solution

1
Analyze the nature of ARM templates.
Determine that ARM templates use a declarative approach rather than an imperative approach.
This rules out options describing imperative, step-by-step procedural scripting.
2
Examine resource group containment boundaries in Azure.
Confirm that resource groups cannot be nested within other resource groups.
This rules out options suggesting nested hierarchies of resource groups.
3
Evaluate the relationship between resource locations and resource group locations.
Identify that resource group locations store metadata, but resources in the group can be deployed across different Azure regions.
This rules out options claiming resources must inherit the resource group's region, confirming that resource regions can be independent.

Key Concept

ARM templates are declarative and support cross-region resource deployment within a single resource group.
Question 132Question

A financial firm requires a hybrid connectivity solution to link its on-premises database to Azure. The security policy mandates that all data in transit must be encrypted using IPsec, and the network path must bypass the public internet entirely to minimize latency and exposure.

Determine whether the following statement is true or false:

To satisfy both requirements, the firm can configure an Azure ExpressRoute circuit with private peering and establish a Site-to-Site VPN connection that runs directly over this private peering path.

Show answer & explanation

Answer: True

Answer

True
The statement is true because Azure supports establishing a Site-to-Site VPN tunnel over an ExpressRoute private peering circuit. This enables organizations to encrypt their traffic using IPsec while routing it over a private connection that bypasses the public internet.

Step-by-Step Solution

1
Analyze the networking requirements: data must be encrypted using IPsec, and the connection must bypass the public internet.
Identify that a standard ExpressRoute circuit is private but unencrypted, and a standard Site-to-Site VPN is encrypted but runs over the public internet.
To evaluate the feasibility of the proposed solution.
2
Evaluate the proposed solution of configuring a Site-to-Site VPN over an ExpressRoute private peering circuit.
Azure supports routing Site-to-Site VPN traffic through an ExpressRoute private peering connection, which encrypts the data using IPsec and transports it over the dedicated ExpressRoute link.
To verify if the proposed solution meets both requirements.

Key Concept

Azure ExpressRoute and VPN Gateway coexistence (VPN over ExpressRoute)
Estimated Time:2m 0s
Question 133Question

A company has an Azure Management Group named MG-Sales. You need to assign permissions to a security officer. The officer must be able to assign roles and delegate access permissions for all subscriptions within MG-Sales, but should not be allowed to create or modify virtual machines or databases. Which configuration should you assign to the security officer to meet these requirements?

Show answer & explanation

Answer: The User Access Administrator role at the Management Group scope

Answer

The User Access Administrator role at the Management Group scope
The correct answer is the User Access Administrator role at the Management Group scope. This built-in role allows the security officer to manage user access (assign roles) to Azure resources, and because it is assigned at the Management Group level, these permissions inherit down to all subscriptions. Unlike the Owner role, it does not grant permissions to create or modify resources such as virtual machines or databases, which aligns with the principle of least privilege.

Step-by-Step Solution

1
Analyze the permission requirements.
The target user needs role delegation capabilities but must be blocked from resource creation/modification.
This establishes the scope of control to focus on access management only.
2
Evaluate the inheritance scope.
The target scope is a Management Group containing multiple subscriptions.
Assigning permissions at the Management Group level ensures the settings propagate down to all child subscriptions through inheritance.
3
Select the built-in role.
Choose User Access Administrator over Owner.
While both allow role assignments, the Owner role also allows resource modification, which violates the restriction. User Access Administrator isolates role delegation without resource-plane management rights.

Key Concept

Azure Role-Based Access Control (RBAC) Built-in Roles and Scope Inheritance
Estimated Time:1m 0s
Question 134Question

An Azure subscription contains a resource group named `rg-corp-networks`. A `ReadOnly` resource lock is applied at the subscription level, and a `CanNotDelete` resource lock is applied directly to `rg-corp-networks`. The resource group contains an Azure Virtual Network named `vnet-prod`.

Which two operations can an administrator successfully perform on `vnet-prod`? Select two.

Select all that apply

Show answer & explanation

Answer: View the IP address settings of `vnet-prod`; Read the current resource tags of `vnet-prod`

Answer

An administrator can view the IP address settings and read the current resource tags of the virtual network.
Resource locks in Azure are inherited from parent scopes (Subscription -> Resource Group -> Resource) and are additive. In this scenario, the subscription has a ReadOnly lock, and the resource group has a CanNotDelete lock. The virtual network inherits both. Because locks are additive, the most restrictive lock (ReadOnly) determines the allowed actions. A ReadOnly lock allows only read operations. Viewing the IP address settings and reading the resource tags are read operations, so they can be performed successfully.

Step-by-Step Solution

1
Determine the inherited locks on the virtual network.
The virtual network inherits the ReadOnly lock from the subscription level and the CanNotDelete lock from the resource group level.
Azure resource locks are inherited from parent scopes down to all child resources.
2
Determine the effective lock behavior by combining the active locks.
The effective restriction is ReadOnly (read operations only, no writes/modifications, no deletions).
Resource locks are additive. When multiple locks are applied at different scopes, the most restrictive lock takes precedence.
3
Evaluate the proposed operations against the effective ReadOnly restriction.
Viewing IP address settings and reading resource tags are allowed read operations. Adding a subnet and associating an NSG are blocked write/modify operations.
A ReadOnly lock blocks all configuration changes (write operations) and deletion, while allowing only read operations.

Key Concept

Resource locks are inherited and additive. A ReadOnly lock restricts all write and delete operations, allowing only read operations.
Estimated Time:1m 30s
Question 135Question

A company plans to migrate a complex microservices-based application to Azure. The application architecture requires advanced container management capabilities, including service discovery, internal load balancing, and coordinated scaling across dozens of container replicas. Is the statement that Azure Kubernetes Service (AKS) is the recommended service for this migration true or false?

Show answer & explanation

Answer: True

Answer

True, because Azure Kubernetes Service (AKS) provides full container orchestration capabilities such as service discovery, load balancing, and coordinated scaling, which are required for complex microservices applications.
Azure Kubernetes Service (AKS) is the correct platform because it is a dedicated container orchestration service. It is designed to manage clusters of containers, handling service discovery, load balancing, scaling, and health monitoring.

Step-by-Step Solution

1
Analyze the requirements of the application scenario.
The application requires advanced container orchestration capabilities including service discovery, load balancing, and coordinated scaling.
To match the application requirements with the features of Azure container hosting services.
2
Evaluate the capabilities of Azure Kubernetes Service (AKS).
AKS is a managed Kubernetes service that provides complete container orchestration, service discovery, load balancing, and automated scaling.
To verify if AKS supports the microservices architecture needs.
3
Compare AKS features with Azure Container Instances (ACI) and Azure App Service.
ACI does not offer full orchestration (e.g., service discovery or coordinated replica scaling), and App Service is focused on web hosting rather than microservice mesh/orchestration.
To confirm AKS is the recommended service and the statement is true.

Key Concept

Azure container services selection based on orchestration requirements
Estimated Time:1m 0s
Question 136Question

An administrator is connecting two Azure virtual networks (VNets) by using virtual network peering (VNet peering). Is it true or false that traffic between these peered virtual networks is routed over the public internet?

Show answer & explanation

Answer: False

Answer

False
Virtual network peering connects virtual networks using the private Microsoft backbone network, so the traffic does not travel over the public internet.

Step-by-Step Solution

1
Analyze how virtual network peering (VNet peering) routes traffic between Azure virtual networks.
VNet peering connects virtual networks directly using private IP addresses.
To determine the path and security boundary of the traffic.
2
Determine if the traffic traverses the public internet.
The traffic stays within the Microsoft private backbone network and does not traverse the public internet.
Peering utilizes Microsoft's private network infrastructure for direct VM-to-VM communication.

Key Concept

Azure Virtual Network Peering Traffic Routing
Question 137Question

A company is planning to migrate a legacy financial application to Azure. The application's database relies heavily on traditional relational features, including strict schema enforcement, foreign key constraints, and complex multi-table joins. A developer suggests migrating this database directly to Azure Cosmos DB using the SQL API. Why is Azure Cosmos DB with the SQL API unsuitable for this workload without a major redesign of the database?

Show answer & explanation

Answer: Azure Cosmos DB is a non-relational database designed for schema-agnostic document storage, meaning it does not natively enforce relational database features like foreign key constraints or complex multi-table joins.

Answer

Azure Cosmos DB is a non-relational database designed for schema-agnostic document storage, meaning it does not natively enforce relational database features like foreign key constraints or complex multi-table joins.
The correct answer explains that Azure Cosmos DB is a non-relational (NoSQL) database engine. Because it is designed for horizontal scale and schema-agnostic document storage, it does not natively enforce relational database behaviors like foreign keys or complex multi-table joins. Transitioning a traditional relational database workload to Cosmos DB SQL API without redesigning the data model is not possible.

Step-by-Step Solution

1
Analyze the database requirements of the legacy application.
The application requires relational database features, specifically strict schema enforcement, foreign keys, and complex table joins.
To identify whether a relational or non-relational database structure is required.
2
Evaluate the architecture of Azure Cosmos DB and its SQL API.
Azure Cosmos DB is a non-relational (NoSQL) database. Its SQL API is for querying document data models (JSON files) using SQL syntax, but it does not support relational capabilities.
To verify if the recommended database option natively supports the required features.
3
Compare the developer's recommendation with the application's requirements.
Azure Cosmos DB cannot support the legacy workload directly because it does not natively enforce relational constraints or joins, requiring a major redesign.
To determine the suitability and explain the deficiency of the proposed solution.

Key Concept

Azure Cosmos DB is a fully managed NoSQL (non-relational) database service. Despite offering a SQL API, it does not support traditional relational database features such as foreign keys or multi-table joins natively.
Estimated Time:2m 0s
Question 138Question

An Azure subscription contains several existing storage accounts that do not have secure transfer enabled. An administrator who is assigned the Owner role at the subscription level applies a new Azure Policy to the subscription. The policy uses a 'Deny' effect to prevent the creation of storage accounts that have secure transfer disabled. The administrator then attempts to create a new storage account with secure transfer disabled. What is the outcome of the administrator's attempt to create the new storage account, and how are the existing storage accounts affected?

Show answer & explanation

Answer: The creation of the new storage account is blocked, and the existing storage accounts remain unchanged but are marked as non-compliant in the compliance dashboard.

Answer

The creation of the new storage account is blocked, and the existing storage accounts remain unchanged but are marked as non-compliant in the compliance dashboard.
The correct answer correctly states that the creation of the new storage account is blocked because Azure Policy rules apply to all resource deployment attempts, regardless of the user's RBAC roles. Furthermore, Azure Policy does not automatically alter or delete existing resources that do not comply with the newly applied policy; it merely identifies them as non-compliant in reports.

Step-by-Step Solution

1
Evaluate the effect of Azure Policy on the new resource request.
The request to create a new storage account with secure transfer disabled violates the subscription-level policy with the 'Deny' effect.
The 'Deny' effect prevents the resource provider from creating or updating resources that do not match the policy definition.
2
Determine if user permissions can bypass the Azure Policy block.
The creation is blocked despite the user having the Owner role.
Azure Role-Based Access Control (RBAC) defines what actions a user can perform, whereas Azure Policy defines resource properties. RBAC roles do not override or bypass Azure Policy restrictions.
3
Analyze the effect of the new policy on pre-existing resources.
The existing non-compliant storage accounts are not modified or deleted, but they are flagged as non-compliant.
Azure Policy does not retroactively change or delete existing resources when a new 'Deny' policy is assigned. Instead, it marks them as non-compliant in compliance reports.

Key Concept

Azure Policy effects and compliance behavior, and its relationship with Azure Role-Based Access Control (RBAC)
Question 139Question

A university wants to link its local campus network to resources in a virtual network. The network team requires a connectivity option that bypasses the public internet entirely, provides high bandwidth, and ensures ultra-low latency. Is the following statement true?

'A VPN gateway connection over the internet will meet these requirements.'

Show answer & explanation

Answer: False

Answer

The statement is false. A VPN gateway routes encrypted traffic over the public internet, which does not bypass the public internet or guarantee low latency. ExpressRoute is required to meet these criteria.
The correct answer is false because VPN gateway connections utilize the public internet to establish an encrypted tunnel. Consequently, they cannot bypass the public internet or provide the guaranteed high-bandwidth and ultra-low latency of a dedicated private link.

Step-by-Step Solution

1
Analyze the connectivity requirements specified in the scenario.
The requirements are: bypassing the public internet entirely, high bandwidth, and ultra-low latency.
Understanding the design criteria is necessary to select or evaluate the correct hybrid networking service.
2
Evaluate the capabilities of a VPN gateway against these requirements.
A VPN gateway uses the public internet to transmit encrypted data, which means it cannot bypass the public internet and is subject to internet routing latency.
This shows why the proposed solution in the statement fails to meet the criteria.
3
Identify the service that meets the requirements.
ExpressRoute provides a dedicated, private connection to Azure that bypasses the public internet, offering higher reliability, faster speeds, and lower latencies.
This confirms that ExpressRoute, not a VPN gateway, is the correct solution, making the statement false.

Key Concept

ExpressRoute provides private, dedicated connectivity that bypasses the public internet, whereas a VPN gateway transmits encrypted traffic over the public internet.
Estimated Time:1m 0s
Question 140Question

An enterprise is planning to migrate its workloads to Microsoft Azure. The migration plan outlines three specific storage requirements:

1. An on-premises database will be hosted on an Azure Virtual Machine (IaaS). The database administrator must retain complete control over the database engine configuration and the operating system patching.
2. A legacy shared file share must be migrated to Azure to allow multiple virtual machines to access the files concurrently using the SMB protocol.
3. Approximately 200 TB200\text{ TB} of compliance logs must be retained for 7 years. These logs are rarely accessed but must be stored at the lowest possible cost, with an acceptable retrieval time of up to 14 hours.

To meet these requirements, the IT department designs a solution using Azure Managed Disks for the Virtual Machine, Azure Files (Cool tier) for the shared file share, and Azure Blob Storage (Archive tier) for the compliance logs.

After deployment, an administrator schedules a script that runs every month to read a random subset of the compliance logs directly from the Archive tier to verify data integrity.

Which of the following statements correctly evaluates this deployment and the administrator's script?

Show answer & explanation

Answer: The virtual machine and file share configurations are appropriate, but the integrity verification script will fail because data in the Archive tier is offline and cannot be read directly without first being rehydrated to an online tier.

Answer

The virtual machine and file share configurations are appropriate, but the integrity verification script will fail because data in the Archive tier is offline and cannot be read directly without first being rehydrated to an online tier.
The configuration correctly identifies the division of responsibilities for IaaS VMs, where the customer maintains control over the OS patching and database engine configuration. Azure Files is suitable for concurrent SMB-based shares. However, the Archive storage tier of Azure Blob Storage is an offline tier. Data stored in this tier cannot be read directly. To read a blob in the Archive tier, it must first be rehydrated to an online tier (Hot, Cool, or Cold), which means the integrity verification script attempting direct reads will fail.

Step-by-Step Solution

1
Analyze the IaaS virtual machine configuration and responsibilities.
Under the Infrastructure as a Service (IaaS) model, the customer manages the operating system, middleware, database configuration, and patching. The proposed VM setup aligns with these requirements.
To verify if the database VM setup violates or conforms to the cloud service model responsibility boundaries.
2
Evaluate the file share protocol and storage requirements.
Azure Files supports concurrent SMB access and offers a Cool tier, which fits the migration requirements for a shared network folder.
To confirm that Azure Files is the correct service for SMB-based concurrent access.
3
Examine the compliance logs storage tier characteristics.
The Archive tier of Azure Blob Storage provides the lowest storage cost, but its data is offline. Direct access/read requests fail immediately.
To determine whether the administrator's script can read the compliance log samples directly.
4
Evaluate the recovery/access process for the Archive tier.
To read the data, the blobs must first be rehydrated to an online tier (Hot, Cool, or Cold), which takes up to 15 hours for standard priority. Thus, direct reads will fail.
To form the final conclusion that the script will fail because of the Archive tier offline state.

Key Concept

Azure Storage Account service types, storage tiers (Archive rehydration), and IaaS shared responsibility model.
PreviousPage 7 / 60Next
All practice questions — Microsoft Azure Fundamentals (AZ-900) | Examkin