Home » Microsoft » DP-200 v.2 » SIMULATION
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 compliance policy states that administrators must be able to review a list of the database object changes that occurred in an Azure SQL database named db2 during the last 100 days.
You need to modify your Azure environment to meet the compliance policy requirements.
To complete this task, sign in to the Azure portal.
A. See the explanation below.
Correct Answer: A
Explanation/Reference:
Explanation:
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 db2/server pane
3. If you prefer to enable auditing on the database level, switch Auditing to ON.
Note: By default the audit database data retention period is set to 100 days.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing