Become MongoDB Certified with updated Associate-Data-Modeler exam questions and correct answers
A MongoDB data modeler is optimizing the performance of an application that frequently executes the following query:
db.orders.find(
{ status: "shipped", deliveryDate: { $lte: new Date("2023-12-31") } }
).sort({ deliveryDate: -1 })
The explain method reveals the following key details indicating the query is not efficiently utilizing indexes:
{
"queryPlanner": {
...
"winningPlan": {
"stage": "SORT",
"sortPattern": { "deliveryDate": -1 },
...
"inputStage": {
"stage": "FETCH",
"inputStage": {
"stage": "IXSCAN",
"keyPattern": { "status": 1 },
...
}
}
}
},
"executionStats": {
"executionSuccess": true,
"nReturned": 100,
"executionTimeMillis": 120,
"totalKeysExamined": 500,
"totalDocsExamined": 500,
...
},
...
}
What action should the data modeler take to enhance the performance of this query?
When optimizing a MongoDB collection's schema for a high-traffic application, what factor is crucial for determining the most effective document structure?
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?
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?
In designing a data model for a new online bookstore application, you are tasked with structuring the relationship between Books and Authors. Each book can have one or more authors, and each author can write multiple books. Considering the requirement for fast reads and updates of both books and their associated authors, which of the following data modeling patterns would be most optimal?
© Copyrights DumpsCertify 2026. All Rights Reserved
We use cookies to ensure your best experience. So we hope you are happy to receive all cookies on the DumpsCertify.