SnowPro Core COF-C03

SnowPro Core COF-C03 practice questions, page 2 of 5, with answer review and explanations.

Question 6

How does Snowflake support storage for external tables?

  1. Snowflake automatically replicates and stores all external table data.
  2. Snowflake stores the metadata from external tables.
  3. Snowflake references external tables using internal directory tables.
  4. Snowflake references external tables using internal transient tables.

Question 7

Which Snowflake features support the ability to write to a Git repository?

  1. Snowsight dashboards and stages
  2. Snowpipe and dynamic tables
  3. Stored procedures, tasks, and worksheets
  4. Streamlit applications, workspaces, and notebooks

Question 8

A Snowflake Practitioner is tasked with designing a data lakehouse architecture that requires:1. Support for ACID transactions to ensure data consistency2. The ability to evolve schemas over time without rewriting existing data3. Efficient querying capabilities on large datasetsWhich table type meets these requirements?

  1. Permanent
  2. Iceberg
  3. External
  4. Transient

Question 9

What is SnowSQL used for?

  1. Developing dashboards
  2. Loading and unloading data
  3. Developing Snowflake Native Apps
  4. Monitoring data transformation activity

Question 10

What is the impact on storage when a user clones a 1 TB sized table and updates 10% of the rows in the cloned table?

  1. Only metadata is stored
  2. Full storage is duplicated
  3. No additional storage is used
  4. Only modified data consumes additional storage