# Summary

The web content provides Azure Solutions Architect Expert-level guidance on selecting appropriate Azure services and configurations for various scenarios involving databases, storage, and compute services.

# Abstract

The article presents a series of expert-level questions and answers related to Azure Solutions Architecture, focusing on optimal service tier selections for Azure SQL databases, Azure Storage configurations, and Azure compute services. It addresses capacity issues by recommending sharding for transactional databases that exceed the limits of a single Azure SQL database. For migrating an on-premises SQL Server database with SQL Server Agent support, it suggests using Azure SQL Managed Instance with the General Purpose service tier. The article also advises on choosing the Hyperscale service tier for large databases requiring fast failover, and the Premium file shares storage account for NFS file share support. It emphasizes the use of Azure Key Vault for customer-managed encryption keys and recommends the Cool access tier for cost-effective storage of infrequently accessed data. For high-performance file storage, the Premium Azure Files tier is advised. The article concludes with recommendations for Azure Traffic Manager to route user requests to the nearest application instance and suggests Azure SQL Database's General Purpose service tier for cost-effective high availability. Failover groups are recommended for cross-regional failover capabilities, and Azure Batch is advised for large-scale image analysis and processing with minimal administrative overhead.

# Opinions

- Sharding is the preferred solution for overcoming capacity limitations in transactional databases.
- Azure SQL Managed Instance with the General Purpose service tier is the recommended architecture for migrating on-premises SQL Server databases that require SQL Server Agent support.
- The Hyperscale service tier is deemed the best choice for supporting large databases up to 40 TB with rapid failover.
- Premium file shares storage accounts are necessary for supporting NFS file shares in Azure Storage.
- Azure Key Vault is essential for managing customer-managed encryption keys for Azure Storage.
- The Cool access tier is cost-effective for storing data that is infrequently accessed but requires immediate availability.
- Premium Azure Files is the most cost-effective tier for high-performance SMB file storage with significant IOPS and bandwidth requirements.
- Azure Traffic Manager is the go-to solution for global traffic routing to the nearest Azure region hosting an application instance.
- The General Purpose service tier of Azure SQL Database is considered sufficient for applications requiring high availability without the additional costs of higher tiers.
- Failover groups are the recommended approach for enabling cross-regional failover in Azure SQL databases.
- Azure Batch is identified as the ideal compute service for large-scale, administrative-light image processing tasks.

Renewal Questions and Answers for Azure Solutions Architect Expert part 1

There are some Azure Questions and answers based on my knowledge

Question 1: Your transactional database requirements exceed the maximum capacity of a single Azure SQL database in the General Purpose service tier.

What should you implement to resolve the capacity issue?

Select only one answer.

sharding elastic pools read scale-out

Answer: sharding

Question 2: You need to migrate an on-premises SQL Server database to Azure. The solution must include support for SQL Server Agent.

Which Azure SQL architecture should you recommend?

Select only one answer.

Azure SQL Database with the General Purpose service tier Azure SQL Database with the Business Critical service tier Azure SQL Managed Instance with the General Purpose service tier Azure SQL Database with the Hyperscale service tier

Answer: Azure SQL Managed Instance with the General Purpose service tier

Question 3: You need to recommend an Azure SQL Database service tier that supports a 40-TB database. The solution must provide the fastest failover time.

Which service tier should you recommend?

Select only one answer.

General Purpose Business critical Hyperscale

Answer: Hyperscale

Question 4: You are designing a storage solution for a customer that will use Azure Storage.

You are evaluating whether the customer needs a standard general purpose v2 storage account or a premium file shares storage account.

Which requirement requires the use of a premium files shares storage account?

Select only one answer.

Support for NFS file shares. Support for Geo-zone-redundant storage (GZRS). Support for private endpoints. Support for SMB file shares.

Answer: Support for NFS file shares.

Question 5: You are designing an application that will store data in Azure Storage.

You need to recommend a solution to ensure that data in the storage account is encrypted by using customer-managed keys.

What should you include in the recommendation?

Select only one answer.

Azure Key Vault Azure Private Link Shared access signature Service endpoint

Answer: Azure Key Vault

Question 6: You need to recommend an Azure Blob storage access tier for infrequently accessed data. The solution must meet the following requirements:

Ensure the data is available for immediate access.Minimizes the cost to store the data. Which access tier should you recommend?

Select only one answer.

Premium Hot Cool Archive

Answer: Cool

Question 7: You are designing an application that will use Azure Files to store data. The application has the following storage requirements:

Must support SMB Must support 90,000 IOPS Must provide 2-GBps of bandwidth

You need to recommend the least costly storage tier that meets the storage requirements. What should you recommend?

Select only one answer.

Premium Transaction optimized Hot Cool

Answer: Premium

Question 8: You are designing the architecture for an application that will be hosted on Azure virtual machines. The application will be available over TCP port 4359. You will have instances of the application in the following Azure Regions:

West US East US East Asia West Europe North Europe Australia East

You need to recommend a solution to route user request for the application to the instance closest to the user.

What should you recommend?

Select only one answer.

Azure Front Door Azure Traffic Manager Azure Application Gateway Azure Load Balancer

Answer: Azure Traffic Manager

Question 9: You are designing an application that will use an Azure SQL database.

You have identified the following database requirements:

Supports four read-scale replicas Supports up to 25 TB of data Provides an SLA of 99.99%

What is the least costly service tier that meets the requirements?

Select only one answer.

General purpose Business critical Hyperscale

Answer: General purpose

Question 10: You are designing a high availability solution for SQL databases that will be migrated to Azure.

You are evaluating whether you need to implement geo-replication or failover groups.

Which requirement will cause you to choose failover groups for high availability?

Select only one answer.

You need to host a database on an Azure SQL managed instance. You need to have multiple readable copies of the database. You need to be able to failover a database to a secondary region.

Answer: You need to be able to failover a database to a secondary region.

Question 11: Your company plans to run large scale image analysis and processing in Azure.

You need to recommend which Azure compute service to use for the planned solution. The solution must minimize administrative effort.

Which Azure service should you recommend?

Select only one answer.

Azure Batch Azure Functions Azure Logic Apps Azure virtual machines

Answer: Azure Batch