Question 1

In the design of a MongoDB database for an application that manages user profiles with varying degrees of completeness and privacy settings, what are the positives and negatives of relying on in-app enforcement versus schema validation to ensure data integrity and compliance with business requirements?

Options :

A : Schema validation ensures that all data writes adhere to the defined schema, reducing the need for additional application logic but lacks flexibility for handling complex conditional validation.

B : In-app enforcement is more performance-efficient because it avoids the overhead of database-level checks but can result in data integrity issues if the application crashes.

C : In-app enforcement allows for more complex logic and conditional validation but may lead to inconsistency if not implemented correctly across all application components.

D : Schema validation simplifies application code by offloading rules to the database but can lead to performance bottlenecks under heavy write loads.

Answer: C

Question 2

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?

Options :

A : Squillions-to-one

B : One-to-one

C : One-to-many

D : Many-to-one

E : Many-to-many

Answer: C

Question 3

A data modeler is tasked with designing a database for a movie streaming service. The database needs to efficiently store and retrieve information about movies, including the movie's title, director, genre(s), release year, and average viewer rating. How should the data modeler structure the Movie entity?

Options :

A : Model Movie as a movie-s title, director, genre(s), release year, and average viewer rating.

B : Model Movie as a movie-s title, director, and genre(s).

C : Model Movie as a movie-s title, director, genre(s), release year, average viewer rating, and the total number of viewers.

D : Model Movie as the movie-s title only.

Answer: A

Question 4

In a MongoDB database, the events collection stores documents related to various events with fields like eventId, title, location, and date. The schema needs to be updated to support a new tags array field, which will store keywords related to each event. What is the most effective way to introduce this change, ensuring backward compatibility and minimal disruption to the existing application?

Options :

A : Create a separate collection named eventTags to store tags with references to their corresponding events by eventId, and adjust the application to aggregate data from both collections.

B : Introduce a schemaVersion field in the documents of the events collection, setting it to 2 for documents including the tags field, and modify the application to handle documents based on their schema version.

C : Add the tags field with an empty array as the default value to all existing documents in the events collection, requiring minimal application changes.

D : Migrate all documents to a new collection named events_v2, including the tags field for new documents, and update the application code to reference the new collection.

Answer: B

Question 5

When designing a MongoDB schema for an application that tracks user activities and their corresponding locations, which approach best facilitates efficient data retrieval and updates?

Options :

A : Create a multidimensional array within each user document to store activities and their corresponding locations.

B : Store user activities and location data in separate documents within a single collection, linking them with unique identifiers.

C : Normalize all data, storing user activities in one collection and locations in another, without using any form of document references.

D : Embed user location data directly within each activity document to capitalize on document locality.

Answer: D

Confidently Practice Online with Free Associate-Data-Modeler Exam Cram

Buying Options: