COF-R02 Exam Questions
329 real COF-R02 exam questions with expert-verified answers and explanations. Page 7 of 7.
- Question #302
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
- 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: 1. Created...
- Question #304
Which of the following can be used when unloading data from Snowflake? (Choose two.)
- Question #305
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
- Question #306
Which formats does Snowflake store unstructured data in? (Choose two.)
- Question #307
Which of the following are characteristics of security in Snowflake?
- 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 w...
- Question #309
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
- Question #310
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
- Question #311
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...
- Question #312
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
- Question #313
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
- Question #314
What privilege should a user be granted to change permissions for new objects in a managed access schema?
- Question #315
A materialized view should be created when which of the following occurs? (Choose two.)
- Question #316
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
- Question #317
Which feature allows a user the ability to control the organization of data in a micro-partition?
- Question #318
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?
- Question #319
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
- Question #320
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
- Question #321
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
- Question #322
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
- Question #323
Which SQL command can be used to see the CREATE definition of a masking policy?
- Question #324
Which statement describes pruning?
- Question #325
How can a user change which columns are referenced in a view?
- Question #326
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.)
- Question #327
Using variables in Snowflake is denoted by using which SQL character?
- Question #328
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
- Question #329
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
- Question #330
Which Snowflake tool would be BEST to troubleshoot network connectivity?