Test QuiZ

You have an Azure SQL managed instance. You need to restore a database named DB1 by using Transact-SQL. Which command should you run? To answer, select the appropriate combination in the answer area.

• Database + URL

• File + URL

• Database + Disk

• Log + URL

You have a new Azure subscription. You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1. You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• From the properties of DB1, configure geo-replication.

• From the properties of Server1, add a failover group.

• Create a new Azure SQL Database server named Server2.

• From the properties of Server1, configure retention for DB1.

• Create a new Azure SQL Database instance named DB2.

You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases. You need to implement alerts by using Azure Monitor. The solution must meet the following requirements: ✑ Minimize costs. ✑ Aggregate Intelligent Insights telemetry from each database. What should you do?

• From the Diagnostic settings of each database, select Send to Log Analytics.

• From the Diagnostic settings of each database, select Stream to an event hub.

• From the Diagnostic settings of SQLMI1, select Send to Log Analytics.

• From the Diagnostic settings of SQLMI1, select Stream to an event hub.

Answer explanation

https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-overview?view=azuresql


https://learn.microsoft.com/en-us/azure/azure-monitor/app/data-model-complete

You have a 50-TB Microsoft SQL Server database named DB1. You need to reduce the time it takes to perform database consistency checks of DB1. Which Transact-SQL command should you run? To answer, select the appropriate combination (see attached image to assist).
NOTE: Each correct selection is worth one point. Hot Area:

• NOINDEX + NO_INFOMSGS

• NOINDEX + PHYSICAL_ONLY

• REPAIR_FAST + NO_INFOMSGS

• REPAIR_REBUILD + PHYSICAL_ONLY

You have an instance of SQL Server on Azure Virtual Machine named SQL1. You need to monitor SQL1 and query the metrics by using Kusto query language. The solution must minimize administrative effort. Where should you store the metrics?

• Azure Event Hubs

• a Log Analytics workspace

• Azure SQL Database

• an Azure Blob storage container

Answer explanation

It seems C can be a choice however it is not optimal for what we need to accomplish. Therefore C

You have an Azure subscription that contains the resources shown in the table in image.

You need to configure a connection between VM1 and MI1. The solution must meet the following requirements:
✑ The connection must be encrypted.
✑ Network latency must be minimized.
What should you implement?

• a site-to-site VPN

• virtual network peering

• private endpoints

• service endpoints