Data Engineering Data Governance and Security 2

Question 1

Which encryption approach protects data while it is stored on disk in a data warehouse?

Accepted Answer

Encryption at rest

Answer

Encryption at rest secures data persisted on storage media.

Question 2

What is the primary purpose of column-level masking in a database?

Accepted Answer

Hide sensitive field values from unauthorized users

Answer

Masking obscures sensitive values so unauthorized users see redacted data.

Question 3

Which regulation governs the protection of personal data for residents of the European Union?

Accepted Answer

GDPR

Answer

GDPR is the EU's general data protection regulation.

Question 4

What does the principle of least privilege require?

Accepted Answer

Grant users only the access they need to do their job

Answer

Least privilege limits access to the minimum necessary.

Question 5

Which technique replaces sensitive values with non-sensitive surrogates that can be mapped back via a secure vault?

Accepted Answer

Tokenization

Answer

Tokenization substitutes data with tokens stored separately.

Data Engineering Practice Test