| 1 | What is the principle of least privilege, and how should it guide how you grant permissions in SQL Server? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Intermediate |
| 2 | How would you design a comprehensive security auditing strategy to track who accessed or modified sensitive data in a SQL Server database? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Advanced |
| 3 | 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 |
| 4 | What is the difference between Windows Authentication and SQL Server Authentication? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Beginner |
| 5 | How do database roles help simplify managing permissions for multiple users with similar access needs? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Intermediate |
| 6 | How do you grant and revoke specific permissions, such as SELECT or EXECUTE, on individual database objects rather than through broader roles? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Intermediate |
| 7 | How do you implement row level security to restrict which specific rows a user can see within a shared table, beyond simply controlling access to entire tables or columns? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Advanced |
| 8 | What security considerations should be kept in mind when configuring the account that SQL Server Agent jobs run under? SQL Server › SQL Server Agent & Job Scheduling | SQL Server | SQL Server Agent & Job Scheduling | Intermediate |
| 9 | What is a linked server in SQL Server, and why would you set one up? SQL Server › Linked Servers | SQL Server | Linked Servers | Beginner |
| 10 | What are the security considerations when configuring authentication for a linked server connection? SQL Server › Linked Servers | SQL Server | Linked Servers | Intermediate |
| 11 | What is SQL injection, and how does it relate to writing dynamic SQL unsafely? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Beginner |
| 12 | How do you safely use sp_executesql to execute dynamic SQL with parameters, avoiding the risks of simple string concatenation? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Intermediate |
| 13 | How would you build a dynamic SQL query where the table or column names themselves need to change based on input, since parameters cannot be used for object names? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Intermediate |
| 14 | How do you test and verify that a linked server connection is working correctly after it has been configured? SQL Server › Linked Servers | SQL Server | Linked Servers | Intermediate |
| 15 | What is dynamic data masking in SQL Server, and what problem does it solve? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Beginner |
| 16 | What built-in masking functions are available in SQL Server for dynamic data masking? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Beginner |
| 17 | What is a view in SQL Server, and what benefits does it provide? SQL Server › Views | SQL Server | Views | Beginner |
| 18 | What is the difference between using EXEC and calling a stored procedure through parameterized application code, and why does this distinction matter for security? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Intermediate |
| 19 | How do you use a view to help enforce a basic level of security by limiting which columns or rows different groups of users can see? SQL Server › Views | SQL Server | Views | Intermediate |
| 20 | What is the difference between what Transparent Data Encryption protects against compared to Dynamic Data Masking? SQL Server › Transparent Data Encryption | SQL Server | Transparent Data Encryption | Beginner |
| 21 | How do you grant a specific user or role permission to see the real, unmasked data despite dynamic data masking being applied? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Intermediate |
| 22 | Does dynamic data masking prevent a determined user from working around it to see the real underlying values? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Intermediate |
| 23 | How do you remove dynamic data masking from a column once it is no longer needed? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Intermediate |
| 24 | What is the hierarchy of encryption keys and certificates involved in setting up Transparent Data Encryption? SQL Server › Transparent Data Encryption | SQL Server | Transparent Data Encryption | Intermediate |
| 25 | Why is it critically important to back up the certificate used for Transparent Data Encryption, and what happens if it is lost? SQL Server › Transparent Data Encryption | SQL Server | Transparent Data Encryption | Intermediate |
| 26 | How do you check whether Transparent Data Encryption is currently enabled on a specific database? SQL Server › Transparent Data Encryption | SQL Server | Transparent Data Encryption | Intermediate |
| 27 | How would you apply dynamic data masking to an existing table with sensitive columns as part of a broader compliance initiative, such as meeting data privacy regulations? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Advanced |
| 28 | How does dynamic data masking behave differently when a masked column is used in a JOIN, WHERE clause, or exported through an application, compared to a simple SELECT query? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Advanced |
| 29 | How would you design a layered set of views to progressively simplify a complex data model for different types of users, such as analysts versus casual business users? SQL Server › Views | SQL Server | Views | Advanced |