COF-C02 exam

How long is Snowpipe data load history retained?A . As configured in the create pipe settings B. Until the pipe is dropped C. 64 days D. 14 daysView AnswerAnswer: C Explanation: Bulk data load Stored in the metadata of the target table for 64 days. Available upon completion of the...

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 commandView AnswerAnswer: C,D

What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitions B. Clustering keys C. Key partitions D. Clustered partitionsView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).A . The table contains a column that has very low cardinality B. DML statements that are being issued against the table are blocked C. The table has a small number...

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).A . Use multi-clustered warehousing to scale out...

Which cache type is used to cache data output from SQL queries?A . Metadata cache B. Result cache C. Remote cache D. Local file cacheView AnswerAnswer: B Explanation: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

Which cache type is used to cache data output from SQL queries?A . Metadata cache B. Result cache C. Remote cache D. Local file cacheView AnswerAnswer: B Explanation: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

Which of the following describes how clustering keys work in Snowflake?A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations. B. Clustering keys sort the designated columns over time, without blocking DML operations C. Clustering keys create a distributed, parallel data structure...

True or False: A Virtual Warehouse can be resized while suspended.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse