Question 1

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?

Options :

A : Embedding user profile, posts, and friends into a single document per user.

B : Storing all user data in a single, large JSON document per user in a NoSQL collection to optimize for read performance at any cost.

C : Embedding posts and friends list within the user profile document, but limiting the size by only including recent posts and closest friends, with additional collections for historical posts and less active friends.

D : Using separate collections for user profiles, posts, and friends, with references between them.

Answer: C

Question 2

In designing a catalog application, a developer is dealing with Product entities that have multiple Review entities. The application frequently displays products along with the top three reviews based on ratings. How should the developer model this data to optimize for performance?

Options :

A : Use a separate collection to maintain a list of product IDs and their associated top three review IDs.

B : Embed the top three Review documents within each Product document.

C : Store each Review in a separate document, linking them to their respective Product via a product ID.

D : Embed all Review documents within their respective Product document.

Answer: B

Question 3

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?

Options :

A : Embed Review documents within the Product document as an array of subdocuments.

B : Store each Review in a separate collection and use the Product ID to link to each Review.

C : Create a separate Review collection and a ProductReview join collection to manage the many-to-many relationship.

D : Store Review documents in a separate collection without storing a reference to the Product ID.

Answer: A

Question 4

A mobile application tracks user activities, interactions, and engagement metrics to offer personalized content and recommendations. To optimize the application's performance, particularly for generating monthly engagement reports and user insights, a data modeler is tasked with designing an efficient data storage strategy. What approach should the data modeler adopt to best meet these requirements?

Options :

A : Maintain separate collections for users, activities, and interactions, calculating engagement metrics and insights in real time upon each query.

B : Use a single collection for activities and employ on-the-fly aggregation queries for generating user engagement reports and insights whenever needed.

C : Store all user data, including activities and interactions, as embedded documents within a single user document in a single collection.

D : Utilize separate collections for Users, Activities, and EngagementMetrics. Use the computed pattern to periodically update EngagementMetrics with aggregated data.

Answer: D

Question 5

In designing a database schema for a MongoDB application that handles user-generated content, such as posts and comments, a data modeler is considering the most efficient way to store comments related to each post to optimize read operations, as the application experiences significantly more reads than writes. The application requires frequent retrieval of posts along with their associated comments. What pattern should the data modeler use to store comments in relation to posts, and why?

Options :

A : Reference Pattern

B : Subset Pattern

C : Bucket Pattern

D : Normalized Pattern

E : Embedded Pattern

Answer: E

Higher Test Marks with Free Online Associate-Data-Modeler Exam Practice

Buying Options: