COF-R02 exam

How a Snowpipe charges calculated?A . Per-second/per Warehouse size B. Per-second/per-core granularity C. Number of Pipes in account D. Total storage bucket sizeView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.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

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

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 statements is true of Snowflake?A . It was built specifically for the cloud B. It was built as an on-premises solution and then ported to the cloud C. It was designed as a hybrid database to allow customers to store data either on premises or in...

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

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

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

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