- (Topic 3)
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Correct Answer:D
Snowflake uses a technique called pruning to limit the number of micro- partitions scanned by each query. Pruning effectively filters out unnecessary micro- partitions based on the query??s filter conditions, which can significantly improve query performance by reducing the amount of data scanned1.
- (Topic 1)
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?
Correct Answer:D
The command list @mystage; is used to view the list of files that have been uploaded to an internal stage in Snowflake. The list command displays the metadata for all files in the specified stage, which in this case is mystage. This command is particularly useful for verifying that files have been successfully unloaded from a Snowflake table to the stage and for managing the files within the stage.
References:
✑ Snowflake Documentation on Stages
✑ SnowPro® Core Certification Study Guide
- (Topic 4)
What is the purpose of the Snowflake SPLIT TO_TABLE function?
Correct Answer:C
The purpose of the Snowflake SPLIT_TO_TABLE function is to split a string based on a specified delimiter and flatten the results into rows. This table function is useful for transforming a delimited string into a set of rows that can be further processed or queried5.
- (Topic 4)
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Correct Answer:AC
An account administrator in the Data Exchange can perform tasks such as adding and removing members and approving or denying listing approval requests. These tasks are part of managing the Data Exchange and ensuring that only authorized listings and members are part of it12.
- (Topic 2)
A virtual warehouse is created using the following command:
Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60 auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
Correct Answer:C
The graphical representation of warehouse utilization indicates periods of significant queuing, suggesting that the current single cluster cannot efficiently handle all incoming queries. Configuring the warehouse to a multi-cluster warehouse will distribute the load among multiple clusters, reducing queuing times and improving overall performance1.
References = Snowflake Documentation on Multi-cluster Warehouses1