Snowflake Quiz Questions With 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? - CORRECT
| | | | | | | |
ANSWER✔✔-AWS, Azure, Google Cloud | | |
What is the maximum number of virtual warehouses available for one
| | | | | | | | | | |
account? - CORRECT 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 - CORRECT ANSWER✔✔-Just permanent
| | | | |
On what is the billing for a virtual warehouse based? - CORRECT
| | | | | | | | | | | |
ANSWER✔✔-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 | | |
What happens if you increase the size of a warehouse while queries are
| | | | | | | | | | | | |
running? - CORRECT ANSWER✔✔-The warehouse size is 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? -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-6 minutes | |
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? - CORRECT
| | | | | | | |
ANSWER✔✔-AWS, Azure, Google Cloud | | |
What is the maximum number of virtual warehouses available for one
| | | | | | | | | | |
account? - CORRECT 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 - CORRECT ANSWER✔✔-Just permanent
| | | | |
On what is the billing for a virtual warehouse based? - CORRECT
| | | | | | | | | | | |
ANSWER✔✔-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 | | |
What happens if you increase the size of a warehouse while queries are
| | | | | | | | | | | | |
running? - CORRECT ANSWER✔✔-The warehouse size is 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? -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-6 minutes | |
