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

문제1

Using variables in Snowflake is denoted by using which SQL character?

A. $

B. &

C. #

D. @

정답: A

문제2

What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers

A. Simplicity

B. Concurrency

C. Performance

D. On-premise availability

E. Open source based

정답: A,B,C

문제3

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A. Snowflake leverages a Role-Based Access Control (RBAC) model.

B. All data in Snowflake is compressed.

C. Snowflake requires a user to configure an IAM user to connect to the database.

D. All data in Snowflake is encrypted.

E. Snowflake can run within a user's own Virtual Private Cloud (VPC).

정답: A,E

문제4

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

A. ORC

B. Parquet

C. JSON

D. Avro

E. XML

정답: B,C

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

문제5

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

A. 24 hours

B. 48 hours

C. 30 days

D. 7 days

정답: A

문제6

What is a responsibility of Snowflake's virtual warehouses?

A. Infrastructure management

B. Query execution

C. Query parsing and optimization

D. Metadata management

E. Management of the storage layer

정답: B

문제7

When cloning a database, what is cloned with the database? (Choose two.)

A. Privileges on the schemas within the database

B. Future child objects within the database

C. Existing child objects within the database

D. Privileges on the database

E. Only schemas and tables within the database

정답: C,E

문제8

Which stage type can be altered and dropped?

A. User stage

B. Database stage

C. External stage

D. Table stage

정답: D

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

문제9

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A. GET

B. INSERT

C. PUT

D. COPY

정답: D

문제10

Which of the following is a data tokenization integration partner?

A. DBeaver

B. SAP

C. Tableau

D. Protegrity

정답: D

문제11

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

A. Federated authentication

B. TLS 1.2

C. OAuth

D. Key-pair authentication

E. SCIM

F. OCSP authentication

정답: A,C,D

문제12

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

A. Use the DELETE LOAD HISTORY command after the load completes.

B. Specify the PURGE copy option in the COPY INTO <table> command.

C. Specify the TEMPORARY option when creating the file format.

D. Use the REMOVE command after the load completes.

E. Use the DROP <file> command after the load completes.

정답: B,D

문제13

A materialized view should be created when which of the following occurs? (Choose two.)

A. The query is highly optimized and does not consume many compute resources.

B. The base table gets updated frequently.

C. There is minimal cost associated with running the query.

D. The query consumes many compute resources every time it runs.

E. The results of the query do not change often and are used frequently.

정답: B,E

문제14

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

A. True

B. False

정답: B

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

문제15

True or False: An active warehouse is required to run a COPY INTO statement.

A. True

B. False

정답: A

문제16

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

문제17

How would you determine the size of the virtual warehouse used for a task?

A. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

C. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

D. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

정답: B

문제18

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

A. Smaller micro-partitions are created for common data values to allow for more parallelism

B. Data is hashed by the cluster key to facilitate fast searches for common data values

C. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

정답: D

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

우리와 연락하기

유용한 링크

최신 업데이트