A data engineering team is optimizing an AI-infused pipeline that processes millions of rows of customer interaction data in a LOG_DATA table using various Snowflake Cortex AI functions. They need to accurately estimate costs and ensure optimal performance. Which of the following statements regarding cost, performance, and operational considerations for these functions are true?
A financial services company is developing an automated data pipeline in Snowflake to process Federal Reserve Meeting Minutes, which are initially loaded as PDF documents. The pipeline needs to extract specific entities like the FED's stance on interest rates ('hawkish', 'dovish', or 'neutral') and the reasoning behind it, storing these as structured JSON objects within a Snowflake table. The goal is to ensure the output is always a valid JSON object with predefined keys. Which AI_COMPLETE configuration, used within an in-line SQL statement in a task, is most effective for achieving this structured extraction directly in the pipeline?
A data engineer is designing an automated pipeline to process customer feedback comments from a 'new_customer_reviews' table, which includes a 'review_text' column. The pipeline needs to classify each comment into one of three predefined categories: 'positive', 'negative', or 'neutral', and store the classification label in a new 'sentiment_label' column.
Which of the following statements correctly describe aspects of implementing this data transformation using 'SNOWFLAKE.CORTEX.CLASSIFY_TEXT' in a Snowflake pipeline?
A development team is preparing to deploy a new Retrieval-Augmented Generation (RAG) application written in Python. They intend to use Snowflake AI Observability with the TruLens SDK to capture detailed logs and traces for debugging and performance analysis. Which of the following configurations are essential prerequisites for enabling this logging capability effectively?
A data engineering team is setting up an automated pipeline in Snowflake to process call center transcripts. These transcripts, once loaded into a raw table, need to be enriched by extracting specific entities like the customer's name, the primary issue reported, and the proposed resolution. The extracted data must be stored in a structured JSON format in a processed table. The pipeline leverages a SQL task that processes new records from a stream. Which of the following SQL snippets and approaches, utilizing Snowflake Cortex LLM functions, would most effectively extract this information and guarantee a structured JSON output for each transcript?
