DP-300 V3

HOTSPOT 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....

HOTSPOT You have an Azure subscription. You need to deploy an Azure SQL resource that will support cross database queries by using an Azure Resource Manager (ARM) template. How should you complete the ARM template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is...

You create five Azure SQL Database instances on the same logical server. In each database, you create a user for an Azure Active Directory (Azure AD) user named User1. User1 attempts to connect to the logical server by using Azure Data Studio and receives a login error. You need to...

You manage 100 Azure SQL managed instances located across 10 Azure regions. You need to receive voice message notifications when a maintenance event affects any of the 10 regions. The solution must minimize administrative effort. What should you do?A . From the Azure portal, create a service health alert. B....

You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements. What should you do?A . Create an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group. B. Add a diagnostic setting that logs QueryStoreRuntimeStatistics...

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals. What should you include in the recommendation?A . For each customer, grant the customer ddl_admin to the existing schema. B. For each customer, create an additional schema...

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...

You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication. You need to migrate SQL1 to Azure. Which service should you use?A . Azure SQL Edge B. Azure SQL Database C. SQL Server on Azure Virtual Machines D. Azure SQL Managed instanceView AnswerAnswer: C

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements. What should you include in the plan?A . Configure the Deleted databases settings for ResearchSrvOL B. Deploy and configure an Azure Backup server. C. Configure the Advanced Data...

HOTSPOT You have an Azure SQL database named DB 1 in the General Purpose service tier. You need to monitor DB 1 by using SQL Insights. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one...