- (Topic 3)
Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).

1. A. Security
2. B. Data storage
3. C. Data visualization
4. D. Query computation
5. E. Metadata management

Correct Answer: AE
The Cloud Services layer in Snowflake is responsible for various services, including security (like authentication and authorization) and metadata management (like query parsing and optimization). References: Based on general cloud architecture knowledge as of 2021.

- (Topic 6)
What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?

1. A. X-Small
2. B. Small
3. C. Medium
4. D. Large

Correct Answer: B
When creating a Snowpark-optimized virtual warehouse in Snowflake, the minimum size requirement is Small. Snowpark is designed to handle data processing workloads efficiently, and the Small size ensures adequate resources for such tasks.
✑ Virtual Warehouse Sizes:
✑ Minimum Size Requirement for Snowpark:
References:
✑ Snowflake Documentation: Virtual Warehouse Sizes

- (Topic 1)
What happens when an external or an internal stage is dropped? (Select TWO).

1. A. When dropping an external stage, the files are not removed and only the stage is dropped
2. B. When dropping an external stage, both the stage and the files within the stage are removed
3. C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
4. D. When dropping an internal stage, the files are deleted with the stage and the files arenot recoverable
5. E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Correct Answer: AD
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. References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Stages

- (Topic 3)
What column type does a Kafka connector store formatted information in a single column?

1. A. ARRAY
2. B. OBJECT
3. C. VARCHAR
4. D. VARIANT

Correct Answer: D
The Kafka connector stores formatted information in a single column of type VARIANT. This column type is used to store semi-structured data like JSON or Avro, which allows for flexibility in the data structure

- (Topic 4)
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

1. A. FLATTEN
2. B. GET_PATH
3. C. CHECK_JSON
4. D. PARSE JSON

Correct Answer: A
The FLATTEN function can be used with the recursive argument to return a list of distinct key names in all nested elements within an object. This function is particularly useful for working with semi-structured data in Snowflake