[2026] Snowflake SnowPro Core Certification - COF-C02 무료 시험 문제

문제1

Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

A. GET_PRESENT_URL

B. GET_STATE_LOCATION

C. BUILD_SCOPED_FILE_URL

D. BUILD_STAGE_FILE_URL

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제2

The fail-safe retention period is how many days?

A. 90 days

B. 7 days

C. 1 day

D. 45 days

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제3

Which constraint is enforced for standard Snowflake tables?

A. FOREIGN KEY

B. UNIQUE

C. NOT NULL

D. PRIMARY KEY

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제4

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?

A. Use a larger-sized warehouse.

B. Compress the file and load the compressed file.

C. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

D. Split the file into multiple files in the recommended size range (100 MB - 250 MB).

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제5

Which Snowflake table objects can be shared with other accounts? (Select TWO).

A. Transient tables

B. Temporary tables

C. External tables

D. Permanent tables

E. User-Defined Table Functions (UDTFs)

정답: C,D

설명: (Fast2test 회원만 볼 수 있음)

문제6

What can be shared when the SECURE_OBJECTS_ONLY property is set to FALSE?

A. User-Defined Function, or UDF

B. Storage integration access

C. Stored procedure

D. View

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제7

What information is stored in the ACCESS_HlSTORY view?

A. Query details such as the objects included and the user who executed the query

B. Details around the privileges that have been granted for all objects in an account

C. Names and owners of the roles that are currently enabled in the session

D. History of the files that have been loaded into Snowflake

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제8

When should a multi-cluster warehouse be used in auto-scaling mode?

A. When a large number of concurrent queries are run on the same warehouse

B. When it is unknown how much compute power is needed

C. If the runtime of the executed query is very slow

D. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제9

What metadata is stored for each micro-partition? (Select TWO)

A. The range of values for each of the columns in the full table

B. The clustering key used in the table

C. The average depth of values for each of the columns

D. The number of distinct values

E. The minimum and maximum values for each of the columns

정답: A,E

문제10

Which task privilege does a Snowflake role need in order to suspend or resume a task?

A. MONITOR

B. USAGE

C. OPERATE

D. OWNERSHIP

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제11

Which of the following describes how clustering keys work in Snowflake?

A. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

B. Clustering keys create a distributed, parallel data structure of pointers to a table ' s rows and columns

C. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

D. Clustering keys sort the designated columns over time, without blocking DML operations

정답: D

설명: (Fast2test 회원만 볼 수 있음)

Snowflake SnowPro Core Certification - COF-C02무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트