SOL-C01 Question #129: Real Exam Question with Answer & Explanation

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.

Explanation

Options B, C, and D are the correct choices. Micro-batching (B) improves data loading efficiency by enabling parallel processing. Optimizing virtual warehouse sizing (C) ensures that the appropriate resources are allocated to different workloads, preventing resource contention and improving query performance. Analyzing query performance using Snowflake's Query Profile (D) allows you to identify and address specific bottlenecks in query execution. Option A is not a good practice as very small warehouses might take longer and increase the total cost. Option E is incorrect; you should enable the automatic query optimization instead.

No community discussion yet for this question.