Type of data architecture?

System Design
Medium
Infosys
74.3K views

Broad question to assess understanding of data storage and processing structures.

Why Interviewers Ask This

Data architecture is fundamental to designing scalable systems. The interviewer wants to see if the candidate understands the different models of organizing data, such as relational, NoSQL, or data warehouses. It tests their ability to discuss high-level system design concepts.

How to Answer This Question

Discuss common architectures like monolithic, layered, microservices, and data-specific ones like star schema or snowflake. Mention the differences between OLTP and OLAP systems. Explain how the choice depends on the use case, such as transaction processing vs. analytics. Keep the answer broad but informative.

Key Points to Cover

  • Relational vs NoSQL
  • OLTP vs OLAP
  • Data warehousing
  • Scalability considerations

Sample Answer

Data architecture encompasses various models depending on the application needs. Common types include relational architectures for structured data, NoSQL for unstructured data, and data warehousing for analytical purposes. We also distinguish between Online Transaction Processing (OLTP) systems for day-to-day operations and Online Analytical Processing (OLAP) systems for reporting. The choice of architecture impacts scalability, consistency, and performance, so it must align with the specific business requirements.

Common Mistakes to Avoid

  • Focusing only on one type
  • Lack of distinction between transactional and analytical
  • Too much jargon without explanation

Practice This Question with AI

Answer this question orally or via text and get instant AI-powered feedback on your response quality, structure, and delivery.

Start Practicing

Related Interview Questions

Browse all 158 System Design questionsBrowse all 65 Infosys questions