Snowpro Core Certification Exam – Qs & As
What is the maximum total Continuous Data Protectiond (CDP) charges
incurred for a temporary table? ✔️Ans - 24 hours
When retrieving a query profile, what is a symptom that a query is too large to
fir into the memory? ✔️Ans - When partitions scanned is equal to
partitions total. For efficient pruning, partitions scanned should be a small
fraction of partitions total.
What type of query benefits the MOST from search optimization? ✔️Ans -
Queries that utilize:
1. Equality or IN Predicates
2. Substrings and Regular Expressions
3. Fields in VARIANT Columns
4. Geospatial Functions
5. Conjunctions of Supported Predicates (AND)
6. Disjunctions of Supported Predicates (OR)
What transformations are supported in the CREATE PIPE ... AS COPY `| FROM
(`|) statement ✔️Ans - Columns can be reordered or they can be omitted.
Cast operations are also supported.
docs.snowflake.com/en/sql-reference/sql/create-pipe.html
How does SnowSQL support specifying a default warehouse? ✔️Ans - A
configuration file option and a command line option
T/F: The default virtual warehouse size can be changed at any time. ✔️Ans -
True
Which command should be used to load data from a file, located in external
storage, into a table in Snowflake? ✔️Ans - COPY
The Snowflake Cloud Data Platform is described as having which of the
following architectures? ✔️Ans - Mutli-Clustered Shared Data (A hybrid of
shared disk and shared nothing architectures)
,Protegrity is an example of which type of integration partner? ✔️Ans - Data
Tokenization Integration
What versions of Snowflake should be used to manage compliance with PII
requirements? ✔️Ans - Virtual Private Snowflake or Business Critical
Edition
What are supported file formats for unloading data from snowflake? ✔️Ans
- JSON, Parquet, or any valid delimiter; default is CSV
The Snowflake cloud services layer is respsonsible for which tasks? ✔️Ans -
Authentication, infrastructure management, metadata management, query
parsing and optimization, access control
What is a key feature of the Snowflake architecture for managing user
requests and resource management? ✔️Ans - Multi-cluster warehouses
allow users to run a query that spans across multiple clusters.
The overarching performance challenge with traditional data warehouses
comes down to one thing: resource contention. Single-cluster systems—both
in shared-disk and shared-nothing architectures—require all users in the data
warehouse to share a limited set of resources. Too many concurrent users or
workloads can lead to significant performance degradation and queueing. In
contrast, Snowflake provides a patented multicluster, shared data architecture
and intelligent use of readily available cloud resources to allow essentially
limitless concurrency
T/F: A data provider can only share with other Snowflake customers? ✔️Ans
- True
A Snowflake user wants to share data with suppliers that don't use Snowflake,
what should the user do? ✔️Ans - Deploy a single reader account to be
shared by all of the non-Snowflake suppliers and extract the shared
transactional data to an external stage and use cloud stage utilities to reload
the suppliers regions.
What is a key characteristic of the Snowflake visual query profiler? ✔️Ans -
It provides a graphic representation of main components of the query
processing
, Which command is used to load files into an internal stage with Snowflake?
✔️Ans - PUT
What object type is granted permissions for reading a table? ✔️Ans -
Attribute
What is the default value in the Snowflake Web UI for auto-suspending a
virtual warehouse? ✔️Ans - 10 minutes
If too many users are using the same warehouse and reporting slow run times
and that many queries are getting queued, what is the Snowflake
recommended solution? ✔️Ans - Increase the warehouse
MAX_CLUSTER_COUNT parameter
List three invalid Snowflake data types ✔️Ans - BLOB, CLOB, JSON. JSON is
intended to be stored in VARIANT, OBJECT, and ARRAY data types.
Are queries running on a virtual warehouse affected when the size of a virtual
warehouse is changed? ✔️Ans - No, queries that are running on the current
warehouse configuration are not impacted.
How often are encryption keys automatically rotated by Snowflake? ✔️Ans -
365 Days
As a practice, all custom roles should be granted to which system-defined
role? ✔️Ans - ACCOUNTADMIN
Which Snowflake object can be accessed in the FROM clause of a query,
returning a set of rows having one or more columns? ✔️Ans - A User-
Defined Table Function (UDTF)
How are micro-partitions typically generated in Snowflake? ✔️Ans -
Automatically
What two recommendation does Snowflake make regarding database object
ownership? ✔️Ans - Create objects with ACCOUNTADMIN and do not
reassign ownership and use only managed access schemas for objects owned
by ACCOUNTADMIN
What is the maximum total Continuous Data Protectiond (CDP) charges
incurred for a temporary table? ✔️Ans - 24 hours
When retrieving a query profile, what is a symptom that a query is too large to
fir into the memory? ✔️Ans - When partitions scanned is equal to
partitions total. For efficient pruning, partitions scanned should be a small
fraction of partitions total.
What type of query benefits the MOST from search optimization? ✔️Ans -
Queries that utilize:
1. Equality or IN Predicates
2. Substrings and Regular Expressions
3. Fields in VARIANT Columns
4. Geospatial Functions
5. Conjunctions of Supported Predicates (AND)
6. Disjunctions of Supported Predicates (OR)
What transformations are supported in the CREATE PIPE ... AS COPY `| FROM
(`|) statement ✔️Ans - Columns can be reordered or they can be omitted.
Cast operations are also supported.
docs.snowflake.com/en/sql-reference/sql/create-pipe.html
How does SnowSQL support specifying a default warehouse? ✔️Ans - A
configuration file option and a command line option
T/F: The default virtual warehouse size can be changed at any time. ✔️Ans -
True
Which command should be used to load data from a file, located in external
storage, into a table in Snowflake? ✔️Ans - COPY
The Snowflake Cloud Data Platform is described as having which of the
following architectures? ✔️Ans - Mutli-Clustered Shared Data (A hybrid of
shared disk and shared nothing architectures)
,Protegrity is an example of which type of integration partner? ✔️Ans - Data
Tokenization Integration
What versions of Snowflake should be used to manage compliance with PII
requirements? ✔️Ans - Virtual Private Snowflake or Business Critical
Edition
What are supported file formats for unloading data from snowflake? ✔️Ans
- JSON, Parquet, or any valid delimiter; default is CSV
The Snowflake cloud services layer is respsonsible for which tasks? ✔️Ans -
Authentication, infrastructure management, metadata management, query
parsing and optimization, access control
What is a key feature of the Snowflake architecture for managing user
requests and resource management? ✔️Ans - Multi-cluster warehouses
allow users to run a query that spans across multiple clusters.
The overarching performance challenge with traditional data warehouses
comes down to one thing: resource contention. Single-cluster systems—both
in shared-disk and shared-nothing architectures—require all users in the data
warehouse to share a limited set of resources. Too many concurrent users or
workloads can lead to significant performance degradation and queueing. In
contrast, Snowflake provides a patented multicluster, shared data architecture
and intelligent use of readily available cloud resources to allow essentially
limitless concurrency
T/F: A data provider can only share with other Snowflake customers? ✔️Ans
- True
A Snowflake user wants to share data with suppliers that don't use Snowflake,
what should the user do? ✔️Ans - Deploy a single reader account to be
shared by all of the non-Snowflake suppliers and extract the shared
transactional data to an external stage and use cloud stage utilities to reload
the suppliers regions.
What is a key characteristic of the Snowflake visual query profiler? ✔️Ans -
It provides a graphic representation of main components of the query
processing
, Which command is used to load files into an internal stage with Snowflake?
✔️Ans - PUT
What object type is granted permissions for reading a table? ✔️Ans -
Attribute
What is the default value in the Snowflake Web UI for auto-suspending a
virtual warehouse? ✔️Ans - 10 minutes
If too many users are using the same warehouse and reporting slow run times
and that many queries are getting queued, what is the Snowflake
recommended solution? ✔️Ans - Increase the warehouse
MAX_CLUSTER_COUNT parameter
List three invalid Snowflake data types ✔️Ans - BLOB, CLOB, JSON. JSON is
intended to be stored in VARIANT, OBJECT, and ARRAY data types.
Are queries running on a virtual warehouse affected when the size of a virtual
warehouse is changed? ✔️Ans - No, queries that are running on the current
warehouse configuration are not impacted.
How often are encryption keys automatically rotated by Snowflake? ✔️Ans -
365 Days
As a practice, all custom roles should be granted to which system-defined
role? ✔️Ans - ACCOUNTADMIN
Which Snowflake object can be accessed in the FROM clause of a query,
returning a set of rows having one or more columns? ✔️Ans - A User-
Defined Table Function (UDTF)
How are micro-partitions typically generated in Snowflake? ✔️Ans -
Automatically
What two recommendation does Snowflake make regarding database object
ownership? ✔️Ans - Create objects with ACCOUNTADMIN and do not
reassign ownership and use only managed access schemas for objects owned
by ACCOUNTADMIN
