SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ10

Design and Manage Snowflake Resources and Performance

A Data Engineer must optimize performance and reduce the costs of a Snowflake dynamic-table pipeline. The Engineer wants to monitor and isolate dynamic-table costs before moving the table-refresh processing to a shared virtual warehouse.

How should the Engineer satisfy these requirements?

Explanation

A dedicated virtual warehouse isolates dynamic-table refresh consumption from other workloads, allowing refresh performance and credit usage to be monitored accurately and a cost baseline to be established. The dynamic tables can then be moved to a shared warehouse.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!