COF-C01 Exam Training Practice Tests (Snowflake SnowPro Core Certification)]

Question 1

On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers

A. Oracle Cloud B. Microsoft Azure Cloud C. Private Virtual Cloud D. Amazon Web Services

Correct Answer: B,D

Question 2

Which statement best describes Snowflake tables?

A. Snowflake tables ate the physical instantiation of data loaded Into Snowflake B. Snowflake tables are owned by a user C. Snowflake tables are logical representations of underlying physical data D. Snowflake tables require that clustering keys be defined to perform optimally

Correct Answer: C

Question 3

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

A. True B. False

Correct Answer: A

Question 4

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

A. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors B. validation_mode=return_all_errors is a parameter of the copy command C. The validation_mode option is used when creating an Internal Stage D. 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

Correct Answer: B,D

Question 5

Which formats are supported for unloading data from Snowflake? Choose 2 answers

A. JSON B. Avro C. Delimited (CSV, TSV, etc.) D. ORC

Correct Answer: A,C

Question 6

Which of the following statement is true of Snowflake?

A. It was built for Hadoop architecture B. it was built as an on-premises solution and then potted to the cloud C. It was built specifically for the cloud D. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud E. It's based on an Oracle Architecture

Correct Answer: C

Question 7

Which of the following items does the Cloud services Layer manage? Choose 4 answers

A. external blob storage B. user authentication C. Query compilation and optimization D. Data security E. Metadata

Correct Answer: B,C,D,E

Question 8

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

A. Concurrency B. Performance C. Simplicity D. On-premise availability E. Open source based

Correct Answer: A,B,C

Question 9

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

A. True B. False

Correct Answer: A

Question 10

Which interfaces can be used to create and/or manage Virtual Warehouses?

A. The Snowflake Web Interface (UI) B. Data integration tools C. All of the above D. SQL commands

Correct Answer: A,D

Question 11

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

A. Via Virtual Warehouses B. Via the Snowflake Web Interface (Ul) C. Via the data_share=true parameter D. Via SQL commands

Correct Answer: B,D

Snowflake SnowPro Core Certification - COF-C01 Exam Practice Test