Snowflake SnowPro Certification Study
Guide with Complete Solutions
A cloned database or schema's child objects retain privileges of the source objects (T/F)
- ANSWER-True
A cloned object retains all granted privileges of the source object (T/F) - ANSWER-
False - It doesn't retain any granted privileges
A customer needs to have a preexisting account with AWS or Azure in order to have a
Snowflake account (T/F) - ANSWER-False
A share can only contain one database (T/F) - ANSWER-False - A share can contain
several databases, as long as they are in the same Snowflake account
A user can't be assigned multiple roles (T/F) - ANSWER-False - A user can be assigned
multiple roles
All cache data are cleared if the underlying data changes (T/F) - ANSWER-True
Are Snowflake's Storage (DB) and Compute (WH) layers
A) Separate and Independent
B) Together and Dependent - ANSWER-A) Separate and Independent
Auto-Suspension limits has to be determined when the Virtual Warehouse is configured
(T/F) - ANSWER-False - it can be changed after initial configuration
Can a cached query be run without a Virtual Warehouse running? - ANSWER-Yes - No
compute is used in a query that's cached in the results cache
Can ACCOUNTADMINS view results of other users queries? - ANSWER-No, they can
only see the queries they ran
Can Snowpipes be configured to not automatically ingest data? - ANSWER-Yes, the
auto_ingest parameter must be set to TRUE for data to automatically ingest
Can Transient tables be cloned? - ANSWER-Yes
Can Virtual Warehouses be cloned? - ANSWER-No, they can't
Can you cluster on the combination of multiple columns? - ANSWER-Yes - CLUSTER
BY (column1, column2)
, Can you replicate data to other users who are on a different provider or region than you
(AWS, Azure, GCP)? - ANSWER-Yes
Can you specify time travel requirements when cloning? - ANSWER-Yes, this is done
by suing the AT and BEFORE commands
Clustering Keys improve performance on all queries that filter or sort on that column
(T/F) - ANSWER-True - This includes some joins
Compute can't scale out as queries are running (T/F) - ANSWER-False
Data doesn't have to be staged prior to being loaded (T/F) - ANSWER-False - Data
must be staged prior to loading
Data partitioning is automatically completed in the natural ingestion order (T/F) -
ANSWER-True
Data replication only needs to happen once per cloud/region (T/F) - ANSWER-True -
Once it's been replicated to that cloud/region, it can be shared as many times as
needed
Data Sharing Consumers can consume data residing from any region (T/F) - ANSWER-
False - Consumer accounts must reside in the same Cloud Provider Region as the
Provider account
Data Sharing Consumers must use the ACCOUNTADMIN role to create a database
based on the share (T/F) - ANSWER-True
Does changing the clustering key on a table incur cost? - ANSWER-Yes
Files uploaded to Snowflake Staging Areas aren't automatically encrypted (T/F) -
ANSWER-False - They're automatically encrypted with 128-bit or 256-bit keys
How are storage costs calculated? - ANSWER-A daily average of all compressed data
storage, including data stored according to Time Travel retention policy and failsafe
procedures
How does Snowflake describe their architecture?
A) Multi-Cluster, Shared Data
B) Single-Cluster, Shared Data - ANSWER-A) Multi-Cluster, Shared Data
How does Snowflake optimize storage of semi-structured data? - ANSWER-Repeated
elements within the strings
How far back does the Time Travel protection go? - ANSWER-90 days
Guide with Complete Solutions
A cloned database or schema's child objects retain privileges of the source objects (T/F)
- ANSWER-True
A cloned object retains all granted privileges of the source object (T/F) - ANSWER-
False - It doesn't retain any granted privileges
A customer needs to have a preexisting account with AWS or Azure in order to have a
Snowflake account (T/F) - ANSWER-False
A share can only contain one database (T/F) - ANSWER-False - A share can contain
several databases, as long as they are in the same Snowflake account
A user can't be assigned multiple roles (T/F) - ANSWER-False - A user can be assigned
multiple roles
All cache data are cleared if the underlying data changes (T/F) - ANSWER-True
Are Snowflake's Storage (DB) and Compute (WH) layers
A) Separate and Independent
B) Together and Dependent - ANSWER-A) Separate and Independent
Auto-Suspension limits has to be determined when the Virtual Warehouse is configured
(T/F) - ANSWER-False - it can be changed after initial configuration
Can a cached query be run without a Virtual Warehouse running? - ANSWER-Yes - No
compute is used in a query that's cached in the results cache
Can ACCOUNTADMINS view results of other users queries? - ANSWER-No, they can
only see the queries they ran
Can Snowpipes be configured to not automatically ingest data? - ANSWER-Yes, the
auto_ingest parameter must be set to TRUE for data to automatically ingest
Can Transient tables be cloned? - ANSWER-Yes
Can Virtual Warehouses be cloned? - ANSWER-No, they can't
Can you cluster on the combination of multiple columns? - ANSWER-Yes - CLUSTER
BY (column1, column2)
, Can you replicate data to other users who are on a different provider or region than you
(AWS, Azure, GCP)? - ANSWER-Yes
Can you specify time travel requirements when cloning? - ANSWER-Yes, this is done
by suing the AT and BEFORE commands
Clustering Keys improve performance on all queries that filter or sort on that column
(T/F) - ANSWER-True - This includes some joins
Compute can't scale out as queries are running (T/F) - ANSWER-False
Data doesn't have to be staged prior to being loaded (T/F) - ANSWER-False - Data
must be staged prior to loading
Data partitioning is automatically completed in the natural ingestion order (T/F) -
ANSWER-True
Data replication only needs to happen once per cloud/region (T/F) - ANSWER-True -
Once it's been replicated to that cloud/region, it can be shared as many times as
needed
Data Sharing Consumers can consume data residing from any region (T/F) - ANSWER-
False - Consumer accounts must reside in the same Cloud Provider Region as the
Provider account
Data Sharing Consumers must use the ACCOUNTADMIN role to create a database
based on the share (T/F) - ANSWER-True
Does changing the clustering key on a table incur cost? - ANSWER-Yes
Files uploaded to Snowflake Staging Areas aren't automatically encrypted (T/F) -
ANSWER-False - They're automatically encrypted with 128-bit or 256-bit keys
How are storage costs calculated? - ANSWER-A daily average of all compressed data
storage, including data stored according to Time Travel retention policy and failsafe
procedures
How does Snowflake describe their architecture?
A) Multi-Cluster, Shared Data
B) Single-Cluster, Shared Data - ANSWER-A) Multi-Cluster, Shared Data
How does Snowflake optimize storage of semi-structured data? - ANSWER-Repeated
elements within the strings
How far back does the Time Travel protection go? - ANSWER-90 days
