COF-C02 V3

A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?A . list @mytable; B. list @%raytable; C. list @ %m.ystage; D. list @mystage;View AnswerAnswer: D

Which of the following can be executed/called with Snowpipe?A . A User Defined Function (UDF) B. A stored procedure C. A single copy_into statement D. A single insert__into statementView AnswerAnswer: C

What is a key feature of Snowflake architecture?A . Zero-copy cloning creates a mirror copy of a database that updates with the original B. Software updates are automatically applied on a quarterly basis C. Snowflake eliminates resource contention with its virtual warehouse implementation D. Multi-cluster warehouses allow users to run...

What happens when a cloned table is replicated to a secondary database? (Select TWO)A . A read-only copy of the cloned tables is stored. B. The replication will not be successful. C. The physical data is replicated D. Additional costs for storage are charged to a secondary account E. Metadata...

What is the MOST performant file format for loading data in Snowflake?A . CSV (Unzipped) B. Parquet C. CSV (Gzipped) D. ORCView AnswerAnswer: B

Which feature is only available in the Enterprise or higher editions of Snowflake?A . Column-level security B. SOC 2 type II certification C. Multi-factor Authentication (MFA) D. Object-level access controlView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/intro-editions.html

A user has unloaded data from Snowflake to a stage. Which SQL command should be used to validate which data was loaded into the stage?A . list @file__stage B. show @file__stage C. view @file__stage D. verify @file__stageView AnswerAnswer: A

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).A . The user has the appropriate privileges on the objects associated with the query B. Micro-partitions have been reclustered since the query was last run C. The new query is run...

User-level network policies can be created by which of the following roles? (Select TWO).A . ROLEADMIN B. ACCOUNTADMIN C. SYSADMIN D. SECURITYADMIN E. USERADMINView AnswerAnswer: B D

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)A . Data can be filtered by an optional where clause B. Incoming data can be joined with other tables C. Columns can be reordered D. Columns can be omitted E. Row level access...