exam questions

Exam SnowPro Advanced Data Engineer All Questions

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

Exam SnowPro Advanced Data Engineer topic 1 question 31 discussion

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

The following chart represents the performance of a virtual warehouse over time:

A Data Engineer notices that the warehouse is queueing queries. The warehouse is size X-Small, the minimum and maximum cluster counts are set to 1, the scaling policy is set to standard, and auto-suspend is set to 10 minutes.
How can the performance be improved?

  • A. Change the cluster settings.
  • B. Increase the size of the warehouse.
  • C. Change the scaling policy to economy.
  • D. Change auto-suspend to a longer time frame.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
stopthisnow
1 month, 1 week ago
Selected Answer: A
A could be correct. The cluster size is 1 and the queries are taking a long time to complete
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago