All practice questions

1186 questions

Question 401Question

During an Azure migration workshop, a team discusses the benefits of using Azure Resource Manager (ARM) templates and Bicep over manual cloud configuration. Which two statements describe the core characteristics or benefits of using these deployment templates?

Select all that apply

Show answer & explanation

Answer: They use declarative syntax to define what the resource infrastructure should look like without needing step-by-step commands.; They are idempotent, allowing the same deployment template to be run multiple times while maintaining the same target state.

Answer

The correct statements are that templates use declarative syntax to define the desired resource state and are idempotent, allowing them to be run multiple times safely.
The correct statements highlight that templates specify the target state using declarative syntax and can be safely redeployed due to their idempotent nature.

Step-by-Step Solution

1
Analyze the core features of Azure Resource Manager (ARM) templates and Bicep.
Identify that templates are declarative (defining the end-state) and idempotent (safe to run repeatedly).
This establishes the defining characteristics of Azure infrastructure-as-code tools.
2
Evaluate the distractors against Azure Resource Manager capabilities.
Determine that templates are not imperative and do not restrict all resources to a single region matching the resource group.
This rules out options describing procedural execution and strict region inheritance rules.

Key Concept

Azure Resource Manager Templates and Bicep Characteristics
Question 402Question

A retail corporation wants to link its centralized inventory management system at a physical headquarters to resources hosted within an Azure Virtual Network (VNet). The network engineers have specified two main requirements: a primary path that utilizes a dedicated private circuit for low latency without using the public internet, and a secondary backup path that secures data using encryption while routing over the public internet. Which two Azure services should the corporation deploy to satisfy these design requirements? (Select two.)

Select all that apply

Show answer & explanation

Answer: Azure ExpressRoute; Azure VPN Gateway

Answer

Azure ExpressRoute and Azure VPN Gateway are the two required services.
To satisfy the requirements, the organization must implement two distinct connectivity paths. The primary requirement for a private, dedicated connection is met by deploying Azure ExpressRoute. The backup requirement for an encrypted, cost-effective connection over the public internet is met by deploying Azure VPN Gateway.

Step-by-Step Solution

1
Analyze the primary connection requirement: a dedicated private circuit that bypasses the public internet.
Identify Azure ExpressRoute as the service that fulfills this criteria by offering dedicated, private connectivity.
ExpressRoute provides private connections to Azure cloud services without traversing the public internet.
2
Analyze the secondary connection requirement: a cost-effective backup connection that encrypts data over the public internet.
Identify Azure VPN Gateway as the service that fulfills this criteria.
VPN Gateway uses the public internet to transmit encrypted traffic securely at a lower cost compared to ExpressRoute.

Key Concept

Azure hybrid networking services including Virtual Networks, ExpressRoute, and VPN Gateway
Estimated Time:1m 30s
Question 403Question

An educational institution is launching an online registration portal. The application is packaged as a Docker container. The portal experiences sudden spikes in traffic during registration periods and requires automatic scaling and custom domain SSL bindings. The IT department has limited staff and wants to avoid the overhead of managing container clusters, node pools, or container orchestration workflows. Which Azure service should the organization select to meet these requirements?

Show answer & explanation

Answer: Azure App Service

Answer

Azure App Service
The correct answer is Azure App Service because it offers a fully managed platform (PaaS) for hosting containerized web applications. It provides built-in autoscaling, custom domain integration, and SSL bindings while completely abstracting infrastructure management, cluster nodes, and container orchestration.

Step-by-Step Solution

1
Identify the hosting requirements and operational constraints of the scenario.
The application is a containerized web portal that requires auto-scaling and custom domain SSL support, with a constraint to minimize cluster and infrastructure management.
This narrows down the potential Azure hosting services to those that support containers.
2
Compare Azure App Service, Azure Kubernetes Service, and Azure Container Instances against the constraints.
Azure App Service supports containerized web hosting with managed scaling and SSL, without requiring cluster management. Azure Kubernetes Service requires cluster/orchestrator configuration, and Azure Container Instances lacks native managed web-routing features.
This identifies the service that fulfills all functional requirements with the lowest management overhead.

Key Concept

Azure Container Instances, Azure Kubernetes Service, and Azure App Service
Estimated Time:1m 0s
Question 404Question

An administrator creates an Azure resource group named Dev-Web-RG. Is the following statement true or false?

