Snowflake COF-C02 Real Exam Questions
The questions for COF-C02 were last updated at Nov 20,2024.
- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Nov 20,2024
What is the MOST performant file format for loading data in Snowflake?
- A . CSV (Unzipped)
- B . Parquet
- C . CSV (Gzipped)
- D . ORC
What is a best practice after creating a custom role?
- A . Create the custom role using the SYSADMIN role.
- B . Assign the custom role to the SYSADMIN role
- C . Assign the custom role to the PUBLIC role
- D . Add__CUSTOM to all custom role names
B
Explanation:
When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
- A . Compute layer
- B . Storage layer
- C . Cloud infrastructure layer
- D . Cloud services layer
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
- A . True
- B . False
A
Explanation:
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.
Where would a Snowflake user find information about query activity from 90 days ago?
- A . account__usage . query history view
- B . account__usage.query__history__archive View
- C . information__schema . cruery_history view
- D . information__schema – query history_by_ses s i on view
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
- A . ORC
- B . XML
- C . Avro
- D . Parquet
- E . JSON
D, E
Explanation:
Semi-structured JSON, Parquet
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)
What are ways to create and manage data shares in Snowflake? (Select TWO)
- A . Through the Snowflake web interface (Ul)
- B . Through the DATA_SHARE=TRUE parameter
- C . Through SQL commands
- D . Through the enable__share=true parameter
- E . Using the CREATE SHARE AS SELECT * TABLE command
Which Snowflake feature is used for both querying and restoring data?
- A . Cluster keys
- B . Time Travel
- C . Fail-safe
- D . Cloning
B
Explanation:
https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.
True or False: Fail-safe can be disabled within a Snowflake account.
- A . True
- B . False
B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .
Which command can be used to load data into an internal stage?
- A . LOAD
- B . copy
- C . GET
- D . PUT
D
Explanation:
https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9