| 1 | Why does a small, simple Flutter app often not actually need a genuinely complex, formal architecture, and at what specific point does adopting a more structured approach typically start to become genuinely worthwhile? Flutter › Flutter App Architecture with Modular Feature Folders | Flutter | Flutter App Architecture with Modular Feature Folders | Beginner |
| 2 | What is Clean Architecture, and what are its three commonly referenced core layers, presentation, domain, and data? Flutter › Flutter Architecture Patterns (MVVM & Clean Architecture) | Flutter | Flutter Architecture Patterns (MVVM & Clean Architecture) | Beginner |
| 3 | What are the practical tradeoffs of adopting a genuinely full, strict Clean Architecture approach for a Flutter app, in terms of both the additional required boilerplate code and the genuine long term maintainability benefits it actually provides? Flutter › Flutter Architecture Patterns (MVVM & Clean Architecture) | Flutter | Flutter Architecture Patterns (MVVM & Clean Architecture) | Advanced |
| 4 | 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 |
| 5 | What is the handler architecture in MAUI? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Intermediate |
| 6 | What is the handler architecture in MAUI? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Intermediate |
| 7 | How do you implement service-to-service authentication in a Node.js microservices architecture, so internal services can trust requests from each other? Node.js › Microservices Architecture with Node.js | Node.js | Microservices Architecture with Node.js | Intermediate |
| 8 | 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 |
| 9 | How do use cases, sometimes also called interactors, in Clean Architecture help encapsulate one single specific piece of application business logic, keeping it fully independent of any specific user interface or specific data source implementation? Flutter › Flutter Architecture Patterns (MVVM & Clean Architecture) | Flutter | Flutter Architecture Patterns (MVVM & Clean Architecture) | Intermediate |
| 10 | What is a layered (n-tier) architecture in a Node.js/Express application, and what are its typical layers? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 11 | What is a Hexagonal Architecture (Ports and Adapters), and what specific benefit does it provide for a Node.js API? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 12 | How would you handle service discovery in a Node.js microservices architecture, so services can find each other's network locations dynamically? Node.js › Microservices Architecture with Node.js | Node.js | Microservices Architecture with Node.js | Advanced |
| 13 | How should a large, complex PHP application evolve its architecture beyond basic MVC to maintain organization and testability as the codebase and team grow significantly? PHP › MVC Architecture in PHP | PHP | MVC Architecture in PHP | Advanced |
| 14 | How should an architecture properly enforce module boundaries between different features, ensuring one feature genuinely does not develop an unwanted, tightly coupled direct dependency on another entirely separate feature's own specific internal implementation details? Flutter › Flutter App Architecture with Modular Feature Folders | Flutter | Flutter App Architecture with Modular Feature Folders | Advanced |
| 15 | How do you properly test each individual distinct layer of a Clean Architecture based Flutter app, including the domain, data, and presentation layers, using genuinely appropriate distinct testing strategies for each one? Flutter › Flutter Architecture Patterns (MVVM & Clean Architecture) | Flutter | Flutter Architecture Patterns (MVVM & Clean Architecture) | Advanced |
| 16 | When is a micro frontend architecture usually not worth the added complexity for a project? Angular › Micro Frontends with Angular | Angular | Micro Frontends with Angular | Beginner |
| 17 | What is a micro frontend architecture, and why might a large organization choose it for their Angular apps? Angular › Micro Frontends with Angular | Angular | Micro Frontends with Angular | Intermediate |
| 18 | How does Kafka's architecture (topics, partitions, consumer groups) differ fundamentally from RabbitMQ's queue-based model? Node.js › Message Queues (RabbitMQ & Kafka) | Node.js | Message Queues (RabbitMQ & Kafka) | Advanced |
| 19 | How should a large Flutter app properly structure its own overall routing architecture to genuinely scale well as the total number of individual screens grows into the dozens or even hundreds? Flutter › Navigation & Routing in Flutter | Flutter | Navigation & Routing in Flutter | Advanced |
| 20 | What are the genuine criticisms commonly raised against GetX within the broader Flutter community, particularly regarding its own considerably looser overall architecture and genuinely reduced compile time safety compared to Provider or Riverpod? Flutter › State Management with GetX | Flutter | State Management with GetX | Advanced |
| 21 | How should you properly structure a genuinely large app's own overall Provider architecture, deciding exactly where within the widget tree each individual specific provider should genuinely be scoped and properly placed? Flutter › State Management with Provider | Flutter | State Management with Provider | Advanced |
| 22 | How should a large team properly organize their overall Riverpod provider architecture, deciding exactly how granular each individual given provider should genuinely be and how they should genuinely be organized across an entire large codebase? Flutter › State Management with Riverpod | Flutter | State Management with Riverpod | Advanced |
| 23 | What is an Availability Zone, and why do AWS architectures commonly span multiple Availability Zones? AWS › AWS Global Infrastructure (Regions, AZs & Edge Locations) | AWS | AWS Global Infrastructure (Regions, AZs & Edge Locations) | Beginner |
| 24 | How do compute, storage, database, and networking services typically work together in a simple three tier web application architecture? AWS › Core Services Overview | AWS | Core Services Overview | Beginner |
| 25 | What is the AWS Well-Architected Tool, and how does it help teams conduct a structured architecture review? AWS › Well-Architected Framework | AWS | Well-Architected Framework | Beginner |
| 26 | How do JWTs, OAuth, and Passport.js fit together in a typical Node.js authentication architecture? Node.js › Authentication & Authorization (JWT, OAuth, Passport) | Node.js | Authentication & Authorization (JWT, OAuth, Passport) | Intermediate |
| 27 | What is the difference between using Angular Elements and building a full micro frontend architecture? Angular › Angular Elements (Web Components) | Angular | Angular Elements (Web Components) | Intermediate |
| 28 | How do you design a multi region architecture, and what are the key challenges involved compared to a multi Availability Zone design within a single region? AWS › AWS Global Infrastructure (Regions, AZs & Edge Locations) | AWS | AWS Global Infrastructure (Regions, AZs & Edge Locations) | Intermediate |
| 29 | What is Amazon Aurora, and how does it differ from standard RDS MySQL or PostgreSQL in terms of performance and architecture? AWS › RDS & Databases | AWS | RDS & Databases | Intermediate |
| 30 | What role does a reverse proxy like Nginx play in front of a PHP application in a typical production deployment architecture? PHP › Deployment & Hosting for PHP Applications | PHP | Deployment & Hosting for PHP Applications | Intermediate |
| 31 | How does a federated plugin architecture let several genuinely separate teams or contributors independently maintain the different platform specific implementations of exactly the same overall shared plugin? Flutter › Flutter Plugin & Package Development | Flutter | Flutter Plugin & Package Development | Intermediate |
| 32 | What are some of the main challenges teams face when adopting a micro frontend architecture with Angular? Angular › Micro Frontends with Angular | Angular | Micro Frontends with Angular | Advanced |
| 33 | How would you design a monitoring system architecture using RedisTimeSeries that efficiently handles both high frequency raw data ingestion and long term historical trend analysis? Redis › RedisTimeSeries | Redis | RedisTimeSeries | Advanced |
| 34 | How does Redshift RA3 node architecture separate compute and storage, and why does this matter? AWS › Amazon Redshift & Data Warehousing | AWS | Amazon Redshift & Data Warehousing | Advanced |
| 35 | How does AWS Transit Gateway simplify complex hybrid network architectures involving many VPCs and on premises connections? AWS › AWS Direct Connect & Hybrid Connectivity | AWS | AWS Direct Connect & Hybrid Connectivity | Advanced |
| 36 | How should an organization design its network architecture to minimize latency and cost when operating across multiple Regions, Availability Zones, and Edge Locations simultaneously? AWS › AWS Global Infrastructure (Regions, AZs & Edge Locations) | AWS | AWS Global Infrastructure (Regions, AZs & Edge Locations) | Advanced |
| 37 | How does a mature organization's use of core AWS services typically evolve from an initial simple deployment toward a more sophisticated, resilient, multi account architecture over time? AWS › Core Services Overview | AWS | Core Services Overview | Advanced |
| 38 | How does EC2 Nitro System architecture improve performance, security, and efficiency compared to older EC2 hypervisor based virtualization? AWS › EC2 & Compute | AWS | EC2 & Compute | Advanced |
| 39 | How do you design a load balancer architecture that supports zero downtime blue green or canary deployments for a production application? AWS › Elastic Load Balancing (ALB, NLB & CLB) | AWS | Elastic Load Balancing (ALB, NLB & CLB) | Advanced |
| 40 | How should an organization approach designing observability and error handling for a complex, multi function serverless architecture built on Lambda? AWS › Lambda & Serverless | AWS | Lambda & Serverless | Advanced |
| 41 | How does RDS Proxy help applications manage database connections more efficiently, particularly for serverless architectures using Lambda? AWS › RDS & Databases | AWS | RDS & Databases | Advanced |
| 42 | How can S3 Multi-Region Access Points and Cross-Region Replication support building a resilient, low latency, globally distributed storage architecture? AWS › S3 & Storage | AWS | S3 & Storage | Advanced |
| 43 | How should an organization design a scalable, secure VPC architecture that supports multiple accounts, hybrid connectivity, and future growth? AWS › VPC & Networking | AWS | VPC & Networking | Advanced |
| 44 | How should a large scale application design its file upload architecture to handle high volumes of uploads reliably, including virus scanning and offloading storage to a dedicated service? PHP › File Upload Handling | PHP | File Upload Handling | Advanced |
| 45 | How can PHP's interface based type hinting combined with abstract classes support building a genuinely extensible plugin architecture within an application? PHP › Interfaces & Abstract Classes | PHP | Interfaces & Abstract Classes | Advanced |
| 46 | What are general best practices for a maintainable MAUI app? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Beginner |
| 47 | What are general best practices for a maintainable MAUI app? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Beginner |
| 48 | What does organizing a Flutter project using a feature based folder structure actually mean, and how does it differ from the more common default approach of organizing files strictly by their specific type? Flutter › Flutter App Architecture with Modular Feature Folders | Flutter | Flutter App Architecture with Modular Feature Folders | Beginner |
| 49 | How should you organize code in a MAUI project? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Intermediate |
| 50 | How do you implement a navigation service to keep view models testable? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Intermediate |
| 51 | How do you handle errors and show user-friendly messages centrally? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Intermediate |
| 52 | How should you organize code in a MAUI project? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Intermediate |
| 53 | How do you implement a navigation service to keep view models testable? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Intermediate |
| 54 | How do you handle errors and show user-friendly messages centrally? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Intermediate |
| 55 | What are the key benefits and tradeoffs of splitting a Node.js monolith into microservices? Node.js › Microservices Architecture with Node.js | Node.js | Microservices Architecture with Node.js | Intermediate |
| 56 | What is an API Gateway, and what role does it play in front of a collection of Node.js microservices? Node.js › Microservices Architecture with Node.js | Node.js | Microservices Architecture with Node.js | Intermediate |
| 57 | How should shared code, such as common reusable widgets, utility functions, and core services, be organized within a feature based folder structure, given that this kind of code is not genuinely specific to just one single individual feature? Flutter › Flutter App Architecture with Modular Feature Folders | Flutter | Flutter App Architecture with Modular Feature Folders | Intermediate |
| 58 | How can a feature based folder structure be further organized internally using distinct architectural layers, such as separating presentation, domain, and data code within each individual feature? Flutter › Flutter App Architecture with Modular Feature Folders | Flutter | Flutter App Architecture with Modular Feature Folders | Intermediate |
| 59 | How do you keep a MAUI codebase testable and loosely coupled? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Advanced |
| 60 | What logging and observability practices suit a MAUI app? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Advanced |
| 61 | How do you decide between native MAUI, Blazor Hybrid, and hybrid approaches for a project? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Advanced |
| 62 | How do you keep a MAUI codebase testable and loosely coupled? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Advanced |
| 63 | What logging and observability practices suit a MAUI app? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Advanced |
| 64 | How do you decide between native MAUI, Blazor Hybrid, and hybrid approaches for a project? .NET MAUI › Best Practices & Architecture | .NET MAUI | Best Practices & Architecture | Advanced |
| 65 | What is the Saga pattern, and how does it manage distributed transactions across multiple Node.js microservices? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 66 | How does distributed data ownership work in microservices -- specifically, why shouldn't multiple services share direct access to the same database? Node.js › Microservices Architecture with Node.js | Node.js | Microservices Architecture with Node.js | Advanced |
| 67 | What are the differences between Redis's threading model in older versions versus improvements introduced in more recent versions for handling input and output operations? Redis › Redis Architecture & Installation | Redis | Redis Architecture & Installation | Advanced |
| 68 | What is .NET MAUI? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Beginner |
| 69 | How does .NET MAUI differ from Xamarin.Forms? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Beginner |
| 70 | What is the 'single project' concept in MAUI? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Beginner |
| 71 | What is .NET MAUI? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Beginner |
| 72 | How does .NET MAUI differ from Xamarin.Forms? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Beginner |
| 73 | What is the 'single project' concept in MAUI? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Beginner |
| 74 | What is Node.js, and how does it differ fundamentally from running JavaScript in a web browser? Node.js › Node.js Fundamentals & Runtime Architecture | Node.js | Node.js Fundamentals & Runtime Architecture | Beginner |
| 75 | What is npm, and what is its relationship to the Node.js runtime itself? Node.js › Node.js Fundamentals & Runtime Architecture | Node.js | Node.js Fundamentals & Runtime Architecture | Beginner |
| 76 | What is an NgModule in Angular, and what was its traditional purpose? Angular › NgModules & Modular Architecture | Angular | NgModules & Modular Architecture | Beginner |
| 77 | What is the SharedModule pattern, and is it still relevant with standalone components? Angular › NgModules & Modular Architecture | Angular | NgModules & Modular Architecture | Beginner |
| 78 | 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 |
| 79 | What are the key architectural characteristics of Redis that make it so fast? Redis › Redis Architecture & Installation | Redis | Redis Architecture & Installation | Beginner |
| 80 | How do you install Redis on a typical Linux server, and how do you verify it is running correctly? Redis › Redis Architecture & Installation | Redis | Redis Architecture & Installation | Beginner |
| 81 | What is the MVC architectural pattern, and how do the Model, View, and Controller components each play a distinct role in a PHP application? PHP › MVC Architecture in PHP | PHP | MVC Architecture in PHP | Beginner |
| 82 | What is the role of a Controller in the MVC pattern, and what responsibilities should typically be kept out of a controller to maintain good separation of concerns? PHP › MVC Architecture in PHP | PHP | MVC Architecture in PHP | Beginner |
| 83 | What is the MVVM, or Model View ViewModel, architectural pattern, and how does it help clearly separate a Flutter app's user interface code from its underlying business logic? Flutter › Flutter Architecture Patterns (MVVM & Clean Architecture) | Flutter | Flutter Architecture Patterns (MVVM & Clean Architecture) | Beginner |
| 84 | Why did MAUI replace renderers with handlers? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Intermediate |
| 85 | Why did MAUI replace renderers with handlers? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Intermediate |
| 86 | What is the Module pattern in Node.js, and how does it enable encapsulation? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Intermediate |
| 87 | How is the Factory pattern commonly applied in Node.js applications, and what problem does it solve? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Intermediate |
| 88 | What is the Singleton pattern, and what are the specific risks of using it in a Node.js application? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Intermediate |
| 89 | What is the Middleware (Chain of Responsibility) pattern as implemented by Express, and how does the 'next()' function drive it? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Intermediate |
| 90 | What is Dependency Injection, and how is it typically implemented in Node.js given the language has no built-in DI container? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Intermediate |
| 91 | What is the Strategy pattern, and how would you apply it to support multiple payment providers in a Node.js checkout service? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Intermediate |
| 92 | What is the V8 JavaScript engine, and what role does it play within the Node.js runtime? Node.js › Node.js Fundamentals & Runtime Architecture | Node.js | Node.js Fundamentals & Runtime Architecture | Intermediate |
| 93 | What is the Node.js LTS (Long-Term Support) release schedule, and why does it matter for choosing which version to run in production? Node.js › Node.js Fundamentals & Runtime Architecture | Node.js | Node.js Fundamentals & Runtime Architecture | Intermediate |
| 94 | What is a feature module, and how does it help organize a larger Angular application? Angular › NgModules & Modular Architecture | Angular | NgModules & Modular Architecture | Intermediate |
| 95 | How do you lazy load a feature module so its code is only downloaded when a user actually navigates to it? Angular › NgModules & Modular Architecture | Angular | NgModules & Modular Architecture | Intermediate |
| 96 | 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 |
| 97 | 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 |
| 98 | What are the most important configuration settings to review and adjust when preparing a Redis instance for production use? Redis › Redis Architecture & Installation | Redis | Redis Architecture & Installation | Intermediate |
| 99 | How does Redis's single threaded command processing model handle high levels of concurrent client connections efficiently? Redis › Redis Architecture & Installation | Redis | Redis Architecture & Installation | Intermediate |
| 100 | How do you check the current version, uptime, and general health information for a running Redis instance? Redis › Redis Architecture & Installation | Redis | Redis Architecture & Installation | Intermediate |
| 101 | How do Models in MVC represent both data structure and business logic, and how does this differ from a Model being purely a simple database representation? PHP › MVC Architecture in PHP | PHP | MVC Architecture in PHP | Intermediate |
| 102 | How do Views in MVC separate presentation logic from application logic, and what role do templating engines like Blade play in this separation? PHP › MVC Architecture in PHP | PHP | MVC Architecture in PHP | Intermediate |
| 103 | How does a typical request flow through an MVC based PHP application, from the initial incoming HTTP request to the final rendered response? PHP › MVC Architecture in PHP | PHP | MVC Architecture in PHP | Intermediate |
| 104 | How does a well organized modular feature folder structure specifically make it genuinely easier for multiple different developers to work simultaneously on entirely separate features without frequently causing disruptive merge conflicts with each other? Flutter › Flutter App Architecture with Modular Feature Folders | Flutter | Flutter App Architecture with Modular Feature Folders | Intermediate |
| 105 | How does the repository pattern abstract away the specific technical details of exactly where data actually comes from, such as a remote API versus a local cache, from the rest of an app's business logic? Flutter › Flutter Architecture Patterns (MVVM & Clean Architecture) | Flutter | Flutter Architecture Patterns (MVVM & Clean Architecture) | Intermediate |
| 106 | How does properly separating business logic from a specific state management library, such as Provider or BLoC, help make that business logic genuinely reusable and considerably easier to test, regardless of which particular library you might actually choose to use? Flutter › Flutter Architecture Patterns (MVVM & Clean Architecture) | Flutter | Flutter Architecture Patterns (MVVM & Clean Architecture) | Intermediate |
| 107 | Explain the MAUI app startup and the role of MauiProgram. .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Advanced |
| 108 | What is the difference between the App, Window, and Page objects? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Advanced |
| 109 | Explain the MAUI app startup and the role of MauiProgram. .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Advanced |
| 110 | What is the difference between the App, Window, and Page objects? .NET MAUI › Fundamentals & Architecture | .NET MAUI | Fundamentals & Architecture | Advanced |
| 111 | What is the Repository pattern, and how does it help decouple business logic from a specific database technology? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 112 | What is the Observer pattern, and how does Node.js's EventEmitter class implement it natively? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 113 | What is Domain-Driven Design (DDD), and how do its concepts of entities, value objects, and aggregates apply to a Node.js codebase? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 114 | What is a Circuit Breaker pattern, and why is it important when a Node.js service calls an unreliable downstream dependency? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 115 | What is the CQRS (Command Query Responsibility Segregation) pattern, and when is it appropriate to introduce in a Node.js system? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 116 | What is a Facade pattern, and how might it be used to simplify a Node.js application's interaction with several third-party SDKs? Node.js › Architecture & Design Patterns | Node.js | Architecture & Design Patterns | Advanced |
| 117 | How does Node.js achieve high concurrency for I/O-bound workloads despite running JavaScript on a single main thread? Node.js › Node.js Fundamentals & Runtime Architecture | Node.js | Node.js Fundamentals & Runtime Architecture | Advanced |
| 118 | Why has Angular moved toward standalone components as the recommended default over NgModules? Angular › NgModules & Modular Architecture | Angular | NgModules & Modular Architecture | Advanced |
| 119 | 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 |
| 120 | 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 |
| 121 | How would you plan the hardware and infrastructure requirements for a new Redis deployment expected to handle a large, growing dataset? Redis › Redis Architecture & Installation | Redis | Redis Architecture & Installation | Advanced |
| 122 | How does the concept of a Service Layer complement traditional MVC by providing an additional place for complex business logic that spans multiple models? PHP › MVC Architecture in PHP | PHP | MVC Architecture in PHP | Advanced |
| 123 | How can a large Flutter application be split into genuinely separate internal packages, one for each major feature, using a monorepo approach, rather than simply keeping everything within just folders inside a single unified app? Flutter › Flutter App Architecture with Modular Feature Folders | Flutter | Flutter App Architecture with Modular Feature Folders | Advanced |
| 124 | What is gRPC, and how does it differ from a traditional REST/JSON API? .NET › gRPC Services | .NET | gRPC Services | Beginner |
| 125 | What is the difference between a relational (SQL) database and a NoSQL database, and how does this affect a Node.js application's data layer? Node.js › Databases | Node.js | Databases | Beginner |
| 126 | Why should an application typically avoid storing uploaded files directly on the same server instance that runs the web application? Node.js › File Uploads & Media Processing | Node.js | File Uploads & Media Processing | Beginner |
| 127 | What does providedIn root mean when registering an Angular service? Angular › Dependency Injection Providers & Injection Tokens | Angular | Dependency Injection Providers & Injection Tokens | Beginner |
| 128 | What is a standalone component in Angular, and how do you create one? Angular › Standalone Components | Angular | Standalone Components | Beginner |
| 129 | What are the three main types of backups in SQL Server, and what does each one capture? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Beginner |
| 130 | How do you restore a SQL Server database from a full backup file? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Beginner |
| 131 | What is the difference between a partition function and a partition scheme in SQL Server? SQL Server › Partitioning | SQL Server | Partitioning | Beginner |
| 132 | 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 |
| 133 | What is the difference between Windows Authentication and SQL Server Authentication? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Beginner |
| 134 | What is RDB persistence in Redis, and how does it work? Redis › Persistence (RDB/AOF) | Redis | Persistence (RDB/AOF) | Beginner |
| 135 | How do you create a manual backup of your Redis data at a specific point in time? Redis › Redis Backup & Disaster Recovery | Redis | Redis Backup & Disaster Recovery | Beginner |
| 136 | How do you restore a Redis instance from a previously saved RDB backup file? Redis › Redis Backup & Disaster Recovery | Redis | Redis Backup & Disaster Recovery | Beginner |
| 137 | What is redis-cli, and how do you use it to connect to and interact with a Redis server? Redis › Redis CLI & Basic Commands | Redis | Redis CLI & Basic Commands | Beginner |
| 138 | What tool does Redis provide for benchmarking its performance, and how do you use it? Redis › Redis Performance Tuning & Benchmarking | Redis | Redis Performance Tuning & Benchmarking | Beginner |
| 139 | How do you set a password to require authentication before clients can execute commands on a Redis instance? Redis › Redis Security & ACL | Redis | Redis Security & ACL | Beginner |
| 140 | What is Redis ACL, and how does it provide more granular access control than a single shared password? Redis › Redis Security & ACL | Redis | Redis Security & ACL | Beginner |
| 141 | Why does Redis Sentinel recommend running at least three Sentinel instances rather than just one? Redis › Redis Sentinel & High Availability | Redis | Redis Sentinel & High Availability | Beginner |
| 142 | How do you run a basic Redis instance using Docker? Redis › Redis with Docker & Kubernetes | Redis | Redis with Docker & Kubernetes | Beginner |
| 143 | How do you persist Redis data when running it in a Docker container, so data survives a container restart? Redis › Redis with Docker & Kubernetes | Redis | Redis with Docker & Kubernetes | Beginner |
| 144 | Why is enabling TLS encryption important for a Redis deployment, and what does it actually protect against? Redis › TLS & Encryption in Redis | Redis | TLS & Encryption in Redis | Beginner |
| 145 | What is Laravel, and what core features make it one of the most popular PHP frameworks for building web applications? PHP › Laravel Framework Essentials | PHP | Laravel Framework Essentials | Beginner |
| 146 | What is Artisan in Laravel, and what kinds of tasks does its command line interface help automate? PHP › Laravel Framework Essentials | PHP | Laravel Framework Essentials | Beginner |
| 147 | What is routing in a PHP web application, and how does a router determine which piece of code should handle a specific incoming request? PHP › Routing & Middleware | PHP | Routing & Middleware | Beginner |
| 148 | What is middleware in the context of a web application, and how does it let you run logic before or after a request is handled by its intended route? PHP › Routing & Middleware | PHP | Routing & Middleware | Beginner |
| 149 | What is Symfony, and what makes it a popular choice for building both full web applications and reusable PHP components? PHP › Symfony Framework Essentials | PHP | Symfony Framework Essentials | Beginner |
| 150 | How does Symfony's routing system let you map URLs to controller actions, and what are the different ways routes can be defined? PHP › Symfony Framework Essentials | PHP | Symfony Framework Essentials | Beginner |
| 151 | What is a template engine, and how do Blade and Twig help separate a PHP application's presentation logic from its business logic? PHP › Template Engines (Blade & Twig) | PHP | Template Engines (Blade & Twig) | Beginner |
| 152 | What is the difference between a WordPress plugin and a WordPress theme, and what kind of functionality does each one typically control? PHP › WordPress Plugin & Theme Development | PHP | WordPress Plugin & Theme Development | Beginner |
| 153 | What is dependency injection, and why is it a generally recommended practice for structuring a Flutter application's various services and repositories? Flutter › Dependency Injection in Flutter (GetIt & Service Locator) | Flutter | Dependency Injection in Flutter (GetIt & Service Locator) | Beginner |
| 154 | What is the GetIt package, and how does it function as a service locator, letting different parts of a Flutter app conveniently access shared service instances without needing them to be manually passed down through many widget constructors? Flutter › Dependency Injection in Flutter (GetIt & Service Locator) | Flutter | Dependency Injection in Flutter (GetIt & Service Locator) | Beginner |
| 155 | What are named routes in Flutter, and how do they let you navigate to a specific screen simply by referencing a genuinely simple string identifier rather than needing to directly construct that particular widget yourself? Flutter › Named Routes & Navigator 2.0 (Router API) | Flutter | Named Routes & Navigator 2.0 (Router API) | Beginner |
| 156 | How do you properly structure a repository class specifically to encapsulate all of your app's own API calls related to one particular given resource, such as orders or products? Flutter › REST API Integration in Flutter | Flutter | REST API Integration in Flutter | Beginner |
| 157 | How do you share code between a MAUI app and other .NET projects (web/API)? .NET MAUI › Native Interop & Libraries | .NET MAUI | Native Interop & Libraries | Intermediate |
| 158 | How do you share code between a MAUI app and other .NET projects (web/API)? .NET MAUI › Native Interop & Libraries | .NET MAUI | Native Interop & Libraries | Intermediate |
| 159 | What is the OAuth 2.0 Client Credentials flow, and when is it used instead of the Authorization Code flow? .NET › Authentication & Authorization (Identity, JWT, OAuth) | .NET | Authentication & Authorization (Identity, JWT, OAuth) | Intermediate |
| 160 | How do you configure and use Redis as a distributed cache in ASP.NET Core with StackExchange.Redis? .NET › Caching (In-Memory, Distributed & Redis) | .NET | Caching (In-Memory, Distributed & Redis) | Intermediate |
| 161 | How do feature flags decouple code deployment from feature release in a CI/CD workflow? .NET › CI/CD, Publishing & Deployment | .NET | CI/CD, Publishing & Deployment | Intermediate |
| 162 | What is Application Insights (or OpenTelemetry) integration, and what value does it add over basic logging? .NET › Diagnostics & Performance | .NET | Diagnostics & Performance | Intermediate |
| 163 | How would you version a gRPC service's contract while maintaining backward compatibility with existing clients? .NET › gRPC Services | .NET | gRPC Services | Intermediate |
| 164 | How does client-side load balancing work for gRPC when calling a service with multiple backend instances, without a dedicated load balancer? .NET › gRPC Services | .NET | gRPC Services | Intermediate |
| 165 | What is a feature flag, and how would you implement one in a Node.js application to control a new feature's rollout? Node.js › Cloud & DevOps | Node.js | Cloud & DevOps | Intermediate |
| 166 | What is middleware in Express, and what is the significance of the order in which middleware is registered? Node.js › Express & Middleware | Node.js | Express & Middleware | Intermediate |
| 167 | What is the difference between application-level, router-level, and route-specific middleware in Express? Node.js › Express & Middleware | Node.js | Express & Middleware | Intermediate |
| 168 | What is the purpose of GraphQL fragments, and how do they help avoid duplicating field selections across multiple queries? Node.js › GraphQL | Node.js | GraphQL | Intermediate |
| 169 | How do you validate a JWT's claims (issuer, audience, expiration) beyond just verifying its cryptographic signature? Node.js › Authentication & Authorization (JWT, OAuth, Passport) | Node.js | Authentication & Authorization (JWT, OAuth, Passport) | Intermediate |
| 170 | What is a database migration, and how do tools like Sequelize's migration system or a standalone tool like Knex help manage schema changes over time? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize) | Node.js | Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize) | Intermediate |
| 171 | How would you validate that all required environment variables are present and correctly typed at application startup, rather than discovering a missing one at runtime? Node.js › Environment Variables & Configuration | Node.js | Environment Variables & Configuration | Intermediate |
| 172 | How would you structure application configuration to support multiple environments (development, staging, production) cleanly? Node.js › Environment Variables & Configuration | Node.js | Environment Variables & Configuration | Intermediate |
| 173 | How do GraphQL Mutations differ from Queries, and how would you define one to create a new resource? Node.js › GraphQL with Node.js | Node.js | GraphQL with Node.js | Intermediate |
| 174 | What is HTTP keep-alive, and how does Node's http.Agent manage connection reuse for outgoing requests? Node.js › HTTP & HTTPS Modules | Node.js | HTTP & HTTPS Modules | Intermediate |
| 175 | How would you implement request correlation IDs to trace a single request's logs across multiple log lines and services? Node.js › Logging & Monitoring | Node.js | Logging & Monitoring | Intermediate |
| 176 | How would you publish and consume messages using RabbitMQ in a Node.js application via the amqplib package? Node.js › Message Queues (RabbitMQ & Kafka) | Node.js | Message Queues (RabbitMQ & Kafka) | Intermediate |
| 177 | When would you choose a message queue/broker (RabbitMQ or Kafka) over simply making direct HTTP calls between Node.js microservices? Node.js › Message Queues (RabbitMQ & Kafka) | Node.js | Message Queues (RabbitMQ & Kafka) | Intermediate |
| 178 | What is the difference between vertical and horizontal performance optimization strategies for a Node.js application, and how do you decide which to pursue first? Node.js › Performance Optimization & Profiling | Node.js | Performance Optimization & Profiling | Intermediate |
| 179 | How do standalone components change the way you organize and use components in Angular? Angular › Components & Templates | Angular | Components & Templates | Intermediate |
| 180 | How do standalone components handle lazy loading differently from NgModule based lazy loading? Angular › Standalone Components | Angular | Standalone Components | Intermediate |
| 181 | What is the difference between automatic failover and manual failover in an Always On Availability Group? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Intermediate |
| 182 | What is an availability group listener, and why is it important for applications connecting to an Always On Availability Group? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Intermediate |
| 183 | What are the licensing and edition requirements for using Always On Availability Groups in SQL Server? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Intermediate |
| 184 | How do you enable Change Data Capture on a specific table, and what does that process actually create? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Intermediate |
| 185 | How is Change Data Capture different from using triggers to track changes to a table? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Intermediate |
| 186 | How do you disable Change Data Capture on a table or an entire database once it is no longer needed? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Intermediate |
| 187 | How does columnstore compression work, and why does it typically achieve much higher compression ratios than regular row based storage? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Intermediate |
| 188 | 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 |
| 189 | What is the difference between Query Store's READ_WRITE and READ_ONLY operational modes, and when does SQL Server switch between them? SQL Server › Query Store | SQL Server | Query Store | Intermediate |
| 190 | What roles do the publisher, distributor, and subscriber play in a transactional replication setup? SQL Server › Replication | SQL Server | Replication | Intermediate |
| 191 | What steps are involved in setting up transactional replication for the first time between a publisher and a new subscriber? SQL Server › Replication | SQL Server | Replication | Intermediate |
| 192 | What improvements did SQL Server 2019 introduce for scalar function performance through a feature called scalar UDF inlining? SQL Server › User Defined Functions | SQL Server | User Defined Functions | Intermediate |
| 193 | What eviction policies are available in Redis for handling the situation when memory usage reaches its configured maximum limit? Redis › Expiration & Eviction | Redis | Expiration & Eviction | Intermediate |
| 194 | What is AOF rewriting, and why is it necessary as an append only file grows over time? Redis › Persistence (RDB/AOF) | Redis | Persistence (RDB/AOF) | Intermediate |
| 195 | What happens if Redis's persistence files, whether RDB or AOF, become corrupted, and how would you attempt to recover? Redis › Persistence (RDB/AOF) | Redis | Persistence (RDB/AOF) | Intermediate |
| 196 | How do you configure and monitor the maxmemory setting in Redis to prevent it from consuming more memory than your server can safely provide? Redis › Redis Memory Optimization | Redis | Redis Memory Optimization | Intermediate |
| 197 | What licensing considerations should you be aware of when using Redis modules in a commercial product? Redis › Redis Modules Overview | Redis | Redis Modules Overview | Intermediate |
| 198 | What third party tools are commonly used for more comprehensive monitoring and visualization of Redis metrics beyond the built-in commands? Redis › Redis Monitoring & Observability | Redis | Redis Monitoring & Observability | Intermediate |
| 199 | What is the difference between full resynchronization and partial resynchronization when a replica reconnects to its primary after a temporary disconnection? Redis › Redis Replication | Redis | Redis Replication | Intermediate |
| 200 | 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 |
| 201 | What are some general security best practices to follow when deploying Redis, beyond just setting a password? Redis › Redis Security & ACL | Redis | Redis Security & ACL | Intermediate |
| 202 | What is the quorum setting in a Sentinel configuration, and how does it affect the decision to trigger a failover? Redis › Redis Sentinel & High Availability | Redis | Redis Sentinel & High Availability | Intermediate |
| 203 | How do the threading models of Redis and Memcached differ, and what performance implications does this have? Redis › Redis vs Memcached | Redis | Redis vs Memcached | Intermediate |
| 204 | If a team is already using Memcached and considering a migration to Redis, what migration considerations and challenges should they plan for? Redis › Redis vs Memcached | Redis | Redis vs Memcached | Intermediate |
| 205 | What Kubernetes resources are typically needed to properly expose and configure a Redis deployment for other applications within the same cluster to use? Redis › Redis with Docker & Kubernetes | Redis | Redis with Docker & Kubernetes | Intermediate |
| 206 | What resource requests and limits should you configure for a Redis pod running on Kubernetes, and why does this matter? Redis › Redis with Docker & Kubernetes | Redis | Redis with Docker & Kubernetes | Intermediate |
| 207 | What does it mean for Redis transactions to lack full rollback support, and how does this differ from transactions in a traditional relational database? Redis › Transactions | Redis | Transactions | Intermediate |
| 208 | How does routing work in Laravel, and how do you define routes that map incoming URLs to specific controller actions? PHP › Laravel Framework Essentials | PHP | Laravel Framework Essentials | Intermediate |
| 209 | What does the __invoke magic method do, and how does it let you use an object instance directly as if it were a function? PHP › Magic Methods | PHP | Magic Methods | Intermediate |
| 210 | How do you organize namespaces effectively in a larger application to reflect logical groupings such as models, services, and controllers? PHP › Namespaces & Autoloading | PHP | Namespaces & Autoloading | Intermediate |
| 211 | How does a middleware pipeline execute multiple middleware in sequence, and how does the concept of calling the next middleware let each one decide whether to continue processing the request? PHP › Routing & Middleware | PHP | Routing & Middleware | Intermediate |
| 212 | How can route groups let you apply shared configuration, such as a common URL prefix or a set of middleware, to several related routes at once? PHP › Routing & Middleware | PHP | Routing & Middleware | Intermediate |
| 213 | How does template inheritance work in Blade and Twig, allowing you to define a shared base layout that individual pages can extend? PHP › Template Engines (Blade & Twig) | PHP | Template Engines (Blade & Twig) | Intermediate |
| 214 | How do control structures like loops and conditionals work within Blade and Twig templates, and how do they compare to writing the equivalent raw PHP directly inside an HTML file? PHP › Template Engines (Blade & Twig) | PHP | Template Engines (Blade & Twig) | Intermediate |
| 215 | What are custom post types and custom fields in WordPress, and how do they let you extend WordPress beyond its default posts and pages to represent other kinds of content? PHP › WordPress Plugin & Theme Development | PHP | WordPress Plugin & Theme Development | Intermediate |
| 216 | How can composition, meaning combining several smaller, focused custom widgets together, help build a complex screen more maintainably than relying on one giant, monolithic widget class? Flutter › Custom Widgets & Reusable Components | Flutter | Custom Widgets & Reusable Components | Intermediate |
| 217 | How do you create a custom generic class in Dart, and why would a generic class be preferable to writing several nearly identical, separate classes each hardcoded for a different specific type? Flutter › Dart Collections & Generics | Flutter | Dart Collections & Generics | Intermediate |
| 218 | What are unmodifiable and immutable collections in Dart, and why might you deliberately choose to use one instead of a regular mutable collection in certain parts of your code? Flutter › Dart Collections & Generics | Flutter | Dart Collections & Generics | Intermediate |
| 219 | How do you organize dependency registration in a large Flutter app, using a dedicated setup function or dedicated modules, to keep the overall service locator configuration clean and maintainable as the app grows significantly? Flutter › Dependency Injection in Flutter (GetIt & Service Locator) | Flutter | Dependency Injection in Flutter (GetIt & Service Locator) | Intermediate |
| 220 | What should a well written pubspec.yaml and a genuinely thorough README file for a Flutter plugin actually include, to help other developers properly understand how to correctly use and depend on it? Flutter › Flutter Plugin & Package Development | Flutter | Flutter Plugin & Package Development | Intermediate |
| 221 | How do you properly implement nested navigation using a considerably more complex router structure, such as one genuinely needed to properly support a bottom navigation bar where each individual tab genuinely maintains its own entirely separate independent navigation stack? Flutter › Named Routes & Navigator 2.0 (Router API) | Flutter | Named Routes & Navigator 2.0 (Router API) | Intermediate |
| 222 | How should you properly organize your sqflite database access code using a dedicated database helper class, keeping your genuine SQL related logic properly and cleanly separated from the rest of your app's own business logic? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Intermediate |
| 223 | How does GetX's own built in route navigation system let you navigate between screens without genuinely needing to pass a BuildContext, unlike Flutter's own standard Navigator? Flutter › State Management with GetX | Flutter | State Management with GetX | Intermediate |
| 224 | How does MultiProvider let you properly and cleanly combine several genuinely separate individual providers together, avoiding a genuinely awkward, deeply nested pyramid of several separate individually nested Provider widgets? Flutter › State Management with Provider | Flutter | State Management with Provider | Intermediate |
| 225 | How do you structure a large, enterprise MAUI solution? .NET MAUI › Advanced & Enterprise | .NET MAUI | Advanced & Enterprise | Advanced |
| 226 | How do you decide between a big-bang and incremental MAUI migration? .NET MAUI › Migration from Xamarin.Forms | .NET MAUI | Migration from Xamarin.Forms | Advanced |
| 227 | How do you structure a large, enterprise MAUI solution? .NET MAUI › Advanced & Enterprise | .NET MAUI | Advanced & Enterprise | Advanced |
| 228 | How do you decide between a big-bang and incremental MAUI migration? .NET MAUI › Migration from Xamarin.Forms | .NET MAUI | Migration from Xamarin.Forms | Advanced |
| 229 | What migration strategies exist for gradually moving a large .NET Framework application to modern .NET rather than a big-bang rewrite? .NET › .NET vs .NET Framework | .NET | .NET vs .NET Framework | Advanced |
| 230 | What are the trade-offs of versioning an entire API at once (global versioning) versus versioning individual endpoints independently? .NET › API Versioning | .NET | API Versioning | Advanced |
| 231 | How does API versioning strategy differ for internal microservice-to-microservice APIs versus public-facing external APIs? .NET › API Versioning | .NET | API Versioning | Advanced |
| 232 | What is IDistributedCache, and how does it differ from IMemoryCache in a multi-instance deployment? .NET › Caching (In-Memory, Distributed & Redis) | .NET | Caching (In-Memory, Distributed & Redis) | Advanced |
| 233 | How does Redis's data structure support (beyond simple key-value) enable caching patterns not possible with IMemoryCache? .NET › Caching (In-Memory, Distributed & Redis) | .NET | Caching (In-Memory, Distributed & Redis) | Advanced |
| 234 | How do you handle cache serialization for complex objects when using IDistributedCache, given it only natively supports byte[]? .NET › Caching (In-Memory, Distributed & Redis) | .NET | Caching (In-Memory, Distributed & Redis) | Advanced |
| 235 | What is the difference between blue-green deployment and canary deployment, and how do they apply to .NET applications? .NET › CI/CD, Publishing & Deployment | .NET | CI/CD, Publishing & Deployment | Advanced |
| 236 | How does GitOps (e.g., using Flux or ArgoCD with Kubernetes) change the deployment model compared to traditional push-based CI/CD pipelines? .NET › CI/CD, Publishing & Deployment | .NET | CI/CD, Publishing & Deployment | Advanced |
| 237 | How would you design configuration for a multi-tenant application where each tenant needs different settings resolved at runtime? .NET › Configuration & Options | .NET | Configuration & Options | Advanced |
| 238 | How does CORS interact with a reverse proxy or API gateway sitting in front of multiple backend microservices? .NET › CORS & Cross-Origin Resource Sharing | .NET | CORS & Cross-Origin Resource Sharing | Advanced |
| 239 | How do EventCounters and the newer System.Diagnostics.Metrics API (Meter) let you expose custom application-specific performance metrics? .NET › Diagnostics & Performance | .NET | Diagnostics & Performance | Advanced |
| 240 | How does distributed tracing correlate a single logical request across multiple microservices, and what is a 'trace context' propagated between them? .NET › Diagnostics & Performance | .NET | Diagnostics & Performance | Advanced |
| 241 | What is .NET Aspire, and how does it improve the local development and orchestration experience for cloud-native, multi-service .NET applications? .NET › Docker & Containerization | .NET | Docker & Containerization | Advanced |
| 242 | How does the Generic Host support hosting multiple independent hosted services with different failure isolation needs? .NET › Generic Host | .NET | Generic Host | Advanced |
| 243 | How does gRPC's use of HTTP/2 multiplexing provide performance advantages over HTTP/1.1-based REST APIs? .NET › gRPC Services | .NET | gRPC Services | Advanced |
| 244 | How do you handle authentication for gRPC calls, and how does it differ from typical REST API authentication patterns? .NET › gRPC Services | .NET | gRPC Services | Advanced |
| 245 | How do you configure deadlines and cancellation for gRPC calls, and how does this differ from typical HTTP request timeouts? .NET › gRPC Services | .NET | gRPC Services | Advanced |
| 246 | What is the difference between a message queue (like RabbitMQ) and a job queue (like BullMQ), and when would you choose one over the other? Node.js › Background Jobs & Queues | Node.js | Background Jobs & Queues | Advanced |
| 247 | What is database replication, and how does a Node.js application typically route reads to replicas while sending writes to a primary? Node.js › Databases | Node.js | Databases | Advanced |
| 248 | What is database sharding, and what problem does it solve that replication alone doesn't address? Node.js › Databases | Node.js | Databases | Advanced |
| 249 | What is a database deadlock, and how might it occur between two concurrent transactions in a Node.js application? Node.js › Databases | Node.js | Databases | Advanced |
| 250 | How would you design a multi-channel notification system in Node.js that can send the same logical notification via email, SMS, or push depending on user preference? Node.js › Email & Notifications | Node.js | Email & Notifications | Advanced |
| 251 | How would you structure a large Express application using the Router to organize routes into feature-based or resource-based modules? Node.js › Express & Middleware | Node.js | Express & Middleware | Advanced |
| 252 | How would you implement a middleware that adds a correlation/request ID to every incoming request for tracing purposes across a distributed system? Node.js › Express & Middleware | Node.js | Express & Middleware | Advanced |
| 253 | How would you implement GraphQL schema stitching or federation to compose a single unified GraphQL API from multiple underlying microservices? Node.js › GraphQL | Node.js | GraphQL | Advanced |
| 254 | How would you implement HTTP/2 or HTTP/1.1 connection pooling on the client side in Node.js when making many outgoing requests to the same downstream API? Node.js › HTTP & Web Servers | Node.js | HTTP & Web Servers | Advanced |
| 255 | What is the N+1 query problem in the context of an ORM like Mongoose or Sequelize, and how do you avoid it? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize) | Node.js | Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize) | Advanced |
| 256 | How would you implement a custom event that carries multiple pieces of data, and what's the convention for structuring the emitted payload? Node.js › Events & EventEmitter | Node.js | Events & EventEmitter | Advanced |
| 257 | How would you implement distributed tracing across multiple Node.js microservices using OpenTelemetry? Node.js › Logging & Monitoring | Node.js | Logging & Monitoring | Advanced |
| 258 | What are some best practices for structuring a large Angular application with many features? Angular › Angular Style Guide & Best Practices | Angular | Angular Style Guide & Best Practices | Advanced |
| 259 | What is hierarchical dependency injection in Angular, and how does providing a service at the component level differ from providing it at the root level? Angular › Services & Dependency Injection | Angular | Services & Dependency Injection | Advanced |
| 260 | How would you migrate an existing NgModule based Angular application to standalone components? Angular › Standalone Components | Angular | Standalone Components | Advanced |
| 261 | How would you plan a disaster recovery strategy that combines Always On Availability Groups across multiple data centers with regular backups? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Advanced |
| 262 | How would you configure Query Store's capture and retention settings to balance detailed monitoring with storage overhead on a very busy production database? SQL Server › Query Store | SQL Server | Query Store | Advanced |
| 263 | How does replication compare to Always On Availability Groups for keeping data synchronized across multiple servers, and when would you choose one over the other? SQL Server › Replication | SQL Server | Replication | Advanced |
| 264 | 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 |
| 265 | How does tempdb contention affect the performance of applications that heavily rely on temporary tables, and what strategies help mitigate this? SQL Server › Temporary Tables & Table Variables | SQL Server | Temporary Tables & Table Variables | Advanced |
| 266 | What is the performance overhead of Transparent Data Encryption, and how does it compare across different SQL Server versions? SQL Server › Transparent Data Encryption | SQL Server | Transparent Data Encryption | Advanced |
| 267 | What happens when a hash join does not have enough memory available to build its hash table entirely in memory, and how does this affect performance? SQL Server › Hash Indexes & Hash Join Operations | SQL Server | Hash Indexes & Hash Join Operations | Advanced |
| 268 | How does Redis actually implement key expiration internally, using both a passive and an active approach? Redis › Expiration & Eviction | Redis | Expiration & Eviction | Advanced |
| 269 | How would you design a persistence strategy that combines both RDB and AOF to get the benefits of both approaches? Redis › Persistence (RDB/AOF) | Redis | Persistence (RDB/AOF) | Advanced |
| 270 | What happens during Redis startup regarding data loading, and how does the choice between RDB and AOF affect startup time for a large dataset? Redis › Persistence (RDB/AOF) | Redis | Persistence (RDB/AOF) | Advanced |
| 271 | What is memory fragmentation in Redis, and how do you detect and address it? Redis › Redis Memory Optimization | Redis | Redis Memory Optimization | Advanced |
| 272 | How would you conduct a thorough performance benchmarking exercise to compare two different Redis configurations before deciding which to use in production? Redis › Redis Performance Tuning & Benchmarking | Redis | Redis Performance Tuning & Benchmarking | Advanced |
| 273 | What operating system level tuning settings can affect Redis performance, and how would you optimize them for a production deployment? Redis › Redis Performance Tuning & Benchmarking | Redis | Redis Performance Tuning & Benchmarking | Advanced |
| 274 | How would you design a comprehensive Redis ACL strategy for an organization with multiple applications and teams accessing the same Redis infrastructure? Redis › Redis Security & ACL | Redis | Redis Security & ACL | Advanced |
| 275 | How do you secure Redis network communication using TLS encryption, and what performance considerations come with enabling it? Redis › Redis Security & ACL | Redis | Redis Security & ACL | Advanced |
| 276 | How does managing different build flavors or environments, such as development, staging, and production, help streamline the process of preparing separate app builds for internal testing versus the actual public release? Flutter › App Deployment (Play Store & App Store) | Flutter | App Deployment (Play Store & App Store) | Advanced |
| 277 | How should a large Flutter application with a substantial design system organize its theming code to keep it maintainable as the number of screens and custom components grows significantly? Flutter › App Theming & Dark Mode | Flutter | App Theming & Dark Mode | Advanced |
| 278 | How should you structure Firestore data using subcollections and denormalization to design efficient queries, given that Firestore does not support traditional relational joins across separate collections? Flutter › Cloud Firestore & Firebase Storage | Flutter | Cloud Firestore & Firebase Storage | Advanced |
| 279 | How do bounded type parameters, using the extends keyword within a generic class definition, let you constrain a generic type to only accept types that satisfy a specific requirement? Flutter › Dart Collections & Generics | Flutter | Dart Collections & Generics | Advanced |
| 280 | How can scoped dependency injection help properly manage the specific lifecycle of dependencies that should genuinely only exist for the duration of a particular feature or a specific user session, rather than living for the entire lifetime of the whole application? Flutter › Dependency Injection in Flutter (GetIt & Service Locator) | Flutter | Dependency Injection in Flutter (GetIt & Service Locator) | Advanced |
| 281 | How does linking multiple different authentication providers to a single Firebase user account work, letting a user sign in using either Google or email and password while still resolving to the exact same underlying account? Flutter › Firebase Authentication in Flutter | Flutter | Firebase Authentication in Flutter | Advanced |
| 282 | How should a large team properly establish and consistently enforce their own genuinely specific Material Design component usage guidelines and conventions across a genuinely large, actively shared Flutter codebase? Flutter › Flutter Material Design Components | Flutter | Flutter Material Design Components | Advanced |
| 283 | How can you design a plugin's own public Dart API to remain genuinely stable and backward compatible across several successive plugin versions, even as its own internal native implementation continues to meaningfully evolve and change over time? Flutter › Flutter Plugin & Package Development | Flutter | Flutter Plugin & Package Development | Advanced |
| 284 | How do you properly build a genuinely complex, multi step form, sometimes called a wizard, that guides a user progressively through several separate sequential distinct steps, while genuinely correctly preserving each individual step's own entered data as they move forward and back between the different steps? Flutter › Forms & Input Validation in Flutter | Flutter | Forms & Input Validation in Flutter | Advanced |
| 285 | How should you properly structure GraphQL fragments to genuinely share a common set of fields consistently across several separate different queries, keeping your overall GraphQL codebase genuinely more maintainable as it steadily grows? Flutter › GraphQL in Flutter | Flutter | GraphQL in Flutter | Advanced |
| 286 | What are the genuine practical tradeoffs of choosing Hive over SQLite specifically for a Flutter app that genuinely needs to store a fairly large, genuinely complex, and highly relational dataset? Flutter › Hive & NoSQL Local Storage | Flutter | Hive & NoSQL Local Storage | Advanced |
| 287 | How should a large team properly manage translation workflows for their app, including working effectively with professional translators and keeping ARB files properly synchronized across several genuinely separate active feature branches? Flutter › Internationalization & Localization (i18n) | Flutter | Internationalization & Localization (i18n) | Advanced |
| 288 | How should you properly implement database transactions in sqflite to ensure several genuinely related separate operations either all fully succeed together, or all genuinely fail together entirely, maintaining your overall data's own genuine consistency? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Advanced |
| 289 | How should a large team properly establish testing conventions and standards, including deciding on a genuinely reasonable required minimum coverage threshold and properly enforcing it through their CI pipeline? Flutter › Unit Testing in Flutter | Flutter | Unit Testing in Flutter | Advanced |