COF-C02 exam

What is a responsibility of Snowflake's virtual warehouses?A . Infrastructure management B. Metadata management C. Query execution D. Query parsing and optimization E. Management of the storage layerView AnswerAnswer: C

What is the MOST performant file format for loading data in Snowflake?A . CSV (Unzipped) B. Parquet C. CSV (Gzipped) D. ORCView AnswerAnswer: A

What is a key feature of Snowflake architecture?A . Zero-copy cloning creates a mirror copy of a database that updates with the original B. Software updates are automatically applied on a quarterly basis C. Snowflake eliminates resource contention with its virtual warehouse implementation D. Multi-cluster warehouses allow users to run...

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

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

Which stage type can be altered and dropped?A . Database stage B. External stage C. Table stage D. User stageView AnswerAnswer: C Explanation: https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).A . Load files that are approximately 25 MB or smaller. B. Remove all dates and timestamps. C. Load files that are approximately 100-250 MB (or larger) D. Avoid using embedded characters...

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: You can experiment the same with snowflake UI.

What is a limitation of a Materialized View?A . A Materialized View cannot support any aggregate functions B. A Materialized View can only reference up to two tables C. A Materialized View cannot be joined with other tables D. A Materialized View cannot be defined with a JOINView AnswerAnswer: D...

When is the result set cache no longer available? (Select TWO)A . When another warehouse is used to execute the query B. When another user executes the query C. When the underlying data has changed D. When the warehouse used to execute the query is suspended E. When it has...