Free AZ-305 Exam Braindumps
Designing Microsoft Azure Infrastructure Solutions Questions 60–64 (page: 36)

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

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:

https://azure.microsoft.com/en-us/blog/understanding-and-leveraging-azure-sql-database-sla/



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have the following projects:
-Project1: A rapidly iterating cloud-based solution that integrates multiple Azure software as a service (SaaS) solutions
-Project2: The migration of a 5-TB on-premises database to Azure
-Project3: The migration of a 30-TB on-premises database to Azure
The projects have the requirements shown in the following table.

You need to recommend a database solution for the projects.
What should you include in the recommendation for each project? 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: SQL Server on Azure Virtual Machines
Project1: A rapidly iterating cloud-based solution that integrates multiple Azure software as a service (SaaS) solutions
Requirements:
Minimize costs.
Minimize administrative effort associated with operating system administration.
In Azure, you can have your SQL Server workloads running as a hosted service (PaaS), or a hosted infrastructure (IaaS) supporting the software layer, such as Software-as-a-Service (SaaS) or an application.
SQL Server on Azure Virtual Machines is a fast and straightforward migration infrastructure as a service (IaaS) option, but it requires a more hands-on approach to database administration.
Box 2: Azure SQL Managed instance
Project2: The migration of a 5-TB on-premises database to Azure
Requirements:
Minimize how long it takes to migrate the database.
Minimize administrative effort associated with operating system updates and backups.
SQL Managed Instance supports database migration from on-premises with minimal to no database changes.
Maximum database size: Up to 16 TB.
Azure SQL Managed Instance falls into the industry category of Platform-as-a-Service (PaaS), and is best for most migrations to the cloud. SQL Managed Instance is a collection of system and user databases with a shared set of resources that is lift-and-shift ready.
Incorrect:
* Azure SQL Database
Migration from SQL Server might be challenging.
Box 3: Azure SQL Database
Project3: The migration of a 30-TB on-premises database to Azure
Requirements:
Minimize how long it takes to migrate the database.
Minimize administrative effort associated with operating system updates and backups.
Azure SQL Databases of up to 128 TB.
Migration from SQL Server might be challenging.
Compatibility with the SQL Server version can be achieved only using database compatibility levels.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview



View Related Case Study

DRAG DROP (Drag and Drop is not supported)
You have an on-premises app named App1.
Customers use App1 to manage digital images.
You plan to migrate App1 to Azure.
You need to recommend a data storage solution for App1. The solution must meet the following image storage requirements:
-Encrypt images at rest.
-Allow files up to 50 MB.
-Manage access to the images by using Azure Web Application Firewall (WAF) on Azure Front Door. The solution must meet the following customer account requirements:
-Support automatic scale out of the storage.
-Maintain the availability of App1 if a datacenter fails.
-Support reading and writing data from multiple Azure regions.
Which service should you include in the recommendation for each type of data? To answer, drag the appropriate services to the correct type of data. 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 answer is worth one point.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Azure Blob storage
Blob Storage, Azure Storage encryption for data at rest
Azure Storage uses service-side encryption (SSE) to automatically encrypt your data when it is persisted to the cloud. Azure Storage encryption protects your data and to help you to meet your organizational security and compliance commitments.
Box 2: Azure Cosmos DB
You can distribute your data globally with Azure Cosmos DB.
Key benefits of global distribution
* Build highly available apps. Running a database in multiple regions worldwide increases the availability of a database. If one region is unavailable, other regions automatically handle application requests. Azure Cosmos DB offers 99.999% read and write availability for multi-region databases.
* Managed failover during a regional outage. During a regional outage, Azure Cosmos DB continues to maintain its latency, availability, consistency, and throughput SLAs. To help make sure that your entire application is highly available, Azure Cosmos DB offers a manual failover API to simulate a regional outage. By using this API, you can carry out regular business continuity drills.


Reference:

https://learn.microsoft.com/en-us/azure/storage/common/storage-service-encryption https://learn.microsoft.com/en-us/azure/cosmos-db/distribute-data-globally



View Related Case Study

You have an on-premises Microsoft SQL Server 2016 database named DB1.
You have an Azure subscription.
You need to migrate DB1 to an Azure SQL database by using the Azure SQL Migration extension for Azure Data Studio.
What should you do first?

  1. Create a user-assigned managed identity.
  2. Configure a Site-to-Site (S2S) VPN connection.
  3. Upgrade DB1.
  4. Define the schema for the Azure SQL database.

Answer(s): D

Explanation:

The Azure SQL migration extension for Azure Data Studio
If your target is Azure SQL Database, make sure you deploy the database schema before you begin the migration.
Note: The Azure SQL migration extension for Azure Data Studio enables you to assess, get right-sized Azure recommendations and migrate your SQL Server databases to Azure.
The workflow of the migration process is illustrated in the following diagram:

Incorrect:
Not B: Microsoft SQL Server 2008 and later is supported.


Reference:

https://learn.microsoft.com/en-us/azure-data-studio/extensions/azure-sql-migration-extension https://learn.microsoft.com/en-us/azure/dms/migration-using-azure-data-studio



View Related Case Study

DRAG DROP (Drag and Drop is not supported)
You have a 500-TB, on premises Microsoft SQL Server database named DB1.
You have an on-premises datacenter that contains virtual machines. The virtual machines host database, web, file and application resources.
You have an Azure subscription.
You need to migrate DB1 and the virtual machines to Azure. The solution must meet the following requirements:
-During the migration of DB1, data cannot be transmitted over the internet, and the impact on the internet must be minimized.
-The migration of the virtual machines must support a test migration before the production migration.
-During the migration of the virtual machines, downtime must be minimized.
What should you use for each migration? To answer, drag the appropriate services to the correct targets. 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:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Azure Data Box enables offline transfer of large datasets (500 TB) without using the internet, meeting the requirement to avoid internet transmission and minimize impact.
Azure Site Recovery supports replication, test failover (test migration), and minimal downtime during migration of virtual machines.



Viewing page 36 of 78
Viewing questions 176 - 180 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!