Exam AZ-500 topic 4 question 75 discussion

Storage 1 and 2 https://docs.microsoft.com/en-us/azure/azure-sql/database/audit-log-format#:~:text=Blob%20audit,in%20the%20Azure%20storage%20account. Log analytics 1,2 and 3

impliedly, the storage for log Analytics will be frequently accessed. as such storage 1 "cool tie" is out of it. even though it is in the same region (East US) correct answer =storage 2 only

1. Storage Account Requirements ✅ Must be in the same region as the SQL Database (SQL1 is in East US). ✅ Must be Blob Storage or General-purpose v2 (GPv2). ❌ General-purpose v1 (GPv1) is NOT supported. Storage 1 2. Log Analytics Workspace Requirements ✅ Can be in any region (but it's recommended to use the same region as SQL1). All workspaces

Cross region storage accounts are now allowed to storage SQL audit logs.

About storage accounts: "If you have a general-purpose v1 or Blob Storage account, upgrade to a general-purpose v2 storage account." https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql#remarks "If you are deploying from the Azure portal, make sure that the storage account is in the same region as your database and server. If you are deploying through other methods, the storage account can be in any region." https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-setup?view=azuresql#audit-to-storage-destination

Created a blob with cool access tier and was able to add it, from the portal only the storage accounts which are in the same location can be used for data auditing hence Storage 1 and 2 is the right answer

Storage 1 and 2 Log analytics 1,2 and 3 https://docs.microsoft.com/en-us/azure/azure-sql/database/audit-logformat#:~: text=Blob%20audit,in%20the%20Azure%20storage%20account.

Storage 1 and 2 Log analytics 1,2 and 3 https://docs.microsoft.com/en-us/azure/azure-sql/database/audit-log- format#:~:text=Blob%20audit,in%20the%20Azure%20storage%20account.

storage1 & 2 both worked on lab

1. Storage1, Storage2, and Storage3 2. Analytics1, Analytics2, and Analytics3 https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-setup?view=azuresql#audit-to-storage-destination If you are deploying from the Azure portal, make sure that the storage account is in the same region as your database and server. If you are deploying through other methods, the storage account can be in any region.

Storage 2 Only Analytics 1, Analytics 2, and Analytics 3

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

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. For specific instructions see, Write audit to a storage account behind VNet and firewall. For more information, see Types of storage accounts.

Storage 1 & 2 - Reference: https://learn.microsoft.com/en-us/azure/storage/blobs/access-tiers-overview?source=recommendations Cool tier - An online tier optimized for storing data that is infrequently accessed or modified. Data in the cool tier should be stored for a minimum of 30 days. The cool tier has lower storage costs and higher access costs compared to the hot tier. Any reason why audit log can't be stored in blob storage with 'cool' tier?

Storage: 2 Only (storage 1 will not be used as the access tier is "Cool") Log Analytics: 1, 2, and 3

Salah lagi jawapan. HAdeiii

Consider storage account type. Blob Storage account (Storage 1) is the answer; GPv1 is not recommended. https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview