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 85 discussion

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

An Architect is troubleshooting a query with poor performance using the QUERY_HISTORY function. The Architect observes that the COMPILATION_TIME is greater than the EXECUTION_TIME.

What is the reason for this?

  • A. The query is processing a very large dataset.
  • B. The query has overly complex logic.
  • C. The query is queued for execution.
  • D. The query is reading from remote storage.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by NachoPrendes at July 18, 2024, 11:43 a.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
Soumak
3 months ago
Selected Answer: B
unless it is a complex query, compilation time would not increase
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago