SnowPro Core Exam Study Guide-
Questions with All Correct Answers
Which groups of SQL statements will run successfully in the Web UI? (Choose 2)
-CREATE INDEX and DROP INDEX
-CREATE USER, ALTER USER and DROP USER
-CREATE TABLESPACE, ALTER TABLESPACE and DROP TABLESPACE
-CREATE LOGFILE GROUP, ALTER LOGFILE GROUP and DROP LOGFILE GROUP
-CREATE SERVER, ALTER SERVER and DROP SERVER
-CREATE WAREHOUSE, ALTER WAREHOUSE and DROP WAREHOUSE
correct - ANSWER - CREATE USER, ALTER USER and DROP USER
CREATE WAREHOUSE, ALTER WAREHOUSE, and DROP WAREHOUSE
In what infrastructures will Snowflake operate?
-AWS, Azure, Rackspace on premise private cloud
-Adobe, IBM Cloud, SalesForce Cloud services
-AWS, Azure, Google Cloud
-Azure, SAP Cloud Services, Rackspace on premise private cloud
-AWS, Azure - ANSWER - AWS, Azure, Google Cloud
What is the maximum number of virtual warehouses available for one account?
200
1000
5000
10,000
Unlimited - ANSWER - Unlimited
If there was a requirement to provide 1 week recovery on a table, which types of table(s) would
provide this feature?
,-Permanent and transient tables
-Permanent, transient and temporary
-Transient and temporary
-External and permanent
-Just permanent - ANSWER - just permanent
On what is the billing for a virtual warehouse based?
-The time the virtual warehouse is running a query calculated by the second, with a minimum of
60 seconds
-The number of seconds the virtual warehouse is running multiplied by the number of virtual
servers in the cluster with a minimum of 60 seconds
-The number of query tasks running on the virtual warehouse multiplied by the number of
seconds with a minimum of 60 seconds
-The average number of virtual servers used by query tasks per minute
-The number of virtual servers used during a query multiplied by the number of seconds, with a
minimum of 60 seconds - ANSWER - The number of seconds the virtual warehouse is running
multiplied by the number of virtual servers in the cluster within a minimum of 60 seconds
What happens if you increase the size of a warehouse while queries are running?
-The query is paused, the virtual warehouse is resized and the query is restarted.
-The query is canceled, the virtual warehouse is resized and the query is started from the
beginning.
-If the virtual warehouse size is increased, the query continues running in the current virtual
servers while the warehouse adds the additional virtual servers. If the virtual warehouse size is
decreased, the query tasks are moved to what will be the remaining virtual servers and the
other servers are removed from the virtual warehouses.
-The warehouse size is increased immediately, but any currently-running queries will keep
running at the old size until they complete.
-The virtual warehouse cancels the current query and stops the virtual warehouse, once the
virtual warehouse is stopped, it is resized and restarted. After it has restarted, the query is res -
ANSWER - the warehouse size increased immediately, but any currently-running queries will
keep running at the old size until they complete
, If a multi-cluster warehouse is using an economy scaling policy, the system will wait to start
another cluster until it estimates that there is enough query load to keep the warehouse busy for
how long?
-2 minutes
-4 minutes
-6 minutes
-8 minutes
-It will start the next cluster as soon as the queue starts backing up - ANSWER - 6 minutes
-Yes - ANSWER - no, auto-ingest is designed to work only with EXTERNAL stages
True/False: Snowflake has a default file format if none is explicitly set or declared in SQL syntax
- ANSWER - True
True/False: The recommended file size range for data loading is different for bulk versus
Snowpipe data loads - ANSWER - False
True/False: Semi-structured data must be transformed prior to loading the data into a Snowflake
table - ANSWER - False
What is the benefit of a warehouse using an economy scaling policy?
-Clusters will stop immediately when no longer needed and stop using credits.
-It keeps the running clusters busier and it does not start a new cluster immediately when a
query is queued, in case the queuing is an anomaly rather than the start of an upward usage
trend.
-The multi-cluster will start all clusters whenever a query is submitted to provide maximum
resources to reduce the queue as fast as possible and then shut down.
-The number of credits is based on the number of virtual servers needed to run a query and idle
virtual servers are not charged.
-It matches the size of the cluster to the query when it starts a new cluster. - ANSWER - it keeps
the running clusters busier and it does not start a new cluster immediately when a query is
queued, in case the queuing is an anomaly rather than the start of an upward usage trend
A year-old database has DATA_RETENTION_TIME_IN_DAYS set to 90 days. The
DATA_RETENTION_TIME_IN_DAYS is reset to 30 days. What happens to the data stored in
time travel older than 30 days for this database?
Questions with All Correct Answers
Which groups of SQL statements will run successfully in the Web UI? (Choose 2)
-CREATE INDEX and DROP INDEX
-CREATE USER, ALTER USER and DROP USER
-CREATE TABLESPACE, ALTER TABLESPACE and DROP TABLESPACE
-CREATE LOGFILE GROUP, ALTER LOGFILE GROUP and DROP LOGFILE GROUP
-CREATE SERVER, ALTER SERVER and DROP SERVER
-CREATE WAREHOUSE, ALTER WAREHOUSE and DROP WAREHOUSE
correct - ANSWER - CREATE USER, ALTER USER and DROP USER
CREATE WAREHOUSE, ALTER WAREHOUSE, and DROP WAREHOUSE
In what infrastructures will Snowflake operate?
-AWS, Azure, Rackspace on premise private cloud
-Adobe, IBM Cloud, SalesForce Cloud services
-AWS, Azure, Google Cloud
-Azure, SAP Cloud Services, Rackspace on premise private cloud
-AWS, Azure - ANSWER - AWS, Azure, Google Cloud
What is the maximum number of virtual warehouses available for one account?
200
1000
5000
10,000
Unlimited - ANSWER - Unlimited
If there was a requirement to provide 1 week recovery on a table, which types of table(s) would
provide this feature?
,-Permanent and transient tables
-Permanent, transient and temporary
-Transient and temporary
-External and permanent
-Just permanent - ANSWER - just permanent
On what is the billing for a virtual warehouse based?
-The time the virtual warehouse is running a query calculated by the second, with a minimum of
60 seconds
-The number of seconds the virtual warehouse is running multiplied by the number of virtual
servers in the cluster with a minimum of 60 seconds
-The number of query tasks running on the virtual warehouse multiplied by the number of
seconds with a minimum of 60 seconds
-The average number of virtual servers used by query tasks per minute
-The number of virtual servers used during a query multiplied by the number of seconds, with a
minimum of 60 seconds - ANSWER - The number of seconds the virtual warehouse is running
multiplied by the number of virtual servers in the cluster within a minimum of 60 seconds
What happens if you increase the size of a warehouse while queries are running?
-The query is paused, the virtual warehouse is resized and the query is restarted.
-The query is canceled, the virtual warehouse is resized and the query is started from the
beginning.
-If the virtual warehouse size is increased, the query continues running in the current virtual
servers while the warehouse adds the additional virtual servers. If the virtual warehouse size is
decreased, the query tasks are moved to what will be the remaining virtual servers and the
other servers are removed from the virtual warehouses.
-The warehouse size is increased immediately, but any currently-running queries will keep
running at the old size until they complete.
-The virtual warehouse cancels the current query and stops the virtual warehouse, once the
virtual warehouse is stopped, it is resized and restarted. After it has restarted, the query is res -
ANSWER - the warehouse size increased immediately, but any currently-running queries will
keep running at the old size until they complete
, If a multi-cluster warehouse is using an economy scaling policy, the system will wait to start
another cluster until it estimates that there is enough query load to keep the warehouse busy for
how long?
-2 minutes
-4 minutes
-6 minutes
-8 minutes
-It will start the next cluster as soon as the queue starts backing up - ANSWER - 6 minutes
-Yes - ANSWER - no, auto-ingest is designed to work only with EXTERNAL stages
True/False: Snowflake has a default file format if none is explicitly set or declared in SQL syntax
- ANSWER - True
True/False: The recommended file size range for data loading is different for bulk versus
Snowpipe data loads - ANSWER - False
True/False: Semi-structured data must be transformed prior to loading the data into a Snowflake
table - ANSWER - False
What is the benefit of a warehouse using an economy scaling policy?
-Clusters will stop immediately when no longer needed and stop using credits.
-It keeps the running clusters busier and it does not start a new cluster immediately when a
query is queued, in case the queuing is an anomaly rather than the start of an upward usage
trend.
-The multi-cluster will start all clusters whenever a query is submitted to provide maximum
resources to reduce the queue as fast as possible and then shut down.
-The number of credits is based on the number of virtual servers needed to run a query and idle
virtual servers are not charged.
-It matches the size of the cluster to the query when it starts a new cluster. - ANSWER - it keeps
the running clusters busier and it does not start a new cluster immediately when a query is
queued, in case the queuing is an anomaly rather than the start of an upward usage trend
A year-old database has DATA_RETENTION_TIME_IN_DAYS set to 90 days. The
DATA_RETENTION_TIME_IN_DAYS is reset to 30 days. What happens to the data stored in
time travel older than 30 days for this database?
