Which features make up Snowflake's column level security? (Select TWO).
Answer : B, C
Snowflake's column level security features include Dynamic Data Masking and External Tokenization.Dynamic Data Masking uses masking policies to selectively mask data at query time, while External Tokenization allows for the tokenization of data before loading it into Snowflake and detokenizing it at query runtime5.
Question 2
Which statement accurately describes a characteristic of a materialized view?
Answer : B
A characteristic of a materialized view is that the data accessed through it can be stale.This is because the data in a materialized view may not reflect the latest changes in the base tables until the viewis refreshed
Question 3
Which Snowflake data governance feature supports the tracking of sensitive data for compliance, discovery, protection, and resource usage?
Answer : D
Question 4
Which metadata table will store the storage utilization information even for dropped tables?
Answer : B
TheTABLE_STORAGE_METRICSmetadata table stores the storage utilization information, including for tables that have been dropped but are still incurring storage costs2.
Question 5
Which Snowflake table supports unstructured data?
Answer : D
While Snowflake primarily deals with structured and semi-structured data, it also has the capability to handle unstructured data. Unstructured data can be stored in Snowflake using variants of SQL data types in tables, which can be permanent tables. These permanent tables, while traditionally used for structured or semi-structured data (like JSON, Avro, or Parquet), can also accommodate unstructured data in the form of binary formats or strings, offering flexibility in data storage and analysis. However, the management and querying of unstructured data in Snowflake may require additional considerations compared to structured data.
Question 6
Which statement MOST accurately describes clustering in Snowflake?
Answer : B
Clustering in Snowflake refers to the organization of data within micro-partitions, which are contiguous units of storage within Snowflake tables.Clustering keys can be defined to co-locate similar rows in the same micro-partitions, improving scan efficiency and query performance12.
Question 7
What happens when an external or an internal stage is dropped? (Select TWO).
Answer : A, D
When an external stage is dropped in Snowflake, the reference to the external storage location is removed, but the actual files within the external storage (like Amazon S3, Google Cloud Storage, or Microsoft Azure) are not deleted. This means that the data remains intact in the external storage location, and only the stage object in Snowflake is removed.
On the other hand, when an internal stage is dropped, any files that were uploaded to the stage are deleted along with the stage itself. These files are not recoverable once the internal stage is dropped, as they are permanently removed from Snowflake's storage.
[COF-C03] SnowPro Core Certification Exam Study Guide
All Official Question Types