ARA-C01 Question #68: Real Exam Question with Answer & Explanation

Question

An Architect needs to design a Snowflake account and database strategy to store and analyze large amounts of structured and semi-structured data. There are many business units and departments within the company. The requirements are scalability, security, and cost efficiency. What design should be used?

Options

• ACreate a single Snowflake account and database for all data storage and analysis needs,
• BSet up separate Snowflake accounts and databases for each department or business unit, to
• CUse Snowflake's data lake functionality to store and analyze all data in a central location, without
• DUse a centralized Snowflake database for core business data, and use separate databases for

Explanation

The best design to store and analyze large amounts of structured and semi-structured data for different business units and departments is to use a centralized Snowflake database for core business data, and use separate databases for departmental or project-specific data. This design allows for scalability, security, and cost efficiency by leveraging Snowflake's features such as: Database cloning: Cloning a database creates a zero-copy clone that shares the same data files as the original database, but can be modified independently. This reduces storage costs and enables fast and consistent data replication for different purposes. Database sharing: Sharing a database allows granting secure and governed access to a subset of data in a database to other Snowflake accounts or consumers. This enables data collaboration and monetization across different business units or external partners. Warehouse scaling: Scaling a warehouse allows adjusting the size and concurrency of a warehouse to match the performance and cost requirements of different workloads. This enables optimal resource utilization and flexibility for different data analysis needs.

No community discussion yet for this question.