QUESTION: 13

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

UPSERT
MERGE
UPDATE
TRUNCATE TABLE

Answer(s): A

Reference:

https://docs.snowflake.com/en/sql-reference/sql-dml.html

Reveal Solution Next Question

QUESTION: 14

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 granted by supported.

True
False

Answer(s): B

Reference:

https://docs.snowflake.com/en/user-guide/connecting.html

Reveal Solution Next Question

QUESTION: 15

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

A multi-cluster Warehouse can add clusters automatically based on query activity
A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
A multi-cluster Warehouse can scale down when query activity slows
A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

Answer(s): A,B,C,D

Reveal Solution Next Question

QUESTION: 16

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

On-premise availability
Simplicity
Open source based
Concurrency
Performance

Answer(s): B,D,E

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 5)

QUESTION: 13

Reference:

QUESTION: 14

Reference:

QUESTION: 15

QUESTION: 16

COF-R02 Discussions & Posts