- (Topic 6)
Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?

1. A. TASK_HISTORY
2. B. TASK_DEPENDENTS
3. C. CURRENT_TASK_GRAPHS
4. D. COMPLETE_TASK_GRAPHS

Correct Answer: C
TheCURRENT_TASK_GRAPHStable function is designed to provide information on Directed Acyclic Graphs (DAGs) that are currently scheduled or executing within Snowflake. This function offers insights into the structure and status of task chains, enabling users to monitor and troubleshoot task executions. DAGs in Snowflake represent sequences of tasks with dependencies, and understanding their current state is crucial for managing complex workflows.References:Snowflake Documentation on Task Management

- (Topic 6)
When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? {Select TWO).

1. A. echo
2. B. quiet
3. C. output_file
4. D. output_format
5. E. force_put_overwrite

Correct Answer: CD
When unloading data from SnowSQL (Snowflake's command-line client), to a file on a local machine, you need to specify certain configuration options to determine how and where the data should be outputted. The correct configuration options required are:
✑ C. output_file: This configuration option specifies the file path where the output from the query should be stored. It is essential for directing the results of your SQL query into a local file, rather than just displaying it on the screen.
✑ D. output_format: This option determines the format of the output file (e.g., CSV, JSON, etc.). It is crucial for ensuring that the data is unloaded in a structured format that meets the requirements of downstream processes or systems.
These options are specified in the SnowSQL configuration file or directly in the SnowSQL command line. The configuration file allows users to set defaults and customize their usage of SnowSQL, including output preferences for unloading data.
References:
✑ Snowflake Documentation: SnowSQL (CLI Client) at Snowflake Documentation
✑ Snowflake Documentation: Configuring SnowSQL at Snowflake Documentation

- (Topic 5)
The effects of query pruning can be observed by evaluating which statistics? (Select TWO).

1. A. Partitions scanned
2. B. Partitions total
3. C. Bytes scanned
4. D. Bytes read from result
5. E. Bytes written

Correct Answer: AC
Query pruning in Snowflake refers to the optimization technique where the system reduces the amount of data scanned by a query based on the query conditions. This typically involves skipping unnecessary data partitions that do not contribute to the query result. The effectiveness of this technique can be observed through:
✑ Option A: Partitions scanned. This statistic indicates how many data partitions were actually scanned as a result of query pruning, showing the optimization in action.
✑ Option C: Bytes scanned. This measures the volume of data physically read during query execution, and a reduction in this number indicates effective query pruning, as fewer bytes are read when unnecessary partitions are skipped.
Options B, D, and E do not directly relate to observing the effects of query pruning. "Partitions total" shows the total available, not the impact of pruning, while "Bytes read from result" and "Bytes written" relate to output rather than the efficiency of data scanning. References:Snowflake documentation on performance tuning and query optimization techniques, specifically how query pruning affects data access.

- (Topic 3)
How would a user run a multi-cluster warehouse in maximized mode?

1. A. Configure the maximum clusters setting to "Maximum."
2. B. Turn on the additional clusters manually after starting the warehouse.
3. C. Set the minimum Clusters and maximum Clusters settings to the same value.
4. D. Set the minimum clusters and maximum clusters settings to different values.

Correct Answer: C
To run a multi-cluster warehouse in maximized mode, a user should set the minimum and maximum number of clusters to the same value. This ensures that all clusters are available when thewarehouse is started, providing maximum resources for query execution. References: Snowflake Documentation2.

- (Topic 4)
Which object can be used with Secure Data Sharing?

1. A. View
2. B. Materialized view
3. C. External table
4. D. User-Defined Function (UDF)

Correct Answer: A
Views can be used with Secure Data Sharing in Snowflake. Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.