Snowflake GES-C02 Certification Exam Sample Questions

GES-C02 Braindumps, GES-C02 Exam Dumps, GES-C02 Examcollection, GES-C02 Questions PDF, GES-C02 Sample Questions, SnowPro Specialty - Gen AI Dumps, SnowPro Specialty - Gen AI Official Cert Guide PDF, SnowPro Specialty - Gen AI VCE, Snowflake SnowPro Specialty - Gen AI PDFWe have prepared Snowflake SnowPro Specialty - Gen AI (GES-C02) certification sample questions to make you aware of actual exam properties. This sample question set provides you with information about the SnowPro Specialty - Gen AI exam pattern, question formate, a difficulty level of questions and time required to answer each question. To get familiar with Snowflake Certified SnowPro Specialty - Gen AI exam, we suggest you try our Sample Snowflake GES-C02 Certification Practice Exam in simulated Snowflake certification exam environment.

To test your knowledge and understanding of concepts with real-time scenario based Snowflake GES-C02 questions, we strongly recommend you to prepare and practice with Premium Snowflake SnowPro Specialty - Gen AI Certification Practice Exam. The premium Snowflake SnowPro Specialty - Gen AI certification practice exam helps you identify topics in which you are well prepared and topics in which you may need further training to achieving great score in actual Snowflake Certified SnowPro Specialty - Gen AI exam.

Snowflake GES-C02 Sample Questions:

01. A table claims.raw_extract stores the output of AI_EXTRACT, called without scores, in a VARIANT column ex. One field in the responseFormat was named policy_number. An analyst is writing a view that needs that value as a string column.
Which expression returns it?
a) ex:policy_number::STRING
b) ex:scoring:scores:policy_number::STRING
c) ex:response[0]:policy_number::STRING
d) ex:response:policy_number::STRING
 
02. A hotel group exposes its booking data to Cortex Analyst through a semantic view. The net_room_revenue metric is defined and calculates correctly, but revenue managers ask about "rooms income" and "lodging takings", and Analyst often fails to connect those phrases to the metric.
Which change to the semantic view most directly addresses this?
a) Add the managers' phrases as synonyms on that metric
b) Redefine net_room_revenue as a fact so that it is evaluated at row level instead of aggregated
c) Add a filter to the bookings logical table that keeps only completed and paid stays
d) Add the managers' phrases as sample_values on the booking date time dimension
 
03. A consumer electronics retailer must pick one of two Cortex-hosted models for drafting replies to product questions within the week. The reviewers are merchandising analysts who do not write code. They want to see both models answer the same sample questions side by side, try different temperature settings with Cortex Guard switched on, and then hand engineers the chosen configuration as SQL. No labeled set of approved replies exists yet.
What should the team use?
a) Set up AI Observability evaluation runs for both models and score their correctness against ground-truth replies
b) Compare both models side by side in Cortex Playground, then export the SQL
c) Have analysts edit a shared Snowflake Notebook that loops both models over the questions with AI_COMPLETE
d) Ask engineers to build a Streamlit in Snowflake app showing both replies
 
04. A rail operator's track inspectors complete paper forms that combine printed labels, tick boxes and handwritten remarks, and the forms are scanned to PDF. The operations lead assumes staff must first retype each form into a digital template before any Snowflake document function can use it.
Which statement corrects this assumption?
a) Tick boxes are read from scans, but handwriting is not
b) Scanned files are accepted once the stage uses server-side encryption, which enables OCR on them
c) AI_EXTRACT reads checkboxes and handwriting directly from scanned files
d) Handwritten remarks are read only after AI_TRANSLATE has converted them into typed text first
 
05. A freight forwarder has an existing Cortex Agent, SHIPMENT_HELPER, owned by the AI_ENG role. Its tools are a Cortex Search service over customs notes and a semantic view over shipment tables. Dispatchers, whose default role is DISPATCH, must be able to ask the agent questions.
DISPATCH already holds the SNOWFLAKE.CORTEX_AGENT_USER database role, USAGE on the dispatchers' default warehouse and on the relevant databases and schemas, and everything the semantic view tool requires.
Which grants does DISPATCH still need?
(Choose two.)
a) USAGE on the SHIPMENT_HELPER agent itself
b) MODIFY on the SHIPMENT_HELPER agent
c) USAGE on the warehouse the AI_ENG team uses for its own work
d) USAGE on the agent's Cortex Search service
 
