- (Topic 4)
What type of query will benefit from the query acceleration service?

Correct Answer:B
The query acceleration service in Snowflake is designed to benefit queries that involve large scans and selective filters. This service can offload portions of the query processing work to shared compute resources, which can handle these types of workloads more efficiently by performing more work in parallel and reducing the wall-clock time spent in scanning and filtering2. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 4)
What is the purpose of the Snowflake SPLIT TO_TABLE function?

Correct Answer:C
The purpose of the Snowflake SPLIT_TO_TABLE function is to split a string based on a specified delimiter and flatten the results into rows. This table function is useful for transforming a delimited string into a set of rows that can be further processed or queried5.

- (Topic 6)
Which Snowflake object contains all the information required to share a database?

Correct Answer:D
In Snowflake, aShareis the object that contains all the information required to share a database with other Snowflake accounts. Shares are used to securely share data stored in Snowflake tables and views, enabling data providers to grant data consumers access to their datasets without duplicating data. When a database is shared, it can include one or more schemas, and each schema can contain tables, views, or both.
References:
✑ Snowflake Documentation on Shares: Shares

- (Topic 6)
Which access control entity in Snowflake can be created as part of a hierarchy within an account?

Correct Answer:B
In Snowflake, a role is an access control entity that can be created as part of a hierarchy within an account. Roles are used to grant and manage privileges in a structured and scalable manner.
✑ Understanding Roles:
✑ Role Hierarchy:
✑ Creating Roles:
✑ Example Usage: CREATE ROLE role1; CREATE ROLE role2;
GRANT ROLE role1 TO role2;
✑ uk.co.certification.simulator.questionpool.PList@546f4af7
✑ Benefits:
References:
✑ Snowflake Documentation: Access Control in Snowflake
✑ Snowflake Documentation: Creating and Managing Roles

- (Topic 6)
What would cause different results to be returned when running the same query twice?

Correct Answer:B
When using the SAMPLE clause in a query, if the seed is not set, Snowflake will use a different random seed for each execution of the query. This results in different rows being sampled each time, leading to different results. Setting a seed ensures that the same rows are sampled each time the query is run.
References:
✑ Snowflake Documentation: Sampling

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

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