SnowPro® Core Certification (COF-C03) (COF-C03) Free Practice Test

Question 1

What column type does a Kafka connector store formatted information in a single column?

A. VARCHAR

B. ARRAY

C. VARIANT

D. OBJECT

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)

A. VARCHAR

B. VARIANT

C. INTEGER

D. OBJECT

E. LIST

Correct Answer: B,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

A. The clone has better query performance.

B. The clone saves space by not duplicating storage.

C. The clone is created almost instantly.

D. The clone always stays in sync with the original table.

E. The clone will have time travel history from the original table.

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

What privilege should a user be granted to change permissions for new objects in a managed access schema?

A. Grant the MANAGE GRANTS global privilege.

B. Grant ALL privileges on the schema.

C. Grant the OWNERSHIP privilege on the schema.

D. Grant the OWNERSHIP privilege on the database.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

What does the Remote Disk I/O statistic in the Query Profile indicate?

A. The level of network activity between the Cloud Services layer and the virtual warehouse.

B. Time when the query processing was blocked by remote disk access.

C. Time spent reading from the result cache.

D. Time spent reading from the virtual warehouse cache.

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

What affects whether the query results cache can be used?

A. If multiple users are using the same virtual warehouse

B. If the referenced data in the table has changed

C. If the virtual warehouse has been suspended

D. If the query contains a deterministic function

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).

A. GO driver

B. Python connector

C. ODBC driver

D. Node.js driver

E. Spark connector

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

Which stage type can be altered and dropped?

A. Table stage

B. User stage

C. External stage

D. Database stage

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

Which Snowflake data governance feature supports resource usage monitoring?

A. Object tagging

B. Data classification

C. Access history

D. Column lineage

Correct Answer: A

Question 10

Which Snowflake object contains all the information required to share a database?

A. Secure view

B. Share

C. Sequence

D. Private listing

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Snowflake SnowPro® Core Certification (COF-C03) (COF-C03) Free Practice Test