To allow developers to manage existing resources in Dev-Web-RG, but prevent them from deploying other resource types (such as Virtual Machines) within that resource group, the administrator must assign the built-in Contributor role to the developers at the Dev-Web-RG scope.

Show answer & explanation

Answer: False

Answer

False
The statement is false because Azure RBAC built-in roles like Contributor grant permission to manage and create all types of resources at their scope. They cannot restrict the specific types of resources (like Virtual Machines) that can be deployed. To enforce resource type restrictions, Azure Policy must be used.

Step-by-Step Solution

1
Analyze the requirement to limit the creation of specific resource types (such as Virtual Machines).
Identify that restricting which resource types can be deployed is a compliance and governance policy limit, not a basic access control permission.
This determines whether Azure RBAC or Azure Policy is the correct service to use.
2
Evaluate the permissions granted by the built-in Contributor role in Azure RBAC.
The Contributor role allows users to create and manage all types of Azure resources within the assigned scope, but does not allow them to grant access to others.
Assigning the Contributor role alone will fail to prevent developers from creating Virtual Machines.
3
Identify the correct Azure service for enforcing resource deployment compliance.
Azure Policy is designed to enforce rules and effects over Azure resources, including restricting allowed resource types.
Azure Policy is the correct governance tool to prevent unauthorized resource types from being deployed, proving that the statement about using RBAC is false.

Key Concept

Azure RBAC vs. Azure Policy
Question 405Question

A company manages a hybrid environment with workloads running on both on-premises servers and Azure Virtual Machines. The operations team is establishing a monitoring and automated remediation plan to address the following administrative requirements:

1. Detect when a global Azure platform outage or planned infrastructure maintenance by Microsoft impacts the availability of their database hosting resources in the East US region.
2. Consolidate and query event log data from both the Azure Virtual Machines and the on-premises servers within a single workspace using a common query language.
3. Automatically trigger a virtual machine reboot if the CPU utilization of a specific database server exceeds 95%95\% for more than 1515 minutes.

Which combination of Azure services or features is required to meet these requirements?

Show answer & explanation

Answer: 1. Azure Service Health, 2. Log Analytics, 3. Azure Monitor Alerts with an action group

Answer

1. Azure Service Health, 2. Log Analytics, 3. Azure Monitor Alerts with an action group
The option containing '1. Azure Service Health, 2. Log Analytics, 3. Azure Monitor Alerts with an action group' is correct. Azure Service Health notifies you about Azure service outages and planned maintenance affecting your resources. Log Analytics workspaces consolidate and allow querying of logs from both Azure and on-premises hosts. Azure Monitor Alerts with action groups allow you to define metric thresholds (like CPU usage) and trigger automated remediations (like restarting a VM) when triggered.

Step-by-Step Solution

1
Evaluate Requirement 1 regarding platform outages and maintenance.
Identify that Azure Service Health is the dedicated service to track platform-wide outages and planned infrastructure maintenance that impact resources.
Azure Monitor Metrics/Logs only track telemetry of resources you own, not the global health of the underlying Azure platform.
2
Evaluate Requirement 2 regarding querying hybrid event log data in a single workspace.
Identify Log Analytics (Azure Monitor Logs) as the tool capable of aggregating and querying logs from both Azure VMs and on-premises physical servers using Kusto Query Language (KQL).
Log Analytics agents can be installed on non-Azure servers to stream event data to a centralized workspace.
3
Evaluate Requirement 3 regarding automatically rebooting a VM based on CPU threshold alerts.
Identify that Azure Monitor Alerts using an action group configured to run an automation runbook or webhook meets the automated remediation criteria.
Azure Policy is for governance and compliance, and cannot perform automated actions based on real-time metric evaluations.

Key Concept

Distinguishing between Azure Monitor (Metrics, Logs, and Alerts) and Azure Service Health for monitoring and remediation.
Estimated Time:2m 0s
Question 406Question

An organization is planning to store rarely accessed backup data in Azure. For this scenario, is the statement that the Archive access tier of Azure Blob Storage offers the lowest storage costs among all access tiers true or false?

Show answer & explanation

Answer: True

Answer

True
The statement is true because the Archive access tier of Azure Blob Storage provides the most cost-effective storage option for data that is rarely accessed and can tolerate retrieval latency, offering the lowest storage cost per gigabyte.

