Question 21
Vou have an Azure SQL database named DB1.
You have 10 Azure virtual machines that connect to a virtual network subnet named Subnet 1.
You need to implement a database-level firewall that meets the following requirements:
* Ensures that only the 10 virtual machines can access DB1
* Follows the principle of least privilege
How should you configure the firewall rule, and how should you establish network connectivity from the virtual machines to DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have 10 Azure virtual machines that connect to a virtual network subnet named Subnet 1.
You need to implement a database-level firewall that meets the following requirements:
* Ensures that only the 10 virtual machines can access DB1
* Follows the principle of least privilege
How should you configure the firewall rule, and how should you establish network connectivity from the virtual machines to DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 22
Your company analyzes images from security cameras and sends alerts to security teams that respond to unusual activity. The solution uses Azure Databricks.
You need to send Apache Spark level events, Spark Structured Streaming metrics, and application metrics to Azure Monitor.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions in the answer area and arrange them in the correct order.
You need to send Apache Spark level events, Spark Structured Streaming metrics, and application metrics to Azure Monitor.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions in the answer area and arrange them in the correct order.
Question 23
You have an Azure virtual machine based on a custom image named VM1.
VM1 hosts an instance of Microsoft SQL Server 2019 Standard.
You need to automate the maintenance of VM1 to meet the following requirements:
* Automate the patching of SQL Server and Windows Server.
* Automate full database backups and transaction log backups of the databases on VM1.
* Minimize administrative effort.
What should you do first?
VM1 hosts an instance of Microsoft SQL Server 2019 Standard.
You need to automate the maintenance of VM1 to meet the following requirements:
* Automate the patching of SQL Server and Windows Server.
* Automate full database backups and transaction log backups of the databases on VM1.
* Minimize administrative effort.
What should you do first?
Question 24
SIMULATION
You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1.
You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1.
You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Question 25
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change.
You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands.
You perform a weekly full backup on Sunday, daily differential backups at 01:00, and transaction log backups every five minutes.
The database fails on Wednesday at 10:00.
Which three backups should you restore in sequence? To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order.
You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands.
You perform a weekly full backup on Sunday, daily differential backups at 01:00, and transaction log backups every five minutes.
The database fails on Wednesday at 10:00.
Which three backups should you restore in sequence? To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order.
