| 1 | What are the main components that make up the SQL Server architecture, and what role does each one play? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Beginner |
| 2 | 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 |
| 3 | 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 |
| 4 | 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 |
| 5 | What is tempdb, and why is its configuration particularly important for overall SQL Server performance? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Intermediate |
| 6 | How does SQL Server on Linux differ architecturally from the traditional Windows based installation, and what should teams consider before choosing it? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Intermediate |
| 7 | How would you plan a hardware and configuration strategy for a new SQL Server installation supporting a large, performance critical application? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Advanced |
| 8 | What is the difference between a SQL Server login and a database user? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Beginner |
| 9 | What is the difference between Windows Authentication and SQL Server Authentication? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Beginner |
| 10 | What is the performance overhead comparison between SQL Server Profiler, server side traces, and Extended Events, and how should this inform monitoring decisions on a production system? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Advanced |