Snowflake COF-C02 SnowPro Core Certification Exam Online Training
Snowflake COF-C02 Online Training
The questions for COF-C02 were last updated at Apr 24,2024.
- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Apr 24,2024
The fail-safe retention period is how many days?
- A . 1 day
- B . 7 days
- C . 45 days
- D . 90 days
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A . True
- B . False
How would you determine the size of the virtual warehouse used for a task?
- A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
- B . Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- C . If using the stored procedure to execute multiple SQL statements, it’s best to test run the stored procedure separately to size the compute resource first
- D . Since task infrastructure is based on running the task body on schedule, it’s recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- A . Users
- B . Tables
- C . Databases
- D . Internal Stages
What is the default File Format used in the COPY command if one is not specified?
- A . CSV
- B . JSON
- C . Parquet
- D . XML
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A . True
- B . False
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
- A . True
- B . False
True or False: A Virtual Warehouse can be resized while suspended.
- A . True
- B . False
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
- A . True
- B . False
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
- A . Via the Snowflake Web Interface (Ul)
- B . Via the data_share=true parameter
- C . Via SQL commands
- D . Via Virtual Warehouses
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
