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

What two parameters would you recommend set up to ensure that the new IPSCustomers database will scale to meet the workload demands?

You need to recommend a data storage solution that meets the following requirements:

* Ensures that applications can access the data by using a REST connection

* Hosts 20 independent tables of varying sizes and usage patterns

* Automatically replicates the data to a second Azure region

* Minimizes costs

What should you recommend?

You have an on-premises Microsoft SQL Server 2008 instance that hosts a 50-GB database.

You need to migrate the database to an Azure SQL managed instance. The solution must minimize downtime.

What should you use?

You have an Azure subscription that contains 10 web apps. The apps are integrated with Azure AD and are accessed by users on different project teams.

The users frequently move between projects.

You need to recommend an access management solution for the web apps. The solution must meet the following requirements:

* The users must only have access to the app of the project to which they are assigned currently.

* Project managers must verify which users have access to their project s app and remove users that are no longer assigned to their project.

* Once every 30 days, the project managers must be prompted automatically to verify which users are assigned to the projects.

What should you include in the recommendation?

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 to enforce the location of resource groups.

Does this meet the goal?

You have an on-premises Microsoft SQL server named SQLI that hosts 50 databases.

You plan to migrate SQL 1 to Azure SQL Managed Instance.

You need to perform an offline migration of SQL 1. The solution must minimize administrative effort.

What should you include in the solution?

You need to design a highly available Azure SQL database that meets the following requirements:

Failover between replicas of the database must occur without any data loss.

The database must remain available in the event of a zone outage.

Costs must be minimized

Which deployment option should you use?