COF-C02 V1

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 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

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

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

What data is stored in the Snowflake storage layer? (Select TWO).A . Snowflake parameters B. Micro-partitions C. Query history D. Persisted query results E. Standard and secure view resultsView AnswerAnswer: B,D

Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of values B. Micro-partitions are immutable objects that support the use of Time Travel. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses D. Rows are automatically stored...

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 namesView AnswerAnswer: B Explanation: When creating roles...

Which command is used to unload data from a Snowflake table into a file in a stage?A . COPY INTO B. GET C. WRITE D. EXTRACT INTOView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.

Which Snowflake feature is used for both querying and restoring data?A . Cluster keys B. Time Travel C. Fail-safe D. CloningView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%2 0through%20Snowflake%20Time%20Travel.