Snowflake GES-C01 Value Pack (Frequently Bought Together)

A data scientist is tasked with improving the accuracy of an LLM-powered chatbot that answers user questions based on internal company documents stored in Snowflake. They decide to implement a Retrieval Augmented Generation (RAG) architecture using Snowflake Cortex Search. Which of the following statements correctly describe the features and considerations when leveraging Snowflake Cortex Search for this RAG application?

• A. The
• B. Cortex Search automatically handles text chunking and embedding generation for the source data, eliminating the need for manual ETL processes for these steps.
• C. To create a Cortex Search Service, one must explicitly specify an embedding model and manually manage its underlying infrastructure, similar to deploying a custom model via Snowpark Container Services.
• D. For optimal search results with Cortex Search, source text should be pre-split into chunks of no more than 512 tokens, even when using models with larger context windows like
  
• E. Enabling change tracking on the source table for the Cortex Search Service is optional; the service will still refresh automatically even if change tracking is disabled.

Explanation: Only visible for PracticeTorrent members. You can sign-up / login (it's free).

A data engineer is tasked with defining a semantic model for Cortex Analyst to enable natural language queries over sales dat a. They are creating a YAML file to describe the logical structure. Which of the following statements correctly describe the configuration of this semantic model? (Select all that apply)

• A. The 'tables' section must define logical tables that directly map to Snowflake physical tables or views, with 'base_table' specifying the fully qualified name (database, schema, table).
• B. The 'VARIANT data type is a supported data type for columns defined as 'dimensions' or 'facts' within the semantic model, allowing flexible storage of complex attributes.
• C. A 'metric' like 'total_revenue' can be defined using an 'expr' that references other logical columns, such as 'sum(profity from a logical 'sales_data' table, within the semantic model.
• D. Dimensions such as 'product_category' can include a configuration, which can specify an optional 'literal_column' that, if omitted, defaults to the search index column.
• E. To ensure high accuracy for specific common questions, 'verified_querieS can be included, where the 'sqr field must reference the underlying physical table and column names (ee.g., not the logical names defined in the semantic model.

Explanation: Only visible for PracticeTorrent members. You can sign-up / login (it's free).

A data engineer has successfully experimented with a prompt and various model settings in the Snowflake Cortex Playground for a text classification task using the mistral-large2 model and Cortex Guard. They now want to operationalize this solution within their Snowflake environment. Which of the following statements correctly describe capabilities or considerations when moving from the Cortex Playground to a production pipeline?

• A. The Playground allows exporting the exact SQL query with all defined model settings, including temperature and Cortex Guard enablement, for direct use in a Snowflake worksheet or task.
• B. The exported SQL query, when used with dynamic tables, supports incremental refresh for efficient processing of new data without recomputing the entire table.
• C. If the mistral-large2 model is not natively available in the target production region, cross-region inference must be enabled by setting the CORTEX_ENABLED_CROSS REGION parameter.
• D. To filter unsafe LLM responses in production, the Cortex Guard option, which is built with Meta's Llama Guard 3, must be explicitly enabled in the COMPLETE function's options argument.
• E. For continuous processing of new data, the exported SQL query can be automated using

Explanation: Only visible for PracticeTorrent members. You can sign-up / login (it's free).

A Gen AI specialist is designing an intelligent document processing workflow using Snowflake Cortex AI PARSE DOCUMENT to handle various types of documents, including scanned research papers, financial 10-K filings with tables, and multilingual presentations. Which of the following statements accurately describe the capabilities and operational modes of Snowflake's AI_PARSE_DOCUMENT function when processing these diverse documents?

• A. Option C
• B. Option B
• C. Option A
• D. Option D
• E. Option E

Explanation: Only visible for PracticeTorrent members. You can sign-up / login (it's free).

A data scientist is optimising a Cortex Analyst application to improve the accuracy of literal searches within user queries, especially for high-cardinality dimension values. They decide to integrate Cortex Search for this purpose. Which of the following statements are true about this integration and the underlying data types in Snowflake? (Select all that apply)

• A. For optimal RAG retrieval performance with Cortex Search, it is generally recommended to split text into chunks of no more than 512 tokens, even when using embedding models with larger context windows such as 'snowflake-arctic-embed-l-v2.0-8k'.
• B. Cortex Search Services, when configured as a source for Snowflake dynamic tables, automatically refresh their search index with continuous data updates, maintaining low-latency search results.
• C. The "VECTOR data type in Snowflake, used to store embeddings generated for Cortex Search, is fully supported as a clustering key in standard tables and as a primary key in hybrid tables to accelerate vector similarity searches.
• D. The cost for embedding data into a Cortex Search Service is primarily incurred per output token generated by the embedding model, as these represent the final vector embeddings, rather than input tokens.
• E. To integrate Cortex Search with a logical dimension, the semantic model YAML must include a block within the dimension's definition, specifying the service name and optionally a 'literal_column' .

Explanation: Only visible for PracticeTorrent members. You can sign-up / login (it's free).