COF-C02 Free Practice Test

- (Topic 5)
How does Snowflake describe its unique architecture?

1. A. A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)
2. B. A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)
3. C. A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)
4. D. A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

Correct Answer: A
Snowflake's unique architecture is described as a multi-cluster, shared data architecture that leverages massively parallel processing (MPP). This architecture separates compute and storage resources, enabling Snowflake to scale them independently. It does not use a single cluster or rely solely on symmetric multiprocessing (SMP); rather, it uses acombination of shared-nothing architecture for compute clusters (virtual warehouses) and a centralized storage layer for data, optimizing for both performance and scalability. References:
✑ Snowflake Documentation: Snowflake Architecture Overview

- (Topic 3)
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

1. A. The number of queries executed
2. B. The number of active users assigned to the warehouse
3. C. The size of the virtual warehouse
4. D. The length of time the warehouse is running
5. E. The duration of the queries that are executed

Correct Answer: CD
Credit charges for Snowflake virtual warehouses are calculated based on the size of the virtual warehouse and the length of time the warehouse is running. The size determines the compute resources available, and charges are incurred for the time these resources are utilized

- (Topic 3)
Which activities are included in the Cloud Sen/ices layer? (Select TWO).

1. A. Data storage
2. B. Dynamic data masking
3. C. Partition scanning
4. D. User authentication
5. E. Infrastructure management

Correct Answer: DE
The Cloud Services layer in Snowflake includes activities such as user authentication and infrastructure management. This layer coordinates activities across Snowflake, including security enforcement, query compilation and optimization, and more

- (Topic 6)
Which semi-structured file format is a compressed, efficient, columnar data representation?

1. A. Avro
2. B. JSON
3. C. TSV
4. D. Parquet

Correct Answer: D
Parquet is a columnar storage file format that is optimized for efficiency in both storage and processing. It supports compression and encoding schemes that significantly reduce the storage space needed and speed up data retrieval operations, making it ideal for handling large volumes of data. Unlike JSON or TSV, which are row- oriented and typically uncompressed, Parquet is designed specifically for use with big data frameworks, offering advantages in terms of performance and cost when storing and querying semi-structured data.References:Apache Parquet Documentation

- (Topic 6)
Which Snowflake database object can be shared with other accounts?

1. A. Tasks
2. B. Pipes
3. C. Secure User-Defined Functions (UDFs)
4. D. Stored Procedures

Correct Answer: C
In Snowflake, Secure User-Defined Functions (UDFs) can be shared with other accounts using Snowflake's data sharing feature. This allows different Snowflake accounts to securely execute the UDFs without having direct access to the underlying data the functions operate on, ensuring privacy and security. The sharing is facilitated through shares created in Snowflake, which can contain Secure UDFs along with other database objects like tables and views.References:Snowflake Documentation on Data Sharing and Secure UDFs