CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free DP-300 Exam Braindumps (page: 17)

Page 17 of 76
PDF with 352 Questions

You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.
You need to implement alerts by using Azure Monitor.

The solution must meet the following requirements:
-Minimize costs.
-Aggregate Intelligent Insights telemetry from each database.

What should you do?

  1. From the Diagnostic settings of each database, select Send to Log Analytics.
  2. From the Diagnostic settings of each database, select Stream to an event hub.
  3. From the Diagnostic settings of SQLMI1, select Send to Log Analytics.
  4. From the Diagnostic settings of SQLMI1, select Stream to an event hub.

Answer(s): A


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming- export-configure?tabs=azure-portal#configure-the-streaming-export-of-diagnostic-telemetry



You have an Azure SQL managed instance that hosts multiple databases.
You need to configure alerts for each database based on the diagnostics telemetry of the database. What should you use?

  1. Azure SQL Analytics alerts based on metrics
  2. SQL Health Check alerts based on diagnostics logs
  3. SQL Health Check alerts based on metrics
  4. Azure SQL Analytics alerts based on diagnostics logs

Answer(s): D


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal#configure-the-streaming-export-of-diagnostic-telemetry



You have an Azure SQL managed instance.
You need to enable SQL Agent Job email notifications.
What should you do?

  1. Use the Agent XPs option.
  2. Enable the SQL Server Agent.
  3. Run the sp_configure command.
  4. Run the sp_set_agent_properties command.

Answer(s): C

Explanation:

You would need to enable Database email extended procedure using Database Mail XPs configuration option:
EXEC sp_configure 'show advanced options', 1;

GO
RECONFIGURE;

GO
EXEC sp_configure 'Database Mail XPs', 1;

GO
RECONFIGURE

GO
Now you can test the configuration by sending emails using sp_send and sp_notify_operator procedures.


Reference:

https://techcommunity.microsoft.com/t5/azure-sql-blog/sending-emails-in-azure-sql-managed-instance/ba-p/386235



You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases.
You need to update the column and index statistics for the databases.
What should you use?

  1. an Azure Automation runbook
  2. a SQL Agent job
  3. Azure SQL Analytics
  4. automatic tuning in Azure SQL Database

Answer(s): A

Explanation:

You can create a runbook for index maintenance in an Azure SQL database.


Reference:

https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/



Page 17 of 76



Post your Comments and Discuss Microsoft DP-300 exam with other Community members:

laks commented on December 26, 2024
so far seems good
UNITED STATES
upvote

Jack commented on October 24, 2024
Muito bom as perguntas
Anonymous
upvote

TheUser commented on October 23, 2024
So far seems good
Anonymous
upvote

anonymus commented on October 23, 2024
master database differential backup is not supported in sql server
EUROPEAN UNION
upvote

Ntombi commented on October 17, 2024
i find the questions helpful for my exam preparation
Anonymous
upvote

Ntombi commented on October 17, 2024
The questions help me to see if I understood what I have learned
Anonymous
upvote

ntombi commented on October 17, 2024
writing exam at the end of the month
Anonymous
upvote

Raby commented on August 13, 2024
Wonderful work guys. The PDF version helped me pass. Thank you
EUROPEAN UNION
upvote