70-466 · Question #40
You install SQL Server Reporting Services (SSRS). You need to back up a copy of the symmetric key. Which command should you run?
The correct answer is C. rskeymgmt-e -f %temp%\rs.key-p Password1. The rskeymgmt utility manages SSRS encryption keys, and the -e flag exports (backs up) the symmetric key to a protected file.
Question
Exhibit
Options
- Arskeymgmt -d
- Brskeymgmt -i
- Crskeymgmt-e -f %temp%\rs.key-p Password1
- Drskeymgmt-a -f %temp%\rs.key-p Password1
How the community answered
(47 responses)- A2% (1)
- C94% (44)
- D4% (2)
Why each option
The rskeymgmt utility manages SSRS encryption keys, and the -e flag exports (backs up) the symmetric key to a protected file.
rskeymgmt -d deletes the encrypted content from the report server database, which destroys key access rather than backing it up.
rskeymgmt -i imports and restores a previously backed-up key file, which is the restore operation rather than the backup operation.
The rskeymgmt -e flag exports the symmetric key to the file path specified by -f, encrypted with the password supplied via -p. This is the correct syntax for creating a backup copy of the SSRS symmetric key. The combination of -e, -f, and -p is required to produce a portable, password-protected key backup.
rskeymgmt -a applies a backup key file to re-encrypt report server content, which is a restoration action and not a backup.
Concept tested: SSRS symmetric key backup 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.