MongoDB C100DBA - MongoDB Associate Database Administrator Exam
Page: 1 / 31
Total 152 questions
Question #1 (Topic: Exam A)
An Atlas Sample Dataset of restaurants is loaded into a database deployment.
How is Data Explorer used to find all restaurants whose name is “The Rose Palace” in the Restaurants database?
How is Data Explorer used to find all restaurants whose name is “The Rose Palace” in the Restaurants database?
A. Select the collection on the left-hand side.
Select the “Aggregation” view.
Specify the first stage as $match query: {name: “The Rose Palace”}
Specify the following query: “$limit: 1”. B. Select the collection on the left-hand side.
Select the “Find” view.
Select “Filter” and type {name: “The Rose Palace”}
Click “Find” to run the query. C. MongoDB Data Explorer is primarily used to insert/edit/delete documents, not find them. D. Select the collection on the left-hand side.
Select the “Find” view.
Select “Filter” and type {name == “The Rose Palace”}
Click “Find” to run the query.
Select the “Aggregation” view.
Specify the first stage as $match query: {name: “The Rose Palace”}
Specify the following query: “$limit: 1”. B. Select the collection on the left-hand side.
Select the “Find” view.
Select “Filter” and type {name: “The Rose Palace”}
Click “Find” to run the query. C. MongoDB Data Explorer is primarily used to insert/edit/delete documents, not find them. D. Select the collection on the left-hand side.
Select the “Find” view.
Select “Filter” and type {name == “The Rose Palace”}
Click “Find” to run the query.
Answer: B
Question #2 (Topic: Exam A)
Given the following query:
db.coll.find({}).sort({“income”: 1, “tax”: -1})
Which two indexes will improve the performance of this query the most? (Choose two.)
db.coll.find({}).sort({“income”: 1, “tax”: -1})
Which two indexes will improve the performance of this query the most? (Choose two.)
A. {“income”: -1, “tax”: -1}
B. {“income”: -1, “tax”: 1}
C. {“income”: 1, “tax”: -1}
D. {“income”: 1, “tax”: 1}
Answer: BC
Question #3 (Topic: Exam A)
Given the following sample documents:
{_id:1, company: “Farm Inc.”, active: true},
{_id:2, company: “Garden Inc.”, active: false}
A developer wants to create a search query to search for a company. There is a business requirement to accommodate misspellings. An Atlas Search index has already been created for this query.
What query satisfies these requirements?
{_id:1, company: “Farm Inc.”, active: true},
{_id:2, company: “Garden Inc.”, active: false}
A developer wants to create a search query to search for a company. There is a business requirement to accommodate misspellings. An Atlas Search index has already been created for this query.
What query satisfies these requirements?
A. db.users.aggregate({$search: {“text”: {“path”: “company”, “query”: “Gardin” }})
B. db.users.aggregate({$search: {“text”: {“path”: “company”, “query”: “Gardin”, “misspelled”: true}})
C. db.users.aggregate({$search: {“text”: {“path”: “company”, “query”: “Gardin”, “fuzzy”: {}}})
D. db.users.aggregate($search: {“company”, “Gardin”, true})
Answer: C
Question #4 (Topic: Exam A)
Given the following documents in a collection:
{_id:1, a: “one”, b: “two”}
{_id:2, a: “two”, b: “three”}
{_id:3, a: “one”, b: “four”, c: “three”}
Using the following update command:
db.coll.replaceOne({a: “one”}, {d: “two”, b: “five”})
What would the contents of the collection be after successfully running this command?
{_id:1, a: “one”, b: “two”}
{_id:2, a: “two”, b: “three”}
{_id:3, a: “one”, b: “four”, c: “three”}
Using the following update command:
db.coll.replaceOne({a: “one”}, {d: “two”, b: “five”})
What would the contents of the collection be after successfully running this command?
A. {_id:1, d: “two”, b: “five”}
{_id:2, a: “two”, b: “three”}
{_id:3, a: “one”, b: “four”, c: “three”} B. {_id:1, a: “one”, b: “five”}
{_id:2, a: “two”, b: “three”}
{_id:3, a: “one”, b: “four”, c: “three”} C. {_id:1, a: “one”, d: “two”, b: “five”}
{_id:2, a: “two”, b: “three”}
{_id:3, a: “one”, b: “four”, c: “three”} D. {_id:1, d: “two”, b: “five”}
{_id:2, a: “two”, b: “three”}
{_id:3, d: “two”, b: “five”}
{_id:2, a: “two”, b: “three”}
{_id:3, a: “one”, b: “four”, c: “three”} B. {_id:1, a: “one”, b: “five”}
{_id:2, a: “two”, b: “three”}
{_id:3, a: “one”, b: “four”, c: “three”} C. {_id:1, a: “one”, d: “two”, b: “five”}
{_id:2, a: “two”, b: “three”}
{_id:3, a: “one”, b: “four”, c: “three”} D. {_id:1, d: “two”, b: “five”}
{_id:2, a: “two”, b: “three”}
{_id:3, d: “two”, b: “five”}
Answer: A
Question #5 (Topic: Exam A)
Given the following match expression:
{“c”: {$eq: “Green”}, “a”: {$gt: 3}}
{ _id: 1, p: 0.75, c: ‘Green’, a: [1,3,5,7]},
{ _id: 2, p: 0.80, c: ‘Orange, a: [1,3]},
{ _id: 3, p: 0.13, c: [‘Green’, ‘Orange’], a: [3]},
{ _id: 4, p: 0.00, c: ‘Green’, a: [5,7]},
{ _id: 5, p: 0.04, c: ‘Green’, a: 3},
{ _id: 6, p: 0.97, c: ‘Red, a:5}
What document will be returned from this expression?
{“c”: {$eq: “Green”}, “a”: {$gt: 3}}
{ _id: 1, p: 0.75, c: ‘Green’, a: [1,3,5,7]},
{ _id: 2, p: 0.80, c: ‘Orange, a: [1,3]},
{ _id: 3, p: 0.13, c: [‘Green’, ‘Orange’], a: [3]},
{ _id: 4, p: 0.00, c: ‘Green’, a: [5,7]},
{ _id: 5, p: 0.04, c: ‘Green’, a: 3},
{ _id: 6, p: 0.97, c: ‘Red, a:5}
What document will be returned from this expression?
A. { _id: 1, p: 0.75, c: ‘Green’, a: [1,3,5,7]},
{ _id: 2, p: 0.80, c: ‘Orange, a: [1,3]},
{ _id: 4, p: 0.00, c: ‘Green’, a: [5,7]} B. { _id: 4, p: 0.00, c: ‘Green’, a: [5,7]} C. { _id: 1, p: 0.75, c: ‘Green’, a: [1,3,5,7]},
{ _id: 3, p: 0.13, c: [‘Green’, ‘Orange’], a: [3]},
{ _id: 4, p: 0.00, c: ‘Green’, a: [5,7]},
{ _id: 5, p: 0.04, c: ‘Green’, a: 3},
{ _id: 6, p: 0.97, c: ‘Red, a:5} D. { _id: 1, p: 0.75, c: ‘Green’, a: [1,3,5,7]},
{ _id: 4, p: 0.00, c: ‘Green’, a: [5,7]}
{ _id: 2, p: 0.80, c: ‘Orange, a: [1,3]},
{ _id: 4, p: 0.00, c: ‘Green’, a: [5,7]} B. { _id: 4, p: 0.00, c: ‘Green’, a: [5,7]} C. { _id: 1, p: 0.75, c: ‘Green’, a: [1,3,5,7]},
{ _id: 3, p: 0.13, c: [‘Green’, ‘Orange’], a: [3]},
{ _id: 4, p: 0.00, c: ‘Green’, a: [5,7]},
{ _id: 5, p: 0.04, c: ‘Green’, a: 3},
{ _id: 6, p: 0.97, c: ‘Red, a:5} D. { _id: 1, p: 0.75, c: ‘Green’, a: [1,3,5,7]},
{ _id: 4, p: 0.00, c: ‘Green’, a: [5,7]}
Answer: D
