GES-C01 Practice Exam Tests Latest Updated on Dec-2025 [Q10-Q28]

NEW QUESTION 10
A data engineering manager needs to audit Cortex LLM function costs to identify specific SQL queries that are unexpectedly high in token consumption for the ‘llama3.1-8b’ model. They require granular analysis of prompt, completion, and guardrail token usage for these queries. Which of the following Snowflake methods or views would provide the necessary insights?

NEW QUESTION 11
A Snowflake administrator is designing a new role, ‘doc_ai_pipeline_creator’ , intended to configure and deploy Document AI extraction pipelines. This role needs the ability to ensure that the designated virtual warehouse, ‘analytics_wh’, can be reliably started and stopped as needed for Document AI tasks. Which of the following SQL statements grants the privilege that directly enables the ‘doc ai_pipeline_creator’ role to control the operational state of ‘analytics_wh’?

NEW QUESTION 12
An analytics team needs to use various Snowflake Cortex LLM functions and wants to understand the cost implications and governance mechanisms for controlling model access and usage. The “ACCOUNTADMIN’ has restricted general LLM access using the ‘CORTEX_MODELS_ALLOWLIST’ parameter. The team is particularly interested in how model complexity and specific function calls impact billing and how access can be managed effectively for different user groups.

NEW QUESTION 13
A data engineer is tasked with establishing AI Observability for a generative AI application that integrates with external systems and will undergo continuous improvement. The goal is to compare different iterations of the application efficiently. Which combination of configuration best practices, features, and governance aspects are most relevant for a robust setup of AI Observability within Snowflake for this scenario?

NEW QUESTION 14
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?

NEW QUESTION 15
A data engineering team is planning to build a real-time data pipeline using Snowflake’s dynamic tables to process incoming log dat a. They want to use SNOWFLAKE. CORTEX. EXTRACT_ANSWER to pull out specific error codes and timestamps from log entries. They are also mindful of the operational costs. Which of the following statements accurately describes limitations or cost considerations for using SNOWFLAKE . CORTEX. EXTRACT_ANSWER in this scenario?

NEW QUESTION 16
A data analyst needs to use SNOWFLAKE. CORTEX. EXTRACT_ANSWER to streamline information retrieval from various contract documents. They are new to Cortex functions and want to understand access requirements and optimal usage. Which of the following statements about using SNOWFLAKE .CORTEX. EXTRACT_ANSWER are correct?

NEW QUESTION 17
A company wants to ingest and process scanned invoices and digitally-born contracts in Snowflake. They need to extract all text, preserving layout for contracts and just the text content for scanned invoices. Which AI_PARSE_DOCUMENT modes would be most appropriate for this scenario, and what is the primary purpose of the function itself?

NEW QUESTION 18
A data application developer is building a Streamlit chat application within Snowflake. This application uses a RAG pattern to answer user questions about a knowledge base, leveraging a Cortex Search Service for retrieval and an LLM for generating responses. The developer wants to ensure responses are relevant, concise, and structured. Which of the following practices are crucial when integrating Cortex Search with Snowflake Cortex LLM functions like AI_COMPLETE for this RAG chatbot?

NEW QUESTION 19
A data engineering team aims to automatically classify incoming customer support requests into predefined categories (‘Technical Issue’, ‘Billing Inquiry’, ‘General Question’) as part of their Snowflake data ingestion pipeline. The goal is to achieve high classification accuracy while managing LLM inference costs efficiently. Which of the following strategies, when applied within a Snowflake data pipeline using Streams and Tasks, would best contribute to meeting these objectives?

NEW QUESTION 20
A financial institution uses Snowflake Cortex Analyst with strict role-based access control (RBAC) on their Snowflake-hosted LLMs. The security team has granted specific ‘CORTEX-MODEL-ROLE application roles to different analyst teams, ensuring they only access approved models. A new requirement arises to enable Azure OpenAI GPT models for Cortex Analyst to leverage a specific feature. An administrator proceeds to execute:

Which of the following statements accurately describe the implications of this change?

NEW QUESTION 21
A Gen AI developer has a Document AI pipeline that uses a query with ‘GET PRESIGNED URL’ to process multi-page PDF documents. Despite the internal stage being correctly set up with ‘SNOWFLAKE SSE’ encryption and the model build being published, they observe inconsistent results. Some documents result in a Received HTTP 403 response for presigned URL. URL may be expired.
error, while other documents (containing complex diagrams and dense text in an unsupported language like Korean) are processed, but the extracted information is often incomplete or inaccurate.
Which two factors are most likely contributing to these observed issues?

NEW QUESTION 22

Which of the following SQL snippets, when executed against a single invoice file like “invoice001 .pdf”, correctly extracts and transforms the desired data, assuming ‘json_content’ holds the raw Document AI output?

NEW QUESTION 23
An enterprise is deploying a new RAG application using Snowflake Cortex Search on a large dataset of customer support tickets. The operations team is concerned about managing compute costs and ensuring efficient index refreshes for the Cortex Search Service, which needs to be updated hourly. Which of the following considerations and configurations are relevant for optimizing cost and performance of the Cortex Search Service in this scenario?

NEW QUESTION 24
A financial institution wants to automate the extraction of key entities (e.g., invoice number, total amount, list of invoice items) from incoming PDF financial statements into a structured JSON format within their Snowflake data pipeline. The extracted data must conform to a specified JSON schema for seamless downstream integration. Which Snowflake Cortex capabilities, when combined, can best achieve this data augmentation and ensure schema adherence in a continuous processing pipeline?

NEW QUESTION 25
A data scientist has successfully deployed a Hugging Face sentence transformer model to Snowpark Container Services (SPCS) for GPU-powered inference, making it accessible via an HTTP endpoint. To ensure secure and proper programmatic access to this service from an external application, which of the following statements correctly describe the authentication and access control considerations for calling this public endpoint?

NEW QUESTION 26
A global analytics firm is developing a Retrieval Augmented Generation (RAG) system in Snowflake to answer customer queries across a large repository of technical documentation, which includes documents in English, German, and Spanish. They are looking to use a Snowflake Cortex embedding model to convert document chunks into vector embeddings for their Cortex Search Service. Which of the following considerations are critical when selecting an appropriate embedding model to optimize for both query relevance and cost-efficiency for their multilingual RAG application? (Select all that apply)

NEW QUESTION 27

NEW QUESTION 28
An organization has implemented a strict governance policy where the ‘ACCOUNTADMIN’ has set the ‘CORTEX MODELS ALLOWLIST’ to only permit ‘gemma-7b’ and ‘llama3.1-8b’ models. A developer then executes the following SQL statements in a Snowflake worksheet using ‘TRY COMPLETE (SNOWFLAKE.CORTEX)”. Assuming no specific RBAC model object grants are in place for the developer’s role, what would be the outcome of these queries? SELECT