Examice

Exam AZ-500 All QuestionsBrowse all questions from this 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:

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

Kelly8023

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

Premium storage with BlockBlobStorage is supported, NOT Premium Storagev2

Kelly8023

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]

you are correct, now its supporting to Premium with blockblob

cosine

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

Same questions

C6H6

Destination Storage set at Server Level (SQL1)

Ajdlfasudfo0

why do you even answer if you have no clue?

dfranco76

DONT PAY ATTENTION TO THIS ANSWER. Better XAVI answer bellow

zellck

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

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

majstor86

YES YES YES

bogard

## Exam 10/09/2021

Ikazimirs

Correct: Auditing limitations Premium storage is currently not supported.

[Removed]

YYN correct

WhalerTom

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

Jimmy500

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!

wardy1983

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.

hfk2020

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

heatfan900

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

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

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.

Logitech

Why storage 3 cannot be used for db3?

Logitech

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

adamsca

## Exam 12/10/2021