Free COF-C02 Exam braindumps download (COF-C02 exam dumps Free)

QUESTION: 356

Which of the following are valid methods for authenticating users for access into Snowflake? (Choose three.)

SCIM
Federated authentication
TLS 1.2
Key-pair authentication
OAuth
OCSP authentication

Answer(s): B,D,E

QUESTION: 357

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Answer(s): D

Show Answer Next Question

QUESTION: 358

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

Answer(s): C

Show Answer Next Question

QUESTION: 359

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.

Answer(s): C

Show Answer Next Question