Step-by-Step Solution

1
Identify the storage requirements of the organization.
The organization needs to store rarely accessed backup data at the lowest possible cost.
Understanding the requirements allows selecting the correct storage tier.
2
Analyze the access tiers available for Azure Blob Storage.
Azure Blob Storage provides Hot, Cool, Cold, and Archive tiers. The Archive tier offers the lowest storage costs but has the highest access costs and retrieval times.
Evaluating options to find the most cost-effective solution.
3
Determine if the Archive tier matches the scenario's cost-saving goal.
Since the data is rarely accessed and cost is the priority, the Archive tier is the correct fit.
To confirm the truth of the statement.

Key Concept

Azure Blob Storage Access Tiers
Question 407Question

An organization is planning to migrate its workloads to the cloud. Is the following statement true or false?

The Azure Pricing Calculator is the primary tool used to estimate the cost savings of migrating an existing on-premises datacenter to Microsoft Azure.

Show answer & explanation

Answer: False

Answer

False
The correct answer is false because the tool used to compare on-premises infrastructure costs and calculate migration savings is the Total Cost of Ownership (TCO) Calculator. The Azure Pricing Calculator is only used to estimate the cost of new Azure services.

Step-by-Step Solution

1
Identify the goal of the organization in the scenario.
The goal is to estimate the cost savings of migrating an existing physical on-premises datacenter to Microsoft Azure.
Defining the objective determines whether we need to compare on-premises costs with cloud costs, or just estimate new cloud resource costs.
2
Evaluate the primary purpose of the Azure Pricing Calculator.
The Azure Pricing Calculator estimates costs for new cloud deployments of specific Azure services but does not model on-premises infrastructure costs.
This establishes that the Pricing Calculator cannot perform on-premises to cloud comparative analysis.
3
Identify the correct tool designed for migrating on-premises workloads.
The Azure Total Cost of Ownership (TCO) Calculator is the tool specifically built to compare on-premises costs (like hardware, electricity, and labor) with Azure costs to show migration savings.
This demonstrates that the statement attributes the migration comparison function to the wrong tool.

Key Concept

Distinction between the Azure Pricing Calculator and the Azure Total Cost of Ownership (TCO) Calculator
Question 408Question

An organization is planning to deploy different database workloads to Microsoft Azure. Match each Azure database service to its corresponding capability description.

Click a left item, then click its matching right item

Items

Azure Cosmos DB
Azure SQL Managed Instance
SQL Server on Azure Virtual Machines

Matches

Show answer & explanation

Answer

Azure Cosmos DB matches the multi-model database service for non-relational data. Azure SQL Managed Instance matches the fully managed relational database service supporting SQL Server agent without operating system access. SQL Server on Azure Virtual Machines matches the relational database deployment providing full administrative control over the operating system.
Azure Cosmos DB matches the multi-model database service because it is Azure's flagship globally distributed NoSQL database. Azure SQL Managed Instance matches the fully managed relational database service supporting SQL Server agent without operating system access because it acts as a PaaS database offering high compatibility with SQL Server engine features without OS management. SQL Server on Azure Virtual Machines matches the relational database deployment providing full administrative control over the operating system because it is an IaaS solution that places the entire VM under customer control.

Step-by-Step Solution

1
Identify the data model and management requirements of the workloads.
Separate the requirements into non-relational (NoSQL), managed relational (PaaS) with specific legacy feature support, and full OS-level control (IaaS).
Azure offers distinct database services optimized for relational versus non-relational data, as well as different levels of administrative management.
2
Map the non-relational workload requirements to the correct service.
Azure Cosmos DB is selected for its schema-less, multi-model, and globally distributed non-relational capabilities.
Cosmos DB is the primary Azure PaaS offering designed specifically for high-performance, non-relational datasets.
3
Differentiate between the two SQL Server relational deployment options based on administrative control.
SQL Server on Azure VMs maps to the option with full operating system access, while Azure SQL Managed Instance maps to the fully managed service without operating system access.
Virtual Machines represent Infrastructure as a Service (IaaS) where you retain OS access, whereas SQL Managed Instance is a Platform as a Service (PaaS) where Microsoft manages the OS.

Key Concept

