- All Exams Instant Download
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.A . True B. FalseView AnswerAnswer: A Explanation: Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.
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...
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?A . The tables are now orphaned B. The user that deleted the role C. SYSADMIN D. The assumed role that dropped the roleView AnswerAnswer: A Explanation: When a role is...
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.A . True B. FalseView AnswerAnswer: B
Will data cached in a warehouse be lost when the warehouse is resized?
Will data cached in a warehouse be lost when the warehouse is resized?A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits. B. Yes. because the compute resource is replaced in its entirety with a new compute resource. C. No. because the...
True or False: Data Providers can share data with only the Data Consumer.
True or False: Data Providers can share data with only the Data Consumer.A . True B. FalseView AnswerAnswer: B
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? Select one.A . More micro-partitions B. Better query scheduling C. Double the numbers of servers In the compute duster D. Higher storage costsView AnswerAnswer: C
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/
Which Snowflake technique can be used to improve the performance of a query?
Which Snowflake technique can be used to improve the performance of a query?A . Clustering B. Indexing C. Fragmenting D. Using INDEX__HINTSView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
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
