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

質問 1

Which view can be used to determine if a table has frequent row updates or deletes?

A. STORAGE_DAILY_HISTORY

B. STORAGE USAGE

C. TABLE_STORAGE_METRICS

D. TABLES

正解: C

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

質問 2

What objects are required to unload data into cloud data storage? (Select TWO).

A. A FILE FORMAT definition

B. A directory table

C. An external stage

D. A STORAGE_INTEGRATION definition

E. An external table

正解: A,C

質問 3

Use of what parameter will allow files to be loaded even if the file metadata has expired?

A. LOAD_UNCERTAIN_FILES = TRUE

B. MATCH_BY_COLUMN_NAME = CASE_INSENSITIVE

C. ENFORCE_LENGTH = TRUE

D. PURGE = TRUE

正解: D

質問 4

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

A. Reader

B. Personalized

C. Vendor

D. Consumer

E. Standard

正解: B,C

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

質問 5

Which feature allows a user the ability to control the organization of data in a micro-partition?

A. Search Optimization Service

B. Automatic Clustering

C. Range Partitioning

D. Horizontal Partitioning

正解: B

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

質問 6

An external stage many_stage contains many directories including one, app_files that contains CSV files How can all the CSV files from this directory be moved into table my_table without scanning files that are not needed?

A. COPY INTO my_table FROM @many_stage;

B. COPY INTO my_table FROM @many_stage/app_files FILE_FORMAT = (TYPE = CSV);

C. COPY INTO my_table FROM @many_stage PATTERN = '.\.csv';

D. COPY INTO my_table FROM @many_stage/app_files/.csv;

正解: D

質問 7

Which feature allows a user to review the monthly projected costs of a Snowflake resource against the monthly actual costs?

A. Budgets

B. Resource monitor

C. Scaling policy

D. Auto-suspend

正解: A

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

質問 8

Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).

A. ARRAY

B. VARCHAK

C. VARIANT

D. BINARY

E. TEXT

正解: A,C

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

質問 9

What is the purpose of configuring the scale factor parameter when using the Query Acceleration Service?

A. It increases the default selectivity of any filter parameters when the query is accelerated.

B. It is a concurrency control tool used to avoid unnecessary scaling up when the query is accelerated and the warehouse is running in Maximized mode.

C. It controls costs by setting an upper bound on the amount of compute resources a warehouse can use for query acceleration.

D. It is used when there are not enough partitions in a table to accelerate the query.

正解: C

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

質問 10

How long is the Fail-safe period for temporary and transient tables?

A. There is no Fail-safe period for these tables.

B. 31 days

C. 1 day

D. 7 days

E. 90 days

正解: A

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

質問 11

Where is Snowflake metadata stored?

A. In the virtual warehouse layer

B. In the cloud services layer

C. Within the data files

D. In the remote storage layer

正解: B

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

質問 12

What is the recommended compressed file size range for continuous data loads using Snowpipe?

A. 8-16 MB

B. 100-250 MB

C. 16-24 MB

D. 10-99 MB

正解: B

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

質問 13

Which functions are used to manipulate semi-structured data? (Select TWO)

A. WIDTH_BUCKET

B. OBJECT_INSERT

C. HASH_AGG

D. ARRAY_APPEND

E. LISTAGG

正解: B,D

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

質問 14

A developer expects Snowflake to refresh a dynamic table incrementally, but Snowflake selects full refresh mode instead.
Which query operator can prevent incremental refresh and cause Snowflake to use full refresh mode when REFRESH_MODE = AUTO?

A. GROUP BY

B. UNION ALL

C. LATERAL JOIN

D. DISTINCT

正解: C

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

質問 15

Which of the following objects can be shared through secure data sharing?

A. External table

B. Task

C. Masking policy

D. Stored procedure

正解: A

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

Snowflake SnowPro® Core Certification 2026 Exam (COF-C03) - COF-C03 模擬練習