AZ-305 Free Practice Questions — Page 11

Question 107

HOTSPOT - You are building an Azure web app that will store the Personally Identifiable Information (PII) of employees. You need to recommend an Azure SQL. Database solution for the web app. The solution must meet the following requirements: • Maintain availability in the event of a single datacenter outage. • Support the encryption of specific columns that contain PII. • Automatically scale up during payroll operations. • Minimize costs. What should you include in the recommendations? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 108

HOTSPOT - You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements: • Support 15,000 disk IOPS. • Support SR-IOV. • Minimize 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.

Question 109

You have an Azure AD tenant named contoso.com that has a security group named Group1. Group1 is configured for assigned memberships. Group1 has 50 members, including 20 guest users. You need to recommend a solution for evaluating the membership of Group1. The solution must meet the following requirements: • The evaluation must be repeated automatically every three months. • Every member must be able to report whether they need to be in Group1. • Users who report that they do not need to be in Group1 must be removed from Group1 automatically. • Users who do not report whether they need to be in Group1 must be removed from Group1 automatically. What should you include in the recommendation?

Question 110

HOTSPOT - You have two on-premises Microsoft SQL Server 2017 instances that host an Always On availability group named AG1. AG1 contains a single database named DB1. You have an Azure subscription that contains a virtual machine named VM1. VM1 runs Linux and contains a SQL Server 2019 instance. You need to migrate DB1 to VM1. The solution must minimize downtime on DB1. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 111

HOTSPOT - You have an on-premises Microsoft SQL Server database named SQL1. You plan to migrate SQL1 to Azure. You need to recommend a hosting solution for SQL1. The solution must meet the following requirements: • Support the deployment of multiple secondary, read-only replicas. • Support automatic replication between primary and secondary replicas. • Support failover between primary and secondary replicas within a 15-minute recovery time objective (RTO). 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.

Question 113

You are designing a point of sale (POS) solution that will be deployed across multiple locations and will use an Azure Databricks workspace in the Standard tier. The solution will include multiple apps deployed to the on-premises network of each location. You need to configure the authentication method that will be used by the app to access the workspace. The solution must minimize the administrative effort associated with staff turnover and credential management. What should you configure?

Question 114

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?

Question 115

Your company has offices in North America and Europe. You plan to migrate to Azure. You need to recommend a networking solution for the new Azure infrastructure. The solution must meet the following requirements: • The Point-to-Site (P2S) VPN connections of mobile users must connect automatically to the closest Azure region. • The offices in each region must connect to their local Azure region by using an ExpressRoute circuit. • Transitive routing between virtual networks and on-premises networks must be supported. • The network traffic between virtual networks must be filtered by using FQDNs. What should you include in the recommendation?

Question 116

You are developing a sales application that will contain several Azure cloud services and handle different components of a transaction. Different cloud services will process customer orders, billing, payment, inventory, and shipping. You need to recommend a solution to enable the cloud services to asynchronously communicate transaction information by using XML messages. What should you include in the recommendation?

Question 117

You have an Azure subscription. You need to deploy an Azure Kubernetes Service (AKS) solution that will use Windows Server 2019 nodes. The solution must meet the following requirements: • Minimize the time it takes to provision compute resources during scale-out operations. • Support autoscaling of Windows Server containers. Which scaling option should you recommend?