Exam 70-764 topic 1 question 12 discussion

Actual exam question from Microsoft's 70-764

Question #: 12
Topic #: 1

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments.
You have a user database named HRDB that contains sensitive human resources data. The HRDB backup files 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

Show Suggested Answer

Suggested Answer: G 🗳️
Restoring the encrypted backup: SQL Server restore does not require any encryption parameters to be specified during restores. It does require that the certificate or the asymmetric key used to encrypt the backup file be available on the instance that you are restoring to. The user account performing the restore must have
VIEW DEFINITION permissions on the certificate or key.
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-encryption

by TheSwedishGuy at Jan. 27, 2020, 10:36 a.m.

Comments

Submit Cancel

Chandra111

4 years, 4 months ago

View Definition.

upvoted 1 times

...

TheSwedishGuy

5 years, 5 months ago

If it has to do with encryptions, you need to see the metadata values in the certificate. This requires View Definition.

upvoted 2 times

...