COF-C02 exam

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 affectedB . When reducing the size of a warehouse the compute resources are removed only when they are no longer...

Which of the following objects can be shared through secure data sharing?A . Masking policyB . Stored procedureC . TaskD . External tableView AnswerAnswer: D Explanation: Secure data sharing in Snowflake allows users to share various objects between Snowflake accounts without physically copying the data, thus not consuming additional storage....

Which services does the Snowflake Cloud Services layer manage? (Select TWO).A . Compute resourcesB . Query executionC . AuthenticationD . Data storageE . MetadataView AnswerAnswer: C, E Explanation: The Snowflake Cloud Services layer manages a variety of services that are crucial for the operation of the Snowflake platform. Among these...

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)A . Via the Snowflake Web Interface (Ul)B . Via the data_share=true parameterC . Via SQL commandsD . Via Virtual WarehousesView AnswerAnswer: A, C Explanation: In Snowflake, Data Shares can be created and managed in two primary...

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO). A. Use multi-clustered warehousing to scale out...

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).A . Materialized viewsB . SequencesC . ProceduresD . TablesE . Secure User Defined Functions (UDFs)View AnswerAnswer: D, E Explanation: Secure sharing in Snowflake allows users to share specific objects with other Snowflake accounts without physically...

Where would a Snowflake user find information about query activity from 90 days ago?A . account__usage. query history viewB . account__usage.query__history__archive ViewC . information__schema. cruery_history viewD . information__schema - query history_by_ses s i on viewView AnswerAnswer: B Explanation: To find information about query activity from 90 days ago, a Snowflake...

What are value types that a VARIANT column can store? (Select TWO)A . STRUCTB . OBJECTC . BINARYD . ARRAYE . CLOBView AnswerAnswer: B, D Explanation: A VARIANT column in Snowflake can store semi-structured data types. This includes: B. OBJECT: An object is a collection of key-value pairs in JSON,...

How often are encryption keys automatically rotated by Snowflake?A . 30 DaysB . 60 DaysC . 90 DaysD . 365 DaysView AnswerAnswer: A Explanation: Snowflake automatically rotates encryption keys when they are more than 30 days old. Active keys are retired, and new keys are created. This process is part...

What is a responsibility of Snowflake's virtual warehouses?A . Infrastructure managementB . Metadata managementC . Query executionD . Query parsing and optimizationE . Management of the storage layerView AnswerAnswer: C Explanation: The primary responsibility of Snowflake’s virtual warehouses is to execute queries. Virtual warehouses are one of the key components...