exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 4 discussion

Actual exam question from Microsoft's DP-300
Question #: 4
Topic #: 3
[All DP-300 Questions]

You have 50 Azure SQL databases.
You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure.
What should you do?

  • A. Create a diagnostic setting for the activity log that has the Security log enabled.
  • B. For the database, create a diagnostic setting that has the InstanceAndAppAdvanced metric enabled.
  • C. Create an alert rule that uses a Metric signal type.
  • D. Create an alert rule that uses an Activity Log signal type.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Activity log events - An alert can trigger on every event, or, only when a certain number of events occur.
The activity log of a database logs the change for the SKU (Stock-keeping-Unit) change.
Incorrect Answers:
C: Metric values - The alert triggers when the value of a specified metric crosses a threshold you assign in either direction. That is, it triggers both when the condition is first met and then afterwards when that condition is no longer being met.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/alerts-insights-configure-portal

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
shweta_majumder1234
Highly Voted 2 years, 1 month ago
The answer is correct.
upvoted 13 times
...
Raffer
Highly Voted 2 years, 4 months ago
Answer is correct. https://docs.microsoft.com/en-us/answers/questions/138020/auto-alert-when-compute-tier-of-azure-sql-is-chang.html
upvoted 7 times
...
raavilam
Most Recent 8 months, 2 weeks ago
D is correct answer Signal type: The type of alert rule you're creating. Types of alerts: Metric alerts: evaluate resource metrics at regular intervals. Log alerts: allow users to use a Log Analytics query to evaluate resource logs at a predefined frequency Activity log alerts: Are triggered when a new activity log event occurs that matches defined conditions. Resource Health alerts and Service Health alerts are activity log alerts that report on your service and resource health. Smart detection alerts: https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-overview#types-of-alerts
upvoted 7 times
...
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
Loading ...