Question 101

You are planning an Azure solution that will host production databases for a high-performance application. The solution will include the following components:
Two virtual machines that will run Microsoft SQL Server 2016, will be deployed to different data centers in the same Azure region, and will be part of an Always On availability group.
SQL Server data that will be backed up by using the Automated Backup feature of the SQL Server IaaS Agent Extension (SQLIaaSExtension) You identify the storage priorities for various data types as shown in the following table.

Which storage type should you recommend for each data type? To answer, drag the appropriate storage types to the correct data types. Each storage type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Question 102

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?
  • Question 103

    You have an Azure subscription. The subscription contains an Azure SQL managed instance that stores employee details, including social security numbers and phone numbers.
    You need to configure the managed instance to meet the following requirements:
    * The helpdesk team must see only the last four digits of an employee's phone number.
    * Cloud administrators must be prevented from seeing the employee's social security numbers.
    What should you enable tor each column in the managed instance? To answer select the appropriate options in the answer area.
    NOTE; Each correct selection is worth one point

    Question 104

    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.

    Question 105

    You have an on-premises database that you plan to migrate to Azure.
    You need to design the database architecture to meet the following requirements:
    Support scaling up and down.
    Support geo-redundant backups.
    Support a database of up to 75 TB.
    Be optimized for online transaction processing (OLTP).
    What should you include in the design? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.