COF-R02 Exam Questions

What privileges are required to create a task?

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

True or False: You can query the files in an External Stage directly without having to load the data into a table.

True or False: An active warehouse is required to run a COPY INTO statement.

True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

Which of the following statements is true of Snowflake?

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

How a Snowpipe charges calculated?

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

True or False: Snowflake supports federated authentication in all editions.

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

True or False: During data unloading, only JSON and CSV files can be compressed.

True or False: Data Providers can share data with only the Data Consumer.

The fail-safe retention period is how many days?

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

How would you determine the size of the virtual warehouse used for a task?

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

What is the default File Format used in the COPY command if one is not specified?

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

True or False: A Virtual Warehouse can be resized while suspended.

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

True or False: Fail-safe can be disabled within a Snowflake account.

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

Which of the following are benefits of micro-partitioning? (Select TWO)

What is the minimum Snowflake edition required to create a materialized view?

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Which feature is only available in the Enterprise or higher editions of Snowflake?

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

What is the default character set used when loading CSV files into Snowflake?

A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?

Which cache type is used to cache data output from SQL queries?

What is a key feature of Snowflake architecture?

What is a limitation of a Materialized View?

What features does Snowflake Time Travel enable?

Which statement about billing applies to Snowflake credits?

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommen...