Which JSON paths are considered to be equivalent in Snowflake? (Choose two.)
Correct Answer: D,E
Question 97
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Correct Answer: C
Micro-partitioning is a Snowflake function that is maintained separately from the data and supports features such as Time Travel, Secure Data Sharing, and pruning.It allows Snowflake to efficiently manage and query large datasets by organizing them into micro-partitions1.
Question 98
Which statement describes Snowflake tables?
Correct Answer: A
In Snowflake, tables represent a logical structure through which users interact with the stored data. The actual physical data is stored in micro-partitions managed by Snowflake, and the logical table structure provides the means by which SQL operations are mapped to this data. This architecture allows Snowflake to optimize storage and querying across its distributed, cloud-based data storage system. References: Snowflake Documentation on Tables
Question 99
Using which feature or object will temporarily scale virtual warehouses running costly queries?
Correct Answer: C
The correct answer is C. Query acceleration service . The Query Acceleration Service is a Snowflake performance optimization feature that can temporarily provide additional compute resources to accelerate eligible queries. It is designed for queries that scan large amounts of data and would otherwise take longer or consume significant warehouse resources. Why C is correct: The Query Acceleration Service can offload portions of query processing to shared compute resources provided by Snowflake. This helps speed up expensive or long-running queries without permanently resizing the virtual warehouse. Why the other options are incorrect: A). Resource monitor controls and monitors credit usage. It can suspend warehouses or send alerts, but it does not scale compute for expensive queries. B). Materialized view stores precomputed query results to improve performance for repeated query patterns, but it does not temporarily scale a warehouse. D). Search optimization service improves point lookup and selective query performance on large tables, but it does not temporarily scale virtual warehouse compute. Official Snowflake documentation reference: Snowflake documentation describes the Query Acceleration Service as a feature that can improve the performance of eligible queries by using additional compute resources. It is commonly associated with accelerating parts of large scans and reducing the impact of outlier queries. Reference: Snowflake Documentation - Query Acceleration Service; SnowPro Core Study Guide - Performance Optimization. ==
Question 100
What command is used to export or unload data from Snowflake?
Correct Answer: A
The command used to export or unload data from Snowflake to a stage (such as a file in an S3 bucket, Azure Blob Storage, or Google Cloud Storage) is the PUT command. The PUT command is designed to upload data files from a local file system (in the case of SnowSQL or other client) or a virtual warehouse to a specified stage. This functionality is critical for scenarios where data needs to be extracted from Snowflake for use in external systems, backups, or further processing. The syntax for the PUT command follows the structure: PUT file://<local_file_path> @<stage_name>, where <local_file_path> specifies the path to the file(s) on the local file system that you wish to upload, and <stage_name> specifies the destination stage in Snowflake. It's important to distinguish that the PUT command is used for exporting data out of Snowflake, whereas the COPY INTO <table> command is used for importing data into Snowflake from a stage. The GET command, on the other hand, is used to download files from a stage to the local file system, essentially the inverse operation of the PUT command. References: Snowflake Documentation on Loading and Unloading Data: [Loading and Unloading Data](https://docs.snowflake.com/en/user-guide/data-load