Snowflake COF-C02 Online Access

SnowPro Core Certification Exam Questions and Answers

Question 33

When do Snowflake object owners lose their ability to make grant decisions?

When the object owner has been granted a database role

When the object owner has been granted an account role

When the object is part of a managed access schema

When the object is part of a regular schema

Question 34

What are type predicates used for?

Extracting data from a variant column

Casting a value in a variant column to a particular data type

Determining if a value in a variant column is a particular data type

Manipulating objects and arrays in a VARIANT column

Question 35

What does a Query Profile metric that shows excessive spillage indicate?

Poor query optimization

Expired temporary tables

Improper virtual warehouse sizing

Improper Common Table Expressions (CTEs)

Question 36

Which action will scale-out a Snowflake virtual warehouse?

Removing 1 cluster from a multi-cluster warehouse

Adding 2 additional clusters to a multi-cluster warehouse

Resizing a warehouse from size Small to X-Large

Resizing a warehouse from size Large to Medium