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 in transit

Answer

TLS handshake

Answer

Token bucketing

Question 2

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

Accepted Answer

Hide sensitive field values from unauthorized users

Answer

Compress columns to save space

Answer

Index columns faster

Answer

Replicate columns across nodes

Question 3

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

Accepted Answer

GDPR

Answer

HIPAA

Answer

SOX

Answer

PCI DSS

Question 4

What does the principle of least privilege require?

Accepted Answer

Grant users only the access they need to do their job

Answer

Give all users admin rights

Answer

Disable all access by default permanently

Answer

Share one account across the team

Question 5

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

Accepted Answer

Tokenization

Answer

Normalization

Answer

Partitioning

Answer

Caching

Question 6

What is a data catalog primarily used for in governance?

Accepted Answer

Discovering and documenting metadata about data assets

Answer

Encrypting backups

Answer

Load balancing queries

Answer

Scheduling ETL jobs

Question 7

Which standard specifically governs the handling of credit card payment data?

Accepted Answer

PCI DSS

Answer

GDPR

Answer

HIPAA

Answer

FERPA