Understanding the differences between Azure relational databases (Azure SQL Managed Instance, SQL Server on Azure VMs) and non-relational databases (Azure Cosmos DB), alongside IaaS versus PaaS management models.
Question 409Question

Azure Role-Based Access Control (RBAC) is used to control which properties and configurations can be deployed for a resource, whereas Azure Policy is used to manage which users and identities have access to those resources.

Show answer & explanation

Answer: False

Answer

The statement is false because Azure Role-Based Access Control (RBAC) controls user permissions, whereas Azure Policy enforces compliance and configuration standards on Azure resources.
The statement is false because it reverses the definitions of RBAC and Azure Policy. RBAC regulates user actions and access, whereas Azure Policy governs resource properties and configuration compliance.

Step-by-Step Solution

1
Define the purpose of Azure Role-Based Access Control (RBAC).
RBAC manages access to Azure resources by determining who (users, groups, service principals) can perform what actions.
This establishes that RBAC is focused on user access management.
2
Define the purpose of Azure Policy.
Azure Policy evaluates and enforces standards on resource properties to ensure compliance with corporate rules.
This establishes that Azure Policy is focused on resource configuration management.
3
Compare the statement's description with the actual purposes of both services.
The statement incorrectly claims RBAC manages resource configurations and Azure Policy manages user access, which is the exact opposite of their roles.
This comparison identifies the statement as false.

Key Concept

Difference between Azure RBAC and Azure Policy
Question 410Question

A system administrator is evaluating command-line tools for managing Azure resources locally on their workstation. Which of the following statements are correct regarding the capabilities and platform support of both Azure CLI and Azure PowerShell? (Select TWO)

Select all that apply

Show answer & explanation

Answer: Both tools can be installed and executed locally on Windows, macOS, and Linux operating systems.; Both tools support interactive command execution and scripting to automate Azure resource management.

Answer

Both tools can be installed and executed locally on Windows, macOS, and Linux operating systems, and both tools support interactive command execution and scripting to automate Azure resource management.
The correct statements describe the cross-platform nature and dual usage modes of both Azure CLI and Azure PowerShell. Both tools can be installed locally on Windows, macOS, and Linux, and both support both interactive execution and scripting.

Step-by-Step Solution

1
Identify the installation capabilities of Azure CLI and Azure PowerShell.
Both tools are cross-platform and can be installed locally on Windows, macOS, and Linux.
Microsoft designed both command-line tools to be cross-platform to accommodate administrators using different operating systems.
2
Determine the operational modes of both tools.
Both tools support both interactive commands and automated scripting.
Administrators can run individual commands interactively or save sequences of commands as scripts (.sh or .ps1) for automation.
3
Evaluate the requirement for storage and web browsers.
Neither tool requires a browser or a storage account for local execution.
Local CLI and PowerShell tools run directly in the OS shell and connect to Azure APIs over the network, unlike the browser-based Cloud Shell which needs Azure Storage to persist files.

Key Concept

Azure command-line management tools (Azure CLI and Azure PowerShell) features and cross-platform compatibility.
Estimated Time:1m 30s
Question 411Question

An enterprise hosts a mission-critical transactional database on Azure Virtual Machines. The operations team wants to identify which of these virtual machines lack backup configurations to protect against accidental data loss and to ensure business continuity. Which Azure tool should the administrator use to obtain proactive, personalized recommendations for enabling virtual machine backups?

Show answer & explanation

Answer: Azure Advisor

Answer

Azure Advisor
Azure Advisor evaluates your resource configuration and telemetry data to provide personalized, actionable recommendations across five categories: Cost, Security, Reliability, Performance, and Operational Excellence. Enabling backups for virtual machines is a key recommendation within the Reliability category.

Step-by-Step Solution

1
Analyze the requirement to find proactive recommendations for resource reliability and data protection.
Identify that enabling backups for virtual machines directly addresses reliability and business continuity.
Understanding the core requirement points to cloud best practices.
2
Evaluate the management tools that provide configuration recommendations based on best practices.
Recognize that Azure Advisor is the dedicated tool for personalized best-practice recommendations across cost, security, reliability, performance, and operational excellence.
Differentiating tool boundaries determines the correct service.

Key Concept

Azure Advisor provides personalized recommendations based on best practices across five pillars, including Reliability.
Question 412Question

A financial analytics firm plans to deploy a new system on Azure consisting of two distinct workloads:

