ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam
Go to Exam

Exam AZ-304 topic 1 question 5 discussion

Actual exam question from Microsoft's AZ-304
Question #: 5
Topic #: 1
[All AZ-304 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Hooters
Highly Voted 4 years ago
YNN is the answer by looking a the storage location and its tier
upvoted 43 times
danielcr
3 years, 11 months ago
YNN, can´t use storage2 because it´s in other region (checked in portal)
upvoted 13 times
examineezer
3 years, 5 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 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 ago
Plus - Premium storage is not supported currently
upvoted 8 times
demonite
4 years ago
Sql Premium sku not premium storage
upvoted 7 times
dennnnnnnnnn
3 years, 9 months ago
blobstorage imply premium storage account
upvoted 3 times
joefdez
3 years, 2 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, 1 month 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, 1 month ago
I have passed AZ-305 on 15th April,2023 and this question was there in the exam
upvoted 1 times
...
GarryK
2 years, 7 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
2 years, 10 months ago
was in the exam on 6/17
upvoted 2 times
...
Azure_daemon
3 years 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, 1 month ago
Presented answer if correct, Y, N , N
upvoted 1 times
...
plmmsg
3 years, 2 months ago
yes. no, no
upvoted 1 times
...
Azure_daemon
3 years, 2 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, 3 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, 4 months ago
On exam 24.12.2021
upvoted 3 times
...
Dpejic
3 years, 4 months ago
On exam 22-dec-2021
upvoted 4 times
...
sharepoint_Azure_pp
3 years, 6 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, 7 months ago
Correct.
upvoted 1 times
...
syu31svc
3 years, 7 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, 8 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, 8 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...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago