Write advanced T-SQL code
5 practice questions under this official exam objective (DP-800) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
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 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 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