COF-R02

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

What are the three layers that make up Snowflake’s architecture? Choose 3 answerA . Compute B. Tri-Secret Secure C. Storage D. Cloud ServicesView AnswerAnswer: A,C,D Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?A . 4 B. 16 C. 32 D. 128View AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

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

Select the different types of Internal Stages: (Choose three.)A . Named Stage B. User Stage C. Table Stage D. Schema StageView AnswerAnswer: A,B,C Explanation: Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

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 scanned B. Bytes sent over the network C. Number of partitions scanned D. Percentage scanned from cache E. External bytes scannedView AnswerAnswer: A,C

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

Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of values B. Micro-partitions are immutable objects that support the use of Time Travel. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses D. Rows are automatically stored...

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide-data-unload.html

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)A . Custom B. Economy C. Optimized D. StandardView AnswerAnswer: B,D Explanation: Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance