Exam AZ-500 topic 4 question 67 discussion

Should be Y Y Y now. Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql Premium storage with BlockBlobStorage is supported. Standard storage is supported. However, for audit to write to a storage account behind a VNet or firewall, you must have a general-purpose v2 storage account.

Should be N N N? 1) Destination storage is not set 2) Destination is only set to storage 2 3) Destination storage is not set

NNY the SQL Managed Instance audit configuration does have an impact on the auditing of the databases within that instance. However, the auditing settings for individual databases can override or complement the managed instance-wide configuration. 1) NO DB1 has auditing off, and the audit log destination is set to none. Since auditing is off for DB1, no audit events will be generated for this database. Because no audit events are generated, the destination (in this case, storage1) will not receive any audit logs. 2)NO DB2 has auditing on, and the audit log destination is configured to storage2. The audit log destination is specifically set to storage2, and not to storage1. Therefore, audit events for DB2 will only be written to storage2, not to storage1. 3) YES DB3 has auditing off, and the audit log destination is set to none. Since auditing is off for DB3, no audit events will be generated, and hence storage3 cannot be used as an audit log destination. Even though storage3 is a Premium storage account, if auditing is off, no logs will be sent to any storage account, including storage3

Yes - server policy applies to all DBs are storage is supported Yes - server policy exists side by side with DB policy, storage is supported No - StorageV2 Premium is NOT supported (Premium Blob Block is)

I think here answer will be Yes,Yes,No. https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql Given link says that Standart storage is supported , if we go to the azure portal we can see that under performance tier of Azure Storage Account we have 2 options Standard which shows General Purpose v2 (Storagev2) and Premium under premium we can create storage account for files, block blobs and page blobs. In the statements (first one) is Standard and it supports audit logs from Azure SQL DB so first one will Yes . Second one will be yes as well. Interesting one is 3 rd one. According to documentation it says Premium supports BlockBlobStorage this means it does not support general purpose v2 *storage v2 , that is why I think answer will be Yes,Yes,NO Regards!

Yes,yes,yes Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql Premium storage with BlockBlobStorage is supported. Standard storage is supported. However, for audit to write to a storage account behind a VNet or firewall, you must have a general-purpose v2 storage account.

Not a valid question part 2 and 3 it should N and Y there is no such thing as GPV2 Premium, but yes premium can be used for audit logs

Can someone please explain to me how the answers are yes if AUDITING is disabled for DB 1 and DB 3 and and DB2 is only writing audit logs to STORAGE 2. AUDIT EVENTS for DB1 written to STORAGE 1 = NO AUDIT EVENTS for DB2 written to STORAGE 1 n 2 = NO STORAGE 3 can be used as audit log destination for DB3 = NO https://medium.com/@sumathikits86/auditing-for-azure-sql-database-and-azure-synapse-analytics-d3e495a0f93

YYY is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-setup?view=azuresql#configure-auditing-for-your-server Server auditing policies apply to all existing and newly created databases on this server. If server auditing is enabled, the database-configured audit exists side-by-side with the server audit. https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql#remarks Premium storage with BlockBlobStorage is supported. Standard storage is supported.

YES YES YES

In exam Feb 23. 47 questions, 1 case study of 5 q, no labs.

Seems like premium storage is supported now - Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql Premium storage with BlockBlobStorage is supported. Standard storage is supported. However, for audit to write to a storage account behind a VNet or firewall, you must have a general-purpose v2 storage account. If you have a general-purpose v1 or blob storage account, upgrade to a general-purpose v2 storage account.

Why storage 3 cannot be used for db3?

YYN correct

In exam Dec 21. 40 questions, 1 case study, no labs.

## Exam 12/10/2021

## Exam 10/09/2021