Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-C02 - SnowPro Core Certification Exam

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 65

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

A.

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

B.

The transient table version cannot be retrieved after 24 hours.

C.

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

D.

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Full Access
Question # 66

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

A.

Shared-disk

B.

Shared-nothing

C.

Multi-cluster shared data

D.

Serverless query engine

Full Access
Question # 67

In a Snowflake role hierarchy, what is the top-level role?

A.

SYSADMIN

B.

ORGADMIN

C.

ACCOUNTADMIN

D.

SECURITYADMIN

Full Access
Question # 68

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

How can this requirement be met?

A.

Use data encryption.

B.

Use dynamic data masking.

C.

Use secure materialized views.

D.

Revoke all roles for functional managers and end users.

Full Access
Question # 69

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

A.

The USERS view in ACCOUNT_USAGE

B.

The LOGIN_HISTORY view in ACCOUNT_USAGE

C.

The ACCESS_HISTORY view in ACCOUNT_USAGE

D.

The SESSIONS view in ACCOUNT_USAGE

Full Access
Question # 70

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

A.

Compress the file and load the compressed file.

B.

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C.

Use a larger-sized warehouse.

D.

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Full Access
Question # 71

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

A.

External Tokenization

B.

External Tables

C.

Materialized Views

D.

User-Defined Table Functions (UDTF)

Full Access
Question # 72

How can a row access policy be applied to a table or a view? (Choose two.)

A.

Within the policy DDL

B.

Within the create table or create view DDL

C.

By future APPLY for all objects in a schema

D.

Within a control table

E.

Using the command ALTER ADD ROW ACCESS POLICY ;

Full Access