Design Data Models and Storage Strategies ARA-C01 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   Which storage optimization technique in Snowflake can reduce the amount of data scanned by queries that filter on a specific column?

   • AIncreasing the warehouse size
   • BUsing a view instead of a table
   • CDefining a clustering key on that column
   • DEnabling automatic compression
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   A company stores historical sales data that is queried frequently for the current year but rarely accessed for older years. Which storage strategy best balances cost and performance?

   • AUse separate tables for each year and query only the needed table.
   • BUse table clustering on the date column and consider moving older data to a lower-cost storage tier if available.
   • CUse Snowflake's automatic clustering and time travel to manage older data.
   • DStore all data in a single standard table with no partitioning.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   A table in Snowflake has a retention time of 1 day. What happens to data that is deleted from the table after 1 day?

   • AIt is immediately and permanently removed from the table.
   • BIt is automatically replicated to another region.
   • CIt is moved to a fail-safe storage for 7 days.
   • DIt remains accessible via Time Travel for 1 day, after which it is purged.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What is a common way to reduce storage costs in Snowflake without losing access to historical data?

   • ACompressing data manually before loading
   • BMoving rarely accessed data to a lower-cost storage tier, if available
   • CUsing automatic clustering on all tables
   • DDeleting old data and relying on Time Travel for recovery
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company stores sensor data in Snowflake. The data is ingested every minute and queried for the last hour for real-time monitoring, and also queried for historical analysis on a monthly basis. They want to reduce storage cost without sacrificing query performance for the real-time monitoring. Which storage strategy is most appropriate?

   • AUse a separate table for the last hour of data and a separate table for historical data, with a view to union them.
   • BUse a single table and set a short time travel retention to reduce storage cost.
   • CUse a single table and create a materialized view for the real-time monitoring.
   • DUse a single table for all data and rely on clustering on the timestamp column.
   Reveal Solution Discussion Select an answer first