You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. The sales and marketing departments contain a total of 60 users…

While SQL Server Agent jobs can schedule tasks, configuring individual jobs for 60+ databases and then manually adding jobs for every new database would be inefficient and does not meet the requirement of automatic inclusion.

Change Data Capture (CDC) is a feature designed to capture and track changes made to data in a SQL Server database, not to perform database backups.

Policy-Based Management (PBM) is used to create and enforce administrative policies for SQL Server instances and objects, focusing on configuration compliance rather than executing operational tasks like backups.

SQL Server Maintenance Plans allow administrators to automate and schedule various administrative tasks, including full, differential, and transaction log backups, across multiple databases. They can be configured to back up 'All user databases' or 'All databases', which ensures that any new databases created on the server are automatically included in the predefined backup schedule without manual intervention.