Question 71

You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
Ensure that all traffic to the public endpoint of SqlSrv1 is blocked.
Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.
What should you create on VNet1?
  • Question 72

    You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements.
    What should you recommend? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 73

    You have the following Transact-SQL query.

    Which column returned by the query represents the free space in each file?
  • Question 74

    You have a database on a SQL Server on Azure Virtual Machines instance.
    The current state of Query Store for the database is shown in the following exhibit.

    Question 75

    You receive numerous alerts from Azure Monitor for an Azure SQL database.
    You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.