- (Topic 4)
What does SnowCD help Snowflake users to do?

1. A. Copy data into files.
2. B. Manage different databases and schemas.
3. C. Troubleshoot network connections to Snowflake.
4. D. Write SELECT queries to retrieve data from external tables.

Correct Answer: C
SnowCD is a connectivity diagnostic tool that helps users troubleshoot network connections to Snowflake. It performs a series of checks to evaluate the network connection and provides suggestions for resolving any issues4.

- (Topic 2)
The Snowflake Cloud Data Platform is described as having which of the following architectures?

1. A. Shared-disk
2. B. Shared-nothing
3. C. Multi-cluster shared data
4. D. Serverless query engine

Correct Answer: C
Snowflake??s architecture is described as a multi-cluster, shared data architecture. This design combines the simplicity of a shared-disk architecture with the performance and scale-out benefits of a shared-nothing architecture, using a central repository accessible from all compute nodes2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

- (Topic 5)
If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

1. A. 60
2. B. 91
3. C. 120
4. D. 121

Correct Answer: C
Snowflake bills virtual warehouse usage in one-minute increments, rounding up to the nearest minute for any partial minute of compute time used. If a virtual warehouse runs for 61 seconds and then, after being shut down, restarts and runs for an additional 30 seconds, the total time billed would be 120 seconds or 2 minutes. The first 61 secondsare rounded up to 2 minutes, and the subsequent 30 seconds are within a new minute, which is also rounded up to the nearest minute.
References:
✑ Snowflake Documentation: Virtual Warehouses Billing

- (Topic 5)
Which Snowflake layer is associated with virtual warehouses?

1. A. Cloud services
2. B. Query processing
3. C. Elastic memory
4. D. Database storage

Correct Answer: B
The layer of Snowflake's architecture associated with virtual warehouses is the Query Processing layer. Virtual warehouses in Snowflake are dedicated compute clusters that execute SQL queries against the stored data. This layer is responsible for the entire query execution process, including parsing, optimization, and the actual computation. It operates independently of the storage layer, enabling Snowflake to scale compute and storage resources separately for efficiency and cost-effectiveness.
References:
✑ Snowflake Documentation: Snowflake Architecture

- (Topic 2)
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON. How can this be accomplished?

1. A. select src:dealership from car_sales;
2. B. select src.dealership from car_sales;
3. C. select src:Dealership from car_sales;
4. D. select dealership from car_sales;

Correct Answer: B
In Snowflake, to extract a specific element from a JSON stored in a VARIANT column, the correct syntax is to use the dot notation. Therefore, the query select src.dealership from car_sales; will return the dealership information contained within each JSON object in the src column.
References: For a detailed explanation, please refer to the Snowflake documentation on querying semi-structured data.