CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free DP-300 Exam Braindumps (page: 39)

Page 39 of 76
PDF with 352 Questions

You have the following resources:

•15 SQL Server on Azure Virtual Machines instances
•20 Azure SQL databases

You need to recommend a solution to centrally monitor the resources for security vulnerabilities.
What should you include in the recommendation?

  1. database audits
  2. Microsoft Defender
  3. SQL insights
  4. Azure SQL Auditing

Answer(s): C


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql
https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql



HOTSPOT (Drag and Drop is not supported)
You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1.

You need to ensure that User1 can perform the following tasks on DB1:

•Create jobs.
•View all jobs.
•Modify, delete, and disable the jobs the user created.

The solution must use the principle of least privilege.

Which built-in database role should you assign to User1, and where is the role defined? To answer, select the appropriate options in the answer area.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1.

You need to collect performance metrics for SQLMI1 and stream the metrics to Workspace.
What should you do first?

  1. Create a private endpoint connection on SQLMI1.
  2. Configure Azure SQL Analytics to use Workspace1.
  3. Modify the Compute + storage settings for SQLMI1.
  4. Modify the diagnostic settings for SQLMI1.

Answer(s): D



HOTSPOT (Drag and Drop is not supported)
You have an Azure SQL database named DB1 in the General Purpose service tier.
You need to monitor DB1 by using SQL Insights.

What should you include in the solution? To answer, select the appropriate options in the
answer area.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Page 39 of 76



Post your Comments and Discuss Microsoft DP-300 exam with other Community members:

laks commented on December 26, 2024
so far seems good
UNITED STATES
upvote

Jack commented on October 24, 2024
Muito bom as perguntas
Anonymous
upvote

TheUser commented on October 23, 2024
So far seems good
Anonymous
upvote

anonymus commented on October 23, 2024
master database differential backup is not supported in sql server
EUROPEAN UNION
upvote

Ntombi commented on October 17, 2024
i find the questions helpful for my exam preparation
Anonymous
upvote

Ntombi commented on October 17, 2024
The questions help me to see if I understood what I have learned
Anonymous
upvote

ntombi commented on October 17, 2024
writing exam at the end of the month
Anonymous
upvote

Raby commented on August 13, 2024
Wonderful work guys. The PDF version helped me pass. Thank you
EUROPEAN UNION
upvote