| 1 | What is In-Memory OLTP in SQL Server, and what performance benefit does it provide? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Beginner |
| 2 | How does the concurrency model of In-Memory OLTP differ from traditional disk based tables, and why does this improve performance? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Intermediate |
| 3 | What SQL Server edition requirements exist for using In-Memory OLTP features? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Intermediate |
| 4 | Does data stored in a memory optimized table get lost if the SQL Server instance restarts? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Beginner |
| 5 | What are natively compiled stored procedures, and how do they work together with memory optimized tables? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Intermediate |
| 6 | How would you decide whether a specific table in your application is a good candidate for conversion to a memory optimized table? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Advanced |
| 7 | What migration steps and limitations should you consider when converting an existing disk based table to a memory optimized table? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Advanced |
| 8 | What are the main differences between SQL Server Express, Standard, and Enterprise editions? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Beginner |
| 9 | What is a hash index, and how is it different from the more common B-tree index used for regular disk based tables? SQL Server › Hash Indexes & Hash Join Operations | SQL Server | Hash Indexes & Hash Join Operations | Beginner |
| 10 | What kinds of workloads benefit the most from columnstore indexes, and which workloads should avoid them? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Intermediate |
| 11 | What is the difference between an optimistic and a pessimistic approach to handling concurrency, and where does SQL Server's snapshot isolation fit into this? SQL Server › Isolation & Locking | SQL Server | Isolation & Locking | Intermediate |
| 12 | How does SQL Server's memory architecture work, particularly regarding the buffer pool and how it affects performance? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Intermediate |
| 13 | How does the BUCKET_COUNT setting affect the performance of a hash index on a memory optimized table? SQL Server › Hash Indexes & Hash Join Operations | SQL Server | Hash Indexes & Hash Join Operations | Intermediate |
| 14 | What are the differences in how a hash index and a memory optimized nonclustered index handle range queries and equality lookups? SQL Server › Hash Indexes & Hash Join Operations | SQL Server | Hash Indexes & Hash Join Operations | Intermediate |
| 15 | What are the licensing implications and cost considerations when choosing between SQL Server editions for a growing company? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Advanced |