What should you create?

You have multiple Microsoft SQL Server databases that are deployed in an Always On availability group. You configure the SQL Server Agent service to start automatically.

You need to automate backups for all user databases.

What should you create?
A . SQL script
B . SQL Agent operator
C . SQL Server message
D . SQL Agent job

View Answer

Answer: D

Explanation:

To schedule backups using a SQL Server Agent job To automate and schedule a backup with SQL Server Agent:

References: https://sqlbackupandftp.com/blog/how-to-automate-sql-server-database-backups