A data pipeline runs a series of transformations on a Medium warehouse. The pipeline is taking longer than expected, and the team suspects that the warehouse is not large enough for the workload. They want to confirm this before increasing the warehouse size. Which metric would best indicate that the warehouse is undersized?

High number of disk spills in query profiles

High percentage of time spent in queuing

Low CPU utilization on the warehouse

High ratio of credits consumed to bytes scanned

SnowflakeSnowPro Advanced — Data Engineer

Domain 3Objective 3

Optimize Data Pipelines DEA-C02 Practice Questions (Page 4)

Part of the Performance Optimization domain, which accounts for 21% of the DEA-C02 exam.

16questions here

4free pages

4concepts

21%of the exam

Questions 16–16

16application · medium
A data pipeline runs a series of transformations on a Medium warehouse. The pipeline is taking longer than expected, and the team suspects that the warehouse is not large enough for the workload. They want to confirm this before increasing the warehouse size. Which metric would best indicate that the warehouse is undersized?
Select an answer first

Finished these 1 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DEA-C02

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “DEA-C02” is a trademark of its owner, used for identification only.

Optimize Data Pipelines DEA-C02 Practice Questions (Page 4)

Questions 16–16

Keep studying — Performance Optimization