Snowflake
SOL-C01 · Question #205
You are tasked with classifying a large dataset of customer support tickets using Snowflake Cortex's CLASSIFY TEXT function. You need to ensure optimal performance and cost- effectiveness. Which of th
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #205. The question stem and answer options stay visible for context.
Querying and Performance
Question
You are tasked with classifying a large dataset of customer support tickets using Snowflake Cortex's CLASSIFY TEXT function. You need to ensure optimal performance and cost- effectiveness. Which of the following strategies would be MOST effective?
Options
- AUse a very large warehouse (e.g., X-LARGE) to execute the CLASSIFY _ TEXT function,
- BIncrease the parameter to a very high value to prevent query failures due to the long processing
- CProfile the execution time of CLASSIFY _ TEXT with different warehouse sizes and choose the
- DDisable auto-suspension on your warehouse to keep it running continuously while classifying the
- ELoad all customer support tickets into a single very wide row and classify that single row using
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Snowflake Cortex#Performance Tuning#Cost Optimization#Virtual Warehouses