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

Which command can be used to load data into an internal stage?A . LOAD B. copy C. GET D. PUTView AnswerAnswer: D Explanation: https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....)statement? (Select TWO.)A . Data can be filtered by an optional where clause B. Incoming data can be joined with other tables C. Columns can be reordered D. Columns can be omitted E. Row level access can...