Free AZ-305 Exam Braindumps
Designing Microsoft Azure Infrastructure Solutions Questions 96–100 (page: 21)

Updated On: 10-Feb-2026

HOTSPOT (Drag and Drop is not supported)

You need to design a storage solution for an app that will store large amounts of frequently used data. The solution must meet the following requirements:

Maximize data throughput.

Prevent the modification of data for one year.

Minimize latency for read and write operations.

Which Azure Storage account type and storage service 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:



Box 1: BlockBlobStorage
Block Blob is a premium storage account type for block blobs and append blobs. Recommended for scenarios with high transactions rates, or scenarios that use smaller objects or require consistently low storage latency.

Box 2: Blob
Immutable storage for Azure Blob Storage enables users to store business-critical data in a WORM (Write Once, Read Many) state.
While in a WORM state, data cannot be modified or deleted for a user-specified interval. By configuring immutability policies for blob data, you can protect your data from overwrites and deletes.


Reference:

https://docs.microsoft.com/en-us/azure/storage/blobs/archive-blob https://docs.microsoft.com/en-us/azure/storage/blobs/immutable-storage-overview



HOTSPOT (Drag and Drop is not supported)

You have an Azure subscription that contains the storage accounts shown in the following table.



You plan to implement two new apps that have the requirements shown in the following table.



Which storage accounts should you recommend using for each app? 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: Storage1 and storage3 only

Need to use Standard accounts.

Data stored in a premium block blob storage account cannot be tiered to hot, cool, or archive using Set Blob Tier or using Azure Blob Storage lifecycle management

Box 2: Storage1 and storage4 only
Azure File shares requires Premium accounts. Only Storage1 and storage4 are premium.


Reference:

https://docs.microsoft.com/en-us/azure/storage/blobs/access-tiers-overview#feature-support https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share?tabs=azure-portal#basics



You are designing an application that will be hosted in Azure.

The application will host video files that range from 50 MB to 12 GB. The application will use certificate-based authentication and will be available to users on the internet.

You need to recommend a storage option for the video files. The solution must provide the fastest read performance and must minimize storage costs.

What should you recommend?

  1. Azure Files
  2. Azure Data Lake Storage Gen2
  3. Azure Blob Storage
  4. Azure SQL Database

Answer(s): C

Explanation:

Blob Storage: Stores large amounts of unstructured data, such as text or binary data, that can be accessed from anywhere in the world via HTTP or HTTPS. You can use Blob storage to expose data publicly to the world, or to store application data privately.
Max file in Blob Storage. 4.77 TB.


Reference:



You are designing a SQL database solution. The solution will include 20 databases that will be 20 GB each and have varying usage patterns.

You need to recommend a database platform to host the databases. The solution must meet the following requirements:

The solution must meet a Service Level Agreement (SLA) of 99.99% uptime.

The compute resources allocated to the databases must scale dynamically.

The solution must have reserved capacity.

Compute charges must be minimized.

What should you include in the recommendation?

  1. an elastic pool that contains 20 Azure SQL databases
  2. 20 databases on a Microsoft SQL server that runs on an Azure virtual machine in an availability set
  3. 20 databases on a Microsoft SQL server that runs on an Azure virtual machine
  4. 20 instances of Azure SQL Database serverless

Answer(s): A

Explanation:

The compute and storage redundancy is built in for business critical databases and elastic pools, with a SLA of 99.99%.
Reserved capacity provides you with the flexibility to temporarily move your hot databases in and out of elastic pools (within the same region and performance tier) as part of your normal operations without losing the reserved capacity benefit.


Reference:



HOTSPOT (Drag and Drop is not supported)

You have an on-premises database that you plan to migrate to Azure.

You need to design the database architecture to meet the following requirements:

Support scaling up and down.

Support geo-redundant backups.

Support a database of up to 75 TB.

Be optimized for online transaction processing (OLTP).

What should you include in the design? 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: Azure SQL Database
Azure SQL Database:
Database size always depends on the underlying service tiers (e.g. Basic, Business Critical, Hyperscale). It supports databases of up to 100 TB with Hyperscale service tier model.

Active geo-replication is a feature that lets you to create a continuously synchronized readable secondary database for a primary database. The readable secondary database may be in the same Azure region as the primary, or, more commonly, in a different region. This kind of readable secondary databases are also known as geo-secondaries, or geo-replicas.

Azure SQL Database and SQL Managed Instance enable you to dynamically add more resources to your database with minimal downtime.

Box 2: Hyperscale

Incorrect Answers:
SQL Server on Azure VM: geo-replication not supported.

Azure Synapse Analytics is not optimized for online transaction processing (OLTP).

Azure SQL Managed Instance max database size is up to currently available instance size (depending on the number of vCores).
Max instance storage size (reserved) – 2 TB for 4 vCores
- 8 TB for 8 vCores
- 16 TB for other sizes


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview https://medium.com/awesome-azure/azure-difference-between-azure-sql-database-and-sql-server-on-vm- comparison-azure-sql-vs-sql-server-vm-cf02578a1188



Viewing page 21 of 67
Viewing questions 101 - 105 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!