Free C100DEV Mock Exam – Practice Online Confidently

In your database there is a collection named trips with the following document structure:{  '_id': ObjectId("572bb8222b288919b68abf6d"),  'trip_duration': 858,  'start_station id': 532,  'end_station_id': 401,  'bike_id': 17057,  'start_station_loc': { type: 'Point', coordinates: [ -73.960876, 40.710451 ] },  'end_station_loc': { type: 'Point', coordinates: [ -73.98997825, 40.72019576 ] },  'start_time': ISODate("2016-01-01T00:09:31.000Z"),  'stop_time': ISODate("2016-01-01T00:23:49.000Z")}How can you extract all trips from this collection ended at stations that are to the west of the -73.5 longitude coordinate?

You are designing a MongoDB schema for an e-commerce platform. The system has three collections: Products, Categories, and Reviews.Products Collection: Contains information about each product, including its name, price, and categoryId referencing the Categories collection.Categories Collection: Contains the category name and description.Reviews Collection: Contains user reviews for products, including the productId referencing the Products collection, userId, rating, and reviewText.Which of the following is the best approach to model the relationships between Products, Categories, and Reviews in MongoDB?

Consider a MongoDB database managing e-commerce product data. The database has a collection named products with documents containing the fields product_id, category, price, and reviews. Each reviews field is an array of subdocuments with fields user_id, rating, and comment. You are tasked with optimizing a query that retrieves all products within a specific category that have an average rating higher than 4. The query is frequently used, and performance is critical. Which indexing strategy would best optimize this query?

You have a MongoDB collection named students, where each document represents a student. The documents include fields like name, age, and courses. The courses field is an array that lists the course codes each student is enrolled in. You want to find all students enrolled in the course with the code "CS101". Which query will correctly retrieve all students enrolled in "CS101"?

In a MongoDB database, you have a collection named orders that contains information about various product orders placed by customers. Each document in the collection has the following structure:{  "customerID": "",  "orderID": "",  "product": "",  "quantity": ,  "price": ,  "date": "",  "status": ""}You are required to write an aggregation query that retrieves all orders placed by customers where the quantity of ordered items is greater than 100 and the status of the order is "delivered". Which of the following $match stages would you use to achieve this? Select the best option.