Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 1 question 21 discussion

Actual exam question from Microsoft's AZ-305

Question #: 21
Topic #: 1

HOTSPOT -
You have an Azure subscription that contains the resources shown in the following table.

You create an Azure SQL database named DB1 that is hosted in the East US Azure region.
To DB1, you add a diagnostic setting named Settings1. Settings1 archive SQLInsights to storage1 and sends SQLInsights to Workspace1.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: Yes -
A single diagnostic setting can define no more than one of each of the destinations. If you want to send data to more than one of a particular destination type (for example, two different Log Analytics workspaces), then create multiple settings.
Each resource can have up to 5 diagnostic settings.
Note: This diagnostic telemetry can be streamed to one of the following Azure resources for analysis.
* Log Analytics workspace
* Azure Event Hubs
* Azure Storage

Box 2: Yes -

Box 3: Yes -
Reference:
https://docs.microsoft.com/en-us/azure/azure-monitor/essentials/diagnostic-settings https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal

by Snownoodles at Sept. 3, 2022, 4:34 p.m.

Comments

Submit Cancel

most_lenyora

Highly Voted 2 years, 8 months ago

Yes, Yes, Yes

upvoted 47 times

TonySuccess

1 year, 3 months ago

That's what sh...

upvoted 18 times

lebeyic620

1 year, 1 month ago

...e said

upvoted 8 times

...

ment0s

Highly Voted 1 year, 11 months ago

On exam June 28, 2023 Answered: Yes,Yes,Yes Passed with 917 Good luck and don't stop believing in yourself.

upvoted 30 times

...

shaiketisalat

Most Recent 6 months, 2 weeks ago

Today's exam question

upvoted 5 times

...

[Removed]

6 months, 2 weeks ago

CORRECT

upvoted 1 times

...

Len83

9 months, 2 weeks ago

This question was in the exam, August 2024. I gave this same answer and scored 870

upvoted 4 times

...

Hannirac

10 months, 3 weeks ago

in the exam 1/7/2024

upvoted 2 times

...

23169fd

11 months ago

Y,Y,Y You can add a new diagnostic setting that archives SQLInsights logs to storage2. Yes. You can add multiple diagnostic settings to an Azure SQL Database, and these settings can send logs to different destinations, including various storage accounts. Since storage2 is a valid Azure Storage account, you can add a new diagnostic setting that archives logs to storage2. You can add a new diagnostic setting that sends SQLInsights logs to Workspace2. Yes. Similar to the first point, Azure SQL Database allows sending logs to multiple Log Analytics workspaces. Since Workspace2 is a valid Log Analytics workspace, you can add a new diagnostic setting that sends logs to Workspace2. You can add a new diagnostic setting that sends SQLInsights logs to Hub1. Yes. Azure SQL Database diagnostic settings can send logs to an Azure Event Hub. Hub1 is a valid Azure Event Hub, so you can add a new diagnostic setting that sends logs to Hub1.

upvoted 4 times

_punky_

7 months ago

Confirmed - the ans is correct

upvoted 1 times

...

Chenn

1 year ago

YYN You can add a new diagnostic setting that archives SQLInsights logs to storage2: Yes, you can add a new diagnostic setting that archives SQLInsights logs to storage2. This is because storage2 is a StorageV2 (general purpose v2) account, which supports the archiving of SQLInsights logs. You can add a new diagnostic setting that sends SQLInsights logs to workspace2: Yes, you can add a new diagnostic setting that sends SQLInsights logs to workspace2. Workspace2 is an Azure Log Analytics workspace, which supports the ingestion of SQLInsights logs. You can add a new diagnostic setting that sends SQLInsights logs to hub1: No, you cannot add a new diagnostic setting that sends SQLInsights logs to hub1. Hub1 is an Azure event hub, which does not support the ingestion of SQLInsights logs.

upvoted 3 times

...