Snowflake SnowPro Core COF-C03 - SnowPro Core COF-C03 Exam
Page: 2 / 20
Total 100 questions
Question #6 (Topic: Exam A)
How does Snowflake support storage for external tables?
A. Snowflake automatically replicates and stores all external table data.
B. Snowflake stores the metadata from external tables.
C. Snowflake references external tables using internal directory tables.
D. Snowflake references external tables using internal transient tables.
Answer: B
Question #7 (Topic: Exam A)
Which Snowflake features support the ability to write to a Git repository?
A. Snowsight dashboards and stages
B. Snowpipe and dynamic tables
C. Stored procedures, tasks, and worksheets
D. Streamlit applications, workspaces, and notebooks
Answer: D
Question #8 (Topic: Exam A)
A Snowflake Practitioner is tasked with designing a data lakehouse architecture that requires:
1. Support for ACID transactions to ensure data consistency
2. The ability to evolve schemas over time without rewriting existing data
3. Efficient querying capabilities on large datasets
Which table type meets these requirements?
1. Support for ACID transactions to ensure data consistency
2. The ability to evolve schemas over time without rewriting existing data
3. Efficient querying capabilities on large datasets
Which table type meets these requirements?
A. Permanent
B. Iceberg
C. External
D. Transient
Answer: B
Question #9 (Topic: Exam A)
What is SnowSQL used for?
A. Developing dashboards
B. Loading and unloading data
C. Developing Snowflake Native Apps
D. Monitoring data transformation activity
Answer: B
Question #10 (Topic: Exam A)
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?
A. Only metadata is stored
B. Full storage is duplicated
C. No additional storage is used
D. Only modified data consumes additional storage
Answer: D
