ADA-C01 Question 13
Single answerIdentify use cases for the different frameworksA Snowflake administrator is designing data onboarding patterns for multiple internal teams. The company has the following requirements: (1) the Finance team wants analysts to load spreadsheet-like data files into Snowflake with minimal SQL knowledge using a guided interface, (2) the Data Engineering team needs a repeatable code-driven process to ingest, transform, and operationalize data pipelines with version control, and (3) the Security team wants a framework to centrally discover, classify, and protect sensitive data across Snowflake accounts. Which combination of Snowflake frameworks best fits these three use cases?
- A
Use Snowsight data loading features for Finance, Snowpark for Data Engineering pipelines, and Horizon Catalog for Security governance
- B
Use Snowpipe Streaming for Finance, Dynamic Tables for Data Engineering pipelines, and Native Apps Framework for Security governance
- C
Use External Tables for Finance, Streams and Tasks for Data Engineering pipelines, and Marketplace listings for Security governance
- D
Use SnowSQL for Finance, Python worksheets for Data Engineering pipelines, and Tri-Secret Secure for Security governance
Show answer and explanation
Correct answer: A
Explanation
This question tests the ability to map Snowflake frameworks and platform capabilities to real operational needs. Snowsight is commonly used for guided file loading and other administrator/analyst workflows, making it appropriate for non-engineering users who need a simple onboarding experience. Snowpark is Snowflake's developer framework for building data pipelines, transformations, and applications in supported programming languages, making it the best fit for engineering teams that require reusable, code-driven processes and integration with version control. Horizon Catalog is Snowflake's governance and security framework for data discovery, classification, lineage, and policy-based protection. In contrast, Snowpipe Streaming is a specialized ingestion technology, Dynamic Tables and Streams/Tasks are pipeline features rather than the broadest development framework, Native Apps Framework is for application distribution, and Marketplace is for data sharing/monetization rather than governance. These distinctions align with Snowflake product documentation and best practices for choosing the right framework based on user persona and operational requirements.
- A. Correct.
Correct. Snowsight provides a guided, low-code experience for loading data files and is appropriate for analyst-driven or ad hoc ingestion of spreadsheet-like files. Snowpark is the right framework when engineering teams need to build programmable, version-controlled data pipelines and transformations using languages such as Python, Java, or Scala. Horizon Catalog is the Snowflake governance framework used for discovery, classification, lineage, and protection of sensitive data across the Snowflake environment.
- B. Incorrect.
Incorrect. Snowpipe Streaming is an API-based ingestion mechanism intended for low-latency streaming use cases, not a guided analyst-friendly interface for spreadsheet uploads. Dynamic Tables can help automate transformation pipelines, but they are not the best answer for a broad code-driven engineering framework requirement involving operationalized pipelines and version control. Native Apps Framework is for building and distributing applications that run in Snowflake, not for centralized security governance and data classification.
- C. Incorrect.
Incorrect. External Tables are used to query data in external cloud storage without fully loading it into Snowflake, which does not match the requirement for a simple guided spreadsheet-loading experience. Streams and Tasks are valid orchestration components for change tracking and scheduling, but the scenario asks for a framework suited to code-driven development; Snowpark is the more complete fit. Marketplace listings are for sharing and acquiring data products, not for sensitive data governance or protection.
- D. Incorrect.
Incorrect. SnowSQL is a command-line client and would not meet the requirement for minimal SQL knowledge and a guided interface for analysts. Python worksheets are useful for development inside Snowsight, but they are not the primary framework answer for enterprise-grade, version-controlled data pipeline development compared with Snowpark. Tri-Secret Secure is a security feature related to key management, not a governance framework for discovering, classifying, and protecting sensitive data.