You have an Azure subscription that contains an Azure SQL database named DB1 in the East US Azure region.
You create the storage accounts shown in the following table.
 
You plan to enable auditing for DB1.
Which storage accounts can you use as the auditing destination for DB1?

A. storage1 and storage4 only

B. storage1 only

C. storage1, storage2, storage3, and storage4

D. storage1, storage2, and storage3 only

E. storage2 and storage3 only






 

Suggested Answer: E

To enable writing to a storage account, the one has to be configured first. Storage accounts are containers used to store Azure Storage objects, including blobs, files, tables, etc, for the auditing needs, general-purpose standard storage accounts will support storing audit data trail, to learn more about storage accounts.
Incorrect:
Not A, Not C: Use a storage account in the same region as the managed instance to avoid cross-region reads/writes.
Reference:
https://www.sqlshack.com/getting-started-with-azure-sql-database-auditing-using-blob-storage/
 https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure

This question is in AZ-500 Exam
For getting Microsoft Azure Security Engineer Associate Certificate


Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.