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?

an Azure Blob storage container

You have an Azure SQL managed instance named MI1.You need to implement automatic tuning for the databases of MI1.What should you do?

Use Transact-SQL to enable the force_last_good_plan option.

Use the REST API to call the patch operation and modify the AutomaticTuningServerMode property

Use Transact-SQL to enable the force_last_good_plan option.

From the Azure portal, configure automatic tuning.

You have an Azure subscription that contains the resources shown in the following table. App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs. What should you do?

Enable automatic tuning for dbl.

Increase the number Of vCores allocated to dbl.

Disable auto-pause delay for dbl.

Decrease the auto-pause delay for dbl.

Enable automatic tuning for dbl.

You have an Azure subscription that contains an Azure SQL database named SQL1.SQL1 is in an Azure region that does not support availability zones.You need to ensure that you have a secondary replica of SQLI in the same region.What should you use?

Microsoft SQL Server failover clusters

Your on-premises network contains a server that hosts a 60-TB database named DB 1. The network has a 10-Mbps internet connection.You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database.What should you use?

Azure Database Migration Service

You have a Microsoft SQL Server 2017 server.You need to migrate the server to Azure. The solution must meet the following requirements:• Ensure that the latest version of SQL Server is used.• Support the SQL Server Agent service.Minimize administrative effort.What should you use?

SQL Server on Azure Virtual Machines

an Azure SQL Database elastic pool

You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements:The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections. Administrative effort must be minimized.What should you use to host the databases?

an Azure SQL Database elastic pool

SQL Server on Azure Virtual Machines

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?

From Microsoft SQL Server Management Studio (SSMS), configure a SQL Server agent job.

From the Azure portal, create a service health alert.

From the Azure portal, create an Azure Advisor operational excellence alert.

From Microsoft SQL Server Management Studio (SSMS), configure a SQL Server agent job.

From the Azure portal, configure an activity log alert.

You have an Azure subscription that contains the resources shown in the following table. App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by Appl as soon as possible, without considering immediate costs What you do?

Enable automatic tuning for db1.

Increase the number of vCores allocated to db1.

Decrease the auto-pause delay for db1.

Disable auto-pause delay for db1.

Enable automatic tuning for db1.

Microsoft DP-300 Practice Test 6 - Free Online Exam Prep & Questions

HOTSPOT

You have an Azure SQL database named db1 that contains an Azure Active Directory (Azure AD) user named user1. You need to test impersonation of user1 in db1 by running a SELECT statement and returning to the original execution context. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-300 Practice Test 6

Question

Microsoft DP-300 Practice Tests

Practice Tests