Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

Exam SC-500 Topic 1 Question 38 Discussion

Actual exam question for Microsoft's SC-500 exam
Question #: 38
Topic #: 1
Drag and Drop Question
You have an Azure subscription named Sub1 that contains an Azure SQL Database logical server named Server1.
Server1 contains a database named DB1.
Microsoft Defender for Cloud security alerts are being generated for Sub1.
You plan to improve investigation capabilities when Microsoft Defender for SQL raises Advanced Threat Protection alerts.
You need to ensure that the Advanced Threat Protection investigations have the audit records of DB1. The solution must include the recommended audit action groups.
How should you configure database auditing for Server1? To answer, drag the appropriate action groups to the correct requirements. Each action group may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Suggested Answer:


Explanation:
Box 1: SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP
To audit successful logins when configuring database auditing for an Azure SQL Database logical server, you should use the SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP action group.
Box 2: FAILED_DATABASE_AUTHENTICATION_GROUP
To audit failed login attempts for an Azure SQL Database logical server, you must use the FAILED_DATABASE_AUTHENTICATION_GROUP audit action group.
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-setup

by Darcy at Jul 30, 2026, 03:00 AM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.