SOL-C01 · Question #10
SOL-C01 Question #10: Real Exam Question with Answer & Explanation
The correct answer is C: Create separate schemas within 'SALES_DB' and grant specific privileges on each schema to. Creating separate schemas within the database and assigning granular privileges provides the most secure and manageable separation. Option A is less secure. Option B is inefficient and overcomplicates the setup. Option D lacks proper schema isolation and management. Option E appl
Question
A data engineer is tasked with creating multiple schemas within a Snowflake database called 'SALES DB'. These schemas need to be isolated from each other to prevent accidental data access. Which of the following approaches is the MOST secure and efficient way to achieve this?
Options
- ACreate all schemas under the 'PUBLIC' schema of 'SALES_DB' and grant specific privileges on
- BCreate a separate database for each schema, leading to multiple databases instead of schemas
- CCreate separate schemas within 'SALES_DB' and grant specific privileges on each schema to
- DCreate one large schema and prefix all table names with the schema name to simulate schema
- ECreating external tables and configuring different storage integrations for each table.
Explanation
Creating separate schemas within the database and assigning granular privileges provides the most secure and manageable separation. Option A is less secure. Option B is inefficient and overcomplicates the setup. Option D lacks proper schema isolation and management. Option E applies to external tables, which are not the focus of internal schema segregation.
Topics
Community Discussion
No community discussion yet for this question.