BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 70-465 Topic 1 Question 4 Discussion

Actual exam question for Microsoft's 70-465 exam
Question #: 4
Topic #: 1
[All 70-465 Questions]

You are creating a database that will store usernames and passwords for an application.

You need to recommend a solution to store the passwords in the database.

What should you recommend?

More than one answer choice may achieve the goal. Select the BEST answer.

Show Suggested Answer Hide Answer
Suggested Answer: C

* Transparent Data Encryption (TDE) is a special case of encryption using a symmetric key. TDE encrypts an entire database using that symmetric key called the database encryption key. The database encryption key is protected by other keys or certificates which are protected either by the database master key or by an asymmetric key stored in an EKM module.

* SQL Server provides the following mechanisms for encryption:

Transact-SQL functions

Asymmetric keys

Symmetric keys

Certificates

Transparent Data Encryption


Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel