Exam DEA-C02 Topic 1 Question 349 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 349
Topic #: 1
A data engineering team is managing a Snowflake warehouse that supports a high volume of ad-hoc queries from data analysts exploring a large, semi-structured JSON dataset containing website clickstream data'. The query performance is frequently slow, and analysts are complaining about long wait times. The warehouse is already sized appropriately. You have identified that many of the queries filter on nested JSON attributes that are not explicitly indexed. Considering only query acceleration service features, what is the MOST effective approach to improve query performance for these ad-hoc queries without modifying the queries themselves or significantly increasing storage costs?

Suggested Answer: C Vote an answer

Search Optimization Service is designed specifically to improve query performance on semi-structured data and complex predicates, especially on JSON data. It automatically creates and maintains search access paths, including paths for nested JSON attributes, enabling faster filtering and retrieval of relevant data. Materialized Views are beneficial, but require creation and maintenance, and might not be ideal for ad-hoc queries. Automatic Clustering helps with data organization, but its impact on complex JSON queries might be limited. Using Query Acceleration alone requires a larger warehouse and may not address the underlying issue of unoptimized queries on semi-structured data. While a dedicated warehouse is a good practice, it does not address the underlying performance issue related to JSON queries.

by Jocelyn at Jul 29, 2026, 08:25 AM

Limited Time Offer

15%

Off

Get Premium DEA-C02 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10