- (Topic 2)
A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?
Correct Answer:B
The list @my_stage command in Snowflake can be used to verify if data has been uploaded to an external stage named my_stage. This command provides a list of files that are present in the specified stage2.
- (Topic 5)
Which Snowflake data type is used to store JSON key value pairs?
Correct Answer:D
The VARIANT data type in Snowflake is used to store JSON key-value pairs along with other semi-structured data formats like AVRO, BSON, and XML. The VARIANT data type allows for flexible and dynamic data structures within a single column, accommodating complex and nested data. This data type is crucial for handling semi- structured data in Snowflake, enabling users to perform SQL operations on JSON objects and arrays directly.
References:
✑ Snowflake Documentation: Semi-structured Data Types
- (Topic 1)
Which Snowflake feature is used for both querying and restoring data?
Correct Answer:B
Snowflake??s Time Travel feature is used for both querying historical data in tables and restoring and cloning historical data in databases, schemas, and tables3. It allows users to access historical data within a defined period (1 day by default, up to 90 days for Snowflake Enterprise Edition) and is a key feature for data recovery and management. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 1)
What feature can be used to reorganize a very large table on one or more columns?
Correct Answer:B
Clustering keys in Snowflake are used to reorganize large tables based on one or more columns. This feature optimizes the arrangement of data within micro- partitions to improve query performance, especially for large tables where efficient data retrieval is crucial. References: [COF-C02] SnowPro Core Certification Exam Study Guide https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
- (Topic 4)
What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
Correct Answer:BC
Virtual warehouses in Snowflake can be started and stopped at any time, providing flexibility in managing compute resources. They can also be resized at any time, even while running, toaccommodate varying workloads910. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 3)
Which of the following describes the Snowflake Cloud Services layer?
Correct Answer:A
The Snowflake Cloud Services layer coordinates activities within the Snowflake account. It is responsible for tasks such as authentication, infrastructure management, metadata management, query parsing and optimization, and access control. References: Based on general cloud database architecture knowledge.