Tag - COF-R02 exam

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

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

What happens when a virtual warehouse is resized?A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected B. When reducing the size of a warehouse the compute resources are removed only when they are no longer...

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

Snowflake is designed for which type of workloads? (Choose two.)A . OLAP (Analytics) workloads B. OLTP (Transactional) workloads C. Concurrent workloads D. On-premise workloadsView AnswerAnswer: A,C Explanation: Reference: https://blog.couchbase.com/its-the-workload-stupid/ https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).A . Load files that are approximately 25 MB or smaller. B. Remove all dates and timestamps. C. Load files that are approximately 100-250 MB (or larger) D. Avoid using embedded characters...

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)A . SCIM B. Federated authentication C. TLS 1.2 D. Key-pair authentication E. OAuth F. OCSP authenticationView AnswerAnswer: B,D,E

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)A . Customers can change the size of the Warehouse after creation B. A Warehouse can be resized while running C. A Warehouse can be configured to suspend after a period of inactivity D. A Warehouse can...