| 1 | 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 |
| 2 | 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 |
| 3 | 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 |
| 4 | How do you request runtime permissions in MAUI? .NET MAUI › Platform Integration & Handlers | .NET MAUI | Platform Integration & Handlers | Intermediate |
| 5 | How do you configure platform requirements for maps (API keys, permissions)? .NET MAUI › Maps & Location | .NET MAUI | Maps & Location | Intermediate |
| 6 | How do you request runtime permissions in MAUI? .NET MAUI › Platform Integration & Handlers | .NET MAUI | Platform Integration & Handlers | Intermediate |
| 7 | How do you configure platform requirements for maps (API keys, permissions)? .NET MAUI › Maps & Location | .NET MAUI | Maps & Location | Intermediate |
| 8 | What permissions are needed to manage ApplicationSets? ArgoCD › RBAC | ArgoCD | RBAC | Intermediate |
| 9 | How do you create a Redis ACL user with permissions restricted to only specific commands and a specific pattern of keys? Redis › Redis Security & ACL | Redis | Redis Security & ACL | Intermediate |
| 10 | What are Redis ACL categories, and how do they simplify granting permissions for groups of related commands? Redis › Redis Security & ACL | Redis | Redis Security & ACL | Intermediate |
| 11 | How can you control access permissions for files and directories stored in EFS? AWS › Amazon EFS (Elastic File System) | AWS | Amazon EFS (Elastic File System) | Intermediate |
| 12 | How do IAM policies use the combination of effect, action, resource, and condition elements to precisely define permissions? AWS › IAM | AWS | IAM | Intermediate |
| 13 | How do you properly request and handle runtime camera and photo library permissions in a Flutter app, and what happens if a user denies that permission? Flutter › Camera & Media Handling in Flutter | Flutter | Camera & Media Handling in Flutter | Intermediate |
| 14 | How should you properly and correctly handle requesting location permissions across the several genuinely different possible permission states, including denied, granted, and permanently denied, using the geolocator or permission_handler packages? Flutter › Maps & Geolocation in Flutter | Flutter | Maps & Geolocation in Flutter | Intermediate |
| 15 | How do you grant fine-grained permissions like sync but not delete? ArgoCD › RBAC | ArgoCD | RBAC | Advanced |
| 16 | How do you audit and troubleshoot effective permissions for a user? ArgoCD › RBAC | ArgoCD | RBAC | Advanced |
| 17 | How would you model a set of flags/permissions using a numeric enum with bitwise values, and how do you check if a flag is set? TypeScript › Enums | TypeScript | Enums | Advanced |
| 18 | How do you implement resource-based authorization, where the authorization decision depends on the specific object being accessed, not just the user's general permissions? ASP.NET Core › Authorization | ASP.NET Core | Authorization | Advanced |
| 19 | How would you design an authorization system supporting dynamically-configurable, admin-managed permissions rather than hardcoded policies in code? ASP.NET Core › Authorization | ASP.NET Core | Authorization | Advanced |
| 20 | What is the principle of least privilege, and how should it guide decisions about database user permissions and environment configuration in a PHP application? PHP › Security | PHP | Security | Advanced |
| 21 | 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 |
| 22 | What is the difference between Windows Authentication and SQL Server Authentication? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Beginner |
| 23 | 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 |
| 24 | 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 |
| 25 | What is MAUI Essentials and what does it provide? .NET MAUI › Platform Integration & Handlers | .NET MAUI | Platform Integration & Handlers | Beginner |
| 26 | How do you get the device's geolocation in MAUI? .NET MAUI › Device Features & Essentials | .NET MAUI | Device Features & Essentials | Beginner |
| 27 | How do you pick or capture a photo in MAUI? .NET MAUI › Device Features & Essentials | .NET MAUI | Device Features & Essentials | Beginner |
| 28 | What is MAUI Essentials and what does it provide? .NET MAUI › Platform Integration & Handlers | .NET MAUI | Platform Integration & Handlers | Beginner |
| 29 | How do you get the device's geolocation in MAUI? .NET MAUI › Device Features & Essentials | .NET MAUI | Device Features & Essentials | Beginner |
| 30 | How do you pick or capture a photo in MAUI? .NET MAUI › Device Features & Essentials | .NET MAUI | Device Features & Essentials | Beginner |
| 31 | 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 |
| 32 | 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 |
| 33 | What is SQL injection, and how does it relate to writing dynamic SQL unsafely? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Beginner |
| 34 | What is a linked server in SQL Server, and why would you set one up? SQL Server › Linked Servers | SQL Server | Linked Servers | Beginner |
| 35 | 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 |
| 36 | What is a view in SQL Server, and what benefits does it provide? SQL Server › Views | SQL Server | Views | Beginner |
| 37 | 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 |
| 38 | 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 |
| 39 | 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 |
| 40 | 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 |
| 41 | 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 |
| 42 | What are the security considerations when configuring authentication for a linked server connection? SQL Server › Linked Servers | SQL Server | Linked Servers | Intermediate |
| 43 | 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 |
| 44 | 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 |
| 45 | 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 |
| 46 | 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 |
| 47 | 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 |
| 48 | 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 |
| 49 | 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 |
| 50 | 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 |
| 51 | 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 |
| 52 | 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 |