Snowpro Core · Free Practice Question Medium

Question 91

Which of the following statements about Snowflake's "table storage metrics" views is true?

  • A

    They provide information only about active table storage.

  • B

    They are available in both the Information Schema and Account Usage Schema.

  • C

    They only display storage information for databases with time travel enabled.

  • D

    They automatically compress table data.

Reveal correct answer

Correct answer: B

A.

The metrics views provide information not only about active storage but also about time travel and failsafe storage.

B.

The "table storage metrics" views are available in both the Information Schema and the Account Usage Schema, offering detailed table storage information including active bytes, time travel, and failsafe data.

C.

These views provide information regardless of whether time travel is enabled for a database.

D.

Table storage metrics views do not manage compression; they display storage statistics.

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need