COF-C02 exam

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

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?A . To accommodate more queries B. To accommodate more users C. To accommodate fluctuations in workload D. To accommodate a more complex workloadView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

Which are true of Snowflake roles?A . All grants to objects are given to roles, and never to users B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation C. The public role controls at...

When unloading to a stage, which of the following is a recommended practice or approach?A . Set SINGLE: = true for larger files B. Use OBJECT_CONSTRUCT ( * ) when using Parquet C. Avoid the use of the CAST function D. Define an individual file formatView 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

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.A . True B. FalseView AnswerAnswer: B