COF-C02 exam

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).A . The user has the appropriate privileges on the objects associated with the query B. Micro-partitions have been reclustered since the query was last run C. The new query is run...

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query time B. Partitions scanned is equal to partitions total C. An AggregateOperacor node is present D. The query...

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)A . Reader B. Consumer C. Vendor D. Standard E. PersonalizedView AnswerAnswer: D,E

What can be used to view warehouse usage over time? (Select Two).A . The load HISTORY view B. The Query history view C. The show warehouses command D. The WAREHOUSE_METERING__HISTORY View E. The billing and usage tab in the Snowflake web UlView AnswerAnswer: D,E

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).A . ORC B. XML C. Avro D. Parquet E. JSONView AnswerAnswer: D,E Explanation: Semi-structured JSON, Parquet https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)

What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMIN B. ORGADMIN C. SECURITYADMIN D. SYSADMINView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

What is a responsibility of Snowflake's virtual warehouses?A . Infrastructure management B. Metadata management C. Query execution D. Query parsing and optimization E. Management of the storage layerView AnswerAnswer: C

What is the purpose of an External Function?A . To call code that executes outside of Snowflake B. To run a function in another Snowflake database C. To share data in Snowflake with external parties D. To ingest data from on-premises data sourcesView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/sql-reference/external-functions.html

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)A . Bytes scanned B. Bytes sent over the network C. Number of partitions scanned D. Percentage scanned from cache E. External bytes scannedView AnswerAnswer: A,D

What happens when a virtual warehouse is resized?A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected B. When reducing the size of a warehouse the compute resources are removed only when they are no longer...