Exam GES-C01 Topic 1 Question 21 Discussion

Actual exam question for Snowflake's GES-C01 exam
Question #: 21
Topic #: 1

A data engineer is building an AI data pipeline to automatically extract specific sentiment categories from customer reviews using 'AI_COMPLETE. They want the output to be a structured JSON object containing 'food_quality', 'food_taste', 'wait_time', and 'food cost' with their respective sentiments (e.g., 'positive', 'negative', 'neutral'). The engineer aims for high accuracy and ensures that all these fields are present in the output. Which of the following statements correctly describe the approach to achieve this?

A. The 'response_format' argument in 'AI COMPLETE should specify a JSON schema, and to ensure all fields are present, the 'required' field must be explicitly set for all desired properties in the schema. B. For optimal accuracy in structured output, it is always best to explicitly instruct the LLM within the prompt to 'Respond in JSON' and provide a detailed description of the schema, regardless of task complexity. C. When using OpenAl (GPT) models for structured output, the 'additionalPropertieS field must be set to 'true' in every node of the schema to allow for flexibility in the generated JSON. D. To improve accuracy, the JSON schema should include detailed descriptions for each field (e.g., 'food_quality', 'food_taste') to guide the model more precisely in identifying and extracting the sentiments. E. The 'temperature' option should be set to a high value (e.g., 0.9) in the 'CompleteOptionS to encourage the model to strictly adhere to the specified JSON schema and reduce non-deterministic responses.

Suggested Answer: A,D Vote an answer

Option A is correct. The argument is used to supply a JSON schema that completion responses must follow, and including the 'required' field in the schema ensures that specified fields are present in the output, with raising an error if a required field cannot be extracted. Option B is incorrect. While prompting the model to 'Respond in JSON' can improve accuracy for complex tasks, it is not always necessary for simple tasks, as 'AI_COMPLETE Structured OutputS already understands that its response should conform to the specified schema. Option C is incorrect. For OpenAl (GPT) models, the 'additionalPropertieS field must be set to 'false' in every node of the schema. Option D is correct. Providing detailed descriptions of the fields to be extracted helps the model more accurately identify them, thereby improving the quality of the structured output. Option E is incorrect. For the most consistent results, it is recommended to set the 'temperature' option to 0 when calling 'COMPLETE (or regardless of the task or model, to make the output more deterministic and focused.

by Beck at Aug 10, 2026, 04:00 AM

Limited Time Offer

15%

Off

Get Premium GES-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business