- All Exams Instant Download
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.A . TrueB . FalseView AnswerAnswer: B
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?A . 1 HourB . 3 HoursC . 12 hoursD . 24 hoursView AnswerAnswer: D Explanation: Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
What is the minimum duration charged when starting a virtual warehouse?
What is the minimum duration charged when starting a virtual warehouse?A . 1 secondB . 1 minuteC . 1 hourD . 1 dayView AnswerAnswer: B
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answersA . Amazon Web ServicesB . Private Virtual CloudC . Oracle CloudD . Microsoft Azure CloudView AnswerAnswer: A,D
What is the MOST performant file format for loading data in Snowflake?
What is the MOST performant file format for loading data in Snowflake?A . CSV (Unzipped)B . ParquetC . CSV (Gzipped)D . ORCView AnswerAnswer: A
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)A . Data can be filtered by an optional where clauseB . Incoming data can be joined with other tablesC . Columns can be reorderedD . Columns can be omittedE . Row level access...
What SQL command would be used to view all roles that were granted to user.1?
What SQL command would be used to view all roles that were granted to user.1?A . show grants to user USER1;B . show grants of user USER1;C . describe user USER1;D . show grants on user USER1;View AnswerAnswer: A
Which interfaces can be used to create and/or manage Virtual Warehouses?
Which interfaces can be used to create and/or manage Virtual Warehouses?A . The Snowflake Web Interface (UI)B . SQL commandsC . Data integration toolsD . All of the aboveView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
What Snowflake role must be granted for a user to create and manage accounts?
What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMINB . ORGADMINC . SECURITYADMIND . SYSADMINView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
