Free Microsoft AZ-305 Practice Test & Real Exam Questions

You have an Azure subscription that contains an Azure App Service app named App1 in a Standard App Service plan. App1 is accessed directly from the internet by using the following URL: https://app1.contoso.com. The Azure region that hosts App1 supports availability zones for App Service apps.
You need to recommend a redundancy solution for App1. The solution must meet the following requirements:
- Ensure that App1 is available if two availability zones fail.
- Minimize administrative effort.
- Minimize costs.
What should you recommend?

You have to design a Data Engineering solution for your company. The company currently has an Azure subscription. They also have application data hosted in a database on a Microsoft SQL Server hosted in their on-premises data center server. They want to implement the following requirements:
- Transfer transactional data from the on-premises SQL server onto a data warehouse in Azure.
- Data needs to be transferred every day in the night as a scheduled job.
- A managed Spark cluster needs to be in place for data engineers to perform analysis on the data stored in the SQL data warehouse.
- Here the data engineers should have the ability to develop notebooks in Scale, R and Python.
- They also need to have a data lake store in place for the ingestion of data from multiple data sources Which of the following would the use for hosting the data warehouse in Azure?

Hotspot Question
You have the Azure resources shown in the following table.

You need to design a solution that provides on-premises network connectivity to SQLDB1 through PE1.
How should you configure name resolution? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have a Microsoft Dataverse instance named dv1 and an Azure Cosmos DB database named db1.
You need to develop a solution to update db1 automatically when a record is updated in dv1. The solution must minimize development effort.
What should you include in the solution?

You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named storage1 and an Azure Synapse Analytics workspace named Workspace1. Workspace1 contains a serverless SQL pool and an Apache Spark pool.
You need to recommend a disaster recovery solution for storage1.
What should you include in the recommendation?

Hotspot Question
You manage a database environment for a Microsoft Volume Licensing customer named Contoso, Ltd. Contoso uses License Mobility through Software Assurance.
You need to deploy 50 databases. The solution must meet the following requirements:
- Support automatic scaling.
- Minimize Microsoft SQL Server licensing costs.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure subscription.
You have a Microsoft Entra tenant.
You need to recommend a Microsoft Entra Identity Governance solution to manage the user lifecycle. The solution must meet the following requirements:
- Ensure that users have the correct permission for the correct
resources and that the permissions are evaluated every quarter.
- If a user is assigned a new role, ensure that the correct permissions are granted for the correct resources and regularly evaluated for the new role.
- When a user leaves the company, ensure that the user's permissions
are revoked.
What should you include in the recommendation?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
Your company plans to deploy various Azure App Service instances that will use Azure SQL databases. The App Service instances will be deployed at the same time as the Azure SQL databases.
The company has a regulatory requirement to deploy the App Service instances only to specific Azure regions. The resources for the App Service instances must reside in the same region.
You need to recommend a solution to meet the regulatory requirement.
Solution: You recommend using an Azure policy initiative to enforce the location.
Does this meet the goal?