- All Exams Instant Download
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 of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).A . The table contains a column that has very low cardinality B. DML statements that are being issued against the table are blocked C. The table has a small number...
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html
According to recommended best practice, what should be done to reduce the Queue volume?
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).A . Use multi-clustered warehousing to scale out...
Which cache type is used to cache data output from SQL queries?
Which cache type is used to cache data output from SQL queries?A . Metadata cache B. Result cache C. Remote cache D. Local file cacheView AnswerAnswer: B Explanation: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
Which cache type is used to cache data output from SQL queries?
Which cache type is used to cache data output from SQL queries?A . Metadata cache B. Result cache C. Remote cache D. Local file cacheView AnswerAnswer: B Explanation: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
Which of the following describes how clustering keys work in Snowflake?
Which of the following describes how clustering keys work in Snowflake?A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations. B. Clustering keys sort the designated columns over time, without blocking DML operations C. Clustering keys create a distributed, parallel data structure...
True or False: A Virtual Warehouse can be resized while suspended.
True or False: A Virtual Warehouse can be resized while suspended.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse
What data is stored in the Snowflake storage layer? (Select TWO).
What data is stored in the Snowflake storage layer? (Select TWO).A . Snowflake parameters B. Micro-partitions C. Query history D. Persisted query results E. Standard and secure view resultsView AnswerAnswer: B,D
Which of the following are benefits of micro-partitioning? (Select TWO)
Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of values B. Micro-partitions are immutable objects that support the use of Time Travel. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses D. Rows are automatically stored...
