1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-R02
  5. SnowPro Core Recertification Exam Questions and Answers

Pass the Snowflake SnowPro Core Certification COF-R02 Questions and answers with CertsForce

 Snowflake Exams      Go to Exam Detail      Get Premium Access
Viewing page 3 out of 10 pages
Viewing questions 21-30 out of questions
Questions # 21:

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

Options:
A.

True

B.

False

Expert Solution
Questions # 22:

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

Options:
A.

UPSERT

B.

MERGE

C.

UPDATE

D.

TRUNCATE TABLE

Expert Solution
Questions # 23:

The PUT command: (Choose two.)

Options:
A.

Automatically creates a File Format object

B.

Automatically uses the last Stage created

C.

Automatically compresses files using Gzip

D.

Automatically encrypts files

Expert Solution
Questions # 24:

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.

Options:
A.

True

B.

False

Expert Solution
Questions # 25:

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

Options:
A.

The validation_mode option is used when creating an Internal Stage

B.

validation_mode=return_all_errors is a parameter of the copy command

C.

The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

D.

The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Expert Solution
Questions # 26:

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

Choose 3 answers

Options:
A.

On-premise availability

B.

Simplicity

C.

Open source based

D.

Concurrency

E.

Performance

Expert Solution
Questions # 27:

When can a Virtual Warehouse start running queries?

Options:
A.

12am-5am

B.

Only during administrator defined time slots

C.

When its provisioning is complete

D.

After replication

Expert Solution
Questions # 28:

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Options:
A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

Expert Solution
Questions # 29:

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

Options:
A.

Columnar shared nothing

B.

Shared disk

C.

Multi-cluster, shared data

D.

Cloud-native shared memory

Expert Solution
Questions # 30:

True or False: During data unloading, only JSON and CSV files can be compressed.

Options:
A.

True

B.

False

Expert Solution
Viewing page 3 out of 10 pages
Viewing questions 21-30 out of questions