SnowPro® Core Certification
(COF-C03) Practice Exam
Questions And Correct Answers
(Verified Answers) Plus
Rationales 2026 Q&A | Instant
Download Pdf.
Question: 1
What is the default file size when unloading data from
Snowflake using the COPY command?
A. 5 MB
B. 8 GB
C. 16 MB
D. 32 MB
Answer: C
Explanation:
,The default file size when unloading data from Snowflake
using the COPY command is not explicitly stated in the
provided resources. However, Snowflake documentation
suggests that the file size can be specified using the
MAX_FILE_SIZE option in the COPY INTO <location>
command2.
Question: 2
What features that are part of the Continuous Data Protection
(CDP) feature set in Snowflake do not require additional
configuration? (Choose two.)
A. Row level access policies
B. Data masking policies
C. Data encryption
D. Time Travel
E. External tokenization
Answer: C, D
Explanation:
Data encryption and Time Travel are part of Snowflake’s
Continuous Data Protection (CDP) feature set that do not
require additional configuration. Data encryption is
automatically applied to all files stored on internal stages, and
Time Travel allows for querying and restoring data without any
extra setup
, Question: 3
Which Snowflake layer is always leveraged when accessing a
query from the result cache?
A. Metadata
B. Data Storage
C. Compute
D. Cloud Services
Answer: D
Explanation:
The Cloud Services layer in Snowflake is responsible for
managing the result cache. When a query is executed, the
results are stored in this cache, and subsequent identical
queries can leverage these cached results without re-executing
the entire query1.
Question: 4
A Snowflake Administrator needs to ensure that sensitive
corporate data in Snowflake tables is not visible to end users,
but is partially visible to functional managers. How can this
requirement be met?
A. Use data encryption.
B. Use dynamic data masking.
C. Use secure materialized views.
D. Revoke all roles for functional managers and end users.
(COF-C03) Practice Exam
Questions And Correct Answers
(Verified Answers) Plus
Rationales 2026 Q&A | Instant
Download Pdf.
Question: 1
What is the default file size when unloading data from
Snowflake using the COPY command?
A. 5 MB
B. 8 GB
C. 16 MB
D. 32 MB
Answer: C
Explanation:
,The default file size when unloading data from Snowflake
using the COPY command is not explicitly stated in the
provided resources. However, Snowflake documentation
suggests that the file size can be specified using the
MAX_FILE_SIZE option in the COPY INTO <location>
command2.
Question: 2
What features that are part of the Continuous Data Protection
(CDP) feature set in Snowflake do not require additional
configuration? (Choose two.)
A. Row level access policies
B. Data masking policies
C. Data encryption
D. Time Travel
E. External tokenization
Answer: C, D
Explanation:
Data encryption and Time Travel are part of Snowflake’s
Continuous Data Protection (CDP) feature set that do not
require additional configuration. Data encryption is
automatically applied to all files stored on internal stages, and
Time Travel allows for querying and restoring data without any
extra setup
, Question: 3
Which Snowflake layer is always leveraged when accessing a
query from the result cache?
A. Metadata
B. Data Storage
C. Compute
D. Cloud Services
Answer: D
Explanation:
The Cloud Services layer in Snowflake is responsible for
managing the result cache. When a query is executed, the
results are stored in this cache, and subsequent identical
queries can leverage these cached results without re-executing
the entire query1.
Question: 4
A Snowflake Administrator needs to ensure that sensitive
corporate data in Snowflake tables is not visible to end users,
but is partially visible to functional managers. How can this
requirement be met?
A. Use data encryption.
B. Use dynamic data masking.
C. Use secure materialized views.
D. Revoke all roles for functional managers and end users.
