Write advanced T-SQL code
7 practice questions under this official exam objective (DP-800), each with the answer key, an option-by-option explanation and instant feedback.
Questions under this objective
7 total · page 1 of 1SQL Server REGEXP_REPLACE for Email Normalization
This question tests the ability to use regular expressions in T-SQL to normalize email addresses by removing subaddressing (the plus sign and everythi
How Do You Complete the REGEXP Phone Query for dbo.CustomerMessages?
This DP-800 drag-drop tests SQL Server 2025 REGEXP functions in a single SELECT over dbo.CustomerMessages. It establishes that RawNumber uses REGEXP_S
How Do You Return One Earliest Ticket per Customer per Day from JSON Data?
This hotspot item asks you to complete a T-SQL query over dbo.SupportTickets that returns exactly one row per customer per day — the earliest ticket —
SQL Server Scalar UDF vs Multi-Statement TVF Execution
Learn why EXEC fails for scalar UDFs and how multi-statement TVFs lead to inconsistent execution plans in SQL Server, with solutions using SELECT/SET
Optimizing JSON Queries with Computed Columns and Covering Indexes
Learn how to optimize SQL queries filtering JSON properties in Microsoft Fabric by creating persisted computed columns and covering indexes to elimina
How to Build a Patient Transaction Running Total in T-SQL for DP-800?
This DP-800 hotspot asks you to complete Transact-SQL that returns every transaction of a given patient between two dates with a running total, in a f
Querying Blocking Chains in Azure SQL with T-SQL
This scenario tests the ability to construct advanced T-SQL queries using dynamic management views (DMVs) to diagnose blocking issues in an OLTP envir