- (Topic 3)
What are benefits of using Snowpark with Snowflake? (Select TWO).

1. A. Snowpark uses a Spark engine to generate optimized SQL query plans.
2. B. Snowpark automatically sets up Spark within Snowflake virtual warehouses.
3. C. Snowpark does not require that a separate cluster be running outside of Snowflake.
4. D. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.
5. E. Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Correct Answer: CD
Snowpark is designed to bring the data programmability to Snowflake, enabling developers to write code in familiar languages like Scala, Java, and Python. It allows for the execution of these codes directly within Snowflake??s virtual warehouses, eliminating the need for a separate cluster. Additionally, Snowpark??s compatibility with Spark allows users to leverage their existing Spark code with minimal changes1.

- (Topic 5)
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

1. A. GET_STATE_LOCATION
2. B. GET_PRESENT_URL
3. C. BUILD_SCOPED_FILE_URL
4. D. BUILD_STAGE_FILE_URL

Correct Answer: D
✑ Purpose:TheBUILD_STAGE_FILE_URLfunction generates a temporary, pre- signed URL that allows you to access a file within a Snowflake stage (internal or external). This URL requires authentication to use.
✑ Key Points:
✑ Snowflake Documentation
(BUILD_STAGE_FILE_URL): https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url.html

- (Topic 5)
While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).

1. A. BINARY
2. B. GEOGRAPHY
3. C. GEOMETRY
4. D. OBJECT
5. E. VARIANT

Correct Answer: AC
A clustering key can be defined when a table is created by appending a CLUSTER Where each clustering key consists of one or more table columns/expressions, which can be of any data type, except GEOGRAPHY, VARIANT, OBJECT, or ARRAYhttps://docs.snowflake.com/en/user-guide/tables-clustering-keys

- (Topic 4)
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

1. A. Bytes scanned
2. B. Bytes written to result
3. C. Partitions scanned
4. D. Partitions total
5. E. Percentage scanned from cache

Correct Answer: CD
The statistics that can be used to identify queries with inefficient pruning are ??Partitions scanned?? and ??Partitions total??. These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34.

- (Topic 1)
What is a key feature of Snowflake architecture?

1. A. Zero-copy cloning creates a mirror copy of a database that updates with the original
2. B. Software updates are automatically applied on a quarterly basis
3. C. Snowflake eliminates resource contention with its virtual warehouse implementation
4. D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
5. E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

Correct Answer: C
One of the key features of Snowflake??s architecture is its unique approach to eliminating resource contention through the use of virtual warehouses. This is achieved by separating storage and compute resources, allowing multiple virtual warehouses to operate independently on the same data without affecting each other. This means that different workloads, such as loading data, running queries, or performing complex analytics, can be processed simultaneously without any performance degradation due to resource contention.
References:
✑ Snowflake Documentation on Virtual Warehouses
✑ SnowPro® Core Certification Study Guide