COF-C02 exam

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?A . The primary cluster in the virtual warehouse B. The entire virtual warehouse C. The database in which the virtual warehouse resides D. The Queries currently being run on the virtual warehouseView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual% 20clusters%20in%20the%20warehouse.

Which of the following are common use cases for zero-copy cloning? Choose 3 answersA . Quick provisioning of Dev and Test/QA environments B. Data backups C. Point in time snapshots D. Performance optimizationView AnswerAnswer: A,B,C Explanation: Reference: https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning

Which statement best describes Snowflake tables?A . Snowflake tables are logical representations of underlying physical data B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake C. Snowflake tables require that clustering keys be defined to perform optimally D. Snowflake tables are owned by a userView AnswerAnswer: A...

Select the three types of tables that exist within Snowflake. Choose 3 answersA . Temporary B. Transient C. Provisioned D. PermanentView AnswerAnswer: A,B,D Explanation: Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)A . Customers can change the size of the Warehouse after creation B. A Warehouse can be resized while running C. A Warehouse can be configured to suspend after a period of inactivity D. A Warehouse can...

On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answersA . Amazon Web Services B. Private Virtual Cloud C. Oracle Cloud D. Microsoft Azure CloudView AnswerAnswer: A,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

True or False: Snowflake charges a premium for storing semi-structured data.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html