Snowflake SnowPro Core Certification; Questions with
Solutions(A+)
True or False? Metadata is created when you load data from a file in an internal stage to a
Snowflake table. Correct Ans-True
True or False? Are Snowpipe charges calculated per second and per core? Correct Ans-True
What types of views are available in Snowflake? Correct Ans-Regular, secure and
materialized
What character identifies a table stage? Correct Ans-@%
What are the types of internal stages? Correct Ans-User, table, internal named
What character identifies a user stage? Correct Ans-@~
What is the difference between an internal stage and an external stage? Correct Ans-
Internal stages store the data directly within Snowflake. External stages store files in an
external o
, Snowflake SnowPro Core Certification; Questions with
Solutions(A+)
What do you use to share data with another Snowflake customer? Correct Ans-Direct
share
What type of account do you use to share with others who are not Snowflake customers?
Correct Ans-Reader account
True or False? If a warehouse is on but not being used, you are still charged for that hour.
Correct Ans-True
True or False? If you resize a warehouse while a query is running, the query will finish with
the original Warehouse size. Correct Ans-True
Sizing a Warehouse up an down allows for
A) More complex queries
B) More queries Correct Ans-More ecomplex queries
What is the default auto suspend time for a warehouse? Correct Ans-10 Minutes
, Snowflake SnowPro Core Certification; Questions with
Solutions(A+)
How many days of time travel come with the standard edition? Correct Ans-1 day
How many days of time travel come with the enterprise edition? Correct Ans-90 days
What features are only available with the business critical edition? Correct Ans-HIPPA
support,
PCI compliance,
Database failover and failback
What features are available in the enterprise edition that are not available in the standard
edition? Correct Ans-Multi-cluster warehouse,
Annual rekeying of encrypted data,
Dynamic data masking
External data tokenization
How much does on demand storage cost per TB and month? Correct Ans-$40
Solutions(A+)
True or False? Metadata is created when you load data from a file in an internal stage to a
Snowflake table. Correct Ans-True
True or False? Are Snowpipe charges calculated per second and per core? Correct Ans-True
What types of views are available in Snowflake? Correct Ans-Regular, secure and
materialized
What character identifies a table stage? Correct Ans-@%
What are the types of internal stages? Correct Ans-User, table, internal named
What character identifies a user stage? Correct Ans-@~
What is the difference between an internal stage and an external stage? Correct Ans-
Internal stages store the data directly within Snowflake. External stages store files in an
external o
, Snowflake SnowPro Core Certification; Questions with
Solutions(A+)
What do you use to share data with another Snowflake customer? Correct Ans-Direct
share
What type of account do you use to share with others who are not Snowflake customers?
Correct Ans-Reader account
True or False? If a warehouse is on but not being used, you are still charged for that hour.
Correct Ans-True
True or False? If you resize a warehouse while a query is running, the query will finish with
the original Warehouse size. Correct Ans-True
Sizing a Warehouse up an down allows for
A) More complex queries
B) More queries Correct Ans-More ecomplex queries
What is the default auto suspend time for a warehouse? Correct Ans-10 Minutes
, Snowflake SnowPro Core Certification; Questions with
Solutions(A+)
How many days of time travel come with the standard edition? Correct Ans-1 day
How many days of time travel come with the enterprise edition? Correct Ans-90 days
What features are only available with the business critical edition? Correct Ans-HIPPA
support,
PCI compliance,
Database failover and failback
What features are available in the enterprise edition that are not available in the standard
edition? Correct Ans-Multi-cluster warehouse,
Annual rekeying of encrypted data,
Dynamic data masking
External data tokenization
How much does on demand storage cost per TB and month? Correct Ans-$40
