SnowPro Core Exam Study Guide- Questions and 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 correct answers 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 correct answers AWS, Azure, Google Cloud What is the maximum number of virtual warehouses available for one account? 200 1000 5000 10,000 Unlimited correct answers 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 answers 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 correct answers 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