COF-C02 V3

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

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

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

What can be used to view warehouse usage over time? (Select Two).A . The load HISTORY view B. The Query history view C. The show warehouses command D. The WAREHOUSE_METERING__HISTORY View E. The billing and usage tab in the Snowflake web UlView AnswerAnswer: D, E

What is the recommended file sizing for data loading using Snowpipe?A . A compressed file size greater than 100 MB, and up to 250 MB B. A compressed file size greater than 100 GB, and up to 250 GB C. A compressed file size greater than 10 MB, and up...

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: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.A . True B. FalseView AnswerAnswer: B

What features does Snowflake Time Travel enable?A . Querying data-related objects that were created within the past 365 days B. Restoring data-related objects that have been deleted within the past 90 days C. Conducting point-in-time analysis for Bl reporting D. Analyzing data usage/manipulation over all periods of timeView AnswerAnswer: B...

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 layerView AnswerAnswer: D

Will data cached in a warehouse be lost when the warehouse is resized?A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits. B. Yes. because the compute resource is replaced in its entirety with a new compute resource. C. No. because the...