SIMULATION - You need to ensure that the audit logs from the SQLdb1 Azure SQL database are stored in the WS12345678 Azure Log Analytics workspace. To complete this task, sign in to the Azure portal and modify the Azure resources.
Suggested Answer:See explanation below.
1. In the Azure portal, type SQL in the search box, select SQL databases from the search results then select SQLdb1. Alternatively, browse to SQL databases in the left navigation pane. 2. In the properties of SQLdb1, scroll down to the Security section and select Auditing. 3. Turn auditing on if it isn't already, tick the Log Analytics checkbox then click on Configure. 4. Select the WS12345678 Azure Log Analytics workspace. 5. Click Save to save the changes.
Answer is Correct - tested in Lab:
1. Open SQLdb1 Ressource page
2. In the properties of SQLdb1, scroll down to the Security section and select Auditing.
3. Turn auditing on if it isn't already, tick the Log Analytics checkbox then click on Configure.
4. Log Analytics
5. Select Subscription and Select the WS12345678 Azure Log Analytics workspace
6. click on save
Sign in to the Azure portal.
In the left-hand menu, click on SQL databases.
Click on the SQLdb1 database.
In the SQL database blade, click on Auditing under the Security section.
In the Auditing blade, set the Status to On.
In the Target section, select Log Analytics.
In the Log Analytics workspace section, select the WS12345678 workspace.
Click Save to apply the changes.
The given answer is correct. Note that you can configure audit under Diagnostic Settings as well, but when the goal is specifically to audit and store database-level events from Azure SQL Database in a Log Analytics workspace, Azure SQL Database Auditing is the more targeted and appropriate choice. It provides the necessary granularity and configuration options for auditing at the database level.
Yes, and also it can be enabled on the Server resource.
The question looks like it is asking to enable only in the database resource.
Always read carefully, as naming can mislead you into the wrong configuration for such a simple thing.
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.
Codelawdepp
1 week agomrt007
2 months, 2 weeks agojaacqu
5 months, 3 weeks agoepomatti
5 months, 2 weeks agojaacqu
5 months, 3 weeks agoliorh
1 year, 1 month ago