You have an Azure subscription that contains an Azure SQL database. The database contains a table named table1. You execute the following Transact-SQL statements. You need to reduce the time it takes

The correct answer is D. BATCH_MODE_ON_ROWSTORE. This feature, Batch Mode on Rowstore, allows all operators enabled for batch mode to operate as such in SQL Server. What does this mean? It means that query operations can process data faster, more efficiently and mimic what makes columnstore so fast. Instead of reading row by ro

Submitted by brentm· Mar 6, 2026Optimize query performance

Question

You have an Azure subscription that contains an Azure SQL database. The database contains a table named table1. You execute the following Transact-SQL statements. You need to reduce the time it takes to perform analytic queries on the database. Which configuration should you enable?

Options

AROW_MODE_MEMORY_GRANT_FEEDBACK
BBATCH_MODE_MEMORY_GRANT_FEEDBACK
CBATCH_MODE_ADAPTIVE_JOINS
DBATCH_MODE_ON_ROWSTORE

How the community answered

(54 responses)

A
6% (3)
B
4% (2)
C
11% (6)
D
80% (43)

Explanation

This feature, Batch Mode on Rowstore, allows all operators enabled for batch mode to operate as such in SQL Server. What does this mean? It means that query operations can process data faster, more efficiently and mimic what makes columnstore so fast. Instead of reading row by row (row store mode) it can read in chunks i.e. batches of 900 rows at a time. The performance impact of this can be tremendous which effectively uses CPU more efficiently. https://sqlespresso.com/2020/06/16/what-is-batch-mode-on-rowstore-in-sql-server/

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice