Free Microsoft AZ-305 Practice Test & Real Exam Questions

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?

Hotspot Question
You have an on-premises app named App1 that stores data in a Microsoft SQL Server database named DB1. App1 uses cross-database transactions.
You plan to move App1 to Azure.
You need to recommend which services to use to host DB1 in Azure and migrate DB1 to Azure.
The solution must meet the following requirements:
- Ensure that once App1 moves to Azure, DB1 users can authenticate by
using their Microsoft Entra credentials.
- Minimize administrative effort to patch and update the database host
once App1 moves to Azure.
- Minimize administrative effort during the migration of DB1 to Azure.
- Minimize costs.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

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 compute resources allocated to the databases must scale
dynamically.
- The solution must meet an SLA of 99.99% uptime.
- The solution must have reserved capacity.
- Compute charges must be minimized.
What should you include in the recommendation?

You have the Azure resources shown in the following table.

You need to deploy a new Azure Firewall policy that will contain mandatory rules for all Azure Firewall deployments. The new policy will be configured as a parent policy for the existing policies.
What is the minimum number of additional Azure Firewall policies you should create?

You have a multi-tier app named App1 and an Azure SQL database named SQL1.
The backend service of App1 writes data to Users use the App1 client to read the data from SQL1.
During periods of high utilization the users experience delays retrieving the data.
You need to minimize how long it takes for data requests.
What should you include in the solution?

Your company has IT, security, and finance departments.
You need to implement a new Azure deployment that will include multiple Azure subscriptions and management groups. The solution must meet the following requirements:
- Ensure that all policies are assigned at the management group level.
- Ensure that all the finance department resources have specific
encryption policies applied.
- Ensure that only users in the IT department can create virtual
machines in any Azure region.
- Ensure that users in the finance department can create virtual
machines in only the East US Azure region.
What is the minimum number of management groups you can create for the planned deployment?

Hotspot Question
You plan to use Azure SQL as a database platform.
You need to recommend an Azure SQL product and service tier that meets the following requirements:
- Automatically scales compute resources based on the workload demand
- Provides per second billing
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Hotspot Question
You are designing a data analytics solution that will use Azure Synapse and Azure Data Lake Storage Gen2.
You need to recommend Azure Synapse pools to meet the following requirements:
- Ingest data from Data Lake Storage into hash-distributed tables.
- Implement query, and update data in Delta Lake.
What should you recommend for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.