exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 42 discussion

Actual exam question from Microsoft's DP-300
Question #: 42
Topic #: 3
[All DP-300 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?

  • A. database audits
  • B. Microsoft Defender
  • C. SQL insights
  • D. Azure SQL Auditing
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
licna
Highly Voted 1 year, 11 months ago
Selected Answer: B
In my opinion it's MS Defender. Keyword is the "vulnerabilities" https://learn.microsoft.com/en-us/azure/defender-for-cloud/defender-for-sql-introduction
upvoted 8 times
Sr18
6 months, 2 weeks ago
Its a blinder, Defender is best in this.
upvoted 1 times
...
KingChuang
1 year, 11 months ago
Agree.
upvoted 1 times
...
BrenFa101
1 year, 11 months ago
I agree Microsoft Defender is the correct answer to the question asked. Auditing and SQL insights primary functions are not to detect vulnerabilities. Defender will monitor both IaaS and PaaS resources.
upvoted 2 times
...
...
voodoo_sh
Most Recent 2 days, 9 hours ago
Selected Answer: B
Vulnerability Assessment Scan = Microsoft Defender for Cloud / for SQL
upvoted 1 times
...
igorclapa
1 year, 2 months ago
Security vulnerability = Microsoft Defender
upvoted 3 times
...
testdumps2017
1 year, 4 months ago
"You need to recommend a solution to centrally monitor the resources for security vulnerabilities." - auditing is meant for monitoring specific securables (say, certain users) and events (login, logout, etc). It has nothing to do with detecting vulnerabilities. So the correct answer is B.
upvoted 1 times
...
Motanel
1 year, 8 months ago
Selected Answer: B
Azure Defender monitors for vulnerabilities
upvoted 2 times
...
amazonalex
1 year, 9 months ago
i think B. Microsoft Defender for SQL provides a set of advanced SQL security capabilities, including SQL Vulnerability Assessment and Advanced Threat Protection.
upvoted 1 times
...
U_C
1 year, 9 months ago
I think the answer is D. Azure SQL Auditing can centrally monitor the resources for security vulnerabilities. Microsoft Defender is not specifically designed to centrally monitor SQL Server on Azure Virtual Machines instances and Azure SQL databases for security vulnerabilities. SQL insights is a feature that provides performance monitoring and tuning for SQL Server running on Azure Virtual Machines.
upvoted 2 times
7afddb1
10 months ago
Comparto, respuesta D
upvoted 1 times
...
U_C
1 year, 9 months ago
I am wrong. The answer should be B.
upvoted 1 times
...
...
Gocsan
1 year, 10 months ago
The question is about centrally monitoring resources for security vulnerability, which includes VMs here. Azure SQL Auditing does not monitor VMs. So the answer should be Microsoft Defender.
upvoted 1 times
...
louisaok
1 year, 11 months ago
Selected Answer: C
it shoud be SQL insight, this is for VM. Azure SQL is for Azure SQL Database and Azure Synapse Analytics 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
upvoted 1 times
louisaok
1 year, 11 months ago
revised. SQL Insights is focused on performance optimization while Azure SQL Auditing is focused on security and compliance. it should be as Manuuzzz advised, Azure SQL auditing.
upvoted 1 times
...
...
Manuuzzz
1 year, 11 months ago
Selected Answer: D
shouldn't this be D, azure sql auditing, as sql insights gathers other metrics (performance)
upvoted 2 times
...
Manuuzzz
1 year, 11 months ago
shouldn't this be D, azure sql auditing, as sql insights gathers other metrics (performance)
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago