Snowflake SnowPro Core Certification (SNOWPRO-CORE) - Snowflake Actual Exam Questions
Last updated on May 14, 2026
Which of the following can be used when unloading data from Snowflake? (Choose two.)
When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
Use the ENCODING file format option to change the encoding from the default UTF-8.
The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
How long can a data consumer who has a pre-signed URL access data files using Snowflake?
Indefinitely
Until the result_cache expires
Until the retention_time is met
Until the expiration time is exceeded
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
What does the LATERAL modifier for the FLATTEN function do?
Casts the values of the flattened data
Extracts the path of the flattened data
Joins information outside the object with the flattened data
Retrieves a single instance of a repeating element in the flattened data
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?
No virtual warehouse will be used, data will be read from the result cache.
No virtual warehouse will be used, data will be read from the local disk cache.
The default virtual warehouse will be used to read all data.
The virtual warehouse that is defined at the session level will be used to read all data.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Views
Materialized views
Tables
External tables
Future grants
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.