Home / Snowflake / COF-R02

Snowflake COF-R02 Practice Test - Questions Answers, Page 30

Question list

List of questions

Question 291

(0)

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

Question 292

(0)

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

Question 293

(0)

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

Question 294

(0)

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

Question 295

(0)

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

Question 296

(0)

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

Question 297

(0)

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

Question 298

(0)

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

Question 299

(0)

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

Question 300

(0)

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

Question 291

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

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

Show Answer Comment (0)

Question 292

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

JSON

BINARY

VARCHAR

VARIANT

Show Answer Comment (0)

Question 293

Which stages are used with the Snowflake PUT command to upload files from a local file system?

(Choose three.)

Schema Stage

User Stage

Database Stage

Table Stage

External Named Stage

Internal Named Stage

Show Answer Comment (0)

Question 294

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

Schema stage

Named stage

User stage

Stream stage

Table stage

Database stage

Show Answer Comment (0)

Question 295

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

Configure the maximum clusters setting to "Maximum."

Turn on the additional clusters manually after starting the warehouse.

Set the minimum Clusters and maximum Clusters settings to the same value.

Set the minimum clusters and maximum clusters settings to different values.

Show Answer Comment (0)

Question 296

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

SHOW STORAGE BY TABLE;

SHOW TABLES;

Information Schema -> TABLE_HISTORY

Information Schema -> TABLE_FUNCTION

Information Schema -> TABLE_STORAGE_METRICS

Show Answer Comment (0)

Question 297

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

Show Answer Comment (0)

Question 298

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

Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask

.. AS call stored_proc1(); call stored_proc2();

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

Show Answer Comment (0)

Question 299

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

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Show Answer Comment (0)