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

1. What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

A) Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
B) Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
C) Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
D) Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
E) Scaling out adds clusters of varying sizes to a virtual warehouse.
F) Scaling up resizes a virtual warehouse so it can handle more complex workloads.

2. A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?

A) Create a view on the table.
B) Add a limit clause to the query.
C) Add a clustering key to the table
D) Add a Dynamic Data Masking policy to the table.

3. What is the MINIMUM Snowflake edition required to add masking policies to selectively mask plain-text data in a table or in view columns at query time?

A) Business Critical
B) Standard
C) Enterprise
D) Virtual Private Snowflake (VPS)

4. Which role has the ability to create a share from a shared database by default?

A) ORGADMIN
B) ACCOUNTADMIN
C) SYSADMIN
D) SECURITYADMIN

5. Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

A) The query includes a User Defined Function (UDF)
B) Micro-partitions have been reclustered since the query was last run
C) The new query is run using the same virtual warehouse as the previous query
D) The user has the appropriate privileges on the objects associated with the query
E) The query has been run within 24 hours of the previously-run query

質問と回答：