Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam

Exam AZ-304 topic 1 question 5 discussion

Actual exam question from Microsoft's AZ-304

Question #: 5
Topic #: 1

HOTSPOT -
You have an Azure subscription that contains the SQL servers on Azure shown in the following table.

The subscription contains the storage accounts shown in the following table.

You create the Azure SQL databases shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: Yes -
Be sure that the destination is in the same region as your database and server.

Box 2: No -

Box 3: No -
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing

by LuiZ146 at April 30, 2021, 1:08 p.m.

Comments

Submit Cancel

Hooters

Highly Voted 4 years, 1 month ago

YNN is the answer by looking a the storage location and its tier

upvoted 43 times

danielcr

4 years, 1 month ago

YNN, can´t use storage2 because it´s in other region (checked in portal)

upvoted 13 times

examineezer

3 years, 6 months ago

Seems like the documentation doesn't say that it has to be in the same region, but if you try it in a lab you'll see that it does.

upvoted 1 times

...

LuiZ146

Highly Voted 4 years, 2 months ago

The last one is no, because the Azure SQL Server and the storage account are in different locations.

upvoted 15 times

kumarofrcet

4 years, 1 month ago

Plus - Premium storage is not supported currently

upvoted 8 times

demonite

4 years, 1 month ago

Sql Premium sku not premium storage

upvoted 7 times

dennnnnnnnnn

3 years, 11 months ago

blobstorage imply premium storage account

upvoted 3 times

joefdez

3 years, 4 months ago

BlobStorage is Standard, BlockBlobStorage and FileStorate are Premium. YNN, because the auditing needs to be on same region.

upvoted 3 times

FrancisFerreira

3 years, 3 months ago

Dont think so... BlobStorage = Premium Page Blob BlockBlobStorage = Premium Block/Append Blob FileStorage = Premium File Share

upvoted 2 times

...

gauravit43

Most Recent 2 years, 2 months ago

I have passed AZ-305 on 15th April,2023 and this question was there in the exam

upvoted 1 times

...

GarryK

2 years, 9 months ago

YNN. BlobStorage is legacy storage. 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. https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql

upvoted 1 times

...

dpakrawat

3 years ago

was in the exam on 6/17

upvoted 2 times

...

Azure_daemon

3 years, 2 months ago

The SQL and storage (event hub or log analytic workspace) has to be in the same region, also one of the auditing limitation is that, Premium storage is currently not supported.

upvoted 2 times

...

Odidepse

3 years, 2 months ago

Presented answer if correct, Y, N , N

upvoted 1 times

...

plmmsg

3 years, 3 months ago

yes. no, no

upvoted 1 times

...

Azure_daemon

3 years, 4 months ago

Auditing limitations Premium storage is currently not supported. Hierarchical namespace for Azure Data Lake Storage Gen2 storage account is currently not supported. Enabling auditing on a paused Azure Synapse is not supported. To enable auditing, resume Azure Synapse. Auditing for Azure Synapse SQL pools supports default audit action groups only.

upvoted 1 times

...

BhupalS

3 years, 5 months ago

YNN Auditing limitations Premium storage is currently not supported. Hierarchical namespace for Azure Data Lake Storage Gen2 storage account is currently not supported. Enabling auditing on a paused Azure Synapse is not supported. To enable auditing, resume Azure Synapse. Auditing for Azure Synapse SQL pools supports default audit action groups only.

upvoted 2 times

...

Dpejic

3 years, 6 months ago

On exam 24.12.2021

upvoted 3 times

...

Dpejic

3 years, 6 months ago

On exam 22-dec-2021

upvoted 4 times

...

sharepoint_Azure_pp

3 years, 8 months ago

YNN is the answer or can say i choose the same. was there in 17th October 2021 cleared with 900

upvoted 5 times

...

tteesstt

3 years, 8 months ago

Correct.

upvoted 1 times

...

syu31svc

3 years, 9 months ago

You can store the audit information in Blob storage as long as the storage account is in the same location as the Azure SQL Server https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview Premium storage is currently not supported. Yes No No is correct

upvoted 3 times

...

SpicyMonkey

3 years, 9 months ago

Auditing limitations Premium storage is currently not supported. https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview#auditing-limitations

upvoted 2 times

...

souvik123

3 years, 9 months ago

Y --> audit is possible on same location N--> different location to sql server N- -> blob is not a valid option on Storage V1 & Storage V2 & Storage in a different location

upvoted 1 times

...

Load full discussion...