SnowPro Core Data Protection Features Quiz

1. Which Snowflake feature tracks all user activity and data access?

Query History

Account Usage

Object Audit Trail

All of the above

2. Which Snowflake feature enables secure data sharing with external organizations?

Secure Data Sharing

Database Replication

Snowflake Marketplace

Direct Share

3. What is the primary benefit of Snowflake's end-to-end encryption?

Protects data throughout its lifecycle

Increases query speed

Reduces storage costs

Improves user interface

4. True or False: Snowflake supports customer-managed encryption keys (CMEK).

True

False

5. Which role has the highest privileges in Snowflake by default?

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

PUBLIC

6. What does Snowflake's masking policy allow you to do?

Hide sensitive data based on user context

Delete data permanently

Archive data to cold storage

Encrypt database passwords

7. True or False: Snowflake allows you to view encrypted data without decryption keys.

True

False

8. Which authentication method provides additional security in Snowflake?

Multi-factor authentication (MFA)

Single sign-on (SSO)

JWT tokens

All of the above

9. What is the purpose of Snowflake's Network Policy feature?

To restrict access by IP address

To encrypt data

To manage user roles

To optimize query performance

10. True or False: Snowflake automatically shares encryption keys with third-party vendors.

True

False

11. Which encryption method does Snowflake use for data at rest in its managed storage?

AES-128

AES-256

RSA-2048

DES-3

12. What does Snowflake's Tri-Secret Secure architecture include?

Customer-managed keys, Snowflake-managed keys, and cloud provider keys

Three password requirements

Three data centers

Three encryption algorithms

13. Which compliance framework is Snowflake certified for?

SOC 2 Type II only

ISO 27001, SOC 2, HIPAA, and GDPR

PCI-DSS only

No compliance certifications

14. What is Snowflake's default authentication method?

Username and password

OAuth only

Multi-factor authentication required

Biometric authentication

15. True or False: Snowflake's key management is handled exclusively by the customer.

True

False

16. Which Snowflake feature provides row-level security by restricting data access?

Row Access Policy

Column Masking Policy

Database Role

Warehouse Policy

17. What does the GRANT command control in Snowflake?

Database backups

User permissions and privileges

Query execution time

Data compression settings

18. Snowflake encrypts data in transit using which protocol by default?

HTTP

TLS 1.2 or higher

SSL 3.0

FTP with encryption

19. Which Snowflake feature allows you to mask sensitive columns based on user roles?

Dynamic Data Masking

Column Encryption

Row-Level Security

Data Vault

20. What is the primary purpose of Snowflake's role-based access control (RBAC)?

To encrypt data in transit

To limit user actions based on assigned roles

To compress data for storage

To monitor query performance

SnowPro Core Data Protection Features Quiz

1. Which Snowflake feature tracks all user activity and data access?

2.

What first name or nickname would you like us to use?

2. Which Snowflake feature enables secure data sharing with external organizations?

3. What is the primary benefit of Snowflake's end-to-end encryption?

4. True or False: Snowflake supports customer-managed encryption keys (CMEK).

5. Which role has the highest privileges in Snowflake by default?

6. What does Snowflake's masking policy allow you to do?

7. True or False: Snowflake allows you to view encrypted data without decryption keys.

8. Which authentication method provides additional security in Snowflake?

9. What is the purpose of Snowflake's Network Policy feature?

10. True or False: Snowflake automatically shares encryption keys with third-party vendors.

11. Which encryption method does Snowflake use for data at rest in its managed storage?

12. What does Snowflake's Tri-Secret Secure architecture include?

13. Which compliance framework is Snowflake certified for?

14. What is Snowflake's default authentication method?

15. True or False: Snowflake's key management is handled exclusively by the customer.

16. Which Snowflake feature provides row-level security by restricting data access?

17. What does the GRANT command control in Snowflake?

18. Snowflake encrypts data in transit using which protocol by default?

19. Which Snowflake feature allows you to mask sensitive columns based on user roles?

20. What is the primary purpose of Snowflake's role-based access control (RBAC)?