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 # 145

Which copy INTO command outputs the data into one file?

A.

SINGLE=TRUE

B.

MAX_FILE_NUMBER=1

C.

FILE_NUMBER=1

D.

MULTIPLE=FAISE

Full Access
Question # 146

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

A.

VARIANT

B.

ARRAY

C.

VARCHAR

D.

XML

E.

BLOB

Full Access
Question # 147

Which statement about billing applies to Snowflake credits?

A.

Credits are billed per-minute with a 60-minute minimum

B.

Credits are used to pay for cloud data storage usage

C.

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D.

Credits are consumed based on the warehouse size and the time the warehouse is running

Full Access
Question # 148

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

A.

Informatica

B.

Power Bl

C.

Adobe

D.

Data Robot

Full Access
Question # 149

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.

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

C.

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

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

Full Access
Question # 150

What is the minimum Snowflake edition required to use Dynamic Data Masking?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPC)

Full Access
Question # 151

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 # 152

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