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

문제1

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 회원만 볼 수 있음)

문제2

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

A. Metadata Management

B. Cloud Services

C. Query Processing

D. Database Storage

정답: D

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

문제3

Which common query problems are identified by the Query Profile? (Select TWO.)

A. Object does not exist or not authorized

B. Syntax error

C. Inefficient pruning

D. Queries too large to fit in memory

E. Ambiguous column names

정답: C,D

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

문제4

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

A. SECURITYADMIN

B. SYSADMIN

C. ACCOUNTADMIN

D. USERADMIN

정답: C

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

문제5

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

A. Temporary tables

B. User-Defined Table Functions (UDTFs)

C. Transient tables

D. Permanent tables

E. External tables

정답: D,E

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

문제6

What is a best practice after creating a custom role?

A. Assign the custom role to the SYSADMIN role

B. Create the custom role using the SYSADMIN role.

C. Assign the custom role to the PUBLIC role

D. Add__CUSTOM to all custom role names

정답: A

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

문제7

How can staged files be removed during data loading once the files have loaded successfully?

A. Use the FORCE = TRUE parameter

B. Use the LOAD UNCERTAIN FILES copy option.

C. Use the purge copy option.

D. Use the DROP command

정답: C

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

문제8

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

A. Warehouses that are multi-cluster can have nodes of different sizes.

B. Warehouses can be started and stopped at any time.

C. Warehouses can be resized at any time, even while running.

D. Warehouses can only be used for querying and cannot be used for data loading.

E. Warehouses are billed on a per-minute usage basis.

정답: B,C

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

문제9

What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));

A. To validate task SQL statements against table t1 in the last 14 days

B. To validate external table files in table t1 across all sessions

C. To return errors from the last executed COPY command into table t1 in the current session

D. To validate a file for errors before it gets executed using a COPY command

정답: C

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

문제10

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

A. A role that has the ownership of the network policy

B. A user with an USERADMIN or higher role

C. A user with a SECURITYADMIN or higher role

D. A role that has been granted the ATTACH POLICY privilege

E. A role that has the NETWORK_POLlCY account parameter set

정답: A,C

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

문제11

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

A. AUTOMATIC__CLUSTERING

B. Scaling up a warehouse

C. Snowpipe

D. Execute a COPY command

E. Updating data

정답: B,C

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

문제12

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

A. The separation ensures consistent data encryption across all virtual data warehouses.

B. Storage volume growth and compute usage growth can be tightly coupled.

C. The separation allows independent scaling of computing resources.

D. Compute can be scaled up or down without the requirement to add more storage.

E. The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

정답: C,D

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

문제13

The following settings are configured:
THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level.
THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level.
For how many days will the data be retained at the object level?

A. 7

B. 3

C. 2

D. 5

정답: C

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

문제14

What is the MAXIMUM Time Travel retention period for a transient table?

A. 90 days

B. 1 day

C. O days

D. 7 days

정답: B

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

문제15

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

A. Business Critical

B. Enterprise

C. Standard

D. Virtual Private Snowflake

정답: A

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

문제16

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

A. JavaScript

B. Swift

C. SQL

D. Python

정답: D

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

문제17

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

A. The table contains a column that has very low cardinality

B. The table has a small number of micro-partitions

C. The clustering depth for the table is large

D. DML statements that are being issued against the table are blocked

E. Queries on the table are running slower than expected

정답: C,E

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

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

우리와 연락하기

유용한 링크

최신 업데이트