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

문제1

What would cause different results to be returned when running the same query twice?

A. SAMPLE is used and the seed is set

B. Fixed-size sampling Is used.

C. sample is used and the seed is not set.

D. Fraction-based sampling is used.

정답: C

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

문제2

What is the MINIMUM role required to set the value for the parameter
ENABLE_ACCOUNT_DATABASE_REPLICATION?

A. SECURITYADMIN

B. ORGADMIN

C. SYSADMIN

D. ACCOUNTADMIN

정답: D

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

문제3

Which of the following statements describe features of Snowflake data caching? (Choose two.)

A. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

B. When the data cache is full, the least-recently used data will be cleared to make room.

C. A user can only access their own queries from the query result cache.

D. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

E. The RESULT_SCAN table function can access and filter the contents of the query result cache.

정답: B,E

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

문제4

Which data types optimally store semi-structured data? (Select TWO).

A. STRING

B. ARRAY

C. VARCHAR

D. VARIANT

E. CHARACTER

정답: B,D

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

문제5

Which statement accurately describes how a virtual warehouse functions?

A. All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.

B. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.

C. Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.

D. Increasing the size of a virtual warehouse will always improve data loading performance.

정답: B

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

문제6

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

A. Scoped URL

B. File URL

C. Pre-Signed URL

D. Relative URL

정답: A

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

문제7

What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'

A. Future grants

B. Tables

C. Views

D. Materialized views

E. External tables

정답: B,C

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

문제8

Which Snowflow object does not consume and storage costs?

A. Transient table

B. Materialized view

C. Temporary table

D. Secure view

정답: C

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

문제9

A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).

A. CREATE USER

B. OWNERSHIP

C. SELECT

D. MODIFY

E. GRANT

정답: A,B

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

문제10

When used with the UNLOAD command, which parameter specifies the destination of unloaded data?

A. COPY INTO <stage name>

B. COPY INTO <table name>

C. PUT <file name>

D. GET <file name>

정답: A

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

문제11

When should a stored procedure be created with caller's rights?

A. When the stored procedure needs to run with the privileges of the role that called the stored procedure

B. When the caller needs to run a statement that could not execute outside of the stored procedure

C. When the stored procedure needs to operate on objects that the caller does not have privileges on

D. When the caller needs to be prevented from viewing the source code of the stored procedure

정답: A

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

문제12

A stream can be created on which Snowflake objects to record data manipulation language(DML) changes?
(Select TWO).

A. Standard views

B. Standard tables

C. Standard tables

D. Pipes

E. Schemas

F. Database

정답: B,C

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

문제13

A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.
Which Snowflake do it the user's IP address does not match the user-level network policy rules?

A. Prevent the user from executing additional queries.

B. Deactivate the network policy.

C. Log the user out.

D. Allow the user to continue until the session or login token expires.

정답: A

문제14

What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?

A. Client-side encryption

B. Tri-secret secure encryption

C. Hierarchical key model

D. Key pair authentication

정답: B

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

문제15

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

A. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

B. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

D. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

E. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

F. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

정답: A,B,E

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

문제16

What Snowflake feature or service is used to prevent third parties from reading data while it is at rest or in transit?

A. Zero-copy cloning

B. End-to-end encryption

C. Incremental data snapshots

D. Network policies

정답: B

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

우리와 연락하기

유용한 링크

최신 업데이트