COF-C02 Free Practice Test

- (Topic 2)
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

1. A. Amazon Web Services
2. B. Docker
3. C. IBM Cloud
4. D. Microsoft Azure Cloud
5. E. Google Cloud Platform
6. F. Oracle Cloud

Correct Answer: ADE
Snowflake supports the use of external stages with Amazon Web Services (AWS), Microsoft Azure Cloud, and Google Cloud Platform (GCP). These platforms allow users to stage data externally and integrate with Snowflake for data loading operations

- (Topic 3)
By definition, a secure view is exposed only to users with what privilege?

1. A. IMPORT SHARE
2. B. OWNERSHIP
3. C. REFERENCES
4. D. USAGE

Correct Answer: B
A secure view in Snowflake is exposed only to users with the OWNERSHIP privilege. This privilege ensures that only authorized users who own the view, or roles that include ownership, can access the secure view

- (Topic 2)
Which of the following is a data tokenization integration partner?

1. A. Protegrity
2. B. Tableau
3. C. DBeaver
4. D. SAP

Correct Answer: A
Protegrity is listed as a data tokenization integration partner for Snowflake. This partnership allows Snowflake users to utilize Protegrity??s tokenization solutions within the Snowflake environment3.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

- (Topic 5)
Which command can be used to list all the file formats for which a user has access privileges?

1. A. LIST
2. B. ALTER FILE FORMAT
3. C. DESCRIBE FILE FORMAT
4. D. SHOW FILE FORMATS

Correct Answer: D
The command to list all the file formats for which a user has access privileges in Snowflake isSHOW FILE FORMATS. This command provides a list of all file formats defined in the user's current session or specified database/schema, along with details such as the name, type, and creation time of each file format. It is a valuable tool for users to understand and manage the file formats available for data loading and unloading operations.
References:
✑ Snowflake Documentation: SHOW FILE FORMATS

- (Topic 5)
When unloading data, which file format preserves the data values for floating-point number columns?

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

Correct Answer: D
When unloading data, the Parquet file format is known for its efficiency in preserving the data values for floating-point number columns. Parquet is a columnar storage file format that offers high compression ratios and efficient data encoding schemes. It is especially effective for floating-point data, as it maintains high precision and supports efficient querying and analysis.
References:
✑ Snowflake Documentation: Using the Parquet File Format for Unloading Data