ARA-C01 · Question #96
A company is designing its serving layer for data that is in cloud storage. Multiple terabytes of the data will be used for reporting. Some data does not have a clear use case but could be useful for
The correct answer is A. Import the data used for reporting into a Snowflake schema with native tables. Then create. The most cost-effective and administratively efficient solution is to use a combination of native and external tables. Native tables for reporting data ensure performance and governance, while external tables allow for flexibility with frequently changing experimental data. Creat
Question
A company is designing its serving layer for data that is in cloud storage. Multiple terabytes of the data will be used for reporting. Some data does not have a clear use case but could be useful for experimental analysis. This experimentation data changes frequently and is sometimes wiped out and replaced completely in a few days. The company wants to centralize access control, provide a single point of connection for the end- users, and maintain data governance. What solution meets these requirements while MINIMIZING costs, administrative effort, and development overhead?
Options
- AImport the data used for reporting into a Snowflake schema with native tables. Then create
- BImport all the data in cloud storage to be used for reporting into a Snowflake schema with native
- CImport all the data in cloud storage to be used for reporting into a Snowflake schema with native
- DImport the data used for reporting into a Snowflake schema with native tables. Then create views
How the community answered
(36 responses)- A61% (22)
- B6% (2)
- C22% (8)
- D11% (4)
Explanation
The most cost-effective and administratively efficient solution is to use a combination of native and external tables. Native tables for reporting data ensure performance and governance, while external tables allow for flexibility with frequently changing experimental data. Creating roles with specific grants to datasets aligns with the principle of least privilege, centralizing access control and simplifying user management.
Topics
Community Discussion
No community discussion yet for this question.