- All Exams Instant Download
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?A . The primary cluster in the virtual warehouse B. The entire virtual warehouse C. The database in which the virtual warehouse resides D. The Queries currently being run on the virtual warehouseView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual% 20clusters%20in%20the%20warehouse.
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)A . Growth of storage and compute are tightly coupled together B. Storage expands without the requirement to add more compute C. Compute can be scaled up or down without the requirement...
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 commands C. Data integration tools D. All of the aboveView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?A . Standard B. Premier C. Enterprise D. Business Critical EditionView AnswerAnswer: C Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
In which use cases does Snowflake apply egress charges?
In which use cases does Snowflake apply egress charges?A . Data sharing within a specific region B. Query result retrieval C. Database replication D. Loading data into SnowflakeView AnswerAnswer: A Explanation: Cloud providers apply data egress charges in either of the following use cases: ✑ Data is transferred from one...
True or False: It is possible to load data into Snowflake without creating a named File Format object.
True or False: It is possible to load data into Snowflake without creating a named File Format object.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html
The PUT command: (Choose two.)
The PUT command: (Choose two.)A . Automatically creates a File Format object B. Automatically uses the last Stage created C. Automatically compresses files using Gzip D. Automatically encrypts filesView AnswerAnswer: C,D Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html
What feature can be used to reorganize a very large table on one or more columns?
What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitions B. Clustering keys C. Key partitions D. Clustered partitionsView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
Which command can be used to load data into an internal stage?
Which command can be used to load data into an internal stage?A . LOAD B. copy C. GET D. PUTView AnswerAnswer: D Explanation: https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9
