A data engineering team is setting up a Retrieval Augmented Generation (RAG) application using Snowflake Cortex Search to provide contextual answers from customer support transcripts. The transcripts are stored in a Snowflake table named SUPPORT _ TRANSCRIPTS. Which of the following statements are crucial considerations or accurate facts regarding the initial setup and configuration of the Cortex Search Service for this use case?
Correct Answer: A,D,E
Option A is correct because change tracking is required for the Cortex Search Service to monitor updates to the base table. Option B is incorrect; Snowflake recommends using a dedicated warehouse no larger than MEDIUM for each service, as larger warehouses do not necessarily increase performance for index materialization. Option C is incorrect because columns in the ATTRIBUTES field must be included in the source query. Options D and E are correct as Cortex Search provides low-latency, high-quality hybrid (vector and keyword) search, handling underlying complexities, and is primarily used as a RAG engine for LLM chatbots leveraging semantic search.