COF-C02 exam

Which of the following compute resources or features are managed by Snowflake? (Select TWO).A . Execute a COPY commandB . Updating dataC . SnowpipeD . AUTOMATIC__CLUSTERINGE . Scaling up a warehouseView AnswerAnswer: C, E Explanation: Snowflake manages various compute resources and features, including Snowpipe and the ability to scale up...

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?A . Each Snowflake account can be hosted in a different cloud vendor and region.B . Each Snowflake account must be hosted in a different cloud vendor and regionC . All Snowflake accounts...

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)A . The ability to scale up warehousesB . The use of warehouse auto scalingC . The ability to resize warehousesD . Use of multi-clustered warehousesE . The use of warehouse indexingView AnswerAnswer: B, D Explanation: Snowflake’s architecture...

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).A . Compute Credits = 50 Credits Cloud Services = 10B . Compute Credits = 80 Credits Cloud Services = 5C . Compute Credits = 10 Credits Cloud Services = 9D . Compute Credits = 120 Credits...

Which Snowflake technique can be used to improve the performance of a query?A . ClusteringB . IndexingC . FragmentingD . Using INDEX__HINTSView AnswerAnswer: A Explanation: Clustering is a technique used in Snowflake to improve the performance of queries. It involves organizing the data in a table into micro-partitions based on...

True or False: A Virtual Warehouse can be resized while suspended.A . TrueB . FalseView AnswerAnswer: A Explanation: Virtual Warehouses in Snowflake can indeed be resized while they are suspended. Resizing a warehouse involves changing the number of compute resources (servers) allocated to it, which can be done to adjust...

What is the default File Format used in the COPY command if one is not specified?A . CSVB . JSONC . ParquetD . XMLView AnswerAnswer: A Explanation: The default file format for the COPY command in Snowflake, when not specified, is CSV (Comma-Separated Values). This format is widely used for...

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

What is the MOST performant file format for loading data in Snowflake?A . CSV (Unzipped)B . ParquetC . CSV (Gzipped)D . ORCView AnswerAnswer: B Explanation: Parquet is a columnar storage file format that is optimized for performance in Snowflake. It is designed to be efficient for both storage and query...

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)A . UsersB . TablesC . DatabasesD . Internal StagesView AnswerAnswer: B, C, D Explanation: The Information Schema and Account Usage Share in Snowflake provide metadata and historical usage data for various objects...