Diferències

Ací es mostren les diferències entre la revisió seleccionada i la versió actual de la pàgina.

--- info:cursos:mongodbuniversity:m001:cap3 [15/12/2018 09:38] – [Challenge Problem] mate
+++ info:cursos:mongodbuniversity:m001:cap3 [15/12/2018 10:16] (actual) – [Challenge Problem] mate
@@ Línia 150: / Línia 150: @@
 <code javascript>{"results": {$in: [{$gte: 70}, {$lt: 90}] } }  // WRONG!</code>
+== Final Exam
+<button collapse="exam" size="xs">Algunas respuestas...</button>
+<collapse id="exam" collapsed="true">
+  * 4: 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.<code javascript>{$and: [{tripduration: {$exists: true}}, {tripduration: { $eq: null}} ] }</code>
+  * 6: 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".<code javascript>{ cast: {$in:["Jack Nicholson","John Huston"]}, viewerRating:{$gt:7},mpaaRating:"R" }</code>
+</collapse>