Microsoft AZ-305 Exam Practice Test Instant Access

Question 1

You have 100 servers that run Windows Server 2012 R2 and host Microsoft SQL Server 2012 R2 instances. The instances host databases that have the following characteristics:

The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.

Stored procedures are implemented by using CLR.

You plan to move all the data from SQL Server to Azure.

You need to recommend an Azure service to host the databases. The solution must meet the following requirements:

Whenever possible, minimize management overhead for the migrated databases.

Minimize the number of database changes required to facilitate the migration.

Ensure that users can authenticate by using their Active Directory credentials.

What should you include in the recommendation?

AAzure SQL Database single databases

BAzure SQL Database Managed Instance

CAzure SQL Database elastic pools

DSQL Server 2016 on Azure virtual machines

Answer : B

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance

SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, SQL Managed Instance preserves all PaaS capabilities (automatic patching and version updates, automated backups, high availability) that drastically reduce management overhead and TCO.

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server#clr

https://docs.microsoft.com/en-gb/azure/azure-sql/database/transact-sql-tsql-differences-sql-server#transact-sql-syntax-not-supported-in-azure-sql-database

Question 2

A company has an on-premises file server cbflserver that runs Windows Server 2019. Windows Admin Center manages this server. The company owns an Azure subscription. You need to provide an Azure solution to prevent data loss if the file server fails.

Solution: You decide to register Windows Admin Center in Azure and then configure Azure Backup.

Would this meet the requirement?

AYes

BNo

Answer : A

Question 3

You have an Azure subscription that contains 100 virtual machines in the North Europe Azure region.

You replicate the virtual machines to the West Europe region by using Azure Site Recovery.

You plan to perform disaster recovery testing once a month. The testing will be performed during an eight-hour period, during which the virtual machines will be accessed, and their functionality validated. The virtual machines will be shut down when testing is not being performed.

You need to estimate the costs of the Site Recovery solution per month. Which costs should the estimate include?

Athe virtual machine compute costs for only eight hours, the virtual machine storage costs for the entire month, and the Site Recovery license costs per protected virtual machine for the entire month

Bthe virtual machine compute costs for the entire month, the virtual machine storage costs for all the hours each month, and the Site Recovery license costs per protected virtual machine for the entire month

Cthe virtual machine compute costs for only eight hours, the virtual machine storage costs for only eight hours, and the Site Recovery license costs per protected virtual machine for only eight hours

Dthe virtual machine compute costs for only eight hours, the virtual machine storage costs for only eight hours, and the Site Recovery license costs per protected virtual machine for the entire month

Answer : A

Question 4

You plan to deploy multiple instances of an Azure web app across several Azure regions.

You need to design an access solution for the app. The solution must meet the following replication requirements:

* Support rate limiting.

* Balance requests between all instances.

* Ensure that users can access the app in the event of a regional outage.

Solution: You use Azure Front Door to provide access to the app.

Does this meet the goal?

AYes

BNo

Answer : B

Question 5

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 creating resource groups based on locations and implementing resource locks on the resource groups.

Does this meet the goal?

AYes

BNo

Answer : B

Resource locks are not used for compliance purposes. Resource locks prevent changes from being made to resources.

https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/lock-resources

Question 6

You are designing a microservices architecture that will be hosted in an Azure Kubernetes Service (AKS) cluster. Apps that will consume the microservices will be hosted on Azure virtual machines. The virtual machines and the AKS cluster will reside on the same virtual network.

You need to design a solution to expose the microservices to the consumer apps. The solution must meet the following requirements:

* Ingress access to the microservices must be restricted to a single private IP address and protected by using mutual TLS authentication.

* The number of incoming microservice calls must be rate-limited.

* Costs must be minimized.

What should you include in the solution?

AAzure API Management Premium tier with virtual network connection

BAzure Front Door with Azure Web Application Firewall (WAF)

CAzure API Management Standard tier with a service endpoint

DAzure App Gateway with Azure Web Application Firewall (WAF)

Answer : A

One option is to deploy APIM (API Management) inside the cluster VNet.

The AKS cluster and the applications that consume the microservices might reside within the same VNet, hence there is no reason to expose the cluster publicly as all API traffic will remain within the VNet. For these scenarios, you can deploy API Management into the cluster VNet. API Management Premium tier supports VNet deployment.

https://docs.microsoft.com/en-us/azure/api-management/api-management-kubernetes

Question 7

You have an Azure subscription.

You plan to deploy a monitoring solution that will include the following:

* Azure Monitor Network Insights

* Application Insights

* Microsoft Sentinel

* VM insights

The monitoring solution will be managed by a single team.

What is the minimum number of Azure Monitor workspaces required?

Answer : A

Microsoft Designing Microsoft Azure Infrastructure Solutions AZ-305 Exam Practice Test