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

문제1

Which cache type is used to cache data output from SQL queries?

A. Result cache

B. Metadata cache

C. Local file cache

D. Remote cache

정답: A

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

문제2

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

A. The duration of the queries that are executed

B. The number of active users assigned to the warehouse

C. The length of time the warehouse is running

D. The size of the virtual warehouse

E. The number of queries executed

정답: C,E

문제3

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.
How can this be accomplished?

A. select src:dealership from car_sales;

B. select src.dealership from car_sales;

C. select src:Dealership from car_sales;

D. select dealership from car_sales;

정답: A

문제4

The Snowflake Cloud Data Platform is described as having which of the following architectures?

A. Serverless query engine

B. Shared-disk

C. Multi-cluster shared data

D. Shared-nothing

정답: C

문제5

Which of the following are options when creating a Virtual Warehouse?

A. Local SSD size

B. Auto-resume

C. Auto-suspend

D. User count

정답: B,C

문제6

What is the MOST performant file format for loading data in Snowflake?

A. ORC

B. Parquet

C. CSV (Unzipped)

D. CSV (Gzipped)

정답: C

문제7

Which command is used to unload data from a Snowflake table into a file in a stage?

A. COPY INTO

B. GET

C. WRITE

D. EXTRACT INTO

정답: A

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

문제8

Where would a Snowflake user find information about query activity from 90 days ago?

A. account__usage.query__history__archive View

B. account__usage . query history view

C. information__schema . cruery_history view

D. information__schema - query history_by_ses s i on view

정답: B

문제9

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

정답: B

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

문제10

Which command sets the Virtual Warehouse for a session?

A. USE WAREHOUSE <<warehouse name>>;

B. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

C. COPY WAREHOUSE FROM <<config file>>;

D. SET WAREHOUSE = <<warehouse name>>;

정답: A

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

문제11

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A. Custom

B. Standard

C. Economy

D. Optimized

정답: B,C

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

문제12

Which of the following roles is recommended to be used to create and manage users and roles?

A. SECURITYADMIN

B. PUBLIC

C. SYSADMIN

D. ACCOUNTADMIN

정답: A

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

문제13

Which of the following describes the Snowflake Cloud Services layer?

A. Manages quotas on the Snowflake account storage

B. Executes queries submitted by the Snowflake account users

C. Coordinates activities in the Snowflake account

D. Manages the virtual warehouse cache to speed up queries

정답: C

문제14

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

A. True

B. False

정답: A

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

문제15

What privileges are required to create a task?

A. Tasks are created at the Application level and can only be created by the Account Admin role.

B. The role must have access to the target schema and the create task privilege on the schema itself.

C. The global privilege create task is required to create a new task.

D. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

정답: B

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

문제16

Which of the following can be used when unloading data from Snowflake? (Choose two.)

A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E. Use the ENCODING file format option to change the encoding from the default UTF-8.

정답: A,D

문제17

Users are responsible for data storage costs until what occurs?

A. Data expires from Time Travel

B. Data expires from Fail-safe

C. Data is truncated from a table

D. Data is deleted from a table

정답: B

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

우리와 연락하기

유용한 링크

최신 업데이트