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.)

ASHOW STORAGE BY TABLE;

BSHOW TABLES;

CInformation Schema -> TABLE_HISTORY

DInformation Schema -> TABLE_FUNCTION

EInformation Schema -> TABLE_STORAGE_METRICS

Show Suggested 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

7 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

6 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

6 months ago

D) Yeah, I agree, Information Schema -> TABLE_FUNCTION doesn't seem very useful for this.

upvoted 0 times

...

Carlee

6 months ago

D) Yeah, I agree. Information Schema -> TABLE_FUNCTION doesn't seem very helpful for monitoring data storage.

upvoted 0 times

...

Roosevelt

6 months ago

C) Information Schema -> TABLE_HISTORY is also a good choice for keeping track of data storage changes.

upvoted 0 times

...

Edna

7 months ago

C) Information Schema -> TABLE_HISTORY is also a good option for monitoring individual table storage.

upvoted 0 times

...

Willetta

7 months ago

E) Information Schema -> TABLE_STORAGE_METRICS is definitely the best option for monitoring data storage.

upvoted 0 times

...

Ashleigh

7 months ago

E) Information Schema -> TABLE_STORAGE_METRICS is definitely the way to go for monitoring data storage.

upvoted 0 times

...

Daniel

7 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

7 months ago

Chocolate teapot? I'm going to have to remember that one! Good one, mate.

upvoted 0 times

Arlean

6 months ago

E) Information Schema -> TABLE_STORAGE_METRICS

upvoted 0 times

...

Valentine

7 months ago

C) Information Schema -> TABLE_HISTORY

upvoted 0 times

...

Heidy

7 months ago

A) SHOW STORAGE BY TABLE;

upvoted 0 times

...

Fernanda

8 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

7 months ago

C) Information Schema -> TABLE_HISTORY

upvoted 0 times

...

Claribel

7 months ago

A) SHOW STORAGE BY TABLE;

upvoted 0 times

...

Shawnda

8 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

8 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

8 months ago

I agree with Magnolia. Those commands and objects are used to monitor data storage for individual tables.

upvoted 0 times

...

Magnolia

8 months ago

I think the answer is A) SHOW STORAGE BY TABLE and C) Information Schema -> TABLE_HISTORY.

upvoted 0 times

...