Free MongoDB Associate-Data-Modeler Exam Questions

In a MongoDB database for an online bookstore, you're designing a data model to handle books, authors, and reviews efficiently, considering a complex scenario involving relationships and potential data skew due to varying numbers of reviews per book. Given the requirements:

Each book can have multiple authors.

Each author can write multiple books.

Books can have a large number of reviews, but most have a few or none, creating potential data skew.

The application frequently queries books with their authors and a sample of reviews to avoid performance issues due to data skew.

How should you model the relationships among books, authors, and reviews to optimize for query performance and data management?

A data modeler is tasked with enhancing query efficiency for the salesRecords collection. Considering the queries:

db.salesRecords.find({"productId": 15}).sort({"saleDate": -1, "quantity": 1})

and

db.salesRecords.find({"saleDate": {"$gte": ISODate("2023-06-01")}}).sort({"productId": 1, "quantity": -1})

which indexing strategy would be most effective in improving response times for both queries?

A database administrator is tasked with designing a MongoDB schema for a social media application that includes features for user profiles, posts, and friend connections. The application requires efficient access to a user's profile information, their posts, and their list of friends. Considering the need for high performance in both read and write operations, which schema design approach is most appropriate?

A database designer is structuring a database for a book publishing company using MongoDB. In this design, there are two entities: Author and Book. An Author can write multiple Books, but each Book can be written by only one Author. What is the relationship between Authors and Books?

In an e-commerce application, the main entity Product includes details such as name, description, and price. Each Product can have multiple Review documents, which include ratings and customer comments. The application frequently displays products along with their reviews. How should the developer optimize the schema for read performance?