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

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

by Sherell at Aug 28, 2024, 11:33 AM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Marge
3 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
2 months ago
E) SHOW STORAGE BY TABLE and Information Schema -> TABLE_STORAGE_METRICS are the best choices for monitoring data storage.
upvoted 0 times
...
Nohemi
2 months ago
D) Yeah, I agree, Information Schema -> TABLE_FUNCTION doesn't seem very useful for this.
upvoted 0 times
...
Carlee
2 months ago
D) Yeah, I agree. Information Schema -> TABLE_FUNCTION doesn't seem very helpful for monitoring data storage.
upvoted 0 times
...
Roosevelt
2 months ago
C) Information Schema -> TABLE_HISTORY is also a good choice for keeping track of data storage changes.
upvoted 0 times
...
Edna
2 months ago
C) Information Schema -> TABLE_HISTORY is also a good option for monitoring individual table storage.
upvoted 0 times
...
Willetta
3 months ago
E) Information Schema -> TABLE_STORAGE_METRICS is definitely the best option for monitoring data storage.
upvoted 0 times
...
Ashleigh
3 months ago
E) Information Schema -> TABLE_STORAGE_METRICS is definitely the way to go for monitoring data storage.
upvoted 0 times
...
...
Daniel
3 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
3 months ago
Chocolate teapot? I'm going to have to remember that one! Good one, mate.
upvoted 0 times
Arlean
2 months ago
E) Information Schema -> TABLE_STORAGE_METRICS
upvoted 0 times
...
Valentine
2 months ago
C) Information Schema -> TABLE_HISTORY
upvoted 0 times
...
Heidy
3 months ago
A) SHOW STORAGE BY TABLE;
upvoted 0 times
...
...
Fernanda
4 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
3 months ago
C) Information Schema -> TABLE_HISTORY
upvoted 0 times
...
Claribel
3 months ago
A) SHOW STORAGE BY TABLE;
upvoted 0 times
...
...
Shawnda
4 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
4 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
4 months ago
I agree with Magnolia. Those commands and objects are used to monitor data storage for individual tables.
upvoted 0 times
...
Magnolia
4 months ago
I think the answer is A) SHOW STORAGE BY TABLE and C) Information Schema -> TABLE_HISTORY.
upvoted 0 times
...

Save Cancel