COF-C02問題集、Snowflake実際の試験問題

質問 1

What Snowpark element represents a data set and provides ways to operate on the data?

A. List

B. Array

C. Table

D. DataFrame

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 2

What is the minimum Snowflake edition required to create a materialized view?

A. Enterprise Edition

B. Standard Edition

C. Virtual Private Snowflake Edition

D. Business Critical Edition

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 3

Which steps will help optimize query performance? (Select TWO).

A. Clustering a table

B. Using the query acceleration service

C. Increasing the size of the micro-partitions

D. Decreasing the size of the virtual warehouse

E. Indexing a column

正解: C,D

質問 4

A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?

A. Grant the additional privileges to a custom role.

B. Grant the additional privileges to the ACCOUNTADMIN role.

C. Grant the additional privileges to the ORGADMIN role.

D. Grant the additional privileges to the SYSADMIN role.

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 5

What are the results of the NULL_COUNT Data Metric Function, or DMF, used to verify?

A. The freshness of the data

B. The accuracy of the data

C. The uniqueness of the data

D. The volume of the data

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 6

Which objects will incur storage costs associated with Fail-safe?

A. External tables

B. Data files available in internal stages

C. Permanent tables

D. Data files available in external stages

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 7

What is the default character set used when loading CSV files into Snowflake?

A. UTF-8

B. ISO S859-1

C. ANSI_X3.A

D. UTF-16

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 8

A virtual warehouse has the same value for MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT. What will happen when the warehouse is started?

A. Snowflake will start all available clusters.

B. Snowflake will start a single cluster and will start an additional cluster once it estimates there is enough query load to keep the new cluster running for 6 minutes.

C. Snowflake will start enough clusters to handle the current workload.

D. Snowflake will start a single cluster and will start additional clusters as soon as queries are in the queue for more than 6 minutes.

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 9

How does the search optimization service use the search access path?

A. By generating a real-time index for all data in a database

B. By identifying where column-level values are located in each micro-partition

C. By creating an up-to-date catalog of all of the tables in a database

D. By listing all of the queries that have been executed on the table data

正解: B

解説: (PassTest メンバーにのみ表示されます)

Snowflake SnowPro Core Certification - COF-C02 模擬練習