1. A customer-facing web application that requires a managed platform where Microsoft automatically handles operating system patching and runtime updates.
2. A lightweight, short-running background job packaged as a single Docker container that runs on demand, without the need for service discovery, load balancing, or active container orchestration.

Which two Azure services should the firm select to host these workloads?

Select all that apply

Show answer & explanation

Answer: Azure App Service; Azure Container Instances

Answer

Azure App Service and Azure Container Instances
The customer-facing web application is best hosted on Azure App Service because it is a Platform as a Service (PaaS) offering where Microsoft manages the underlying OS patching, provisioning, and updates. The lightweight, short-running containerized background job is best hosted on Azure Container Instances (ACI) because it allows running a single container on demand without the management overhead or complexity of a full container orchestrator.

Step-by-Step Solution

1
Analyze the web application requirements.
The web application requires a fully managed platform where Microsoft takes care of OS-level patching.
Identify Platform as a Service (PaaS) compute options. Azure App Service fits this by allowing code or container deployment with zero OS management.
2
Analyze the background job requirements.
The background job runs in a single Docker container, executes quickly on demand, and does not need container orchestration features.
Identify container hosting options. Azure Container Instances (ACI) is designed for quickly running single containers without orchestrator complexity.

Key Concept

Azure App Service, Azure Container Instances (ACI), and Azure Kubernetes Service (AKS) differences and use cases.
Estimated Time:1m 0s
Question 413Question

An organization hosts a multi-container web application on Azure. The IT team needs to implement a monitoring solution that allows them to perform both of the following actions:

1. Detect and diagnose performance bottlenecks and exceptions within the web application's application code.
2. Consolidate and run custom query analysis on container system logs across multiple resource groups.

Which two features of Azure Monitor should the team use to meet these requirements?

Select all that apply

Show answer & explanation

Answer: Application Insights; Log Analytics workspaces

Answer

Application Insights and Log Analytics workspaces
The correct features are Application Insights and Log Analytics workspaces. Application Insights is specifically designed to monitor live application code and diagnose performance bottlenecks and exceptions. Log Analytics workspaces serve as the central repository where logs from various sources (such as containers) are stored and queried using Kusto Query Language (KQL).

Step-by-Step Solution

1
Identify the requirement to monitor and diagnose issues within the application code.
Determine that Application Insights is the Azure Monitor feature designed for application performance management (APM) and code-level diagnostics.
Application Insights collects telemetry data such as exceptions, response times, and page views from running apps.
2
Identify the requirement to consolidate and query container system logs across multiple resource groups.
Determine that a Log Analytics workspace is the centralized repository in Azure Monitor where log data is stored and queried using Kusto Query Language (KQL).
Log Analytics allows querying logs aggregated from various infrastructure sources, including container logs.

Key Concept

Azure Monitor features and use cases
Question 414Question

A company needs to collect, analyze, and act on telemetry data from their Azure Virtual Machines, including CPU usage and memory utilization, to ensure the VMs are running efficiently. Which service should the company use to meet these requirements?

Show answer & explanation

Answer: Azure Monitor

Answer

Azure Monitor
Azure Monitor is designed to collect, analyze, and act on telemetry data from both cloud and on-premises environments. It helps you understand how your applications are performing and proactively identifies issues affecting them and the resources they depend on, such as CPU and memory utilization.

Step-by-Step Solution

1
Analyze the business requirement which focuses on collecting, analyzing, and acting on telemetry data (such as CPU and memory utilization) of specific Azure resources.
Identify that the task requires resource-level performance monitoring and alerting.
This narrows down the choice to services that track resource metrics and logs.
2
Compare the available Azure services to find which one tracks resource-level telemetry.
Azure Monitor is the native tool for resource telemetry, while Azure Service Health tracks global/regional service outages, Azure Policy handles compliance, and RBAC handles authorization.
Azure Monitor is the only service that fulfills the requirement of tracking specific resource CPU and memory metrics.

Key Concept

Azure Monitor
Estimated Time:45s
Question 415Question

A database administrator needs to estimate the monthly cost of running a new Azure SQL Database and two Azure Storage accounts before creating the resources. Which tool should the database administrator use?

Show answer & explanation

Answer: Azure Pricing Calculator

Answer

