New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Free Microsoft DP-300 Exam Dumps

Here you can find all the free questions related with Microsoft Administering Microsoft Azure SQL Solutions (DP-300) exam. You can also find on this page links to recently updated premium files with which you can practice for actual Microsoft Administering Microsoft Azure SQL Solutions Exam. These premium versions are provided as DP-300 exam practice tests, both as desktop software and browser based application, you can use whatever suits your style. Feel free to try the Administering Microsoft Azure SQL Solutions Exam premium files for free, Good luck with your Microsoft Administering Microsoft Azure SQL Solutions Exam.
Question No: 1

MultipleChoice

Task 1

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

Options
Question No: 2

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.

Question No: 3

Hotspot

You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configured as shown in the following exhibit.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

.

Question No: 4

Hotspot

You have an Azure SQL database.

You need to identify whether a delayed query execution is associated to a RESOURCE wait.

How should you complete the Transact -SQL statement? To answer, select the appropriate option in the answer area.

NOTE: Each correct selection is worth one point.

Question No: 5

MultipleChoice

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 m DBV 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

Options
Question No: 6

Hotspot

You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configured as shown in the following exhibit.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Question No: 7

Hotspot

You have a SQL Server on Azure Virtual Machines instance that hosts a database named Db1.

You need to configure the autogrow and autoshrink settings for DB1.

Which statements should you use? To answer, select the appropriate options in the answer are

a.

NOTE: Each correct selection is worth one point.

https://learn.microsoft.com/en-us/troubleshoot/sql/admin/considerations-autogrow-autoshrink

Question No: 8

Hotspot

You have a SQL Server on Azure Virtual Machines instance named VM1 that hosts a database named DB1. You run the following query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Question No: 9

Hotspot

You have a SQL Server on Azure Virtual Machines instance that hosts a database named Db1.

You need to configure the autogrow and autoshrink settings for DB1.

Which statements should you use? To answer, select the appropriate options in the answer are

a.

NOTE: Each correct selection is worth one point.

Question No: 10

MultipleChoice

D18912E1457D5D1DDCBD40AB3BF70D5D

You need to identify the cause of the performance issues on SalesSQLDb1.

Which two dynamic management views should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options

Save Cancel