SnowPro Advanced: Data Engineer — Question 110

A Data Engineer needs to optimize the performance and minimize the costs of a dynamic table pipeline in Snowflake. The Engineer wants to monitor and separate the dynamic table costs prior to transferring the table refresh processing to a shared virtual warehouse.

How should the Engineer meet these requirements?

Answer options

• A. Use a shared virtual warehouse to test the performance of the dynamic table refresh process and monitor the costs for all workloads.
• B. Before moving the table, test the process on a dedicated virtual warehouse to establish a cost baseline.
• C. Execute the dynamic tables on multiple virtual warehouses simultaneously to distribute the load equally.
• D. Set up the dynamic tables directly on a production virtual warehouse to obtain real-time cost insights.

Correct answer: B

Explanation

The correct answer is B because testing the process on a dedicated virtual warehouse allows the Engineer to accurately measure costs without interference from other workloads. Option A is incorrect as it mixes workloads in a shared warehouse, making it hard to isolate costs. Option C may help with load distribution but does not address cost monitoring effectively. Option D risks affecting production performance and does not provide a controlled environment for cost analysis.