Designing Microsoft Azure Infrastructure Solutions232 questions across 24 pages are complete and free, with no account or card.
232 questions in this bank
Free access · progress saved on this device
You need to recommend a data storage strategy for WebApp1. What should you include in the recommendation?
Answer: D
vCore-based Azure SQL database -- because the case states they want to use Azure Hybrid Benefit licensing. You cannot utilize that with the DTU model.
Source: Adapted from community discussion — jellybiscuit
HOTSPOT - You plan to migrate DB1 and DB2 to Azure. You need to ensure that the Azure database and the service tier meet the resiliency and business requirements. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Box 1: An Azure SQL Database elastic pool Scenario: * Resiliency Requirements. Once migrated to Azure, DB1 and DB2 must meet the following requirements: Maintain availability if two availability zones in the local Azure region fail. Fail over automatically. Minimize I/O latency. * Litware identifies the following business requirements: Minimize administrative effort. Minimize costs. Box 2: Business Critical
Source: Adapted from community discussion — NotMeAnyWay
DRAG DROP - You need to recommend a solution that meets the file storage requirements for App2. What should you deploy to the Azure subscription and the on-premises network? To answer, drag the appropriate services to the correct locations. Each service may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Box 1: Azure Files - Scenario: App2 has the following file storage requirements: ✑ Save files to an Azure Storage account. ✑ Replicate files to an on-premises location. ✑ Ensure that on-premises clients can read the files over the LAN by using the SMB protocol. Box 2: Azure File Sync - Use Azure File Sync to centralize your organization's file shares in Azure Files, while keeping the flexibility, performance, and compatibility of an on-premises file server. Azure File Sync transforms Windows Server into a quick cache of your Azure file share. You can use any protocol that's available on Windows Server to access your data locally, including SMB, NFS, and FTPS. You can have as many caches as you need across the world. Reference: https://docs.microsoft.com/en-us/azure/storage/file-sync/file-sync-deployment-guide
Source: Adapted from community discussion — airmancompsci
You need to recommend a solution that meets the data requirements for App1. What should you recommend deploying to each availability zone that contains an instance of App1?
Answer: A
A. an Azure Cosmos DB that uses multi-region writes Explanation: The data requirements for App1 specify that each instance will write data to a data store in the same availability zone, and that data written by any App1 instance must be visible to all App1 instances. Azure Cosmos DB with multi-region writes is a globally distributed database service. It allows you to read and write data (with automatic failover) in the region closest to the users, providing both low latency and high availability. This meets the requirements of App1, as it ensures that data written by any instance is visible to all instances regardless of the region. Azure Data Lake and Azure Storage with GZRS do not natively support this type of active-active data replication across multiple regions.
Source: Adapted from community discussion — NotMeAnyWay
HOTSPOT - You are evaluating whether to use Azure Traffic Manager and Azure Application Gateway to meet the connection requirements for App1. What is the minimum numbers of instances required for each service? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Box 1: 1 - App1 will only be accessible from the internet. App1 has the following connection requirements: ג€¢ Connections to App1 must be active-active load balanced between instances. ג€¢ All connections to App1 from North America must be directed to the East US region. All other connections must be directed to the West Europe region. App1 will have six instances: three in the East US Azure region and three in the West Europe Azure region. Note: Azure Traffic Manager is a DNS-based traffic load balancer. This service allows you to distribute traffic to your public facing applications across the global Azure regions. Box 2: 2 - For production workloads, run at least two gateway instances. A single Application Gateway deployment can run multiple instances of the gateway. Use one Application Gateway in East US Region, and one in the West Europe region. Reference: https://docs.microsoft.com/en-us/azure/architecture/high-availability/reference-architecture-traffic-manager-application-gateway
Source: Adapted from community discussion — Lazylinux
HOTSPOT - How should the migrated databases DB1 and DB2 be implemented in Azure? Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Box 1: SQL Managed Instance - Scenario: Once migrated to Azure, DB1 and DB2 must meet the following requirements: ✑ Maintain availability if two availability zones in the local Azure region fail. ✑ Fail over automatically. ✑ Minimize I/O latency. The auto-failover groups feature allows you to manage the replication and failover of a group of databases on a server or all databases in a managed instance to another region. It is a declarative abstraction on top of the existing active geo-replication feature, designed to simplify deployment and management of geo- replicated databases at scale. You can initiate a geo-failover manually or you can delegate it to the Azure service based on a user-defined policy. The latter option allows you to automatically recover multiple related databases in a secondary region after a catastrophic failure or other unplanned event that results in full or partial loss of the SQL Database or SQL Managed Instance availability in the primary region. Box 2: Business critical - SQL Managed Instance is available in two service tiers: General purpose: Designed for applications with typical performance and I/O latency requirements. Business critical: Designed for applications with low I/O latency requirements and minimal impact of underlying maintenance operations on the workload. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview
Source: Adapted from community discussion — GarryK
HOTSPOT - You design a solution for the web tier of WebApp1 as shown in the exhibit.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Box 1: Yes - Any new deployments to Azure must be redundant in case an Azure region fails. Traffic Manager is resilient to failure, including the failure of an entire Azure region. Box 2: No - Traffic Manager provides load balancing, but not auto-scaling. Box 3: No - Automatic failover using Azure Traffic Manager: when you have complex architectures and multiple sets of resources capable of performing the same function, you can configure Azure Traffic Manager (based on DNS) to check the health of your resources and route the traffic from the non-healthy resource to the healthy resource. Reference: https://docs.microsoft.com/en-us/azure/traffic-manager/traffic-manager-overview https://docs.microsoft.com/en-us/azure/networking/disaster-recovery-dns-traffic-manager
Source: Adapted from community discussion — ezfix
You have 100 servers that run Windows Server 2012 R2 and host Microsoft SQL Server 2014 instances. The instances host databases that have the following characteristics: ✑ Stored procedures are implemented by using CLR. ✑ The largest database is currently 3 TB. None of the databases will ever exceed 4 TB. You plan to move all the data from SQL Server to Azure. You need to recommend a service to host the databases. The solution must meet the following requirements: ✑ Whenever possible, minimize management overhead for the migrated databases. ✑ Ensure that users can authenticate by using Azure Active Directory (Azure AD) credentials. ✑ Minimize the number of database changes required to facilitate the migration. What should you include in the recommendation?
Answer: B
Answer is B. Azure SQL Database (single or elastic) does not support CLR and we need to minimize management (managed vs no managed) https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql Both support 3gb size. https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-general-purpose?view=azuresql
Source: Adapted from community discussion — Gowind
You are designing an application that will aggregate content for users. You need to recommend a database solution for the application. The solution must meet the following requirements: ✑ Support SQL commands. ✑ Support multi-master writes. ✑ Guarantee low latency read operations. What should you include in the recommendation?
Answer: A
A is the answer. https://learn.microsoft.com/en-us/azure/cosmos-db/introduction#key-benefits - Gain unparalleled SLA-backed speed and throughput, fast global access, and instant elasticity. Real-time access with fast read and write latencies globally, and throughput and consistency all backed by SLAs - Multi-region writes and data distribution to any Azure region with just a button.
Source: Adapted from community discussion — zellck
HOTSPOT - You have an Azure subscription that contains the SQL servers on Azure shown in the following table.
The subscription contains the storage accounts shown in the following table.
You create the Azure SQL databases shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Box 1: Yes - Auditing works fine for a Standard account. Box 2: No - Auditing limitations: Premium storage is currently not supported. Box 3: No - Auditing limitations: Premium storage is currently not supported. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview#auditing-limitations
Source: Adapted from community discussion — jkklim
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
AZ-305 practice, question 61. 232 questions available.
Version 1.0.0. How we source questions