| 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 |