DP-300 Certification Practice Question #183

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?

Accepted Answer

The T-SQL commands in the exhibit create standard rowstore indexes (clustered and nonclustered indexes) on `table1`. Traditionally, SQL Server's high-performance batch mode execution was exclusive to tables with columnstore indexes. Under SQL Server 2019 and Azure SQL Database, the Intelligent Query Processing feature "Batch Mode on Rowstore" (Option D) allows analytical queries on traditional rowstore tables to run in batch mode (processing up to 900 rows per batch) without needing a columnstore index, thereby significantly reducing query execution time.

More DP-300 practice questions