ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 2 question 37 discussion

Actual exam question from Microsoft's DP-300
Question #: 37
Topic #: 2
[All DP-300 Questions]

You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the following columns.



You plan to enable Always Encrypted for Table1.

Which two columns support encryption? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

  • A. Column1
  • B. Column2
  • C. Column3
  • D. Column4
  • E. Column5
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
by JG1984 at April 10, 2023, 8:35 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
kev22
Highly Voted 1 year, 7 months ago
Selected Answer: DE
Always Encrypted isn't supported for the columns using one of the following data types: xml, timestamp, rowversion, image, ntext, text, sql_variant, hierarchyid, geography, geometry, alias, user-defined types.
upvoted 17 times
...
Brandon_Marlin
Most Recent 8 months, 2 weeks ago
Selected Answer: DE
As everyone said Always Encrypted isn't supported for the columns with the below characteristics: Columns using one of the following data types: xml, timestamp, rowversion, image, ntext, text, sql_variant, hierarchyid, geography, geometry, alias, user-defined types
upvoted 2 times
...
bsk1983
1 year, 2 months ago
Selected Answer: DE
Alwayson encrypted is not supported for ntext data type
upvoted 2 times
...
[Removed]
1 year, 2 months ago
Selected Answer: DE
Only D and E are supported on Always Encrypted
upvoted 3 times
...
pixieD
1 year, 5 months ago
Selected Answer: DE
D&E Always Encrypted isn't supported for ntext
upvoted 2 times
...
susejzepol
1 year, 6 months ago
Selected Answer: DE
Correct answer is D and E.
upvoted 2 times
...
taianycoelho
1 year, 6 months ago
https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver16 A,b,c is wrong
upvoted 2 times
...
amazonalex
1 year, 7 months ago
D and E
upvoted 3 times
...
Pranava_GCP
1 year, 7 months ago
Selected Answer: D
D is definitely correct, not sure about E, as datetime2 is a timestamp that should not be included as supported data type.
upvoted 1 times
...
JG1984
1 year, 7 months ago
Answer is D & E https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver16
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel