Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Azure Solutions Architect Expert · Microsoft
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
chatgpt answer regarding requirement of storage account to be in the same region as azure sql database: It depends how you configure auditing: Using the Azure portal: yes, the storage account must be in the same region as the Azure SQL database/server. Using other methods such as PowerShell, Azure CLI, REST API, ARM/Bicep: the storage account can be in any region. Microsoft’s Azure SQL auditing setup doc states that when deploying from the Azure portal, the storage account must be in the same region as the database and server, but with other deployment methods it can be in any region.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
chatgpt answer regarding requirement of storage account to be in the same region as azure sql database: It depends how you configure auditing: Using the Azure portal: yes, the storage account must be in the same region as the Azure SQL database/server. Using other methods such as PowerShell, Azure CLI, REST API, ARM/Bicep: the storage account can be in any region. Microsoft’s Azure SQL auditing setup doc states that when deploying from the Azure portal, the storage account must be in the same region as the database and server, but with other deployment methods it can be in any region.
Y,N,Y Y-SQLdb1 and storage1 are in the same resource group (RG1) and same region (East US), which is supported for auditing. N- SQLdb2 is in RG1 and on SQLsvr1 (East US), while storage2 is in RG2 and Central US. Cross-region auditing is not supported unless using a centralized logging solution. Y- SQLdb3 is in RG2 and on SQLsvr2 (West US), and storage2 is also in RG2, making it a valid target for audit logs.
YYY According to https://learn.microsoft.com/en-us/azure/storage/common/storage-account-create?tabs=azure-portal, "BlobStorage" Account Kind is Legacy Blob Storage. According to https://learn.microsoft.com/en-us/azure/storage/common/storage-account-overview?toc=%2Fazure%2Fstorage%2Fblobs%2Ftoc.json#legacy-storage-account-types, BlobStorage supports append blobs. No reason it can't be used for audit logging. As others have said can specify storage account in a different region if not doing it in Portal. References to Premium in the question are about SQL Service Tier; Not Storage Account.