Your network contains a System Center 2012 Configuration Manager environment. The
Configuration Manager databases are located on a remote server that runs Microsoft SQL
Server.
You need to ensure that you can restore the Central Administration site.
What should you do?
A.
From the Configuration Manager console, enable the Backup Site Server maintenance
task and set a schedule.
B.
From Microsoft SQL Server Management Studio, create a maintenance plan for the site
databases.
C.
From Task Scheduler, create a scheduled task that runs smssqlbkup.exe.
D.
From Windows Server Backup, schedule a full system backup.
Explanation:
From the Configuration Manager console, enable the Backup Site Server maintenance task
and set a schedule.
http://technet.microsoft.com/en-us/library/gg712697.aspx
Backup and Recovery in Configuration Manager
Enterprise solutions such as System Center 2012 Configuration Manager must prepare for
both backup and recovery operations to avoid loss of critical data. For Configuration
Manager sites, this preparation ensures that sites and hierarchies are recovered with the
least data loss and in the quickest possible time. Back up a Configuration Manager Site
System Center 2012 Configuration Manager provides a backup maintenance task that runs
on a schedule and backs up the site database, specific registry keys, and specific folders
and files. Backup Maintenance Task You can automate backup for Configuration Manager
sites by scheduling the predefined Backup Site Server maintenance task. You can back up acentral administration site and primary site, but there is no backup support for secondary
sites or site system servers.
To enable the site backup maintenance task
1. In the Configuration Manager console, click Administration.
2. In the Administration workspace, expand Site Configuration, and then click Sites.
3. Select the site in which you want to enable the site backup maintenance task.
4. On the Home tab, in the Settings group, click Site Maintenance Tasks.
5. Click Backup Site Server and then click Edit.
6. Select Enable this task, and then click Set Paths to specify the backup destination.
7. Configure an appropriate schedule for the site backup task. As a best practice, consider a
backup schedule that is outside active working hours. If you have a hierarchy, consider a
schedule that runs at least two times a week to ensure maximum data retention in the event
of site failure.
8. Select whether to create an alert if the site backup task fails, click OK, and then click OK.
When selected, Configuration Manager creates a critical alert for the backup failure that you
can review in the Alerts node in the Monitoring workspace.
In my opinion A & B are both correct. You can configure SQL Maintenance Plan in SQL Management Studio. It is actually database backup. Later it can be restored or the DB can be imported on the new server.
I believe Maintenance on a SQL Database isn’t going to back it op. But I could be wrong.
Also, this exam is about the wonderful features of SCCM 2012 and not of SQL, so Microsoft would expect an answer that states the ability to backup the SCCM Environment from using the SCCM Management Console 🙂