Snowflake Data Governance and Compliance: Intermediate-Level Quiz

Data governance and compliance are critical to managing data effectively and meeting regulatory requirements. In Snowflake, these aspects involve understanding and implementing various features and practices to protect data, ensure quality, and comply with legal and regulatory standards. This intermediate-level quiz will test your knowledge and skills in these areas.

1 / 20

Which role in Snowflake is responsible for managing data governance policies?

SYSADMIN

USERADMIN

ACCOUNTADMIN

SECURITYADMIN

2 / 20

Snowflake’s Time Travel feature provides a continuous backup of data.

True

False

3 / 20

How can you enforce encryption for all data in a Snowflake account?

Using the ENCRYPTION parameter

Data is automatically encrypted by Snowflake

Creating an encryption role

Manually encrypting each table

4 / 20

Which statement correctly creates a masking policy for a column?

CREATE MASKING POLICY mask_policy AS (val STRING) RETURNS STRING -> CASE WHEN current_role() = 'SECURITYADMIN' THEN val ELSE 'MASKED' END;

DEFINE MASKING POLICY mask_policy AS (val STRING) RETURNS STRING -> CASE WHEN current_role() = 'SECURITYADMIN' THEN val ELSE 'MASKED' END;

CREATE MASK mask_policy AS (val STRING) RETURNS STRING -> CASE WHEN current_role() = 'SECURITYADMIN' THEN val ELSE 'MASKED' END;

ADD MASKING POLICY mask_policy AS (val STRING) RETURNS STRING -> CASE WHEN current_role() = 'SECURITYADMIN' THEN val ELSE 'MASKED' END;

5 / 20

Which command shows the access history for a specific table named sales_data?

SELECT * FROM information_schema.access_log WHERE object_name = 'SALES_DATA';

SELECT * FROM access_history WHERE object_name = 'SALES_DATA';

SELECT * FROM table(information_schema.access_history) WHERE object_name = 'SALES_DATA';

SELECT * FROM information_schema.access_history WHERE object_name = 'SALES_DATA';

6 / 20

Which feature in Snowflake helps track data access and usage?

Data Masking

Data Replication

Virtual Warehouses

Access History

7 / 20

Snowflake supports the setup of virtual warehouses for managing different user groups.

False

True

8 / 20

How does Snowflake ensure compliance with regulatory requirements?

By enhancing data visualization

By providing free storage

By offering built-in compliance features and auditing tools

By improving query speed

9 / 20

Snowflake automatically complies with HIPAA if all security configurations are enabled.

False

True

10 / 20

Snowflake allows data sharing only within the same region.

False

True

11 / 20

What is the primary objective of data governance in Snowflake?

- a) To enhance query performance
- b) To ensure data security, quality, and compliance (Correct)
- c) To reduce storage costs
- d) To improve data visualization

To enhance query performance

To improve data visualization

To reduce storage costs

To ensure data security, quality, and compliance

12 / 20

What does PII stand for in the context of data governance?

Personally Identifiable Information

Primary Information Index

Personal Identification Information

Performance Integrity Index

13 / 20

Which Snowflake feature helps in managing data retention policies?

Time Travel

Data Masking

Materialized Views

Network Policies

14 / 20

Identify the error in the following SQL code for creating a role:

CREATE ROLE data_steward;

Incorrect command

Incorrect role name

Missing semicolon

No error

15 / 20

You cannot share data securely between different Snowflake accounts.

False

True

16 / 20

Only one user role can access a shared database in Snowflake.

False

True

17 / 20

Which command is used to grant a role to a user in Snowflake?

GRANT ROLE

ENABLE ROLE

ASSIGN ROLE

CREATE ROLE

18 / 20

Which feature in Snowflake allows the definition of security policies to protect sensitive data?
- a) Virtual Warehouses
- b) Secure Data Sharing
- c) Dynamic Data Masking (Correct)
- d) Data Clustering

Data Clustering

Dynamic Data Masking

Secure Data Sharing

Virtual Warehouses

19 / 20

Snowflake’s multi-factor authentication can be enabled by configuring:

A) User Account Settings
B) Security Integrations
C) Access Controls
D) Password Policy

Password Policy

Access Controls

User Account Settings

Security Integrations

20 / 20

What is the role of the SYSADMIN role in Snowflake?

Granting user access

Managing system-level objects

Optimizing query performance

Managing security settings

Your score is

The average score is 0%

This intermediate-level quiz evaluates your understanding of Snowflake data governance and compliance features.

This quiz helps reinforce key concepts and practical skills for users who already understand Snowflake basics. It is also suitable for users who want to deepen their data governance and compliance knowledge.

After completing the quiz, users will have a more comprehensive understanding of Snowflake’s governance tools and compliance protocols. It will also help you gain insight into secure data handling practices, which are essential for managing data compliant and securely.

Good luck.