SnowPro Core Certification Exam (COF-C01) Free Practice Test

Question 1

Which statement best describes Snowflake tables?

A. Snowflake tables are owned by a user

B. Snowflake tables require that clustering keys be defined to perform optimally

C. Snowflake tables ate the physical instantiation of data loaded Into Snowflake

D. Snowflake tables are logical representations of underlying physical data

Correct Answer: D

Question 2

Which item in the Data Warehouse migration process does not apply in Snowflake>

A. Migrate Schemas

B. Migrate Users

C. Migrate Indexes

D. Build the Data pipeline

Correct Answer: C

Question 3

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

A. On-premise availability

B. Concurrency

C. Open source based

D. Performance

E. Simplicity

Correct Answer: B,D,E

Question 4

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

A. Concurrency

B. Performance

Correct Answer: B

Question 5

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

A. False

B. True

Correct Answer: A

Question 6

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

A. SYSADMIN

B. The user that deleted the role

C. The tables are now orphaned

D. The assumed role that dropped the role

Correct Answer: D

Question 7

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A. Standard

B. Economy

C. Custom

D. Optimized

Correct Answer: A,B

Question 8

True or False: Fail-safe can be disabled within a Snowflake account.

A. False

B. True

Correct Answer: A

Question 9

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

A. They should use the SYSADMIN role to perform administrative work on database objects

B. Their default role should be set to SYSTEMADMIN (the lower of the two)

C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

D. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

E. They should not set up multi_Factor Authentication (MFA)-as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so

Correct Answer: A,B,C

Question 10

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

A. To accommodate more users

B. To accommodate more queries

C. To accommodate fluctuations in workload

D. To accommodate a more complex workload

Correct Answer: D

Question 11

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

A. SUM(<< column value >>)

B. COPY

C. UPDATE

D. MIN(< < column value>>)

Correct Answer: A,B,C

Question 12

What is the most granular object that the Time Travel retention period can be defined on?

A. Table

B. Database

C. Schema

D. Account

Correct Answer: A

Question 13

True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

A. False

B. True

Correct Answer: A

Question 14

Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

A. Worksheets

B. Warehouses

C. Database

D. Tables

Correct Answer: A,B,C

Welcome to TestSimulate

Snowflake SnowPro Core Certification (COF-C01) Free Practice Test