Solutions Architect Technical Interview Questions

Pathworks P. - "To answer this, I will focus my efforts on explaining the most common type of API used in most modern software development applications - the REST API. For the purpose of simplicity, I will also keep the topics of Authorization and Authentication out of the mix. In essence, an API is a group of logic that takes in a specific set of inputs and responds with a specific set of outputs. This is analogous to going to a drive-thru and placing an order for a meal. When you give an API a bunch of"See full answer

Praful B. - "The customer's business needs and requirements. The technical aspects of their legacy system. The budget and timeline constraints. The risks and mitigation strategies. The customer's specific concerns. Assess the feasibility of migrating their legacy system to the cloud - This will involve evaluating the technical aspects of their legacy system, as well as the business impact of the migration. Develop a migration plan -This plan should outline the steps involved in migrat"See full answer

Manas M. - "I'd ask Clarification questions here before proceeding with designing a CDN. The questions would be. What is the Use Case with multiple questions in it What sort of Content do you want to serve - Static files or Streaming Media or trending content? How many regions do you want to cover Do you want to prioritize speed and the Latest file availability or do you want to prioritize time-based caching per region? Budget constraints(push cdn's can be cheaper). Whether"See full answer

Kanwal jeet singh L. - " I have told about the challenge I have faced while designing the Automation Framework for Angular and React website and why we have to use 1 library puppeteer sharp over selenium e.g. we need to handle the asynch calls correctly when an object is selected in the UI and result is awaited for it."See full answer

Ali H. - "SQL databases are relational, NoSQL databases are non-relational. SQL databases use structured query language and have a predefined schema. NoSQL databases have dynamic schemas for unstructured data. SQL databases are vertically scalable, while NoSQL databases are horizontally scalable."See full answer

Rishabh L. - "Pizza Ordering System orderdetail - orderdetailid (PK), orderid (FK), itemid (FK), itemqty, itemized_price order - orderid (PK), customerid (FK), orderdate, locationid (FK), ordertype (DINEIN, PICKUP, DELIVERY), refid (dineinid, pickupid, deliveryid), subtotal, tax, tip, totalamount, payment_method (CASH, CARD) location - locationid (PK), locationdesc, city, state, startdate, enddate customer - customer_id (PK), name, address (nullable), phone (nullable), dob (d"See full answer

Kanika - "https://www.freecodecamp.org/news/what-happens-when-you-hit-url-in-your-browser/"See full answer

Nikunj V. - "OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) are two types of data processing systems, each designed for specific purposes in the context of database and data warehouse environments. OLTP (Online Transaction Processing):Purpose: OLTP systems are designed to manage and handle high volumes of transactions, such as inserting, updating, and deleting data. These systems are typically used in day-to-day business operations. Characteristics: Handles small, si"See full answer

Tej prakash V. - "DNS is a service for resolving hostname and provide fully qualified domain name of the host."See full answer

T I. - "Idempotence refers to the property that the same request multiple times produces the same result on the server side. No matter how many times I repeat the request, the server state does not change after the first request. This concept is important to ensure consistency, especially in systems where requests may be repeated due to network failures or other problems. Let's take a look at different HTTP methods for a clearer understanding. GET: By definition, GET requests must be powerless. Execut"See full answer

T I. - "This is due to sticky sessions. The load balancer is not correctly configured with sticky session option. It is likely the servers were storing session data on the server themselves (in-memory), and thus when user makes a request, the load balancer routes this to a different server than the one they started with, that second server may not recognise the user's session. This could prompt the user to log in again. One way to resolve this, is to use a centralised session storage, something like"See full answer

Ali H. - "CIDR (Classless Inter-Domain Routing) -- also known as supernetting -- is a method of assigning Internet Protocol (IP) addresses that improves the efficiency of address distribution and replaces the previous system based on Class A, Class B and Class C networks."See full answer

Gopal R. - "Stateful Firewall Tracks the state of active network connections (TCP, UDP, etc.) and makes decisions based on both rules and connection state (e.g., established sessions). Stateless Firewall Makes decisions based only on packet header information (source IP, destination IP, port, protocol) without tracking connection states."See full answer

Anonymous Narwhal - "Ability for system to keep in service without much degradation in SLA or adding significant latency."See full answer

Archna M. - "Caching is a strategy to have the frequently accessed data in the memory to reduce the latency. whenever a client request the data from server, it is first accessed into cache and if not available then it is getting fetched from the storage and stored into cache. As cache is having limited memory, so amount of data can be stored in cache is less. Data will be flushed out from cache based on a criteria which is termed as caching strategy. There could be different mechanisms under which a data can"See full answer

Madhini G. - "Use sticky sessions in loadbalancer to save the user sessions. In case of DB, use Redis cache to maintain user sessions"See full answer