Which of the following statements is true about Dataflow Gen2 in Microsoft Fabric?

• A. Dataflow Gen2 supports both append and replace update methods for all the destinations
• B. Dataflow Gen2 only supports structured data sources
• C. Dataflow Gen2 allows defining transformations visually, but it automatically generated M query in the background
• D. Unlike Power BI Dataflows, Dataflow Gen2 relies solely on SQL-based transformations

Answer: (C)

Dataflow Gen2 in Microsoft Fabric lets you build data transformations with a visual interface while the system generates the underlying M (Power Query) code in the background. You can design steps visually, and the engine translates those steps into M queries that run to produce the transformed data. This blend of a user-friendly, drag‑and‑drop experience with the power and flexibility of M code is what makes that statement the correct one. It’s not limited to structured sources, it doesn’t rely solely on SQL-based transformations, and the update methods for destinations aren’t described as universal across all targets, so those options don’t fit as accurately.