Q221. How does BigQuery separate storage and compute?
BigQuery is a serverless, columnar data warehouse built on a separation of storage and compute. - Storage: data lives in Capacitor, a columnar format backed by Colossus d...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (2,728 available).
Q222. When would you use Azure Functions versus App Service?
Both can host code, but they optimise for different workloads. Azure Functions is serverless and event-driven: - Consumption or Premium plans scale to zero and bill per e...
Q223. What is the difference between an Application Load Balancer and a Network Load Balancer?
Both are Elastic Load Balancers, but they operate at different OSI layers. - Application Load Balancer (layer 7) understands HTTP and HTTPS, supports host and path-based ...
Q224. Compare write-through, write-behind and write-around caching.
- Write-through: write to the cache and the database in the same operation, synchronously. The cache stays fresh and reads are fast, but writes are slower and every write...
Q225. What is the difference between OAuth 2.0 and OIDC?
OAuth 2.0 is an authorization framework for delegated access. It lets a user grant a third-party application limited access to a resource without sharing the password, an...
Q226. Compare at-most-once, at-least-once and exactly-once delivery.
- At-most-once: the broker may deliver a message once or not at all. It never duplicates, so it can lose data. Achieved by acknowledging before processing. Suitable for m...
Q227. When should you not use microservices?
Avoid microservices when: - The domain is still being explored. Wrong boundaries are far more expensive to move than within a monolith. - The team is small. Each service ...
Q228. What is the N+1 problem in GraphQL and how do you solve it?
Resolvers run per field. If a list resolver returns N items and a child field resolver loads related data one item at a time, you get one query for the list plus N querie...
Q229. How do you version a public REST API?
Common strategies: - URI path versioning: `https://api.example.com/v1/orders`. Most visible and easiest to route and cache, at the cost of polluting the URL. - Query para...
Q230. How does tree shaking work and what breaks it?
Tree shaking removes unused exports from the final bundle. It relies on ES modules being statically analysable: imports and exports are known at parse time, so the bundle...