SOL-C01 · Question #11
SOL-C01 Question #11: Real Exam Question with Answer & Explanation
The correct answer is C: Utilize a third-party lac tool (e.g., Terraform) to define the schemas as resources, managing their. Using a dedicated lac tool like Terraform is the best practice for managing Snowflake resources, including schemas. It ensures consistency, repeatability, and version control. Options A and D are manual and error-prone. Option B is better than A and D but lacks the full features
Question
You are tasked with deploying a new data application to Snowflake. This application requires several schemas for staging, transformation, and reporting. What is the recommended approach to create these schemas using Infrastructure as Code (laC) and ensuring consistency across multiple Snowflake environments (DEV, TEST, PROD)?
Options
- AManually create the schemas in each environment using the Snowflake web UI, documenting the
- BUse a Snowflake client (e.g., SnowSQL) and a script to execute 'CREATE SCHEMA' statements,
- CUtilize a third-party lac tool (e.g., Terraform) to define the schemas as resources, managing their
- DCopy the DDL (Data Definition Language) scripts generated by the Snowflake UI after manually
- EUtilize Snowflake's data replication feature to replicate schemas between different environments
Explanation
Using a dedicated lac tool like Terraform is the best practice for managing Snowflake resources, including schemas. It ensures consistency, repeatability, and version control. Options A and D are manual and error-prone. Option B is better than A and D but lacks the full features of lac tools (state management, dependency resolution, etc.). Option E is for data replication and not schema
Topics
Community Discussion
No community discussion yet for this question.