COF-C02 exam

How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of executionB . Querying (select) the size of the stream content...

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).A . The table contains a column that has very low cardinalityB . DML statements that are being issued against the table are blockedC . The table has a small number...

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . TrueB . FalseView AnswerAnswer: A Explanation: Provisioning time can vary based on the size of the warehouse. A 4X-Large Warehouse typically has more resources and may take longer to provision compared to...

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