Question

You are building a query in the Visual Query Editor of a Fabric Warehouse SQL analytics endpoint. Business users need a preview limited to sales transactions from the current fiscal quarter where the order status is 'Completed'. You want to reduce the number of rows returned before any grouping or joining steps, using the low-code interface rather than writing raw SQL. Which Visual Query Editor action should you apply first?

Accepted Answer

Add a 'Filter rows' step with conditions on OrderDate within the quarter range and Status equals 'Completed'

Answer

Add a 'Group by' step on Status and then keep only the 'Completed' group

Answer

Add a 'Merge queries' step to join the sales table to a calendar table and drop unmatched rows

Answer

Add a 'Keep top rows' step to return the first 1000 rows of the table