Snowflake
SOL-C01 · Question #129
You are managing a Snowflake environment that ingests data from various sources, including structured data (CSV files) and semi-structured data (JSON files). You notice that query performance is degra
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #129. The question stem and answer options stay visible for context.
Querying and Performance
Question
You are managing a Snowflake environment that ingests data from various sources, including structured data (CSV files) and semi-structured data (JSON files). You notice that query performance is degrading over time, particularly on tables containing both types of dat
Options
- AYou suspect that inefficient data loading practices and suboptimal virtual warehouse configurations
- BConsistently use the smallest virtual warehouse size possible for all data loading tasks to minimize
- CImplement micro-batching for data loading, breaking down large files into smaller chunks for
- DOptimize the virtual warehouse sizing for different workloads, using larger warehouses for complex
- ERegularly analyze query performance using Snowflake's Query Profile and identify areas for
- FDisable automatic query optimization to have more control over query execution plans.
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
#Virtual Warehouse Sizing#Query Performance Optimization#Data Loading Practices#Micro-batching