VMCE_V12 practice question 24 of 25

A corporation needs to give their MS SQL DBAs a way to restore their MS SQL databases. Which action would allow the corporation to grant this access without giving access to other operations?

Full set: 109 questions

Domain Veeam Backup Enterprise Manager

Answer options
A: Deny access to restore VMs in Enterprise Manager
B: Give the DBA group Restore Operator access to the backup server
C: Give the DBA group Restore Operator access to MS SQL DBs in Enterprise Manager Correct answer
D: Delegate application item recoveries to the DBA Group
Correct Answer:
C. Give the DBA group Restore Operator access to MS SQL DBs in Enterprise Manager
Explanation

Veeam Enterprise Manager is the designated component for delegating restore capabilities to specific users or groups, such as database administrators (DBAs). By assigning the "Restore Operator" role to the DBA group within Enterprise Manager and scoping this role to the specific Microsoft SQL Server database objects, the corporation can enable self-service restores for DBAs. This approach grants them the necessary permissions to restore their databases through the web-based interface without providing access to the main Veeam Backup & Replication console or other restore operations, thereby adhering to the principle of least privilege.

Why Incorrect

A. Denying access is a restrictive action. It does not grant the necessary permissions for the DBAs to perform their required tasks.
B. The Restore Operator role on the main backup server provides broad permissions to restore any workload, not just SQL databases, violating the principle of least privilege.
D. This option describes the desired outcome (delegation) but does not specify the correct Veeam mechanism or role required to implement it.

References

1. Veeam Backup Enterprise Manager Guide V12, "Security," section "Managing Roles and Users." This section details the predefined security roles, including the "Restore Operator." It states, "Users with this role can perform restore operations with Veeam Backup Enterprise Manager. When you assign this role, you can specify the scope of objects that the user will be able to restore." This confirms that the role can be scoped to specific items.

2. Veeam Backup Enterprise Manager Guide V12, "Restoring Microsoft SQL Server Databases," section "Required Permissions." This section explicitly states, "To restore Microsoft SQL Server databases, you must have the Portal Administrator or Restore Operator role." This directly links the required task to the specific role in Enterprise Manager.

Scroll to Top