{"id":2357,"date":"2014-04-21T08:13:26","date_gmt":"2014-04-21T08:13:26","guid":{"rendered":"http:\/\/blog.cloudthat.com\/?p=2357"},"modified":"2024-06-25T11:14:35","modified_gmt":"2024-06-25T11:14:35","slug":"sample-questions-for-mongodb-certified-dba-c100dba-exam-part-ii","status":"publish","type":"blog","link":"https:\/\/www.cloudthat.com\/resources\/blog\/sample-questions-for-mongodb-certified-dba-c100dba-exam-part-ii","title":{"rendered":"Sample Questions for MongoDB Certified DBA (C100DBA) exam – Part II"},"content":{"rendered":"

Here are some more sample questions for C100DBA: MongoDB Certified DBA Associate Exam.<\/p>\n

Please give them a try and the answers are at the end of this blog post.<\/p>\n

If you have not yet attempted Part I of sample questions – they are available here<\/a>.<\/p>\n

Section 1: Philosophy & Features:<\/strong><\/h2>\n

1. Which of the following are valid json documents? Select all that apply.<\/strong><\/p>\n

a. {\u201cname\u201d:\u201dFred Flintstone\u201d;\u201doccupation\u201d:\u201dMiner\u201d;\u201dwife\u201d:\u201dWilma\u201d}<\/p>\n

b. {}<\/p>\n

c. {\u201ccity\u201d:\u201dNew York\u201d, \u201cpopulation\u201d, 7999034, boros:{\u201cqueens\u201d, \u201cmanhattan\u201d, \u201cstaten island\u201d, \u201cthe bronx\u201d, \u201cbrooklyn\u201d}}<\/p>\n

d. {\u201ca\u201d:1, \u201cb\u201d:{\u201cb\u201d:1, \u201cc\u201d:\u201dfoo\u201d, \u201cd\u201d:\u201dbar\u201d, \u201ce\u201d:[1,2,4]}}<\/p>\n

Section 2: CRUD Operations:<\/strong><\/h2>\n

1. Which of the following operators is used to updated a document partially?<\/strong><\/p>\n

a. $update<\/p>\n

b. $set<\/p>\n

c. $project<\/p>\n

d. $modify<\/p>\n

Section 3: Aggregation Framework:<\/strong><\/h2>\n

Questions 1 to 3<\/strong><\/p>\n

Below is a sample document of \u201corders\u201d collection<\/strong><\/p>\n

{<\/strong><\/p>\n

cust_id: “abc123”,<\/strong><\/p>\n

ord_date: ISODate(“2012-11-02T17:04:11.102Z”),<\/strong><\/p>\n

status: ‘A’,<\/strong><\/p>\n

price: 50,<\/strong><\/p>\n

items: [ { sku: “xxx”, qty: 25, price: 1 },<\/strong><\/p>\n

{ sku: “yyy”, qty: 25, price: 1 } ]<\/strong><\/p>\n

}<\/strong><\/p>\n

Select operators for the below query to determine the sum of \u201cqty\u201d fields associated with the orders for each \u201ccust_id\u201d.<\/strong><\/p>\n

db.orders.aggregate( [<\/strong><\/p>\n

{ $OPR1: “$items” },<\/strong><\/p>\n

{<\/strong><\/p>\n

$OPR2: {<\/strong><\/p>\n

_id: “$cust_id”,<\/strong><\/p>\n

qty: { $OPR3: “$items.qty” }<\/strong><\/p>\n

}<\/strong><\/p>\n

}<\/strong><\/p>\n

] )<\/strong><\/p>\n

1. OPR1 is<\/strong><\/p>\n

a. $group<\/p>\n

b. $project<\/p>\n

c. $unwind<\/p>\n

d. $sum<\/p>\n

2. OPR2 is<\/strong><\/p>\n

a. $group<\/p>\n

b. $sort<\/p>\n

c. $limit<\/p>\n

d. $sum<\/p>\n

3. OPR3 is<\/strong><\/p>\n

a. $match<\/p>\n

b. $project<\/p>\n

c. $skip<\/p>\n

d. $sum<\/p>\n

Section 4: Indexing:<\/strong><\/h2>\n

1. Which of the following index would be optimum for the query? Select all valid.<\/strong><\/p>\n

db.test.find( { a : 5, c : 2 })<\/strong><\/p>\n

a. db.test.ensureIndex( { a: 1, b :1, c:1, d:1})<\/p>\n

b. db.test.ensureIndex( { a : 1, c: 1, d: 1, b : 1})<\/p>\n

c. db.test.ensureIndex( { a :1, c:1})<\/p>\n

d. db.test.ensureIndex( { c:1, a: 1})<\/p>\n

Section 5: Replication:<\/strong><\/h2>\n

1. What is the replication factor for a replicated cluster with 1 primary, 3 secondaries with one of them hidden. The set also has an arbiter?<\/strong><\/p>\n

a. 3<\/p>\n

b. 4<\/p>\n

c. 5<\/p>\n

d. None of the above<\/p>\n

Section 6: Sharding:<\/strong><\/h2>\n

1. Write the command(s) are correct to enable sharding on a database \u201ctestdb\u201d and shard a collection \u201ctestCollection\u201d with _id as shard key.<\/strong><\/p>\n

Section 7: Server & Application Administration:<\/strong><\/h2>\n

1. To add a new user and enable authentication in MongoDB, which of the following steps need be executed?<\/strong><\/p>\n

a. update users collection and restart mongodb<\/p>\n

b. update users collection and restart mongodb with –auth option<\/p>\n

c. update users collection and run db.enableAuthentication()<\/p>\n

d. All of the above<\/p>\n

Section 8: Backup & Restore:<\/strong><\/h2>\n

1. Which of the following needs to be performed prior to initiate backup on a sharded cluster?<\/strong><\/p>\n

a. db.stopServer()<\/p>\n

b. db.stopBalancer()<\/p>\n

c. sh.stopServer()<\/p>\n

d. sh.stopBalancer()<\/p>\n

Answers<\/strong><\/h3>\n

Section 1: Philosophy & Features:<\/strong><\/p>\n

1. b,d<\/p>\n

Section 2: CRUD Operations<\/strong><\/p>\n

1. b<\/p>\n

Section 3: Aggregation Framework<\/strong><\/p>\n

1. c<\/p>\n

2. a<\/p>\n

3. d<\/p>\n

Section 4: Indexing<\/strong><\/p>\n

1. b,c<\/p>\n

Section 5: Replication<\/strong><\/p>\n

1. b<\/p>\n

Section:6 Sharding<\/strong><\/p>\n

1. sh.enableSharding(“testdb”) & sh.shardCollection(“testdb.testCollection”, {_id : 1 }, true )<\/p>\n

Section 7: Server & Application Administration<\/strong><\/p>\n

1. b<\/p>\n

Section 8: Backup & Restore<\/strong><\/p>\n

1. d<\/p>\n

I will also be conducting a bootcamp for this certification in Bangalore and online. If you are interested to join, please click here and fill out the form<\/a>.<\/p>\n

Also more sample questions are coming, so keep checking.. Please share if you liked the post by using the social buttons below.<\/p>\n

Disclaimer:<\/strong> These questions are NOT what were in my certification exam. I personally or CloudThat do not have any official tie-up with MongoDB regarding the certification or the kind of questions asked. These are my best guesses for the kind of questions to expect, given my experience with MongoDB in general and with the examination.<\/p>\n","protected":false},"author":219,"featured_media":0,"parent":0,"comment_status":"open","ping_status":"open","template":"","blog_category":[3639,3774],"user_email":"prarthitm@cloudthat.com","published_by":"324","primary-authors":"","secondary-authors":"","acf":[],"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog\/2357"}],"collection":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/users\/219"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/comments?post=2357"}],"version-history":[{"count":1,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog\/2357\/revisions"}],"predecessor-version":[{"id":45971,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog\/2357\/revisions\/45971"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/media?parent=2357"}],"wp:term":[{"taxonomy":"blog_category","embeddable":true,"href":"https:\/\/www.cloudthat.com\/resources\/wp-json\/wp\/v2\/blog_category?post=2357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}