exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 224 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 224
Topic #: 1
[All SnowPro Core Questions]

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Choose two.)

  • A. Bytes scanned
  • B. Bytes sent over the network
  • C. Number of partitions scanned
  • D. Percentage scanned from cache
  • E. External bytes scanned
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️

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
BigDataBB
Highly Voted 1 year, 11 months ago
Selected Answer: CD
I think that the right answer si C,D. Because the number of bytes scanned has no values if don't know if your query has or not make a prune, reducing the number of partition tha has scanned. I have a good query if my filters reduce the number of (micro) partiotion that the query must access to get the data.
upvoted 19 times
...
bibisa
Highly Voted 1 year, 8 months ago
Selected Answer: AC
A. Bytes scanned represents the amount of data scanned by the query. By minimizing the number of bytes scanned, query performance can be improved. C. Number of partitions scanned represents the number of partitions read during query execution. By minimizing the number of partitions scanned, query performance can be improved. B, D, and E are incorrect statements. Bytes sent over the network, percentage scanned from cache, and external bytes scanned may provide useful information for monitoring or troubleshooting, but they are not directly related to optimizing query performance.
upvoted 6 times
...
Kuldeepkd
Most Recent 4 weeks ago
A and C should be the correct answers
upvoted 1 times
...
Jarturo
4 months, 2 weeks ago
D & E D: Inefficient Pruning https://docs.snowflake.com/en/user-guide/ui-query-profile.html#inefficient-pruning E: Queries Too Large to Fit in Memory: https://docs.snowflake.com/en/user-guide/ui-query-profile.html#queries-too-large-to-fit-in-memory
upvoted 1 times
...
Mallikharjuna452
5 months ago
C and D are correct
upvoted 1 times
...
PrashantGupta1616
6 months, 2 weeks ago
Selected Answer: AC
AC is the answer
upvoted 1 times
...
Lematthew31
8 months ago
Selected Answer: AC
A. Bytes scanned: This indicates the amount of data scanned from the tables or files involved in the query. By minimizing the number of bytes scanned, you can optimize query performance by reducing the amount of data processed. C. Number of partitions scanned: This represents the number of partitions accessed during the query execution. Optimizing the number of partitions scanned can improve query performance, as accessing fewer partitions typically requires less processing time. So, the correct options are A. Bytes scanned and C. Number of partitions scanned
upvoted 2 times
...
_yyukta
10 months ago
Selected Answer: AC
AC are correct
upvoted 2 times
...
sfdumps
12 months ago
Selected Answer: AC
QUERY RESULT CACHE IS NOT HELPFULL
upvoted 2 times
...
niho1993
1 year, 2 months ago
Selected Answer: AC
reference to this question https://community.snowflake.com/s/question/0D7Do000000cglDKAQ/detail
upvoted 1 times
...
Marge23
1 year, 3 months ago
Selected Answer: AC
CORRECT
upvoted 1 times
...
Marge23
1 year, 3 months ago
Selected Answer: AC
bytes scanned, partition scanned
upvoted 1 times
...
MultiCloudIronMan
1 year, 5 months ago
Selected Answer: CD
Should be correct
upvoted 1 times
...
bonniezl
1 year, 6 months ago
Selected Answer: CD
CD is correct
upvoted 1 times
...
dmitriypo
1 year, 7 months ago
Selected Answer: AC
I would go for AC. The query should not rely on cache.
upvoted 1 times
...
shyemko
1 year, 9 months ago
Selected Answer: AD
https://docs.snowflake.com/en/user-guide/ui-query-profile
upvoted 1 times
...
OTE
1 year, 9 months ago
Selected Answer: CD
Number of partitions being scanned (in relation to the total number) -> Pruning Cache usage can significantly boost the performance
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago