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

Questions 6–10

1. 6application · medium

   A company is designing a data model for a new application. The business requires real-time dashboards on recent data and periodic deep-dive analysis on historical data. They want to minimize storage cost. Which modeling approach is most appropriate?

   • AUse a single table and create a materialized view for the real-time dashboard.
   • BCreate two tables: one for recent data (e.g., last 30 days) and one for historical data, with a view to union them.
   • CUse a single table with a time travel retention of 90 days and rely on fail-safe for older data.
   • DUse a single table for all data and rely on clustering to handle both access patterns.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the purpose of Snowflake's Time Travel feature?

   • ATo automatically optimize query performance
   • BTo query data as it existed at a past point in time
   • CTo enforce data retention policies for compliance
   • DTo replicate data to other accounts
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   A data architect is designing a Snowflake data model for a retail analytics application. The primary query pattern is a daily sales dashboard that aggregates revenue by store and product category. Which design principle should guide the modeling decisions?

   • AModel tables to match the grain and access patterns of the dashboard queries, such as using a star schema with fact and dimension tables.
   • BNormalize all tables to the third normal form to minimize data redundancy.
   • CStore all data in a single wide table to avoid joins entirely.
   • DUse only views to model data so that no physical tables are needed.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is the primary purpose of Snowflake Data Sharing?

   • ATo provide read-only access to data in one account from another account without copying the data
   • BTo migrate data from on-premises systems to Snowflake
   • CTo create a backup of the data in a separate account
   • DTo replicate data to a different region for disaster recovery
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   When selecting a storage strategy in Snowflake, what is the primary trade-off an architect must consider?

   • AData volume versus data variety
   • BSecurity versus compliance
   • CCompute cost versus network bandwidth
   • DStorage cost versus query performance
   Reveal Solution Discussion Select an answer first