COF-C02

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?A . Okta Verify B. Duo Mobile...

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access? A) B) C) D) A. Option A B. Option B C. Option C D. Option DView AnswerAnswer: A

What is the minimum Snowflake edition required to create a materialized view?A . Standard Edition B. Enterprise Edition C. Business Critical Edition D. Virtual Private Snowflake EditionView AnswerAnswer: B Explanation: Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:A . Configure the Maximum Clusters setting to “Auto-Scale” B. Set the Warehouse type to “Auto” C. Set the Minimum Clusters and Maximum Clusters settings to the same value D. Set the Minimum Clusters and Maximum Clusters settings to the...

Which of the following describes how clustering keys work in Snowflake?A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations. B. Clustering keys sort the designated columns over time, without blocking DML operations C. Clustering keys create a distributed, parallel data structure...

The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answersA . The complexity of each query B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account C. The size of the data required for each query D. The tool that s executing the queryView...

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

True or False: You can define multiple columns within a clustering key on a table.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answersA . On-premise availability B. Simplicity C. Open source based D. Concurrency E. PerformanceView AnswerAnswer: B,D,E

True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/credits.html