SQL Agent Jobs Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Task Automation

SQL Agent Jobs Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which SQL Server component is primarily responsible for scheduling and executing automated tasks such as backups and maintenance plans?

  2. 2

    When creating a new SQL Agent Job, which component defines the actual work (e.g., T-SQL script, PowerShell, or SSIS package) to be performed?

  3. 3

    If you need a job to run every day at 2:00 AM, which component of the SQL Agent Job must be configured?

  4. 4

    You want to be notified via email immediately if a critical maintenance job fails. Which feature should you configure in the job properties?

  5. 5

    You are running a job step that executes a PowerShell script. The job fails with an 'Access Denied' error, even though the SQL Server Agent service account has high privileges. What is the most secure way to resolve this?