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

Questions 1–5

1. 1foundation · easy

   In an elastic job, what defines the specific T-SQL script to be executed?

   • AJob schedule
   • BJob agent
   • CJob step
   • DJob target group
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   You are configuring an Elastic Job to rebuild indexes on a set of Azure SQL databases. The job must run every Sunday at 2:00 AM. If the job fails, you need to be notified. What should you do to configure this?

   • AUse Azure Automation to create a runbook that runs the script, and then link it to an Elastic Job schedule.
   • BCreate a job step that runs the script, then create a separate schedule for each database in the target group.
   • CConfigure the job to run continuously and use a logic app to check the time and trigger the job.
   • DCreate a job with a job step that runs the index rebuild script, and set a schedule with a recurrence of weekly on Sunday at 2:00 AM. Add an alert on the job to send an email on failure.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is a key benefit of setting up alerts for database automation tasks?

   • AAutomatic rollback of failed tasks
   • BEarly detection of failures or anomalies
   • CElimination of the need for database backups
   • DReduction of database storage costs
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is the first step when creating an elastic job in Azure SQL Database?

   • ACreate a job agent
   • BAdd a schedule
   • CDefine a job step
   • DRun the job
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   Your company uses Azure Automation to run a daily PowerShell runbook that performs a backup verification on an Azure SQL Managed Instance. The runbook currently runs successfully, but the operations manager wants to be notified by email when the runbook completes successfully, and by SMS when it fails. What should you configure?

   • ACreate a single action group with both email and SMS actions, and create one alert on the runbook's 'Completed' status.
   • BCreate two action groups: one with an email action for success, and one with an SMS action for failure. Create two alerts on the runbook: one for 'Completed' status and one for 'Failed' status, each linked to the appropriate action group.
   • CModify the runbook to send an email on success and an SMS on failure using the Send-MailMessage and Send-SMS cmdlets.
   • DUse the runbook's output to trigger a logic app that sends email on success and SMS on failure.
   Reveal Solution Discussion Select an answer first