COF-C02 exam

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)A . ROLES B. POLICY_REFERENCES C. QUERY_HISTORY D. RESOURCE_MONIT ORS E. ACCESS_HISTORYView AnswerAnswer: BE

Which copy INTO command outputs the data into one file?A . SINGLE=TRUE B. MAX_FILE_NUMBER=1 C. FILE_NUMBER=1 D. MULTIPLE=FAISEView AnswerAnswer: B

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