Exam DP-200 topic 4 question 6 discussion

SIMULATION -
Use the following login credentials as needed:

Azure Username: xxxxx -

Azure Password: xxxxx -
The following information is for technical support purposes only:

Lab Instance: 10543936 -

Your company's security policy states that administrators must be able to review a list of the failed logins to an Azure SQL database named db1 during the previous 30 days.
You need to modify your Azure environment to meet the security policy requirements.
To complete this task, sign in to the Azure portal.

Suggested Answer: See the explanation below.
Set up auditing for your database
The following section describes the configuration of auditing using the Azure portal.
1. Go to the Azure portal.
2. Navigate to Auditing under the Security heading in your SQL database db1/server pane

3. If you prefer to enable auditing on the database level, switch Auditing to ON.

Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing