Exam GES-C01 Topic 1 Question 98 Discussion

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

A data engineer is tasked with defining a semantic model for Cortex Analyst to enable natural language queries over sales dat a. They are creating a YAML file to describe the logical structure. Which of the following statements correctly describe the configuration of this semantic model? (Select all that apply)

A. The 'tables' section must define logical tables that directly map to Snowflake physical tables or views, with 'base_table' specifying the fully qualified name (database, schema, table). B. Dimensions such as 'product_category' can include a configuration, which can specify an optional 'literal_column' that, if omitted, defaults to the search index column. C. The 'VARIANT data type is a supported data type for columns defined as 'dimensions' or 'facts' within the semantic model, allowing flexible storage of complex attributes. D. To ensure high accuracy for specific common questions, 'verified_querieS can be included, where the 'sqr field must reference the underlying physical table and column names (ee.g., not the logical names defined in the semantic model. E. A 'metric' like 'total_revenue' can be defined using an 'expr' that references other logical columns, such as 'sum(profity from a logical 'sales_data' table, within the semantic model.

Suggested Answer: A,B,E Vote an answer

Option A is correct. A logical table, a foundational concept of Snowflake's semantic model, represents either a physical database table or a view and its 'base_table' field specifies the fully qualified name of the underlying physical table. Option B is correct. Dimensions can specify a block to integrate with Cortex Search, and the 'literal_column' field within this block is optional and defaults to the search index. Option C is incorrect. The 'VARIANT, 'OBJECT, GEOGRAPHY' , and 'ARRAY' data types are explicitly not supported for dimensions, time dimensions, or facts within a semantic model. Option D is incorrect. Verified queries must use the names of the logical tables and columns as defined in the semantic model, not those in the underlying physical dataset. For example, sales_data' for a logical table named 'sales_data'. Option E is correct. Metrics can be defined using an SQL expression ('expr') that can reference logical columns (facts, dimensions, or time dimensions) within the same logical table or from another logical table in the semantic model.

by Hardy at May 12, 2026, 09:28 AM

Limited Time Offer

15%

Off

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

Comments

Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

RECENT DISCUSSIONS

Useful Links

Contact Us

Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday

Support: Contact now

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Disclaimer:
Actual4test doesn't offer Real SANS and GIAC Exam Questions.
Oracle and Java are registered trademarks of Oracle and/or its affiliates
Actual4test material do not contain actual actual Oracle Exam Questions or material.
Actual4test doesn't offer Real Microsoft Exam Questions.
Microsoft®, Azure®, Windows®, Windows Vista®, and the Windows logo are registered trademarks of Microsoft Corporation
Actual4test Materials do not contain actual questions and answers from Cisco's Certification Exams. The brand Cisco is a registered trademark of CISCO, Inc
CFA Institute does not endorse, promote or warrant the accuracy or quality of these questions. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Actual4test does not offer exam dumps or questions from actual exams. We offer learning material and practice tests created by subject matter experts to assist and help learners prepare for those exams. All certification brands used on the website are owned by the respective brand owners. Actual4test does not own or claim any ownership on any of the brands.