New Year Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Snowflake COF-R02 - SnowPro Core Recertification Exam

Snowflake COF-R02 Premium Access     Download Demo    
Page: 9 / 10
Total 330 questions

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

A.

No virtual warehouse will be used, data will be read from the result cache.

B.

No virtual warehouse will be used, data will be read from the local disk cache.

C.

The default virtual warehouse will be used to read all data.

D.

The virtual warehouse that is defined at the session level will be used to read all data.

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;

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

A.

Local disk caching

B.

Authentication and access control

C.

Metadata management

D.

Query processing

E.

Database storage

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

A.

Gathering the hourly credit usage for an account

B.

Compiling an account's average cloud services cost over the previous month

C.

Summarizing the throughput of Snowpipe costs for an account

D.

Calculating the funds left on an account's contract

In the Snowflake access control model, which entity owns an object by default?

A.

The user who created the object

B.

The SYSADMIN role

C.

Ownership depends on the type of object

D.

The role used to create the object

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

A.

SHOW GRANTS ON ROLE DATA_SCIENCE

B.

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

C.

SHOW GRANTS TO USER INQUISITIVE_PERSON

D.

SHOW GRANTS OF ROLE DATA_SCIENCE

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

A.

INSERT

B.

PUT

C.

GET

D.

COPY

Which Snowflake layer is always leveraged when accessing a query from the result cache?

A.

Metadata

B.

Data Storage

C.

Compute

D.

Cloud Services

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

A.

CREATE_SHARE on the account

B.

SHARE on databases and schemas

C.

SELECT on tables used by the secure view

D.

REFERENCE_USAGE on databases

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

A.

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B.

An error will occur, as views with qualified references cannot be cloned.

C.

An error will occur, as stored objects cannot be cloned.

D.

The stored procedures and views will refer to tables in the source database.