MS SQL Server - 69 - Creating Jobs and Operators (SQL Server Agent) MCQ

69 – Creating Jobs and Operators (SQL Server Agent) MCQ

1 / 25

1. What is the primary purpose of SQL Server Agent?

To manage database tables

To optimize query performance

To schedule and automate tasks and jobs

To create database backups

2 / 25

2. In SQL Server, which service must be running to use SQL Server Agent?

SQL Server Integration Services

SQL Server Analysis Services

SQL Server Reporting Services

SQL Server Database Engine

3 / 25

3. What is the first step to start SQL Server Agent?

Use the SQL Server Configuration Manager

Use the SQL Server Management Studio

Use the Windows Task Manager

Use the SQLCMD utility

4 / 25

4. In SQL Server, what is the primary purpose of creating jobs?

To schedule and automate tasks

To create database backups

To optimize query performance

To manage database users

5 / 25

5. What is an operator in SQL Server Agent?

A database user with elevated privileges

A system administrator

A database administrator

A recipient of job status notifications

6 / 25

6. In SQL Server, what is a job step?

A database table

A query execution plan

A unit of work within a job

A database backup operation

7 / 25

7. What is the primary purpose of creating a job step in SQL Server Agent?

To define individual units of work within a job

To configure job schedules

To specify job notifications

To create database backups

8 / 25

8. In SQL Server Agent, what type of job step allows you to run a Transact-SQL script?

SSIS Package

PowerShell

Transact-SQL

CmdExec

9 / 25

9. What is the primary purpose of creating a job schedule in SQL Server Agent?

To define job steps

To specify job notifications

To set the job status

To control when a job runs

10 / 25

10. Which SQL Server Agent job step type allows you to execute operating system commands or batch files?

SSIS Package

PowerShell

Transact-SQL

CmdExec

11 / 25

11. In SQL Server Agent, what is the purpose of job notifications?

To configure job schedules

To notify operators about the job status

To optimize query performance

To define job steps

12 / 25

12. What is the primary purpose of configuring job notifications in SQL Server Agent?

To specify job schedules

To create database backups

To send notifications when job status changes

To define individual units of work within a job

13 / 25

13. In SQL Server Agent, what is the Job History Log?

A log of database backup operations

A log of job status changes and execution details

A log of all executed SQL queries

A log of operator notifications

14 / 25

14. How can you view the Job History Log in SQL Server Agent?

Using the Windows Task Manager

Using the SQLCMD utility

Using the SQL Server Management Studio

Using the SQL Server Configuration Manager

15 / 25

15. Which SQL Server Agent job step type allows you to execute PowerShell scripts?

PowerShell

SSIS Package

CmdExec

Transact-SQL

16 / 25

16. In SQL Server Agent, what type of job step allows you to run SQL Server Integration Services packages?

SSIS Package

Transact-SQL

CmdExec

PowerShell

17 / 25

17. What is the primary advantage of using SQL Server Agent to automate tasks?

It creates database backups automatically

It provides a graphical user interface for managing databases

It optimizes query performance

It enables you to schedule and automate repetitive tasks

18 / 25

18. Which SQL Server Agent job step type allows you to execute a batch or script file with PowerShell commands?

PowerShell

Transact-SQL

SSIS Package

CmdExec

19 / 25

19. In SQL Server Agent, how can you specify who receives notifications about job status changes?

By creating operators

By configuring the Job History Log

By defining job steps

By configuring the job schedule

20 / 25

20. What is the primary purpose of creating operators in SQL Server Agent?

To receive notifications about job status

To define job steps

To configure job schedules

To optimize query performance

21 / 25

21. In SQL Server, what is the primary benefit of viewing the Job History Log?

It optimizes query performance.

It allows you to execute Transact-SQL scripts.

It provides a list of operators in the system.

It provides a record of job executions and their outcomes.

22 / 25

22. What is the primary advantage of using SQL Server Agent to schedule and automate tasks?

It reduces manual intervention and errors.

It configures job notifications automatically.

It ensures all queries run at maximum speed.

It simplifies database design.

23 / 25

23. Which SQL Server Agent job step type is used for executing SQL Server Integration Services packages?

PowerShell

CmdExec

SSIS Package

Transact-SQL

24 / 25

24. In SQL Server, what is the primary benefit of using the PowerShell job step type in SQL Server Agent?

It enables you to run batch files with PowerShell commands.

It allows you to execute Transact-SQL scripts.

It automates the creation of operators.

It provides a graphical user interface for managing jobs.

25 / 25

25. Which SQL Server Agent job step type allows you to execute operating system commands and batch files?

CmdExec

PowerShell

Transact-SQL

SSIS Package

Your score is

MS SQL Server – 69 – Creating Jobs and Operators (SQL Server Agent) MCQ