COF-C02 exam

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

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