Exam AZ-500 topic 7 question 3 discussion

Actual exam question from Microsoft's AZ-500

Question #: 3
Topic #: 7

HOTSPOT
-

You have an Azure subscription that contains the resources shown in the following table.

SQL1 has the following configurations:

• Auditing: Enabled
• Audit log destination: storage1, Workspace1

DB1 has the following configurations:

• Auditing: Enabled
• Audit log destination: storage2

DB2 has auditing disabled.

Where are the audit logs for DB1 and DB2 stored? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by billo79152718 at May 21, 2023, 12:27 p.m.

Comments

Submit Cancel

Corvus99

Highly Voted 1 year, 2 months ago

Correct : Enabling auditing on the database in addition to enabling auditing on the server doesn't override or change any of the settings of the server auditing. Both audits exist side by side. In other words, the database is audited twice in parallel; once by the server policy and once by the database policy. https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-server-level-database-level?view=azuresql

upvoted 19 times

...

billo79152718

Highly Voted 1 year, 2 months ago

DB1: storage1, storage2, and Workspace1 DB2: storage1 and workspace1

upvoted 13 times

...

heatfan900

Most Recent 11 months ago

CORRECT. AUDITING CAN BE APPLIED AT THE DB AND SERVER LEVEL. IF IT IS APPLIED ON BOTH THEN THE COMBONIATION SETTINGS IS APPLIED TO THE DB. IF IT IS DISABLED ON THE DB BUT ENABLED ON THE SERVER THEN THE SETTINGS SET ON THE SERVER ARE APPLIED TO ALL DBS HOSTED ON THE SERVER. IF IT IS ONLY APPLIED TO THE DB, N DISABLED ON THE SERVER, THEN THOSE SETTINGS ARE APPLIED TO THAT DB SPECIFICALLY.

upvoted 5 times

...

massnonn

1 year, 1 month ago

Sorry but db2 has audit disabled

upvoted 1 times

Ario

1 year, 1 month ago

yes but SQL1 has auding enabled

upvoted 6 times

...