Free Snowflake GES-C01 Practice Test & Real Exam Questions

A Snowflake administrator needs to implement a granular access control strategy for LLMs. The general policy is to restrict access to a select few models via an account-level allowlist. However, a specific data science team (using role 'DATA SCIENCE TEAM ROLE) requires access to the 'claude-3-5-sonnet' model, which should not be available to other users or globally via the allowlist. Given this scenario, which set of commands would correctly establish this access control while adhering to the specified requirements?

A data science team is implementing a large-scale Retrieval Augmented Generation (RAG) application on Snowflake, using 'SNOWFLAKE.CORTEX.EMBED TEXT 1024' to process millions of customer support tickets for semantic search. The goal is to achieve high retrieval quality and manage costs effectively. Which of the following are recommended practices and accurate cost/performance considerations when leveraging 'EMBED TEXT 1024' in this scenario? (Select all that apply)

A data engineering team is setting up an automated pipeline to extract information from new invoices using Document AI. They've created a database and schema Cinvoice_db.invoice_schema') and a Document AI model build ('invoice_extractor'). They then created an internal stage for documents. When they attempt to run the 'invoice_extractor!PREDlCT' method on documents uploaded to 'invoice_stage' , they consistently receive the following error:

Given this error message, which 'corrective SQL command' addresses the most likely misconfiguration of the 'invoice_stage' to allow Document AI processing?

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?

A Gen AI Specialist in Snowflake Cortex aims to fine-tune an LLM for enhanced task-specific performance. When creating a fine-tuning job using SNOWFLAKE. CORTEX. FINETUNE( 'CREATE', ... ) , which statement accurately describes the required training data format and a supported base model, aligning with Snowflake's Gen AI principles for leveraging LLMs?

A Gen AI developer is implementing a Cortex Search Service for a RAG application and needs to configure the text splitting for optimal performance using SNOWFLAKE.CORTEX.SPLIT_TEXT_RECURSIVE_CHARACTER Which of the following statements represent best practices or outcomes when applying text splitting with this function for Cortex Search in a RAG scenario? (Select all that apply)

A multi-national corporation uses Snowflake across several AWS regions. Their primary operational Snowflake account is in AWS US East (Ohio), but they need to leverage a specific AI_COMPLETE model, llama4-maverick, which is natively available in AWS US East 1 (N. Virginia) but not in US East (Ohio). To address this, the Snowflake administrator enables cross-region inference for their US East (Ohio) account.

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?

An administrator is reviewing their Snowflake bill and observes higher than expected storage and cloud services compute costs for a newly deployed Cortex Search Service. They need to investigate these charges. Which of the following statements correctly explains how these specific costs are incurred or can be monitored for a Cortex Search Service?

A data pipeline processes thousands of scanned legal contracts daily using a Document AI model via the '!PREDICT function. The process involves fetching presigned URLs for documents from an internal stage using 'GET PRESIGNED URL'. Recently, the pipeline has started failing intermittently, returning the error:

The data engineering team confirms network connectivity and privileges are stable. Which of the following is the most likely cause of this issue?

A data operations team is attempting to scale up their Document AI automated pipeline. They are using a Snowflake Task to process a large volume of daily scanned invoices and receipts, which are stored in an internal stage 'financial_docs stage'. The current processing involves documents that are frequently around 75 MB each, and often there are batches exceeding 1 ,200 documents in a single day. The pipeline is failing consistently. Which of the following factors could be contributing to the failures in this Document AI automated pipeline? (Select all that apply.)