Which permission should you grant?

You are the database administrator for a company that hosts Microsoft SQL Server. You manage both onpremisesand Microsoft Azure SQL Database environments.

You have a user database named HRDB that contains sensitive human resources data. The HRDB backupfiles must be encrypted.

You need to grant the correct permission to the service account that backs up the HRDB database.

Which permission should you grant?
A . DDLAdmin
B . db_datawriter
C . dbcreator
D . dbo
E . View Database State
F . View Server State
G . View Definition
H . sysadmin

View Answer

Answer: G

Explanation:

Restoring the encrypted backup: SQL Server restore does not require any encryption parameters to bespecified during restores. It does require that the certificate or the asymmetric key used to encrypt the backupfile be available on the instance that you are restoring to. The user account performing the restore must haveVIEW DEFINITION permissions on the certificate or key.

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-encryption