Microsoft DP-300 Exam Dumps

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations: • Automated patching is enabled. • The SQL Server laaS Agent extension is installed. • The Microsoft SQL Server instance on SQLVM1 is managed by using the Azuie portal. You need to automate the deployment of cumulative updates to SQLVM1 by using Azure Update Manager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed by using the Azure portal. What should you do first on SQLVM1?

You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains an Extended Events session named session! that captures Microsoft SQL Server events. You need to correlate the session events with events captured by Event Tracing for Windows (ETW). What should you do for session1?

You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation. You need to create the required Automation accounts. Which two accounts should you create? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1 and an Azure Storage account named storage1. You need to ensure that you can back up db1 to storage1. The solution must meet the following requirements: * Use block blob storage. * Maximize security.

You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2 . SQLM2 contains a database named DB1 and a user named User1. User1 drops DB1. You need to perform a point-in-time restore of DB1 to SQLMI2.

You have SQL Server 2019 or an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. Vou scale up the virtual machine to 8 vCPUs and 64 GB of memory. You need to reduce tempdb contention without regatively affecting server performance. What is the number of secondary data files that you should configure for tempdb?

You have an Azure subscription. You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image You need to register the SQL Server laaS Agent extension (SqllaasExtension). The solution must meet the following requirements: • Install critical updates for SQL Server automatically. • Minimize performance impact on the virtual machine. Which management mode should you select?

You have an Azure subscription. You need to deploy an Azure SQL database. The solution must meet the following requirements: • Dynamically scale CPU resources. • Ensure that the database can be paused to reduce costs. What should you use?

You have an Azure SQL database named DB1. A user named User 1 has an Azure AD account. You need to provide User1 with the ability to add and remove columns from the tables inDBV The solution must use the principle of least privilege. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point

You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on?premises network connects to VNET1 by using an ExpressRoute connection. You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service. You need to configure VNET1 to support the migration. What should you do?

Task 4You need to enable change data capture (CDC) for db1.

Task 10You need to protect all the databases on sql37006S95 from SQL injection attacks.

Task 5You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.

Task 2You need to configure your user account as the Azure AD admin for the server named sql3700689S.

Task 3You need to ensure that all queries executed against dbl are captured in the Query Store.

Task 7You plan to create an automation runbook that will create database users in db1 from Azure AD identities. You need to configure sq1370O6895 to support the creation of new database users.

Task 1In an Azure SQL database named db1, you need to enable page compression on the PK_SalesOrderHeader_SalesOrderlD clustered index of the SalesLT.SalesOrderHeader table.

Task 6You need to ensure that any enhancements made to the Query Optimizer through patches are available to dbl and db2 on sql37006895.

Task 12You need to configure high availability for dbl. The solution must tolerate the loss of an Azure datacenter without data loss or the need to modify application connection strings.

Task 11You 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.

Task 8You plan to perform performance testing of db1.You need prevent db1 from reverting to the last known good query plan.

Task 9You need to generate an email alert to [email protected] when CPU percentageutilization for db1 is higher than average.

You need to recommend a solution to meet the security requirements and the business requirements for DB3. What should you recommend as the first step of the solution?

You need to recommend which configuration to perform twice to enable access to the primary and secondary replicas of DB3. The solution must meet the availability requirements. What should you recommend?

You need to recommend a process to automate the management of DB3. The solutionmust meet the management requirements. What should be the first step of the process?