M001 MongoDB Basics Q&A (Quiz, Labs & Final Exam)

Lab 2.1 :  How many comedies:

If you have not already loaded the movieDetails collection, please review the previous video for a tutorial. Then, use the script, loadMovieDetailsDataset.js, provided in the handouts for the lesson, "Connecting to an Atlas Cluster from the Mongo Shell" to load the movieDetails collection.

Use Compass to connect to your sandbox cluster.

In Compass, view the video.movieDetails collection and apply the filter {genres: "Comedy"}.

How many documents in video.movieDetails match the filter {genres: "Comedy"}?

Ans>> 749

Creating Documents: insertOne()

Lab 2.2 :  How many inserted:

If the collection video.myMovies is currently empty, how many documents would be inserted by the following call to insertMany().

db.myMovies.insertMany(

  [

    {

      "_id" : "tt0084726",

      "title" : "Star Trek II: The Wrath of Khan",

      "year" : 1982,

      "type" : "movie"

    },

    {

      "_id" : "tt0796366",

      "title" : "Star Trek",

      "year" : 2009,

      "type" : "movie"

    },

    {

      "_id" : "tt0084726",

      "title" : "Star Trek II: The Wrath of Khan",

      "year" : 1982,

      "type" : "movie"

    },

    {

      "_id" : "tt1408101",

      "title" : "Star Trek Into Darkness",

      "year" : 2013,

      "type" : "movie"

    },

    {

      "_id" : "tt0117731",

      "title" : "Star Trek: First Contact",

      "year" : 1996,

      "type" : "movie"

    }

  ],

  {

    ordered: false

  }

);

Ans >>  4 (as this is an un-ordered insert)

Reading Documents: Scalar Fields

Explore the movieDetails collection that you loaded into your Atlas sandbox cluster and then issue a query to answer the following question. How many movies in the movieDetails collection have exactly 2 award wins and 2 award nominations?

You will find the count() method useful in answering this question using the mongo shell.

Using Compass:

Ans >> 12 (as above)

Lab 2.3 :  Query on Scalar Fields:

Explore the movieDetails collection that you loaded into your Atlas sandbox cluster and then issue a query to answer the following question. How many movies in the movieDetails collection are rated PG and have exactly 10 award nominations?

You will find the count() method useful in answering this question using the mongo shell.

Using Compass:

Using MongoShell:

 Ans>>  3 (as above)

Reading Documents: Array Fields

Explore the movieDetails collection that you loaded into your Atlas sandbox cluster and then issue a query to answer the following question. How many documents list just two writers: "Ethan Coen" and "Joel Coen", in that order?

You will find the count() method useful in answering this question using the mongo shell.

Using Compass:

Using Mongo Shell:

Ans>> 1

Lab 2.4:  Query on Array Fields (Part 1):

Explore the movieDetails collection that you loaded into your Atlas sandbox cluster and then issue a query to answer the following question. How many movies in the movieDetails collection list "Family" among its genres?

You will find the count() method useful in answering this question using the mongo shell.

Using Compass:

Using mongo Shell:

Ans>> 124

Lab 2.5:  Query on Array Fields (Part 2):

Explore the movieDetails collection that you loaded into your Atlas sandbox cluster and then issue a query to answer the following question. How many movies in the movieDetails collection list "Western" second among its genres?

You will find the count() method useful in answering this question using the mongo shell.

Using Compass:

Using mongo Shell:

Ans>> 14

Lab 2.6:  Update Operators:

Suppose you wish to update the value of the plot field for one document in our movieDetails collection to correct a typo. Which of the following update operators and modifiers would you need to use to do this?

Check all that apply:

Ans>>

Final Exam

Q1: Connect to our class Atlas cluster from Compass and view the citybike.tripscollection. Use the schema view and any filters you feel are necessary to determine the range of values for the usertype field. Which of the following are values found in this collection for the field usertype?

Ans>>

Q2: Connect to our class Atlas cluster from Compass and view the 100YWeatherSmall.datacollection. Using the Schema view, explore the wind field. The wind field has the value type of document. Which of the following best describes the schema of this embedded document?

Ans>>

Q3: Connect to the M001 class Atlas cluster from Compass and view the 100YWeatherSmall.data collection. What is the value type of the "wind.speed.rate" field?

Ans >>

Q4: Please connect to the M001 class Atlas cluster. You may answer this question using either the mongo shell or Compass.

For this question we will use the citibike database.

How many documents in the citibike.trips collection have the key tripduration set to null? Ignore any documents that do not contain the tripduration key.

Ans>>

There are two documents in citibike.trips that have the tripduration key set to null. 

Using mongo shell:
Connect to the M001 class Atlas cluster, use the below commands:

use citibike

db.trips.find({$and: [{tripduration: null}, {tripduration: {$exists: true}}]}).count()

Using Compass: 
Navigate to the citibike.trips collection and use filter in either the Schema or Documents view.

{$and: [{tripduration: null}, {tripduration: {$exists: true}}]}

Q5: Using the video.movieDetails collection, which of the queries below would produce output documents that resemble the following. Check all that apply.

{ "title" : "P.S. I Love You" }

{ "title" : "Love Actually" }

{ "title" : "Shakespeare in Love" }

NOTE: We are not asking you to consider specifically which documents would be output from the queries below, but rather what fields the output documents would contain.

Ans>>

Q6: Please connect to the M001 class Atlas cluster from the mongo shell or Compass and view the video.movies collection. How many movies match the following criteria?

• The cast includes either of the following actors: "Jack Nicholson", "John Huston"
• The viewerRating is greater than 7
• The mpaaRating is "R".

Ans>>

Using Mongo shell:

Connect to the M001 class Atlas cluster & used below commands:

use video

db.movies.find({cast: {$in: ["Jack Nicholson", "John Huston"]}, viewerRating: {$gt: 7}, mpaaRating: "R"}).count()

Using Compass:
Use video.movies collection and then apply the following filter in either the Schema or Documents view.

{cast: {$in: ["Jack Nicholson", "John Huston"]}, viewerRating: {$gt: 7}, mpaaRating: "R"}