nerdexam
Veeam

VMCE_V12 · Question #19

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?

The correct answer is C. Give the DBA group Restore Operator access to MS SQL DBs in Enterprise Manager. To grant MS SQL DBAs the ability to restore their databases without giving access to other operations, the appropriate action is to give the DBA group Restore Operator access specifically to MS SQL databases within Veeam Enterprise Manager. This role-based access control allows…

Access Control and Delegation

Question

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?

Options

  • ADeny access to restore VMs in Enterprise Manager
  • BGive the DBA group Restore Operator access to the backup server
  • CGive the DBA group Restore Operator access to MS SQL DBs in Enterprise Manager
  • DDelegate application item recoveries to the DBA Group

How the community answered

(47 responses)
  • A
    17% (8)
  • B
    4% (2)
  • C
    72% (34)
  • D
    6% (3)

Explanation

To grant MS SQL DBAs the ability to restore their databases without giving access to other operations, the appropriate action is to give the DBA group Restore Operator access specifically to MS SQL databases within Veeam Enterprise Manager. This role-based access control allows DBAs to perform the needed restores while restricting access to other functionality.

Topics

#role-based access control#Enterprise Manager#SQL restore delegation#least privilege

Community Discussion

No community discussion yet for this question.

Full VMCE_V12 Practice