Courseiva
← AZ-500
Full test
easymultiple choiceObjective-mapped

A company uses Azure SQL Database and wants to periodically scan the database for vulnerabilities such as misconfigurations, excessive permissions, and missing patches. The scans should generate actionable reports that the security team can use to remediate issues. Which built-in Azure feature should they enable?

Question 1easymultiple choice
Full question →

A company uses Azure SQL Database and wants to periodically scan the database for vulnerabilities such as misconfigurations, excessive permissions, and missing patches. The scans should generate actionable reports that the security team can use to remediate issues. Which built-in Azure feature should they enable?

Full question →

Answer choices

Why each option matters

Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.

A

Distractor review

Azure Defender for SQL

Azure Defender for SQL includes the Vulnerability Assessment feature, but the question asks for the specific feature that scans for vulnerabilities and generates reports, which is the Vulnerability Assessment itself. Azure Defender also includes threat detection and other capabilities not required here.

B

Best answer

SQL Vulnerability Assessment

Correct. Vulnerability Assessment is the dedicated tool that scans for SQL database vulnerabilities and generates actionable reports.

C

Distractor review

SQL Auditing

Auditing records database events for compliance and forensic analysis, but it does not scan for vulnerabilities.

D

Distractor review

Azure SQL Insights

Azure SQL Insights is a monitoring solution for database performance, not for vulnerability scanning.

Common exam trap

Common exam trap: NAT rules depend on direction and matching traffic

NAT is not only about the public address. The inside/outside interface roles and the ACL or rule that matches traffic are just as important.

Technical deep dive

How to think about this question

NAT questions usually test address translation, overload/PAT behaviour, static mappings and whether the right traffic is being translated. Read the interface direction and address terms carefully.

KKey Concepts to Remember

  • Static NAT maps one inside address to one outside address.
  • PAT allows many inside hosts to share one public address using ports.
  • Inside local and inside global describe the private and translated addresses.
  • NAT ACLs identify traffic for translation, not always security filtering.

TExam Day Tips

  • Identify inside and outside interfaces first.
  • Check whether the scenario needs static NAT, dynamic NAT or PAT.
  • Do not confuse NAT matching ACLs with normal packet-filtering intent.

Related practice questions

Related AZ-500 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

AZ-500 fundamentals practice questions

Practise AZ-500 questions linked to AZ-500 fundamentals.

AZ-500 scenario practice questions

Practise AZ-500 questions linked to AZ-500 scenario.

AZ-500 troubleshooting practice questions

Practise AZ-500 questions linked to AZ-500 troubleshooting.

More questions from this exam

Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.

Question 1

A DevOps team wants Defender for Cloud to identify secrets exposed in GitHub repositories. What should be configured?

Question 2

A public web application should be protected from OWASP-style attacks and network-layer DDoS attacks. Which two Azure services are most relevant?

Question 3

A Sentinel scheduled rule runs every 5 minutes and looks back 1 hour. Analysts see repeated alerts for the same event. Which change best prevents duplicate detections without missing late-arriving logs?

Question 4

A SOC analyst needs a Sentinel query that detects multiple failed sign-ins followed by a successful sign-in for the same user. Which table is the best primary source?

Question 5

A Sentinel watchlist contains high-value administrator accounts. Which KQL pattern best uses it in a detection rule?

Question 6

A SOC wants a Sentinel rule to include account, host, and IP entities so analysts can pivot during investigation. What should be configured in the analytics rule?

FAQ

Questions learners often ask

What does this AZ-500 question test?

Static NAT maps one inside address to one outside address.

What is the correct answer to this question?

The correct answer is: SQL Vulnerability Assessment — The SQL Vulnerability Assessment (VA) is a built-in tool in Azure SQL Database that scans the database for security vulnerabilities and provides a detailed report with remediation steps. It can be configured to run automatically on a schedule. Azure Defender for SQL (option A) includes VA but also other threat detection features. However, the specific scanning and reporting tool is called Vulnerability Assessment. SQL Auditing (option C) tracks database events but does not scan for vulnerabilities. Azure SQL insights (option D) monitors performance, not security vulnerabilities.

What should I do if I get this AZ-500 question wrong?

Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.

Discussion

Loading comments…

Sign in to join the discussion.