Create and Manage Database Tasks in Azure DP-300 Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   Which common issue might cause an Azure Automation runbook to fail when connecting to a database?

   • AIncorrect credentials or connection string
   • BThe runbook does not have a schedule
   • CThe database is too large
   • DThe runbook is too short
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is the role of Azure Automation in managing database tasks?

   • AIt replaces the need for any manual database administration
   • BIt provides a fully managed database service
   • CIt allows you to create and manage virtual machines
   • DIt provides a cloud-based service for automating and orchestrating tasks using runbooks
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   Your team has an Azure Automation runbook that performs a database maintenance task. The runbook currently runs on a schedule, but the team wants to also be able to trigger it manually from a mobile device when needed. What should you configure?

   • AUse the Azure Mobile App to start the runbook directly from the Automation Account blade.
   • BCreate a second schedule that runs the runbook every hour, and use the Azure Mobile App to check if it ran.
   • CCreate a webhook for the runbook and use the Azure Mobile App to call the webhook.
   • DCreate a logic app that triggers the runbook, and use the Azure Mobile App to trigger the logic app.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which of the following is a common notification channel that can be configured in an action group?

   • AAzure Storage
   • BEmail
   • CAzure SQL Database
   • DAzure Active Directory
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   You have an Elastic Job that runs a data aggregation process on a large Azure SQL Database. The job runs every hour and takes about 10 minutes to complete. Recently, the job has been failing because the database is under heavy load from other applications during the job's scheduled time. You need to reduce the impact of the job on the database while ensuring it completes. What should you do?

   • AIncrease the job step's retry attempts to 5 with a short retry interval, and keep the current schedule.
   • BChange the job's schedule to run during off-peak hours, and set the job step's timeout to 30 minutes.
   • CUse the job step's 'MAXDOP' setting to limit parallelism and reduce resource consumption.
   • DCreate a second job that runs the same process and use a load balancer to distribute the load.
   Reveal Solution Discussion Select an answer first