COF-R02 Exam Questions

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? Select one.

Which of the following statement is true of Snowflake? Select one.

The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

Which of the following statements would be used to export/unload data from Snowflake?

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

What are the three layers that make up Snowflake's architecture? Choose 3 answer

Which type of table corresponds to a single Snowflake session?

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

Which of the following are options when creating a Virtual Warehouse?

Which of the following DML commands isn't supported by Snowflake?

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly gran...

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

True or False: Snowflake charges a premium for storing semi-structured data.

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

True or False: A single database can exist in more than one Snowflake account.

Which of the following roles is recommended to be used to create and manage users and roles?

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

Select the different types of Internal Stages: (Choose three.)

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

True or False: The COPY command must specify a File Format in order to execute.

Which of the following objects can be cloned? (Choose four.)

Snowflake is designed for which type of workloads? (Choose two.)

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

The PUT command: (Choose two.)

Which interfaces can be used to create and/or manage Virtual Warehouses?

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

True or False: It is possible to load data into Snowflake without creating a named File Format object.

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

Which of the following statements are true of Snowflake releases: (Choose two.)

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Which of the following terms best describes Snowflake's database architecture?

Which of the following objects is not covered by Time Travel?

When can a Virtual Warehouse start running queries?

True or False: Pipes can be suspended and resumed.

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