If a table has a data retention of 10 days and is loaded with 256 MB of data daily, what will be the total storage after 5 days of ingestion?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

If a table has a data retention of 10 days and is loaded with 256 MB of data daily, what will be the total storage after 5 days of ingestion?

Explanation:
Understanding how data retention interacts with daily ingestion helps you predict storage growth. If you load 256 MB each day and keep data for 10 days, the storage increases by 256 MB per day until the retention window is full; no data is purged yet. After 5 days, all five days of data are still within the 10-day retention, so you simply have 256 MB times 5 days. That equals 1280 MB of total storage. So 1280 MB is the correct total after 5 days. The other amounts would imply holding only one day of data, holding data for the full 10 days, or having no data at all, which isn’t the case here.

Understanding how data retention interacts with daily ingestion helps you predict storage growth. If you load 256 MB each day and keep data for 10 days, the storage increases by 256 MB per day until the retention window is full; no data is purged yet.

After 5 days, all five days of data are still within the 10-day retention, so you simply have 256 MB times 5 days. That equals 1280 MB of total storage.

So 1280 MB is the correct total after 5 days. The other amounts would imply holding only one day of data, holding data for the full 10 days, or having no data at all, which isn’t the case here.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy