You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a tablenamed CustomerPII.You need to record whenever users query the CustomerPII table.Which two options should you enable? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
What should you use to migrate the PostgreSQL database?
You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in fiveminute intervals and report only events that arrive during the interval.The output will be sent to a Delta Lake table.Which output mode should you use?
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1to 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 VM1 cannot connect to any Azure SQL Server other than SqlSrv1.Restrict network connectivity to SqlSrv1.What should you create on VNet1?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.Solution: You run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2.Does this meet the goal?