Microsoft DP-300 Exam - Topic 3 Question 112 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 112
Topic #: 3

[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

AColumn1

BColumn2

CColumn3

DColumn4

EColumn5

Show Suggested Answer

Suggested Answer: A, D

by Vinnie at Mar 20, 2025, 06:09 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Thurman

4 months ago

Column4 definitely can't be encrypted, just saying.

upvoted 0 times

...

Celestine

5 months ago

Wait, are you sure about Column2? I thought it was Column3.

upvoted 0 times

...

Alonso

5 months ago

Column1 and Column2 are the ones that support encryption.

upvoted 0 times

...

Janey

5 months ago

Totally agree, those are the right choices!

upvoted 0 times

...

Daryl

5 months ago

I thought Always Encrypted only worked with certain data types, right?

upvoted 0 times

...

Mabel

5 months ago

I feel like Column2 and Column4 are the ones that support encryption, but I need to double-check the data types for Always Encrypted.

upvoted 0 times

...

Isaac

6 months ago

I have a vague memory that numeric types can be encrypted, but I can't recall if that applies to all columns listed here.

upvoted 0 times

...

Brandee

6 months ago

I think Column1 and Column5 might be the right choices. I practiced a similar question where certain columns were restricted based on their data types.

upvoted 0 times

...

Miesha

6 months ago

I remember that Always Encrypted can only be applied to certain data types, but I'm not sure which columns here are eligible.

upvoted 0 times

...

Brittni

6 months ago

I've worked with Always Encrypted before, so I'm confident I can identify the right columns to encrypt for this scenario. Let me carefully review the information provided.

upvoted 0 times

...

Gianna

6 months ago

This seems straightforward enough. I'll just need to match the column names to the encryption capabilities to determine the correct answer.

upvoted 0 times

...

Laticia

7 months ago

I'm a bit confused on the specifics of Always Encrypted and which data types are supported. I'll need to do some quick research to make sure I understand the requirements before answering.

upvoted 0 times

...

Rolande

7 months ago

Okay, let me think this through step-by-step. I need to identify which columns can be encrypted based on the data types and encryption capabilities.

upvoted 0 times

...

Edgar

7 months ago

Hmm, this looks like a tricky one. I'll need to carefully review the column data types and encryption requirements to determine which columns support Always Encrypted.

upvoted 0 times

...

Chauncey

1 year ago

Good idea. Let's make sure we get this right for the exam.

upvoted 0 times

...

Christiane

1 year ago

Hmm, I'm not sure. Let's check the documentation to confirm.

upvoted 0 times

...

Chauncey

1 year ago

I believe it's Column3 and Column5 that support encryption.

upvoted 0 times

...

Tegan

1 year ago

Ah, the ol' Azure SQL encryption conundrum. I'm putting my money on C and D, the dynamic duo of data security!

upvoted 0 times

Ligia

11 months ago

No, it's definitely C and D for enabling encryption on Azure SQL.

upvoted 0 times

...

Meghann

11 months ago

I'm not so sure, I think it might be A and B instead.

upvoted 0 times

...

Madalyn

11 months ago

I agree, C and D are the correct choices for enabling Always Encrypted.

upvoted 0 times

...

Lyla

11 months ago

I think you're right, C and D are the columns that support encryption.

upvoted 0 times

...

Goldie

12 months ago

I'm leaning towards C and D as well, they seem like the best options for encryption.

upvoted 0 times

...

Jovita

12 months ago

I'm not so sure about C, but D definitely looks like a good choice for encryption.

upvoted 0 times

...

Verda

12 months ago

I agree, C and D seem like the most likely candidates for encryption.

upvoted 0 times

...

Alaine

1 year ago

I think C and D are the columns that support encryption.

upvoted 0 times

...

Christiane

1 year ago

I think Column2 and Column4 support encryption.

upvoted 0 times

...

Aretha

1 year ago

Hmm, this is a tricky one. I'm gonna have to go with my gut and say C and D are the way to go. *crosses fingers*

upvoted 0 times

...

Marget

1 year ago

I'd go with C and D. Those columns look like they can handle the encryption requirements based on the image.

upvoted 0 times

Howard

1 year ago

User1: Let's go with C and D then.

upvoted 0 times

...

Kayleigh

1 year ago

User2: I agree, those columns seem to be suitable for encryption.

upvoted 0 times

...

Melissa

1 year ago

User1: I think C and D are the correct columns for encryption.

upvoted 0 times

...

Kimberely

1 year ago

Looks like Column3 and Column4 are the only ones that support encryption. The others don't have the required data types.

upvoted 0 times

Gabriele

1 year ago

User1: So, we should focus on setting up Always Encrypted for Column3 and Column4.

upvoted 0 times

...

Buck

1 year ago

User2: Yeah, the others don't have the right data types for encryption.

upvoted 0 times

...

Chantell

1 year ago

User1: I think Column3 and Column4 are the ones that support encryption.

upvoted 0 times

...