Home / Snowflake / COF-R02

Snowflake COF-R02 Practice Test - Questions Answers, Page 31

Question list

List of questions

Question 301

(0)

What is cached during a query on a virtual warehouse?

Question 302

(0)

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Question 303

(0)

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

Question 304

(0)

Which of the following can be used when unloading data from Snowflake? (Choose two.)

Question 305

(0)

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Question 306

(0)

Which formats does Snowflake store unstructured data in? (Choose two.)

Question 307

(0)

Which of the following are characteristics of security in Snowflake?

Question 308

(0)

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 priv

Question 309

(0)

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

Question 310

(0)

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Question 301

What is cached during a query on a virtual warehouse?

All columns in a micro-partition

Any columns accessed during the query

The columns in the result set of the query

All rows accessed during the query

Show Answer Comment (0)

Question 302

Which of the following activities consume virtual warehouse credits in the Snowflake environment?

(Choose two.)

Caching query results

Running EXPLAIN and SHOW commands

Cloning a database

Running a custom query

Running COPY commands

Show Answer Comment (0)

Question 303

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

Created a user called "CONSUMER"

Created a database to hold the share and an extra-small warehouse to query the data

Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?

The reader account will automatically use the Standard edition of Snowflake.

The reader account compute will be billed to the provider account.

The reader account can clone data the provider has shared, but cannot re-share it.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Show Answer Comment (0)

Question 304

Which of the following can be used when unloading data from Snowflake? (Choose two.)

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

Use the ENCODING file format option to change the encoding from the default UTF-8.

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Show Answer Comment (0)

Question 305

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

The warehouse size does not change until all queries currently running in the warehouse have completed.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

The warehouse size does not change until the warehouse is suspended and restarted.

It does not return from the command until the warehouse has finished changing its size.

Show Answer Comment (0)

Question 306

Which formats does Snowflake store unstructured data in? (Choose two.)

GeoJSON

Array

XML

Object

BLOB

Show Answer Comment (0)

Question 307

Which of the following are characteristics of security in Snowflake?

Account and user authentication is only available with the Snowflake Business Critical edition.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Show Answer Comment (0)

Question 308

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?

SHOW GRANTS ON ROLE DATA_SCIENCE

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

SHOW GRANTS TO USER INQUISITIVE_PERSON

SHOW GRANTS OF ROLE DATA_SCIENCE

Show Answer Comment (0)