COF-C02 Free Practice Test

- (Topic 4)
When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

1. A. File URL
2. B. Scoped URL
3. C. Relative URL
4. D. Pre-Signed URL

Correct Answer: B
A Scoped URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens. It provides a secure way to share access to files stored in Snowflake

- (Topic 6)
When unloading data with the COPY into command, what is the purpose of the PARTITION BY parameter option?

1. A. To sort the contents of the output file by the specified expression.
2. B. To delimit the records in the output file using the specified expression.
3. C. To include a new column in the output using the specified window function expression.
4. D. To split the output into multiple files, one for each distinct value of the specified expression.

Correct Answer: D
ThePARTITION BY <expression>parameter option in theCOPY INTO <location>command is used to split the output into multiple files based on the distinct values of the specified expression. This feature is particularly useful for organizing large datasets into smaller, more manageable files and can help with optimizing downstream processing or consumption of the data. For example, if you are unloading a large dataset of transactions and usePARTITION BY DATE(transactions.transaction_date), Snowflake generates a separate output file for each unique transaction date, facilitating easier data management and access.
This approach to data unloading can significantly improve efficiency when dealing with large volumes of data by enabling parallel processing and simplifying data retrieval based on specific criteria or dimensions.
References:
✑ Snowflake Documentation on Unloading Data: COPY INTO

- (Topic 3)
Which feature allows a user the ability to control the organization of data in a micro- partition?

1. A. Range Partitioning
2. B. Search Optimization Service
3. C. Automatic Clustering
4. D. Horizontal Partitioning

Correct Answer: C
Automatic Clustering is a feature that allows users to control the organization of data within micro-partitions in Snowflake. By defining clustering keys, Snowflake can automatically reorganize the data in micro-partitions to optimize query performance1.

- (Topic 3)
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

1. A. 10
2. B. 50
3. C. 64
4. D. 256

Correct Answer: D
For the ALLOWED VALUES tag property, the maximum number of possible string values for a single tag is 256. This allows for a wide range of values to be assigned to a tag when it is set on an object

- (Topic 3)
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

1. A. STRIP_NULL_VALUES
2. B. SKIP_BYTE_ORDER_MARK
3. C. REPLACE_INVALID_CHARACTERS
4. D. VALIDATION_MODE

Correct Answer: D
The VALIDATION_MODE parameter can be used with the COPY command to verify data files without loading them into the specified table. This parameter allows users to check for errors in the files