Evaluate Choice of Database Types with Respect to Application Requirements (such as Relational, Document, Graph, Columnar, and Time Series) 350-901 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   An e-commerce platform stores product listings. Each product can have different attributes (e.g., color, size, material) depending on the category, and new categories are added monthly. The team needs to store and query these products without predefined schemas. Which database type is most appropriate?

   • AGraph database
   • BRelational database with nullable columns
   • CTime series database
   • DDocument database
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   An application needs to store sensor readings that arrive every second and must support queries like 'average temperature over the last hour'. Which database type is most appropriate?

   • ATime series database
   • BRelational database
   • CDocument database
   • DGraph database
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which data structure is fundamental to a graph database?

   • AColumns optimized for analytical queries
   • BDocuments with flexible schemas
   • CNodes and edges representing entities and their relationships
   • DTables with rows and columns
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A social network application needs to answer queries like 'find all friends of friends' and 'find the shortest path between two users'. The data is highly connected, and the team expects to traverse relationships frequently. Which database type is best suited for this workload?

   • ADocument database
   • BGraph database
   • CColumnar database
   • DRelational database
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A company is building a reporting system that generates daily sales reports. The system needs to store transactional data (orders, customers) and also run analytical queries that aggregate sales by product and region. They are considering using a relational database for transactions and a columnar database for analytics. What is the primary benefit of this architecture?

   • AIt reduces the total cost of ownership
   • BIt allows each database to be optimized for its specific workload
   • CIt eliminates the need for data transformation
   • DIt simplifies the application architecture
   Reveal Solution Discussion Select an answer first