Valid GES-C01 Dumps shared by EduDump.com for Helping Passing GES-C01 Exam! EduDump.com now offer the newest GES-C01 exam dumps, the EduDump.com GES-C01 exam questions have been updated and answers have been corrected get the newest EduDump.com GES-C01 dumps with Test Engine here:
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)
Correct Answer: A,B,E
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.