COF-C02 V5

Which of the following commands cannot be used within a reader account?A . CREATE SHAREB . ALTER WAREHOUSEC . DROP ROLED . SHOW SCHEMASE . DESCRBE TABLEView AnswerAnswer: A Explanation: In Snowflake, a reader account is a type of account that is intended for consuming shared data rather than performing...

When is the result set cache no longer available? (Select TWO)A . When another warehouse is used to execute the queryB . When another user executes the queryC . When the underlying data has changedD . When the warehouse used to execute the query is suspendedE . When it has...

What is the recommended file sizing for data loading using Snowpipe?A . A compressed file size greater than 100 MB, and up to 250 MBB . A compressed file size greater than 100 GB, and up to 250 GBC . A compressed file size greater than 10 MB, and up...

What is the minimum Snowflake edition required to create a materialized view?A . Standard EditionB . Enterprise EditionC . Business Critical EditionD . Virtual Private Snowflake EditionView AnswerAnswer: B Explanation: Materialized views in Snowflake are a feature that allows for the pre-computation and storage of query results for faster query...

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?A . SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;B . SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())C . SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;D ....

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)A . Bytes scannedB . Bytes sent over the networkC . Number of partitions scannedD . Percentage scanned from cacheE . External bytes scannedView AnswerAnswer: A, C Explanation:...

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?A . Compute layerB . Storage layerC . Cloud infrastructure layerD . Cloud services layerView AnswerAnswer: D Explanation: Query compilation in Snowflake occurs in the Cloud Services layer. This layer is responsible for coordinating and managing all aspects...

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 queryB . Micro-partitions have been reclustered since the query was last runC . The new query is run...

Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimumB . Credits are used to pay for cloud data storage usageC . Credits are consumed based on the number of credits billed for each hour that a warehouse runsD . Credits are consumed...

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)A . Customer-managed encryption keys through Tri-Secret SecureB . Automatic encryption of all dataC . Up to 90 days of data recovery through Time TravelD . Object-level access controlE . Column-level security to apply data masking policies...