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

Save Cancel