COF-C02 exam

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).A . Materialized views B. Sequences C. Procedures D. Tables E. Secure User Defined Functions (UDFs)View AnswerAnswer: AD

Which of the following commands cannot be used within a reader account?A . CREATE SHARE B. ALTER WAREHOUSE C. DROP ROLE D. SHOW SCHEMAS E. DESCRBE TABLEView AnswerAnswer: ABC

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?A . Pipe B. External stage C. Task D. StreamView AnswerAnswer: A Explanation: Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load...

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

Which of the following describes external functions in Snowflake?A . They are a type of User-defined Function (UDF). B. They contain their own SQL code. C. They call code that is stored inside of Snowflake. D. They can return multiple rows for each row receivedView AnswerAnswer: A Explanation: External functions...

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

What are the default Time Travel and Fail-safe retention periods for transient tables?A . Time Travel - 1 day. Fail-safe - 1 day B. Time Travel - 0 days. Fail-safe - 1 day C. Time Travel - 1 day. Fail-safe - 0 days D. Transient tables are retained in neither...

True or False: A Virtual Warehouse can be resized while suspended.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse

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

What is the default File Format used in the COPY command if one is not specified?A . CSV B. JSON C. Parquet D. XMLView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html