COF-C02 Practice Questions

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the followin...

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Which statement is true about running tasks in Snowflake?

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));

Which file formats are supported for unloading data from Snowflake? (Choose two.)

The Snowflake Search Optimization Services supports improved performance of which kind of query?

What are common issues found by using the Query Profile? (Choose two.)

What happens to historical data when the retention period for an object ends?

By default, which Snowflake role is required to create a share?

In a Snowflake role hierarchy, what is the top-level role?

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?

How should a virtual warehouse be configured if a user wants to ensure that additional multi- clusters are resumed with no delay?

Where is Snowflake metadata stored?

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Which statement MOST accurately describes clustering in Snowflake?

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

How often are the Account and Table master keys automatically rotated by Snowflake?

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

Which TABLE function helps to convert semi-structured data to a relational representation?

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

What is the recommended compressed file size range for continuous data loads using Snowpipe?

Which of the following statements describes a schema in Snowflake?

What is a responsibility of Snowflake's virtual warehouses?

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

Which statement describes how Snowflake supports reader accounts?

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

Which data type can store more than one type of data structure?

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

What internal stages are available in Snowflake? (Choose three.)

How would a user run a multi-cluster warehouse in maximized mode?

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

How many resource monitors can be assigned at the account level?

How would a user execute a series of SQL statements using a task?

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

A user has a standard multi-cluster warehouse auto-scaling policy in place. Which condition will trigger a cluster to shut-down?

What is cached during a query on a virtual warehouse?

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