Question 1

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 2

Regarding MongoDB schema design and document structure, which two of the following statements are accurate?

Options :

A : All documents within a collection must have the same fields and data types.

B : Embedding documents is recommended for frequently accessed data that is read together.

C : Schema validation rules are enforced by default on all collections upon creation.

D : Denormalization can reduce the need for expensive joins and improve read performance.

Answer: B,D

Question 3

In the context of a MongoDB database application for an online news platform, the data modeler is tasked with optimizing the storage and retrieval of news articles that are frequently accessed by readers. The articles undergo occasional updates by the editorial team and include metadata such as publication date, author, and a set of tags. The application has a high read-to-write ratio, with the need for efficient retrieval of articles based on tags and publication dates. What data modeling strategy should be adopted to maximize query performance for retrieving articles based on metadata?

Options :

A : Adopt the Bucket Pattern, grouping articles into buckets by publication month or year.

B : Apply the Reference Pattern, creating separate collections for articles and metadata, with references between them.

C : Employ the Indexing Pattern, creating indexes on tags and publication dates within the articles collection.

D : Implement the Embedded Documents Pattern, embedding metadata within each article document.

Answer: C

Question 4

A startup is designing a new MongoDB database to store user information and their respective device data. Each user can have multiple devices, and each device can generate daily usage statistics. The startup's application needs to frequently access a user's profile and their device's latest usage statistics. Considering scalability, efficiency, and security, which data model would best suit the startup's requirements?

Options :

A : Hybrid Model

B : Normalized Data Model

C : Embedded Documents Model

D : Bucketing

Answer: C

Question 5

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

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

Buying Options: