You need to design a highly available Azure SQL database that meets the following requirements:
• Failover between replicas of the database must occur without any data loss.
• The database must remain available in the event of a zone outage.
• Costs must be minimized.
Which deployment option should you use?
A. Azure SQL Managed Instance General Purpose
B. Azure SQL Database Hyperscale
C. Azure SQL Database Premium
D. Azure SQL Managed Instance Business Critical
Show Answer
Correct Answer: C
Explanation: Azure SQL Database Premium provides built-in high availability with synchronous replicas, ensuring zero data loss (RPO = 0) during failover. It also supports zone-redundant deployments, allowing the database to remain available during an availability zone outage. Compared to Business Critical Managed Instance and Hyperscale, Premium meets the requirements while generally offering a lower cost for a single database scenario, satisfying the cost-minimization requirement.
Question 64
You are developing a sales application that will contain several Azure cloud services and handle different components of a transaction. Different cloud services will process customer orders, billing, payment, inventory, and shipping.
You need to recommend a solution to enable the cloud services to asynchronously communicate transaction information by using XML messages.
What should you include in the recommendation?
A. Azure Service Fabric
B. Azure Queue Storage
C. Azure Traffic Manager
D. Azure Application Gateway
Show Answer
Correct Answer: B
Explanation: Azure Queue Storage is designed for asynchronous communication between distributed components. It allows different cloud services (orders, billing, payment, inventory, shipping) to exchange messages reliably and independently, decoupling the services. Queue messages can carry XML payloads and are processed asynchronously, which matches the requirement. The other options handle orchestration, traffic routing, or load balancing rather than asynchronous messaging.
Question 65
You are developing a sales application that will contain several Azure cloud services and handle different components of a transaction. Different cloud services will process customer orders, billing, payment, inventory, and shipping.
You need to recommend a solution to enable the cloud services to asynchronously communicate transaction information by using XML messages.
What should you include in the recommendation?
A. Azure Application Gateway
B. Azure Queue Storage
C. Azure Data Lake
D. Azure Traffic Manager
Show Answer
Correct Answer: B
Explanation: Azure Queue Storage is designed for asynchronous messaging between application components. It allows different cloud services to exchange messages (including XML payloads) reliably and independently, which fits a distributed transaction workflow such as orders, billing, payment, inventory, and shipping. The other options focus on traffic routing, data analytics storage, or load balancing rather than asynchronous message-based communication.
Question 66
You need to recommend a solution to generate a monthly report of all the new Azure Resource Manager (ARM) resource deployments in your Azure subscription.
What should you include in the recommendation?
A. Azure Arc
B. Azure Log Analytics
C. Application insights
D. Azure Monitor action groups
Show Answer
Correct Answer: B
Explanation: Azure Log Analytics can collect and query Azure Activity Log and Resource Manager deployment logs, allowing you to identify and report on newly deployed ARM resources over a given time period. Using Log Analytics workspaces and Kusto queries, you can generate scheduled or monthly reports. The other options do not provide centralized querying and reporting of ARM deployment events.
Question 67
You need to design a highly available Azure SQL database that meets the following requirements:
• Failover between replicas of the database must occur without any data loss.
• The database must remain available in the event of a zone outage.
• Costs must be minimized.
Which deployment option should you use?
A. Azure SQL Database Business Critical
B. Azure SQL Database Basic
C. Azure SQL Managed Instance General Purpose
D. Azure SQL Database Hyperscale
Show Answer
Correct Answer: A
Explanation: Azure SQL Database Business Critical uses synchronous replicas with Always On availability groups, providing zero data loss failover. It supports zone-redundant configurations to remain available during an availability zone outage, and among options that meet these requirements it is the most cost-effective. Other options either lack zone redundancy, use asynchronous replication, or are more expensive.
Question 68
You are developing a sales application that will contain several Azure cloud services and handle different components of a transaction. Different cloud services will process customer orders, billing, payment, inventory, and shipping.
You need to recommend a solution to enable the cloud services to asynchronously communicate transaction information by using XML messages.
What should you include in the recommendation?
A. Azure Notification Hubs
B. Azure Service Bus
C. Azure Blob Storage
D. Azure Service Fabric
Show Answer
Correct Answer: B
Explanation: Azure Service Bus is designed for reliable, asynchronous messaging between distributed cloud services. It supports message queues and topics, enables decoupled communication, and can carry structured payloads such as XML, making it ideal for coordinating transaction components like orders, billing, payment, inventory, and shipping.
Question 69
You are developing a sales application that will contain several Azure cloud services and handle different components of a transaction. Different cloud services will process customer orders, billing, payment, inventory, and shipping.
You need to recommend a solution to enable the cloud services to asynchronously communicate transaction information by using XML messages.
What should you include in the recommendation?
A. Azure Blob Storage
B. Azure Data Lake
C. Azure Queue Storage
D. Azure Service Fabric
Show Answer
Correct Answer: C
Explanation: The requirement is for asynchronous communication between multiple cloud services using messages. Azure Queue Storage is designed for decoupled, asynchronous message-based communication and can carry XML payloads reliably between services. Blob Storage and Data Lake are for storage and analytics, not messaging, and Service Fabric is an application hosting platform rather than a messaging service.
Question 70
You need to design a highly available Azure SQL database that meets the following requirements:
• Failover between replicas of the database must occur without any data loss.
• The database must remain available in the event of a zone outage.
• Costs must be minimized.
Which deployment option should you use?
A. Azure SQL Database Serverless
B. Azure SQL Managed Instance General Purpose
C. Azure SQL Database Basic
D. Azure SQL Database Business Critical
Show Answer
Correct Answer: D
Explanation: The requirements specify zero data loss on failover and availability during an availability zone outage, while minimizing cost. Azure SQL Database Business Critical uses synchronous replication with Always On availability groups, guaranteeing no data loss during failover. It also supports zone-redundant deployments, keeping the database available if a zone fails. Other options (Basic, General Purpose, Serverless) rely on single replicas with remote storage or asynchronous mechanisms and do not guarantee zero data loss or zone-level resiliency. Business Critical is therefore the lowest-cost option that satisfies all requirements.
Question 71
Your company has the divisions shown in the following table.
Sub1 contains an Azure App Service web app named App1. App1 uses Azure AD for single-tenant user authentication. Users from contoso.com can authenticate to App1.
You need to recommend a solution to enable users in the fabrikam.com tenant to authenticate to App1.
What should you recommend?
A. Configure Azure AD Identity Protection.
B. Configure assignments for the fabrikam.com users by using Azure AD Privileged Identity Management (PIM).
C. Configure Supported account types in the application registration and update the sign-in endpoint.
D. Configure a Conditional Access policy.
Show Answer
Correct Answer: C
Explanation: App1 is currently configured as a single-tenant Azure AD application, which only allows users from the contoso.com tenant to sign in. To enable users from the fabrikam.com tenant, the app must be configured to support multi-tenant access. This is done by changing the Supported account types in the app registration to allow accounts in any organizational directory and updating the sign-in endpoint accordingly. The other options (Identity Protection, PIM, Conditional Access) do not enable cross-tenant authentication.
Question 72
You need to recommend a solution to generate a monthly report of all the new Azure Resource Manager (ARM) resource deployments in your Azure subscription.
What should you include in the recommendation?
A. Azure Arc
B. Azure Monitor metrics
C. Azure Advisor
D. Azure Log Analytics
Show Answer
Correct Answer: D
Explanation: To generate a monthly report of new ARM resource deployments, you need access to deployment and activity logs that record resource creation events over time. Azure Log Analytics can ingest Azure Activity Logs, store them centrally, and allow querying and reporting (for example, by month) using Kusto queries. The other options do not provide detailed, queryable deployment history suitable for reporting.
$19
Get all 273 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.