70-466 · Question #66
You reinstall SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run?
The correct answer is B. rskeymgmt -a -f %temp%\rs.key -p Password1. To restore a symmetric key in SSRS, the rskeymgmt utility must be run with the -a flag, which applies a previously exported key backup file to the report server.
Question
Options
- Arskeymgmt -d
- Brskeymgmt -a -f %temp%\rs.key -p Password1
- Crskeymgmt -e -f %temp%\rs.key -p Password1
- Drskeymgmt -l
How the community answered
(20 responses)- A10% (2)
- B85% (17)
- D5% (1)
Why each option
To restore a symmetric key in SSRS, the rskeymgmt utility must be run with the -a flag, which applies a previously exported key backup file to the report server.
rskeymgmt -d deletes the symmetric key and all encrypted content from the report server database, which is the opposite of restoring.
The rskeymgmt -a flag stands for 'apply' and is used to restore a backup copy of the symmetric key from a specified file (-f) using the password (-p) that was set when the key was exported. After a reinstall, this restores access to previously encrypted content such as credentials stored in the report server database.
rskeymgmt -e extracts (exports) the current symmetric key to a backup file - this creates a backup, it does not restore one.
rskeymgmt -l lists all accounts registered in the report server service, providing no functionality for key restoration.
Concept tested: SSRS symmetric key restoration using rskeymgmt
Source: https://learn.microsoft.com/en-us/sql/reporting-services/tools/rskeymgmt-utility-ssrs
Topics
Community Discussion
No community discussion yet for this question.