M201 MongoDB Performance - Labs & Final Exam Q&A

M201 MongoDB Performance

 Chapter-1 Introduction to MongoDB Performance
Chapter – 2 MongoDB Indexes
Chapter – 3 Index Operations
Chapter 4: CURD Optimization
Chapter 5: Performance on Clusters

Final Exam

Comments

Post a Comment

Popular posts from this blog

Question 1

Image
Which of these statements is/are true? Answer: You can index multiple array fields in a single document with a single compound index - False   Multikey indexes allow us to index on array fields, but they do not support indexes on multiple array fields on single documents. Covered queries can sometimes still require some of your documents to be examined - False A query is covered if and only if it can be satisfied using the keys of the index. Write concern has no impact on write latency - False Different write concerns can certainly impact your write latency. Write concerns that only need acknowledgment from a primary are generally faster than ones that need acknowledgment from a majority of replica set members. Creating an ascending index on a monotonically increasing value creates index keys on the right-hand side of the index tree - True A collection scan has a logarithmic search time - False No, collection scans have a  linear  search time. ...
Read more

Lab 2.1

Image
In this lab you're going to determine which queries are able to successfully use a given index for both filtering and sorting. Given the following index: {"first_name": 1, "address.state": -1, "address.city": -1, "ssn": 1} Which of the following queries are able to use it for both filtering and sorting? Check all that apply: Answer: db.people.find({ "first_name": { $gt: "J" } }).sort({ "address.city": -1 }) - No - This query doesn't use equality on the index prefix. When using an index for filtering and sorting the query must include equality conditions on all the prefix keys that precede the sort keys. Moreover, on the sort predicate it skipped the next key in the prefix "address.state". db.people.find({ "first_name": "Jessica" }).sort({ "address.state": 1, "address.city": 1 }) - Yes . This query matches with equality on the query predicate wit...
Read more