최신 COF-R02 무료덤프 - Snowflake SnowPro Core Recertification

문제1

True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

A. True

B. False

정답: A

문제2

True or False: A single database can exist in more than one Snowflake account.

A. True

B. False

정답: B

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

문제3

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

A. True

B. False

정답: B

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

문제4

Where can a user find and review the failed logins of a specific user for the past 30 days?

A. The SESSIONS view in ACCOUNT_USAGE

B. The ACCESS_HISTORY view in ACCOUNT_USAGE

C. The USERS view in ACCOUNT_USAGE

D. The LOGIN_HISTORY view in ACCOUNT_USAGE

정답: D

문제5

Which statement MOST accurately describes clustering in Snowflake?

A. The clustering key must be included in the COPY command when loading data into Snowflake.

B. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

C. Clustering can be disabled within a Snowflake account.

D. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

정답: D

문제6

Will data cached in a warehouse be lost when the warehouse is resized?

A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B. Yes. became the new compute resource will no longer have access to the cache encryption key

C. Yes. because the compute resource is replaced in its entirety with a new compute resource.

D. No. because the size of the cache is independent from the warehouse size

정답: A

문제7

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

A. True

B. False

정답: A

문제8

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

A. True

B. False

정답: B

문제9

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

A. TABLE_NAME

B. CHECK_OPTION

C. IS_UPDATEABLE

D. IS_SECURE

정답: D

문제10

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

A. Business Critical

B. Enterprise

C. Standard

D. Virtual Private Snowflake

정답: A

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

문제11

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

A. Premier

B. Enterprise

C. Standard

D. Business Critical Edition

정답: B

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

문제12

What is a responsibility of Snowflake's virtual warehouses?

A. Infrastructure management

B. Query execution

C. Query parsing and optimization

D. Permanent storage of micro-partitions

E. Metadata management

정답: B

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

문제13

What are common issues found by using the Query Profile? (Choose two.)

A. Identifying inefficient micro-partition pruning

B. Locating queries that consume a high amount of credits

C. Identifying logical issues with the queries

D. Identifying queries that will likely run very slowly before executing them

E. Data spilling to a local or remote disk

정답: A,D

최신 COF-R02 무료덤프 - Snowflake SnowPro Core Recertification

우리와 연락하기

유용한 링크

최신 업데이트