Snowpro Advanced Architect · Free Practice Question Medium

Question 44

A retail company requires real-time monitoring of Time Travel storage usage. Which approach provides the most efficient insights?
  • A Use the Snowsight interface to monitor storage.
  • B Query the ACCOUNT_USAGE view for storage metrics.
  • C

    Set up real-time monitoring using Snowflake events or external integrations.

  • D Enable alerts for Time Travel storage thresholds.
  • E Run periodic queries on the Information Schema.
Reveal correct answer

Correct answer: C

Explanation

Setting up real-time monitoring using Snowflake events or external integrations would involve configuring:

  1. Snowflake Tasks and Streams: To monitor and capture Time Travel data usage in near real-time.

  2. Custom Monitoring Tools: Using tools like Snowpipe or external log monitoring systems that integrate with Snowflake for more immediate insights.

A. Snowsight offers insights but may not update frequently enough.

B. ACCOUNT_USAGE views provide detailed storage data, including Time Travel.

C.

Set up real-time monitoring using Snowflake events or external integrations.

This involves configuring:

  1. Snowflake Tasks and Streams: To monitor and capture Time Travel data usage in near real-time.

  2. Custom Monitoring Tools: Using tools like Snowpipe or external log monitoring systems that integrate with Snowflake for more immediate insights.

D. Alerts provide notifications but lack granular data for analysis.

E. Information Schema updates faster but lacks detailed metrics.

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