Microsoft
70-473 · Question #76
70-473 Question #76: Real Exam Question with Answer & Explanation
Sign in or unlock 70-473 to reveal the answer and full explanation for question #76. The question stem and answer options stay visible for context.
Question
Your company has a data warehouse that contains a database named DB1. You plan to implement data encryption for DB1. You need to configure DB1 to meet the following requirements: - Prevent the system administrators of App1 from reading the Personally Identifiable Information (PII) stored in DB1. - Ensue that all backups are Stored in an on-premises local drive for three days. - Ensure that all backups are stored in a remote location for 10 days. - Encrypt all backups. All solution must support the ODBC Driver for Microsoft SQL Server 2012. Which two solutions should you implement for DB1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- AEncrypt within the application tier.
- BBack up DB1 by using VSS snapshots.
- CImplement the Always Encrypted feature.
- DBack up DB1 to a disk and a URL by using Mirror TO.
- EEncrypt within DB1 by using EncryptBypassword.
Unlock 70-473 to see the answer
You've previewed enough free 70-473 questions. Unlock 70-473 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.