COF-C02 exam

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

Which of the following statements is true of data loading?A . Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast B. The "deal file size for loading is 16MB to match micro-partition size C. Marry files in the 10-lOOMB range tend to land...

Which Snowflake partner specializes in data catalog solutions?A . Alation B. DataRobot C. dbt D. TableauView AnswerAnswer: A Explanation: Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise. https://docs.snowflake.com/en/user-guide/ecosystem-all.html

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