- All Exams Instant Download
How should you complete the template?
HOTSPOT You need to use an Azure Resource Manager ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maximize disk I/O performance for the SQL Server database and log files How should you complete the template? To answer, select the...
What should you include in the recommendation?
You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements: • Support real-time data replication to a different geographic region. • Use Azure as a disaster recovery target. • Minimize costs and administrative effort. What should you include...
What should you create on VNet1?
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...
Which three actions should you perform in sequence?
DRAG DROP You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures. You need to ensure that SOL Server Agent jobs running on SQL 1 can notify administrators when a failure occurs. Which three actions should you perform in sequence? To answer, move...
Which metric should you monitor?
Your company uses Azure Stream Analytics to monitor devices. The company plans to double the number of devices that are monitored. You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the additional load. Which metric should you monitor?A . Input Deserialization...
Which three Transact-SQL statements should you execute in sequence?
DRAG DROP You have an Azure subscription that contains the resources shown in the following table. You need to back up db1 to mysqlbackups, and then restore the backup to a new database named db2 that is hosted on SQL1. The solution must ensure that db1 is backed up to...
Which four actions should you perform in sequence?
DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. View AnswerAnswer: Explanation:...
What should you use to migrate the PostgreSQL database?
What should you use to migrate the PostgreSQL database?A . Azure Data Box B. AzCopy C. Azure Database Migration Service D. Azure Site RecoveryView AnswerAnswer: C Explanation: Reference: https://docs.microsoft.com/en-us/azure/dms/dms-overview
Which job attribute is unsupported in SQLMI1?
You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1. Which job attribute is unsupported in SQLMI1?A . log to table B. email notifications C. schedules D. output filesView...
You have an Azure subscription that contains a group named Group1 and an Azure SQL managed instance that hosts a database named 081. You need to ensure that Group 1 has read access to new tables created m 06I. The solution must use the principle of least privilege
HOTSPOT You have an Azure subscription that contains a group named Group1 and an Azure SQL managed instance that hosts a database named 081. You need to ensure that Group 1 has read access to new tables created m 06I. The solution must use the principle of least privilege. How...
