DP-300 · Question #292
DP-300 Question #292: Real Exam Question with Answer & Explanation
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
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
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.