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

문제1

While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

A. BUILD SCOPED FILE URL

B. GET_PRESIGNED_URL

C. GET_ABSOLUTE_PATH

D. BUILD_STAGE_FILE_URL

정답: D

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

문제2

Where is Snowflake metadata stored?

A. Within the data files

B. In the virtual warehouse layer

C. In the remote storage layer

D. In the cloud services layer

정답: D

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

문제3

Which privilege is required on a virtual warehouse to abort any existing executing queries?

A. USAGE

B. MONITOR

C. MODIFY

D. OPERATE

정답: D

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

문제4

What is used to diagnose and troubleshoot network connections to Snowflake?

A. Snowpark

B. SnowCD

C. Snowsight

D. SnowSQL

정답: B

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

문제5

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A. Bytes sent over network

B. Bytes spilled to local storage

C. Partitions total

D. Partitions scanned

E. Percentage scanned from cache

정답: C,D

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

문제6

What is the maximum Time Travel retention period for a temporary Snowflake table?

A. 90 days

B. 1 day

C. 45 days

D. 7 days

정답: B

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

문제7

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

A. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

B. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

C. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

D. A Data Exchange allows groups of accounts to share data privately among the accounts.

E. A Data Exchange allows accounts to share data with third, non-Snowflake parties.

정답: A,D

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

문제8

Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

A. JSON_EXTRACT_PATH_TEXT

B. CHECK_JSON

C. PARSE_XML

D. PARSE_JSON

정답: D

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

문제9

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

A. An error stating that the referenced object could not be uniquely identified.

B. An error stating that the view could not be compiled.

C. The data from the temporary table.

D. The data from the permanent table.

정답: D

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

문제10

How does the search optimization service help Snowflake users improve query performance?

A. It keeps track of running queries and their results and saves those extra scans on the table.

B. It scans the local disk cache to avoid scans on the tables used in the Query.

C. It scans the micro-partitions based on the joins used in the queries and scans only join columns.

D. II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.

정답: D

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

문제11

How does Snowflake Fail-safe protect data in a permanent table?

A. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

B. Fail-safe makes data available for 7 days, recoverable by user operations.

C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

D. Fail-safe makes data available up to 1 day, recoverable by user operations.

정답: C

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

문제12

How does a scoped URL expire?

A. The encoded URL access is permanent.

B. When the data cache clears.

C. The length of time is specified in the expiration_time argument.

D. When the persisted query result period ends.

정답: D

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

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

우리와 연락하기

유용한 링크

최신 업데이트