BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam COF-R02 Topic 6 Question 39 Discussion

Actual exam question for Snowflake's COF-R02 exam
Question #: 39
Topic #: 6
[All COF-R02 Questions]

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

Show Suggested Answer Hide Answer
Suggested Answer: A, E

Contribute your Thoughts:

Marge
2 months ago
D) Information Schema -> TABLE_FUNCTION? Really? That's about as useful as a chocolate teapot for monitoring data storage. E) and C) are the way to go, for sure.
upvoted 0 times
Glory
10 days ago
E) SHOW STORAGE BY TABLE and Information Schema -> TABLE_STORAGE_METRICS are the best choices for monitoring data storage.
upvoted 0 times
...
Nohemi
27 days ago
D) Yeah, I agree, Information Schema -> TABLE_FUNCTION doesn't seem very useful for this.
upvoted 0 times
...
Carlee
29 days ago
D) Yeah, I agree. Information Schema -> TABLE_FUNCTION doesn't seem very helpful for monitoring data storage.
upvoted 0 times
...
Roosevelt
1 months ago
C) Information Schema -> TABLE_HISTORY is also a good choice for keeping track of data storage changes.
upvoted 0 times
...
Edna
1 months ago
C) Information Schema -> TABLE_HISTORY is also a good option for monitoring individual table storage.
upvoted 0 times
...
Willetta
1 months ago
E) Information Schema -> TABLE_STORAGE_METRICS is definitely the best option for monitoring data storage.
upvoted 0 times
...
Ashleigh
1 months ago
E) Information Schema -> TABLE_STORAGE_METRICS is definitely the way to go for monitoring data storage.
upvoted 0 times
...
...
Daniel
2 months ago
A) SHOW STORAGE BY TABLE sounds like it could work, but I've never heard of that command before. E) and C) seem like the reliable choices here.
upvoted 0 times
...
Denna
2 months ago
Chocolate teapot? I'm going to have to remember that one! Good one, mate.
upvoted 0 times
Arlean
1 months ago
E) Information Schema -> TABLE_STORAGE_METRICS
upvoted 0 times
...
Valentine
1 months ago
C) Information Schema -> TABLE_HISTORY
upvoted 0 times
...
Heidy
1 months ago
A) SHOW STORAGE BY TABLE;
upvoted 0 times
...
...
Fernanda
2 months ago
Haha, yeah, that's a pretty creative analogy. Gotta love a bit of humor in these dry exam questions.
upvoted 0 times
Jarvis
1 months ago
C) Information Schema -> TABLE_HISTORY
upvoted 0 times
...
Claribel
2 months ago
A) SHOW STORAGE BY TABLE;
upvoted 0 times
...
...
Shawnda
2 months ago
I believe option E) Information Schema -> TABLE_STORAGE_METRICS could also be a valid choice for monitoring data storage.
upvoted 0 times
...
Suzan
2 months ago
I'm not sure about option D) Information Schema -> TABLE_FUNCTION. I think it's not related to monitoring data storage.
upvoted 0 times
...
Charisse
3 months ago
I agree with Magnolia. Those commands and objects are used to monitor data storage for individual tables.
upvoted 0 times
...
Magnolia
3 months ago
I think the answer is A) SHOW STORAGE BY TABLE and C) Information Schema -> TABLE_HISTORY.
upvoted 0 times
...

Save Cancel