Snowflake COF-C01 SnowPro Core Certification Exam Online Training
Snowflake COF-C01 Online Training
The questions for COF-C01 were last updated at Jan 06,2025.
- Exam Code: COF-C01
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Jan 06,2025
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
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers
- A . MIN(< < column value>>)
- B . COPY
- C . SUM(<< column value >>)
- D . UPDATE
What are the default Time Travel and Fail-safe retention periods for transient tables?
- A . Time Travel – 1 day. Fail-safe – 1 day
- B . Time Travel – 0 days. Fail-safe – 1 day
- C . Time Travel – 1 day. Fail-safe – 0 days
- D . Transient tables are retained in neither Fail-safe nor Time Travel
What happens when a virtual warehouse is resized?
- A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
- B . When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
- C . The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
- D . Users who are trying to use the warehouse will receive an error message until the resizing is complete
Which statements are true of micro-partitions? Choose 2 answers
- A . They are approximately 16MB in size
- B . They are stored compressed only if COMPRESS=TRUE on Table
- C . They are Immutable
- D . They are only encrypted in the Enterprise edition and above
Which Snowflake partner specializes in data catalog solutions?
- A . Alation
- B . DataRobot
- C . dbt
- D . Tableau
A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?
- A . The primary cluster in the virtual warehouse
- B . The entire virtual warehouse
- C . The database in which the virtual warehouse resides
- D . The Queries currently being run on the virtual warehouse
True or False: Snowpipe via RFST API can only reference External Stages as source.
- A . True
- B . False
Which statement best describes ” clustering”?
- A . Clustering represents the way data is grouped together and stored within snowflake’s micro-partitions
- B . The database administrator must define the clustering methodology for each Snowflake table.
- C . The clustering key must be included on the COPV command when loading data into Snowflake.
- D . Clustering can be disabled within a Snowflake account.
Which of the following statements would be used to export/unload data from Snowflake?
- A . COPY INTO @stage
- B . EXPORT TO @stage
- C . INSERT INTO @stage
- D . EXPORT_TO_STAGE (stage = > @Wage, select = > ‘select * from t1);
Latest COF-C01 Dumps Valid Version with 162 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
