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

Questions 11–15

1. 11application · medium

   You have an Elastic Job that runs a critical data load every night. You need to ensure that the DBA team is notified if the job fails. What is the most efficient way to set this up?

   • AConfigure the job step to send an email if it fails.
   • BCreate a separate job that runs every hour and checks the status of the critical job.
   • CUse a logic app to monitor the job history and send an email on failure.
   • DCreate an alert rule on the job that sends an email to the DBA team when the job status is 'Failed'.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   You have an Elastic Job that runs a data integrity check on several Azure SQL databases. The job runs successfully, but you need to be notified if the job takes longer than 30 minutes. What is the best way to configure this?

   • AUse a log alert on the job history to detect when the job runs longer than 30 minutes.
   • BConfigure the job step to send an email if the step takes longer than 30 minutes.
   • CCreate a metric alert on the job execution duration that triggers an email when the duration exceeds 30 minutes.
   • DCreate a separate job that runs every 30 minutes to check if the previous job is still running.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   What is the primary purpose of elastic jobs in Azure SQL Database?

   • ATo automate the execution of T-SQL scripts across multiple Azure SQL databases on a schedule or on demand
   • BTo provide a fully managed backup and restore service for Azure SQL Database
   • CTo enable real-time data replication between Azure SQL databases
   • DTo replace the need for any manual database administration tasks
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which Azure service is commonly used to set up alerts for automated database tasks?

   • AAzure SQL Database
   • BAzure Automation
   • CAzure Logic Apps
   • DAzure Monitor
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   You have an Elastic Job that runs a data cleanup task on a set of Azure SQL Databases. The job is scheduled to run every day at 3:00 AM. Recently, the job has been failing because the target databases are not available at that time due to a maintenance window. You need to ensure the job runs successfully. What should you do?

   • AAdd a retry policy to the job step to retry the job if it fails.
   • BChange the job schedule to run at a time when the databases are available, such as 5:00 AM.
   • CCreate a new target group that excludes the databases that are unavailable during the maintenance window.
   • DIncrease the job step timeout to allow more time for the databases to become available.
   Reveal Solution Discussion Select an answer first