Exam GES-C01 Topic 1 Question 182 Discussion
Actual exam question for Snowflake's GES-C01 exam
Question #: 182
Topic #: 1
Question #: 182
Topic #: 1
A financial analytics team is using to extract specific financial metrics (e.g., revenue, profit margin) from quarterly reports and requires the output in a strict JSON format for automated ingestion into a data warehouse. They've encountered issues where the LLM sometimes generates malformed JSON or includes extraneous text. Which of the following approaches will help ensure deterministic, schema-compliant JSON outputs and mitigate these 'hallucinations' related to format?


Suggested Answer: A,B,C,D Vote an answer
Option A is correct because 'AI_COMPLETE Structured Outputs allows supplying a JSON schema via the 'response_format' argument, which defines the structure, data types, and constraints, ensuring responses conform to the schema and reducing post-processing. Option B is correct as it specifically states requirements for OpenAI (GPT) models when using 'response_format' , including 'additionalProperties: false' and explicitly listing all properties in the 'required' field. Option C is correct because, for medium-to-complex tasks, adding 'Respond in JSON' to the prompt can further improve JSON adherence accuracy, even when 'response_format' is specified. Option D is correct as setting 'temperature' to 0 is recommended for the most consistent results, which is crucial for deterministic JSON outputs, regardless of task or model. Option E is incorrect because 'CLASSIFY_TEXT is for categorizing text, not for validating JSON structure, making it an inappropriate tool for this task.
by Maxine at Jul 10, 2026, 10:54 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).