Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Data Engineer All Questions

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

Exam SnowPro Advanced Data Engineer topic 1 question 1 discussion

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

A Data Engineer is investigating a query that is taking a long time to return. The Query Profile shows the following:

What step should the Engineer take to increase the query performance?

  • A. Add additional virtual warehouses.
  • B. Increase the size of the virtual warehouse.
  • C. Rewrite the query using Common Table Expressions (CTEs).
  • D. Change the order of the joins and start with smaller tables first.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by BigDataBB at Nov. 10, 2023, 4:10 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
BigDataBB
Highly Voted 1 year ago
Selected Answer: B
What is disk spilling? When Snowflake warehouse cannot fit an operation in memory, it starts spilling (storing) data first to the local disk of a warehouse node, and then to remote storage. In such a case, Snowflake first tries to temporarily store the data on the warehouse local disk. As this means extra IO operations, any query that requires spilling will take longer than a similar query running on similar data that is capable to fit the operations in memory. Also, if the local disk is not sufficient to fit the spilled data, Snowflake further tries to write to the remote cloud storage, which will be shown in the query profile as "Bytes spilled to remote storage".
upvoted 5 times
...
falo197
Most Recent 5 days, 6 hours ago
Has anyone taken this certificate recently? are the questions here still relevant? Thanks you in advance for answer!
upvoted 1 times
...
rbeam
7 months, 4 weeks ago
Selected Answer: B
Bytes spilled to local means insufficient memory. to increase memory, the suggested way is increasing warehouse size.
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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