Holly is the Microsoft Project Server administrator and she has completed a full backup of her
Microsoft SQL Server database. Holly has added a media set password to the backup tape. Holly later
learns that someone has overwritten the media although she used a password on the backup tape.
What is the most likely reason why the media was overwritten even though Holly used a password
on the backup tape?
A.
Passwords do not encrypt the data or prevent someone from overwriting or appending to the
media.
B.
Passwords only work with Microsoft Windows Backup.
C.
Someone has guessed Holly’s password for the media.
D.
Holly did not check the “Password Require for Media” option during the backup.
Explanation:
The password option for media is weak and unsecure. It does not prevent another person from
overwriting the media.Answer option C is incorrect. This is possible, but it is not the best answer.
Answer option B is incorrect. The passwords in the Windows Backup are weak and do not prevent
the data from being accessed elsewhere, but this is not the best answer.
Answer option D is incorrect. This is not a valid option in the backup software for the SQL database.