Database Structure Types DS0-001 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A team is designing a database for a library system. They need to store information about books, authors, and the many-to-many relationship between them. They also need to enforce that a book must have at least one author. Which data model is most appropriate?

   • AGraph model with nodes and edges
   • BRelational model with a junction table
   • CKey-value model with book and author keys
   • DDocument model with embedded author arrays
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which scaling approach is most commonly associated with non-relational databases?

   • AVertical scaling by adding more CPU and memory to a single server
   • BScaling by partitioning the database schema
   • CScaling by using read replicas only
   • DHorizontal scaling by adding more servers to distribute the load
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   How does the data model of a relational database differ from that of a document-oriented NoSQL database?

   • ARelational databases use flexible schemas, while document databases use fixed schemas
   • BRelational databases are schema-less, while document databases require a predefined schema
   • CRelational databases use normalized tables, while document databases use denormalized documents
   • DRelational databases store data in documents, while document databases store data in tables
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which of the following best describes the fundamental structure of a relational database?

   • AA graph of nodes and edges representing entities and their connections
   • BA collection of column families, each storing rows with varying columns
   • CA set of tables composed of rows and columns, with relationships defined between tables
   • DA collection of documents, each containing key-value pairs
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A university database stores student records, courses, and enrollments. The administration needs to generate a report showing each student's name and the courses they are enrolled in. The data is currently normalized into separate tables. What is the most efficient way to generate this report?

   • ADenormalize the data into a single table
   • BUse a JOIN query to combine the tables
   • CExport all tables to a spreadsheet and manually combine
   • DUse a subquery to fetch courses for each student
   Reveal Solution Discussion Select an answer first