Question 1

How does MongoDB handle sorting on fields that contain missing values (i.e., values that are not present in all documents in the collection)?

Options :

A : The behavior of sorting on missing values depends on the version of MongoDB being used.

B : The sort fails and returns an error.

C : Missing values are sorted first.

D : Missing values are sorted last.

Answer: C

Question 2

In MongoDB, the $out operator is commonly used within an aggregation pipeline. Which of the following statements accurately describes the functionality and usage of the $out operator?

Options :

A : $out operator is used to output the results to a specified collection.

B : $out operator can be used to output the results to a collection in a different MongoDB database.

C : $out operator is used to export data directly to a file.

D : $out operator is used to read data from multiple collections in a single command.

Answer: A

Question 3

Suppose you have a products collection with an index:

{ product_category: 1 }

For which of the following queries can MongoDB look at only a subset of the index entries, rather than all of the index entries?

Options :

A : db.products.find( { product_category: /A$/ } )

B : db.products.find( { product_category: /A./ } )

C : db.products.find( { product_category: /S./ } )

D : db.products.find( { product_category: /^A./ } )

Answer: D

Question 4

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.

Options :

A : { "$match": { "quantity": { "$gt": 100 }, "status": "delivered" } }

B : { "$match": { "quantity": { "$lt": 100 }, "status": "delivered" } }

C : { "$match": { "quantity": { "$gt": 100 }, "status": { "$eq": "delivered" } } }

D : { "$match": { "quantity": { "$gte": 100 }, "status": "delivered" } }

Answer: A

Question 5

As a MongoDB Developer, you are tasked with the deletion of specific documents in a collection named users. The documents to be deleted are those that meet the following criteria: the age field is less than 18 and the status field is "inactive". After the deletion, you need to know the count of the deleted documents. Which of the following commands would correctly perform this operation?

Options :

A :

B :

C :

D :

E :

Answer: A

Higher Test Marks with Free Online C100DEV Exam Practice

Buying Options: