Free Snowflake Architect Data Security and Governance Questions and Answers

Question 1

Which feature in Snowflake allows you to control column-level access to sensitive data?

Accepted Answer

Dynamic Data Masking

Answer

Row Access Policies

Answer

Secure Views

Answer

Time Travel

Question 2

What is the primary purpose of Snowflake’s Zero Trust security model?

Accepted Answer

To enforce strict access control and authentication

Answer

To enable dynamic scaling of compute resources

Answer

To optimize query performance

Answer

To ensure data replication across regions

Question 3

Which of the following does Snowflake use to encrypt data at rest and in transit?

Accepted Answer

SSL/TLS for data in transit and AES-256 for data at rest

Answer

RSA-1024 for data at rest and SHA-256 for data in transit

Answer

DES encryption for data at rest and HTTPS for data in transit

Answer

MD5 for both data at rest and in transit

Question 4

Which governance feature allows Snowflake to track and manage who accessed which data and when?

Accepted Answer

Access History

Answer

Data Lineage

Answer

Time Travel

Answer

Data Sharing

Question 5

How can Snowflake ensure compliance with GDPR or HIPAA regulations?

Accepted Answer

By configuring role-based access control (RBAC) and auditing features

Answer

By enabling secure data sharing

Answer

By optimizing query performance

Answer

By replicating data across multiple clouds