COF-R02 Exam Questions

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

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: 1. Created...

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

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

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

Which of the following are characteristics of security in Snowflake?

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 w...

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

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

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does...

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

What privilege should a user be granted to change permissions for new objects in a managed access schema?

A materialized view should be created when which of the following occurs? (Choose two.)

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

Which feature allows a user the ability to control the organization of data in a micro-partition?

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?

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

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

Which SQL command can be used to see the CREATE definition of a masking policy?

Which statement describes pruning?

How can a user change which columns are referenced in a view?

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

Using variables in Snowflake is denoted by using which SQL character?

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

Which Snowflake tool would be BEST to troubleshoot network connectivity?