Practice Questions · Part 7
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
SnowPro Core COF-C03 Study GuidePart 7: AI featuresPractice Questions: Part 7
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
A support team wants every ticket labeled with one of five product areas, which it supplies as a list. The team doesn't want to write a prompt or choose a model. Which function fits?
AI_CLASSIFY with the five areas passed as categoriesAI_EMBED, then AI_SIMILARITY against each areaAI_SENTIMENT with the five areas passed as categoriesAI_COMPLETE with a prompt that lists the five areasIn an account that still has its default settings, any role can call AI_COMPLETE. Which two grants held by PUBLIC make this possible? (Choose two.)
SNOWFLAKE.CORTEX_USER database roleSNOWFLAKE.AI_FUNCTIONS_USER database roleSNOWFLAKE.CORTEX_EMBED_USER database roleA team replaces SNOWFLAKE.CORTEX.SENTIMENT with AI_SENTIMENT in a dashboard query. The dashboard expected a number between -1 and 1. What does AI_SENTIMENT return instead?
AI_SIMILARITYA query running on warehouse BI_WH calls AI_COMPLETE once for each of 10,000 rows. Which charges does this produce?
A nightly job runs AI_CLASSIFY over 2 million rows on an X-Large warehouse. What does Snowflake recommend for the warehouse?
Which two statements about how Cortex AI Functions are billed are correct? (Choose two.)
AI_CLASSIFY bills only input tokens, since it returns a label.AI_COMPLETE counts both input and output tokens.AI_EMBED counts only input tokens.A FinOps lead wants an email when the account's total spend for the month, including AI functions and other serverless features, is projected to exceed 20,000 credits. Which feature fits?
A regulated company requires that its prompts to AI functions be processed only in the account's home region. What should the account administrator set?
CORTEX_ENABLED_CROSS_REGION = 'DISABLED'CORTEX_ENABLED_CROSS_REGION = 'AWS_US'CORTEX_ENABLED_CROSS_REGION = 'ANY_REGION'Where do the large language models behind Snowflake's AI functions run when a call to AI_COMPLETE is processed?
A company stores 50,000 help-center articles as text in a table. It wants a chat app that finds the most relevant passages for each user's question before an LLM writes the answer. Which feature provides the retrieval step?
AI_AGG over the article column, called for each questionWhich three are cost components of a Cortex Search service? (Choose three.)
Role SUPPORT holds USAGE on Cortex Search service KB_SEARCH and on its database and schema, but no privilege on the source table. A row access policy on that table would hide half of its rows from SUPPORT. What can SUPPORT's searches return?
What does TARGET_LAG = '1 hour' control on a Cortex Search service?
How is Cortex Analyst billed?
A team is starting a new Cortex Analyst project. Where does Snowflake recommend declaring the tables, joins, metrics and synonyms that Analyst uses?
Given privileges on the underlying objects, which two database roles each let a role use Cortex Analyst? (Choose two.)
SNOWFLAKE.CORTEX_USERSNOWFLAKE.GOVERNANCE_VIEWERSNOWFLAKE.CORTEX_ANALYST_USERSNOWFLAKE.COPILOT_USERSNOWFLAKE.USAGE_VIEWERAnalysts with role EU_FIN use a Cortex Analyst app that runs the generated SQL in the analyst's own session. Table REFUNDS has a row access policy that returns only European rows to EU_FIN. An analyst asks for total refunds by region. What do the results include?
What does Cortex Analyst use to generate SQL for a user's question?
A pipeline calls invoice_model!PREDICT on a Document AI model build to pull vendor, amount and due date from PDF invoices. What is Snowflake's documented replacement?
AI_EXTRACT, with the fields in its responseFormatAI_PARSE_DOCUMENT in LAYOUT mode on each fileAI_CLASSIFY, with the fields passed as categoriesHow does a data engineer tell AI_EXTRACT which values to pull from each document?
Which two pairings of a job and a Snowflake feature are correct? (Choose two.)
AI_EXTRACTA team wants the full text of scanned contracts, with headings and tables kept in reading order, so it can split them into chunks for a Cortex Search service. Which function fits?
AI_PARSE_DOCUMENT in LAYOUT mode on each contractAI_PARSE_DOCUMENT in OCR mode on each contractAI_TRANSCRIBE on each scanned page of the contractsAI_EXTRACT with one question for each headingWhich two statements about Cortex Code (CoCo) in Snowsight are correct? (Choose two.)
Which statement about Snowflake's ML functions, such as SNOWFLAKE.ML.FORECAST, is correct?
An operations team wants each day's order count flagged when it falls outside the range its history predicts, with a lower and an upper bound for each day. Which feature fits?
SNOWFLAKE.ML.CLASSIFICATIONAI_FILTER over the order tableSNOWFLAKE.ML.ANOMALY_DETECTIONSNOWFLAKE.ML.FORECASTTraining an ANOMALY_DETECTION model on a single series of 40 million rows runs out of memory on a standard warehouse. What does Snowflake suggest?
Which two statements about AI_AGG are correct? (Choose two.)
Which statement about AI_FILTER is correct?
Which two functions require the caller to name a model? (Choose two.)
AI_SENTIMENTAI_FILTERAI_COMPLETEAI_TRANSLATEAI_EMBEDA FinOps analyst needs last month's AI function credits broken down by function, model and user. Which source answers this?
SNOWFLAKE.ACCOUNT_USAGE.QUERY_ACCELERATION_HISTORYSNOWFLAKE.ACCOUNT_USAGE.CORTEX_AI_FUNCTIONS_USAGE_HISTORYSNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORYSNOWFLAKE.ACCOUNT_USAGE.METERING_DAILY_HISTORYFinish this set to count it as done.