SnowPro Specialty: Gen AI Question 31
Single answerDifferent interfacesA data engineering team is evaluating how different Snowflake interfaces should be used for a new Gen AI workflow. Analysts want to quickly test prompts against Cortex LLM functions without writing application code. At the same time, an application team needs to build a customer-facing chatbot that sends prompts programmatically and integrates responses into a web app. Which interface choice best matches these requirements while minimizing unnecessary development effort?
- A
Use Snowsight worksheets for analysts to test Cortex SQL functions interactively, and use the Snowflake Connector/API-based approach for the application team to call Snowflake programmatically.
- B
Use only SnowSQL for both analysts and the application team, because it provides the full Gen AI experience including interactive prompt experimentation and embedded chatbot UI features.
- C
Use Streamlit in Snowflake exclusively for both teams, because it is the only interface that can access Cortex functions and external applications cannot call Snowflake directly.
- D
Use the Classic Console for analysts to test prompts, and require the application team to export prompt results manually from the UI into the web application.
Show answer and explanation
Correct answer: A
Explanation
The key skill being tested is choosing the right Snowflake interface for the right persona and workload. In practice, Snowsight is the primary web experience for running SQL interactively, including testing Snowflake Cortex SQL functions such as completion and summarization capabilities. That makes it a strong choice for analysts and engineers exploring prompts, validating outputs, and iterating quickly. By contrast, customer-facing applications typically need programmatic access through supported drivers, connectors, or APIs so the application can send prompts and process responses dynamically. Streamlit in Snowflake is valuable for building lightweight interactive apps within Snowflake, but it is not the only way to work with Cortex and is not required for external app integration. Snowflake documentation and best practices consistently separate interactive development interfaces like Snowsight from programmatic integration interfaces used by applications and services.
- A. Correct.
Correct. Snowsight worksheets are well suited for interactive exploration and testing of Cortex functions through SQL, making them a practical choice for analysts who want low-friction experimentation. For application developers, programmatic access through drivers, connectors, or APIs is the appropriate interface when integrating Snowflake-powered Gen AI functionality into an external application such as a customer-facing chatbot.
- B. Incorrect.
Incorrect. SnowSQL is a command-line client for executing SQL, but it is not the best fit for analysts seeking a convenient interactive environment for prompt experimentation, and it does not provide built-in chatbot UI capabilities. This option reflects the misconception that a CLI is the default best interface for all users and use cases.
- C. Incorrect.
Incorrect. Streamlit in Snowflake can be used to build internal data apps and Gen AI experiences, but it is not the only interface that can access Cortex functions. External applications can call Snowflake programmatically using supported connectors and APIs. This option overstates Streamlit's exclusivity and ignores common app integration patterns.
- D. Incorrect.
Incorrect. The Classic Console is not the preferred interface for modern interactive SQL-based Gen AI experimentation. Requiring manual export of prompt results into a web app is also inefficient and not aligned with production integration practices. This option reflects an outdated, manual workflow rather than an applied architecture decision.