ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam
Go to Exam

Exam SnowPro Advanced Architect topic 1 question 142 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 142
Topic #: 1
[All SnowPro Advanced Architect Questions]

An Architect is investigating a performance issue with an existing architecture and found a query where the Query Profile indicates a high number of bytes spilled to remote storage. The query includes a where clause that filters out a high percentage of records.

What actions can be taken to reduce the spillage to remote storage and improve the query performance? (Choose two.)

  • A. Increase the size of the virtual warehouse.
  • B. Increase the maximum number of clusters for the virtual warehouse.
  • C. Define a clustering key on columns used for selective filtering with a high clustering depth.
  • D. Ensure primary keys and foreign keys are defined for large tables referenced by the query.
  • E. Decrease the data retention period for tables referenced by the query.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
by ArunH at Nov. 26, 2025, 7:31 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
ArunH
23 hours, 18 minutes ago
Selected Answer: AC
A and C are close. But High clustering depth is an indication of poor clustering.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel