Microsoft Discussions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam

Go to Exam

Exam 70-764 topic 1 question 240 discussion

Actual exam question from Microsoft's 70-764

Question #: 240
Topic #: 1

[All 70-764 Questions]

You work as a Database Administrator (DBA) for a company named ABC.com.
The company has a Windows Azure subscription.
The company uses a cloud based SQL Server environment hosted on SQL Azure.
Developers in your company are creating an ecommerce website.
You are designing a database for the website.
The database will be hosted on SQL Azure.
The database will store and reuse web site login details and customer credit card numbers.
You need to ensure the username, passwords and credit card details are securely stored in the database.
Which of the following would be the most suitable secure storage solution?

A. Secure Sockets Layer (SSL)
B. IPSec
C. Data encryption
D. Transparent Data Encryption (TDE)
E. Encrypting File System (EFS)

Show Suggested Answer

Suggested Answer: C 🗳️

by TheSwedishGuy at Jan. 31, 2020, 1:42 p.m.

Comments

Submit Cancel

V_karag

4 years, 11 months ago

"securely stored in the database". This concept refers to data encryption at rest so TDE is also an option that meets requirements.

upvoted 1 times

V_karag

4 years, 11 months ago

i am wrong. data encryption is a prefered soloution. The question wants specific data to be encrypted not the entire data file.

upvoted 1 times

...

...

TheSwedishGuy

5 years, 4 months ago

Data encryption = AlwaysEncrypted

upvoted 2 times

huzein

4 years, 7 months ago

Data encryption = cell-level encryption.

upvoted 1 times

...

...