Snowflake SnowPro Core Certification - COF-C01 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What is the default File Format used in the COPY command if one is not specified?

A. JSON B. Parquet C. XML

Discussion 0

Correct Answer: A Vote an answer

Question 2

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

A. MERGE B. UPSERT C. TRUNCATE TABLE D. UPDATE

Discussion 0

Correct Answer: B Vote an answer

Question 3

True or False: You can query the files in an External Stage directly without having to load the data into a table.

A. True B. False

Discussion 0

Correct Answer: A Vote an answer

Question 4

When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

A. Concurrency B. Performance

Discussion 0

Correct Answer: B Vote an answer

Question 5

A deterministic query is run at 8am, takes 5 minutes, and the results are cached .
Which of the following statements are true? Choose 2 answers

A. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period B. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed C. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period D. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous

Discussion 0

Correct Answer: A,D Vote an answer

Question 6

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.

A. True B. False

Discussion 0

Correct Answer: A Vote an answer

Question 7

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

A. The user that deleted the role B. The tables are now orphaned C. The assumed role that dropped the role D. SYSADMIN

Discussion 0

Correct Answer: C Vote an answer

Question 8

Which of the following commands are not blocking operations?
Choose 2 answers

A. MERGE B. COPY C. UPDATE D. INSERT

Discussion 0

Correct Answer: B,D Vote an answer

Question 9

True or False: Snowflake supports federated authentication in all editions.

A. True B. False

Discussion 0

Correct Answer: A Vote an answer

Question 10

True or False: The COPY command must specify a File Format in order to execute.

A. True B. False

Discussion 0

Correct Answer: B Vote an answer

Question 11

What is the recommended method for loading data into Snowflake?

A. Load row by row B. Load data via frequent, angle row DML's C. Load data in batch D. Load data by writing it In the Snowflake Web Interface (UI)

Discussion 0

Correct Answer: C Vote an answer

Question 12

Select the different types of Internal Stages: (Choose three.)

A. User Stage B. Named Stage C. Table Stage D. Schema Stage

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 13

Which of the following statements is true of Snowflake?

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

Discussion 0

Correct Answer: C Vote an answer

Question 14

Which statement best describes Snowflake tables?

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

Discussion 0

Correct Answer: A Vote an answer

Question 15

Which of the following commands sets the Virtual Warehouse for a session?

A. COPT WAREHOUSE FROM <<Config file> ; B. USE VIRTUAL_WAREHOUSE <<warehouse name>>; C. USE WAREHOUSE <<warehouse name>>; D. SET warehouse = <<warehouse name>>;

Discussion 0

Correct Answer: C Vote an answer