AZ-500 Exam QuestionsBrowse all questions from this exam
Go to Exam

AZ-500 Exam - Question 292

HOTSPOT -

You have an Azure subscription that contains three storage accounts, an Azure SQL managed instance named SQL1, and three Azure SQL databases.

The storage accounts are configured as shown in the following table.

SQL1 has the following settings:

✑ Auditing: On

✑ Audit log destination: storage1

The Azure SQL databases are configured as 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 Answer
Correct Answer:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview

Discussion

16 comments
Sign in to comment
Kelly8023
Oct 8, 2022

Should be Y Y Y now. Reference: 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.

heatfan900
Aug 3, 2023

Premium storage with BlockBlobStorage is supported, NOT Premium Storagev2

cosine
Oct 6, 2021

Should be N N N? 1) Destination storage is not set 2) Destination is only set to storage 2 3) Destination storage is not set

alialiba
Oct 8, 2021

Same questions

C6H6
Oct 11, 2021

Destination Storage set at Server Level (SQL1)

Ajdlfasudfo0
Dec 28, 2022

why do you even answer if you have no clue?

dfranco76
Dec 30, 2022

DONT PAY ATTENTION TO THIS ANSWER. Better XAVI answer bellow

Kelly8023
Oct 2, 2022

Seems like premium storage is supported now - Reference: 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.

[Removed]
Oct 4, 2022

you are correct, now its supporting to Premium with blockblob

zellck
May 4, 2023

YYY is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-setup?view=azuresql#configure-auditing-for-your-server Server auditing policies apply to all existing and newly created databases on this server. If server auditing is enabled, the database-configured audit exists side-by-side with the server audit. https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql#remarks Premium storage with BlockBlobStorage is supported. Standard storage is supported.

Khasan
Feb 10, 2023

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

majstor86
Mar 4, 2023

YES YES YES

Ikazimirs
Sep 27, 2021

Correct: Auditing limitations Premium storage is currently not supported.

bogard
Oct 10, 2021

## Exam 10/09/2021

WhalerTom
Dec 29, 2021

In exam Dec 21. 40 questions, 1 case study, no labs.

[Removed]
Dec 30, 2021

YYN correct

adamsca
Dec 10, 2021

## Exam 12/10/2021

Logitech
Feb 26, 2022

Why storage 3 cannot be used for db3?

Logitech
Feb 26, 2022

ah is not supported https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview

heatfan900
Aug 3, 2023

Can someone please explain to me how the answers are yes if AUDITING is disabled for DB 1 and DB 3 and and DB2 is only writing audit logs to STORAGE 2. AUDIT EVENTS for DB1 written to STORAGE 1 = NO AUDIT EVENTS for DB2 written to STORAGE 1 n 2 = NO STORAGE 3 can be used as audit log destination for DB3 = NO https://medium.com/@sumathikits86/auditing-for-azure-sql-database-and-azure-synapse-analytics-d3e495a0f93

heatfan900
Aug 3, 2023

AUDIT EVENTS for DB1 written to STORAGE 1 =YES AUDIT EVENTS for DB2 written to STORAGE 1 n 2 = YES Just found the answer in the link provided about (so YES,YES, NO)

heatfan900
Sep 6, 2023

I MISUNDERSTOOD THE QUESTION: ITS ONE MANAGED INSTANCE WITH THREE DBs. THEREFORE, ITS Y, Y, Y. IF THE DBs ARE HOSTED IN ONE MANAGED INSTANCE AND AUDITING IS ENABLED THEN AUDITING WILL TAKE EFFECT REGARDLESS OF WHAT IS SET AT THE DB LEVEL. IF THERE IS AUDITING SET AT THE DB LEVEL THEN THAT WILL TAKE EFFECT AS WELL. SO FOR DB1 THE ANSWER IS YES. FOR DB2 THE ANSWER IS YES AND FOR THREE, SINCE BLOCK BLOB IS NOW SUPPORTED AND IS A TYPE OF PREMIUM STORAGE THEN THE ANSWER IS YES. EVEN THOUGH THE QUESTION DOES NOT TECHNICALLY SAY BLOCK BLOB FOR PREMIUM STORAGE TYPE.

hfk2020
Oct 2, 2023

Not a valid question part 2 and 3 it should N and Y there is no such thing as GPV2 Premium, but yes premium can be used for audit logs

wardy1983
Nov 2, 2023

Yes,yes,yes Reference: 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.

Jimmy500
Jul 19, 2024

I think here answer will be Yes,Yes,No. https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql Given link says that Standart storage is supported , if we go to the azure portal we can see that under performance tier of Azure Storage Account we have 2 options Standard which shows General Purpose v2 (Storagev2) and Premium under premium we can create storage account for files, block blobs and page blobs. In the statements (first one) is Standard and it supports audit logs from Azure SQL DB so first one will Yes . Second one will be yes as well. Interesting one is 3 rd one. According to documentation it says Premium supports BlockBlobStorage this means it does not support general purpose v2 *storage v2 , that is why I think answer will be Yes,Yes,NO Regards!