COF-C01 V1

Which of the following statement is true of Snowflake?A . It was built specifically for the cloudB . it was built as an on-premises solution and then potted to the cloudC . It was designed as a hybrid database to allow customers to store data either on premises or in...

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

Which statement best describes '' clustering''?A . Clustering represents the way data is grouped together and stored within snowflake's micro-partitionsB . The database administrator must define the clustering methodology for each Snowflake table.C . The clustering key must be included on the COPV command when loading data into Snowflake.D ....

True or False: Snowpipe via RFST API can only reference External Stages as source.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

Which of the following is true of Snowpipe via REST API? Choose 2 answersA . you can only use it on internal StagesB . All COPY INTO options are available fluting pipe creationC . Snowflake automatically manages the compute required to execute the Pipe's copy into commandsD . Snowpipe keeps...

How often are encryption keys automatically rotated by Snowflake?A . 30 DaysB . 60 DaysC . 90 DaysD . 365 DaysView AnswerAnswer: A Explanation: All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When...

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

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answersA . MIN(< < column value>>)B . COPYC . SUM(<< column value >>)D . UPDATEView AnswerAnswer: B,C,D

True or False: Users are able to see the result sets of queries executed by other users that share their same role.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

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 valueD . Set the Minimum Clusters and Maximum Clusters settings to the...