최신 COF-C02 무료덤프 - Snowflake SnowPro Core Certification

문제1

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

A. True

B. False

정답: B

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

문제2

How would a user run a multi-cluster warehouse in maximized mode?

A. Turn on the additional clusters manually after starting the warehouse.

B. Set the minimum Clusters and maximum Clusters settings to the same value.

C. Configure the maximum clusters setting to "Maximum."

D. Set the minimum clusters and maximum clusters settings to different values.

정답: B

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

문제3

What is the MAXIMUM size limit for a record of a VARIANT data type?

A. 16MB

B. 32MB

C. 8MB

D. 128MB

정답: A

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

문제4

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A. Users

B. Warehouses

C. Accounts

D. Roles

E. Databases

정답: A,C

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

문제5

A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

A. verify @file__stage

B. list @file__stage

C. view @file__stage

D. show @file__stage

정답: B

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

문제6

What can a user win a reader account do in Snowflake?

A. Load now data

B. Update existing data

C. Create a new snare

D. Query shared data

정답: D

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

문제7

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

A. Use secure materialized views.

B. Use data encryption.

C. Revoke all roles for functional managers and end users.

D. Use dynamic data masking.

정답: D

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

문제8

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

A. Metadata

B. Authentication

C. Query execution

D. Compute resources

E. Data storage

정답: A,B

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

문제9

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

A. A single join node uses more than 50% of the query time

B. An AggregateOperacor node is present

C. The query is spilling to remote storage

D. Partitions scanned is equal to partitions total

정답: C

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

문제10

A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?

A. MINUS

B. INTERSECT

C. MFRCK

D. UNION

정답: B

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

문제11

Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

A. NUMBER

B. STRING

C. OBJECT

D. VARCHAR

E. VARIANT

정답: C,E

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

문제12

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

A. PUBLIC

B. ORGADMIN

C. SYSADMIN

D. USERADMIN

정답: D

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

문제13

Which Snowflake command can be used to unload the result of a query to a single file?

A. Use COPY INTO <external stage> followed by a GET command to download the file.

B. Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.

C. Use COPY INTO <internal stage> followed by a put command to download the file.

D. Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.

정답: B

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

문제14

Which of the following can be executed/called with Snowpipe?

A. A stored procedure

B. A User Defined Function (UDF)

C. A single copy_into statement

D. A single insert__into statement

정답: C

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

최신 COF-C02 무료덤프 - Snowflake SnowPro Core Certification

우리와 연락하기

유용한 링크

최신 업데이트