Azure Pricing Calculator
The Azure Pricing Calculator is the correct tool because it allows users to estimate the monthly costs of new Azure services (such as Azure SQL Database and Azure Storage accounts) by configuring specific options like region, tier, and capacity before any resources are actually created.

Step-by-Step Solution

1
Analyze the business requirement to identify whether it involves estimating costs for new, undeployed cloud services or comparing on-premises migration costs.
The requirement is to estimate monthly costs for a new Azure SQL Database and two Azure Storage accounts before creation.
This establishes that the tool needed must support upfront configuration and pricing estimates for specific cloud-native resources.
2
Select the correct Azure tool that matches the requirement for pre-deployment pricing estimation of individual services.
The Azure Pricing Calculator is selected.
The Azure Pricing Calculator is the designated tool for configuring services and generating monthly cost estimates before deploying resources, whereas the TCO Calculator compares on-premises to cloud migration.

Key Concept

Distinction between the Azure Pricing Calculator and the Azure TCO Calculator
Question 416Question

An administrator assigns a new Azure Policy definition that prevents the creation of SQL databases unless they use a specific collation. The subscription already contains several SQL databases that do not use this collation. What effect will the new policy have on the existing databases?

Show answer & explanation

Answer: The existing databases remain unchanged but are flagged as non-compliant in the Azure Policy dashboard.

Answer

The existing databases remain unchanged but are flagged as non-compliant in the Azure Policy dashboard.
When a new Azure Policy is assigned, it evaluates existing resources and marks any that do not meet the criteria as non-compliant. It does not retroactively modify or delete them.

Step-by-Step Solution

1
Analyze the policy enforcement behavior on existing resources.
When a new Azure Policy is assigned, it does not retroactively delete or modify existing resources that violate the policy rules.
This prevents unexpected resource modification or deletion in production environments.
2
Determine how non-compliant existing resources are tracked.
Existing resources are evaluated against the new policy definition and marked as non-compliant in the compliance dashboard.
This allows administrators to identify compliance gaps without impacting active workloads.

Key Concept

Azure Policy compliance evaluation and enforcement behavior on existing resources
Estimated Time:45s
Question 417Question

A company has an Azure environment with a management group named Tenant-MG. Under Tenant-MG, there is a subscription named Enterprise-Sub, which contains a resource group named App-RG.

An administrator needs to assign permissions to a developer named Jordan. Jordan must be able to view all resources across the entire Enterprise-Sub subscription, but must only be able to create and manage resources within App-RG.

Which combination of role assignments should the administrator configure?

Show answer & explanation

Answer: Assign Jordan the Reader role at the Enterprise-Sub scope, and the Contributor role at the App-RG scope.

Answer

Assign Jordan the Reader role at the Enterprise-Sub scope, and the Contributor role at the App-RG scope.
Assigning the Reader role at the subscription scope (Enterprise-Sub) ensures that the permissions inherit down to all resource groups and resources within that subscription, allowing the user to view everything. Assigning the Contributor role at the resource group scope (App-RG) grants the necessary permissions to create and manage resources specifically within that resource group. Since Azure RBAC permissions are additive, the user will have Contributor access in App-RG and Reader access elsewhere in the subscription.

Step-by-Step Solution

1
Analyze the read-only requirement.
Determine the appropriate scope and role for viewing all subscription resources.
To grant read access across the entire subscription, the Reader role should be assigned at the subscription scope (Enterprise-Sub). This permission inherits down to all resource groups and resources within that subscription.
2
Analyze the write/management requirement.
Determine the appropriate scope and role for resource creation and management.
To restrict resource creation and management to a single resource group, the Contributor role should be assigned at the resource group scope (App-RG).
3
Combine the roles using Azure RBAC inheritance and additive rules.
The final permission set allows Jordan to view all resources in the subscription and manage resources within App-RG.
Azure RBAC permissions are additive. When Jordan accesses App-RG, the inherited Reader role and the direct Contributor role combine, giving Jordan Contributor rights inside App-RG, while retaining only Reader rights elsewhere in the subscription.

Key Concept

Azure RBAC scopes, built-in roles, and permission inheritance
Question 418Question

A software development team is designing a telemetry ingestion system. The system requires a globally distributed database that can store unstructured JSON documents and support MongoDB API compatibility. A team member suggests deploying Azure SQL Database for this workload. Why is this suggestion incorrect?

