Microsoft DP-300 Exam - Topic 10 Question 33 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 33
Topic #: 10

[All DP-300 Questions]

You have a data warehouse in Azure Synapse Analytics.

You need to ensure that the data in the data warehouse is encrypted at rest.

What should you enable?

ATransparent Data Encryption (TDE)

BAdvanced Data Security for this database

CAlways Encrypted for all columns

DSecure transfer required

Show Suggested Answer

Suggested Answer: A

Transparent data encryption (TDE) helps protect Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics against the threat of malicious offline activity by encrypting data at rest.

https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview

by Dean at May 08, 2022, 12:14 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Xochitl

4 months ago

C sounds cool, but it’s not for encryption at rest, right?

upvoted 0 times

...

Ressie

4 months ago

I agree, A is the best option here!

upvoted 0 times

...

Chantell

4 months ago

Wait, is TDE really enough for all scenarios?

upvoted 0 times

...

Mary

5 months ago

I thought B was the right choice, but I guess TDE is simpler.

upvoted 0 times

...

Annice

5 months ago

Definitely A, TDE is the go-to for encryption at rest.

upvoted 0 times

...

Regenia

5 months ago

I feel like Advanced Data Security might be relevant, but I can't recall if it specifically covers encryption at rest.

upvoted 0 times

...

Whitney

5 months ago

I’m a bit confused; I thought Always Encrypted was for data in transit, not at rest.

upvoted 0 times

...

Jimmie

5 months ago

I think it's TDE that we need to enable for encryption at rest, but I'm not completely sure.

upvoted 0 times

...

Mindy

5 months ago

I remember practicing a question about data encryption in Azure, and TDE was the answer there too.

upvoted 0 times

...

Rodolfo

5 months ago

Okay, I think I've got it. The key is to use a combination of conditions and permissions to meet all the requirements.

upvoted 0 times

...

Kimi

5 months ago

This seems like a tricky question. I'll need to carefully consider each option and think about what the ethical and proper way for an employee to obtain authorization would be.

upvoted 0 times

...

Staci

5 months ago

Okay, let's see. If the SANs are in the discovered state, that probably means they haven't been fully configured or associated with the networks yet. I'm guessing that could limit some of the storage management features.

upvoted 0 times

...