Snowflake SnowPro® Core Certification (COF-C03) 認定 COF-C03 試験問題:

1. A directory table that references an external stage is being refreshed manually.
What will happen to any scheduled automatic-refresh operations occurring at the same time as the manual- refresh operations?

A) The automatic-refresh operations will be performed more often.
B) The automatic-refresh operations will be aborted.
C) The manual-refresh operations and the automatic-refresh operations will both take place.
D) The automatic-refresh operations will continue on the established schedule.

2. When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A) Partitions scanned is equal to partitions total
B) An AggregateOperacor node is present
C) A single join node uses more than 50% of the query time
D) The query is spilling to remote storage

3. What are type predicates used for?

A) Casting a value in a variant column to a particular data type
B) Determining if a value in a variant column is a particular data type
C) Extracting data from a variant column
D) Manipulating objects and arrays in a VARIANT column

4. Which governance feature is supported by all Snowflake editions?

A) OBJECT_DEPENDENCIES View
B) Row access policies
C) Masking policies
D) Object tags

5. How do secure views compare to non-secure views in Snowflake?

A) Non-secure views are preferred over secure views when sharing data.
B) Secure views execute slowly compared to non-secure views.
C) Secure views are similar to materialized views in that they are the most performant.
D) There are no performance differences between secure and non-secure views.

質問と回答：