To address a high volume of queries queuing in a warehouse, Snowflake recommends two best practices:
* A. Use multi-clustered warehousing to scale out warehouse capacity: This approach allows for the distribution of queries across multiple clusters within a warehouse, effectively managing the load and reducing the queue volume.
* B. Scale up the warehouse size to allow Queries to execute faster: Increasing the size of the warehouse provides more compute resources, which can reduce the time it takes for queries to execute and thus decrease the number of queries waiting in the queue.
These strategies help to optimize the performance of the warehouse by ensuring that resources are scaled appropriately to meet demand.
References:
* Snowflake Documentation on Multi-Cluster Warehousing
* SnowPro Core Certification best practices

* A pre-signed URL in Snowflake grants access to unstructured files (e.g., in external stages) without requiring additional authentication.
* The URL includes an embedded token that specifies the expiration time and access permissions.
* Key Point: Anyone who has the pre-signed URL can access the referenced file for the duration of the token's validity.
Why Other Options Are Incorrect:
* B. Only the user who generates the URL can use it: The URL is shareable and not restricted to its creator.
* C. Users with roles and privileges: Pre-signed URLs bypass direct role or privilege checks.
* D. Role specified in GET REST API call: This is unrelated to pre-signed URL access.
References:
* Pre-Signed URLs Documentation

In Snowflake, to extract a specific element from a JSON stored in a VARIANT column, the correct syntax is to use the dot notation. Therefore, the query select src.dealership from car_sales; will return the dealership information contained within each JSON object in the src column.
References: For a detailed explanation, please refer to the Snowflake documentation on querying semi-structured data.