Free AZ-305 Exam Braindumps
Designing Microsoft Azure Infrastructure Solutions Questions 1–67 (page: 37)

Updated On: 16-Nov-2026
View Related Case Study

Your company has 50 business units across the globe. The business units operate from 08:00 AM to 06:00 PM from Monday to Friday in their local time zone. Transactions are only processed during business hours.
You have an Azure subscription.
You plan to deploy an app named App1 that will manage the transactions for the business units. App1 will use a separate Azure SQL database for each business unit.
You need to recommend an Azure SQL Database configuration for App1. The solution must meet the following requirements:
-Support Azure Hybrid Benefit licensing.
-Minimize costs.
What should you recommend?

  1. a vCore purchasing model and multiple single database instances
  2. a DTU purchasing model and multiple single database instances
  3. a vCore purchasing model and multiple database instances in an elastic pool
  4. a DTU purchasing model and multiple database instances in an elastic pool

Answer(s): C

Explanation:

Compare vCore and DTU purchasing models
The vCore purchasing model used by Azure SQL Database provides several benefits over the DTU-based purchasing model:
* Higher compute, memory, I/O, and storage limits.
* Choice of hardware configuration to better match compute and memory requirements of the workload. *-> Pricing discounts for Azure Hybrid Benefit (AHB).
* Etc.
Note: Azure Elastic Pools:
* A deployment option that allows you to share a pool of resources (such as CPU, memory, and storage) across multiple databases.
*-> Ideal for scenarios where you have multiple databases with varying levels of usage, and you want to optimize resource utilization and reduce costs.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore https://learn.microsoft.com/en-us/answers/questions/1523610/diff-between-azure-elastic-pools-and-standalone -db



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an Azure-based global media processing solution that generates JSON telemetry files and application logs. Data engineers query the files and logs by using Apache Hadoop-compatible batch analytics jobs.
Background thumbnail generation is implemented as asynchronous workers that read pending work items.
You need to recommend a storage solution for each workload component. The solution must ensure that all data be stored by using Azure services.
What should you recommend? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Azure Data Lake Storage Gen2
Azure Queue Storage
Azure Data Lake Storage Gen2 provides Hadoop-compatible access through the Azure Blob File System (ABFS) driver. Its hierarchical namespace and analytics-optimized storage support batch processing of JSON files and application logs.
Azure Queue Storage stores pending work as messages that asynchronous workers retrieve and process. It decouples work submission from thumbnail generation and buffers backlogs when incoming demand exceeds processing capacity.


Reference:

https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-introduction https://learn.microsoft.com/en-us/azure/storage/queues/storage-performance-checklist



View Related Case Study

You are planning an Azure IoT Hub solution that will include 50,000 IoT devices.
Each device will stream data, including temperature, device ID, and time data. Approximately 50,000 records will be written every second. The data will be visualized in near real time.
You need to recommend a service to store and query the data.
Which two services can you recommend? Each correct answer presents a complete solution.
Note: Each correct selection is worth one point.

  1. Azure Table Storage
  2. Azure Event Grid
  3. Azure Cosmos DB for NoSQL
  4. Azure Time Series Insights

Answer(s): C,D

Explanation:

D: Time Series Insights is a fully managed service for time series data. In this architecture, Time Series Insights performs the roles of stream processing, data store, and analytics and reporting. It accepts streaming data from either IoT Hub or Event Hubs and stores, processes, analyzes, and displays the data in near real time.
C: The processed data is stored in an analytical data store, such as Azure Data Explorer, HBase, Azure Cosmos DB, Azure Data Lake, or Blob Storage.


Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/scenarios/time-series



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
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:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



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-app lication-gateway



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
How should the migrated databases DB1 and DB2 be implemented in Azure?
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



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



Viewing page 37 of 78
Viewing questions 181 - 185 out of 382 questions


Post your Comments and Discuss Microsoft AZ-305 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!