COF-C02 exam

Which Snowflake technique can be used to improve the performance of a query?A . Clustering B. Indexing C. Fragmenting D. Using INDEX__HINTSView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?A . Data is hashed by the cluster key to facilitate fast searches for common data values B. Larger micro-partitions are created for common data values to reduce the number of partitions that...

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: Query result cache is all about fetching the data from cloud services layer and saving the cost by not running...

Which command can be used to load data into an internal stage?A . LOAD B. copy C. GET D. PUTView AnswerAnswer: D Explanation: https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

What tasks can be completed using the copy command? (Select TWO)A . Columns can be aggregated B. Columns can be joined with an existing table C. Columns can be reordered D. Columns can be omitted E. Data can be loaded without the need to spin up a virtual warehouseView AnswerAnswer:...

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,C

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

What happens when an external or an internal stage is dropped? (Select TWO).A . When dropping an external stage, the files are not removed and only the stage is dropped B. When dropping an external stage, both the stage and the files within the stage are removed C. When dropping...

How often are encryption keys automatically rotated by Snowflake?A . 30 Days B. 60 Days C. 90 Days D. 365 DaysView AnswerAnswer: A Explanation: All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When...

Which of the following objects can be shared through secure data sharing?A . Masking policy B. Stored procedure C. Task D. External tableView AnswerAnswer: D Explanation: Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be...