06. A knowledge-base engineer at a software vendor must create a Cortex Search service over the ARTICLES table in schema SUPPORT.KB. The engineer's role, KB_ENG, holds SNOWFLAKE.CORTEX_USER, SELECT on ARTICLES (which has change tracking enabled), USAGE on the refresh warehouse, and USAGE on the database and schema. The CREATE CORTEX SEARCH SERVICE statement fails with an insufficient-privileges error on the schema.
Which grant resolves the failure?
a) GRANT CREATE MODEL ON SCHEMA support.kb TO ROLE kb_eng;
b) GRANT USAGE ON CORTEX SEARCH SERVICE support.kb.articles_search TO ROLE kb_eng;
c) GRANT CREATE CORTEX SEARCH SERVICE ON SCHEMA support.kb TO ROLE kb_eng;
d) GRANT DATABASE ROLE SNOWFLAKE.CORTEX_EMBED_USER TO ROLE kb_eng;
 
07. An energy trading firm has logged four models to the Snowflake Model Registry and is deciding where each will run inference. Warehouse inference is preferred wherever it is supported, because the scoring already runs inside scheduled SQL and stored procedures.
Which two models will need to be served through Snowpark Container Services instead of a warehouse?
(Choose two.)
a) A 3 GB gradient-boosted price model scored on CPU by an hourly stored procedure
b) A 22 GB transformer that classifies trader chat messages once nightly on CPU
c) A 2 GB anomaly model scored nightly in SQL across 40 million meter readings
d) A 4 GB image model for substation photos that requires a GPU to execute
 
08. A ferry operator's customer chat archive holds messages in many languages, and no column records which language each message is written in. An analyst wants every message rendered in English with one function call per row.
Which expression does this?
a) AI_TRANSLATE(msg_text, '', 'en')
b) AI_TRANSLATE(msg_text, 'en', '')
c) AI_TRANSLATE(msg_text, 'en')
d) AI_TRANSLATE(msg_text, 'auto', 'en')
 
09. A logistics company has written Python code that calls Cortex AI functions to answer dispatchers' questions about delayed shipments. It wants to give dispatchers a simple web interface for this, written in Python, with the app's code stored in Snowflake, access controlled by roles, and no separate web server or container image to build and maintain.
What should the team use to deliver the interface?
a) A Snowflake Notebook shared with the dispatchers' role so they can run its cells
b) A Streamlit in Snowflake app owned by the team's role
c) A Snowpark Container Services service with a public endpoint running a Python web framework
d) A semantic view for Cortex Analyst that dispatchers query from a Snowsight worksheet
 
10. A travel agency keeps 9,000 past customer emails and the replies its agents approved in trips.cx.reply_pairs, with columns email_text and approved_reply. An engineer is preparing the training-data query argument for a Cortex fine-tuning job and will not supply a separate validation query.
Which training-data query meets the fine-tuning requirements?
a) SELECT email_text AS user_prompt, approved_reply AS model_completion FROM trips.cx.reply_pairs
b) SELECT OBJECT_CONSTRUCT('prompt', email_text, 'completion', approved_reply) AS example FROM trips.cx.reply_pairs
c) SELECT email_text AS prompt, approved_reply AS completion FROM trips.cx.reply_pairs
d) SELECT email_text AS messages, approved_reply AS completion FROM trips.cx.reply_pairs WHERE approved_reply IS NOT NULL

Answers:

Question: 01
Answer: d		 Question: 02
Answer: a		 Question: 03
Answer: b		 Question: 04
Answer: c		 Question: 05
Answer: a, d
Question: 06
Answer: c		 Question: 07
Answer: b, d		 Question: 08
Answer: a		 Question: 09
Answer: b		 Question: 10
Answer: c

Note: Please update us by writing an email on feedback@vmexam.com for any error in Snowflake Certified SnowPro Specialty - Gen AI certification exam sample questions

Rating: 4.8 / 5 (114 votes)