Show answer & explanation

Answer: Azure SQL Database is a relational database engine that does not natively support NoSQL features like MongoDB API compatibility.

Answer

Azure SQL Database is a relational database engine that does not natively support NoSQL features like MongoDB API compatibility.
The option stating that Azure SQL Database is a relational database engine that does not natively support MongoDB API compatibility is correct because Azure SQL Database is designed for relational data and does not support NoSQL APIs like MongoDB API. To get MongoDB API compatibility, Azure Cosmos DB should be used instead.

Step-by-Step Solution

1
Analyze the requirements for the telemetry ingestion system.
The workload requires global distribution, unstructured JSON document storage, and MongoDB API compatibility.
Identifying the data model and API requirements is necessary to evaluate the suitability of the proposed database service.
2
Evaluate the suggested service (Azure SQL Database) against the requirements.
Azure SQL Database is a relational database service and does not support NoSQL database APIs like MongoDB API.
This shows that the suggested service does not meet the core application requirements.
3
Select the correct option detailing the mismatch.
The option explaining that Azure SQL Database is a relational engine lacking NoSQL MongoDB API compatibility is correct.
This accurately identifies why Azure SQL Database is the wrong choice for a MongoDB workload.

Key Concept

Azure SQL Database is a relational database service, whereas Azure Cosmos DB is a multi-model NoSQL database service supporting APIs like MongoDB API.
Estimated Time:1m 0s
Question 419Question

A company plans to store archival data in Azure Blob Storage. The data will be accessed less than once a year, and a retrieval latency of several hours is acceptable. The company wants to minimize storage costs. Which storage access tier should they use?

Show answer & explanation

Answer: The Archive tier, which offers the lowest storage cost but requires data rehydration before it can be read.

Answer

The Archive tier, which offers the lowest storage cost but requires data rehydration before it can be read.
The Archive tier is designed for data that is rarely accessed and can tolerate retrieval latency. It offers the lowest storage costs among all Azure Blob Storage tiers, but the data must be rehydrated to a Hot or Cool tier before it can be read.

Step-by-Step Solution

1
Identify the data access frequency and retrieval time tolerance.
The scenario specifies that the data is accessed less than once a year and a retrieval time of several hours is acceptable.
This matches the characteristics of the Archive access tier, which is optimized for rarely accessed data with high latency tolerance.
2
Determine the most cost-effective storage tier that meets these requirements.
The Archive tier offers the lowest storage cost compared to the Hot and Cool tiers.
Choosing the Archive tier minimizes storage costs for long-term data retention.
3
Understand the access mechanism for the chosen tier.
Data in the Archive tier cannot be read directly and must be rehydrated to the Hot or Cool tier first.
This is a technical requirement of the Archive access tier in Azure Blob Storage.

Key Concept

Azure Storage access tiers (Hot, Cool, Cold, Archive) and their access requirements.
Estimated Time:1m 0s
Question 420Question

Azure Monitor is the primary service used to track global Azure infrastructure outages and planned maintenance events that affect Azure services.

Show answer & explanation

Answer: False

Answer

The statement is false. Azure Service Health is the service used to track global service outages and planned maintenance, whereas Azure Monitor is used to collect and analyze telemetry data from individual resources.
The statement is false because Azure Service Health, not Azure Monitor, is the service designed to track global Azure service outages and planned maintenance. Azure Monitor focuses on collecting and analyzing telemetry data from your specific resources.

Step-by-Step Solution

1
Analyze the service mentioned in the statement: Azure Monitor.
Azure Monitor is responsible for collecting, analyzing, and acting on telemetry data (metrics and logs) from your specific Azure resources, such as CPU usage on a Virtual Machine.
To determine if its primary purpose matches the tracking of global service outages.
2
Compare this with the service responsible for global outages and planned maintenance.
Azure Service Health is the service that provides notifications and guidance about Azure service outages, planned maintenance, and other health advisories.
To identify the correct service for the described scenario.
3
Evaluate the truth value of the statement.
Since the statement attributes the tracking of global service outages to Azure Monitor instead of Azure Service Health, the statement is false.
To formulate the final answer.

Key Concept

Azure Monitor vs. Azure Service Health
Estimated Time:45s
PreviousPage 21 / 60Next
All practice questions — Microsoft Azure Fundamentals (AZ-900) | Examkin