DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ51

VerifiedMonitor and optimize an analytics solution

You have a Fabric workspace that includes a write-intensive warehouse named DW1. DW1 contains staging tables used to load a dimensional model. The tables are frequently read once, dropped, and recreated to process new data.

You need to minimize DW1 load time.

What should you do?

Explanation

V-Order is a write-time Parquet optimization that improves read performance but adds ingestion overhead. For a write-intensive staging warehouse whose tables are read only once and then dropped and recreated, disabling V-Order reduces ingestion time and can shorten the overall load process.

Learn more

Community Discussion

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