C100DBA Exam Questions
126 real C100DBA exam questions with expert-verified answers and explanations. Page 2 of 3.
- Question #56Replication
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?
replication factorreplica set membersarbiterhidden member - Question #57MongoDB Fundamentals
Aggregation Pipelines have a limit of:
aggregation pipelinedocument size limitRAM limitpipeline constraints - Question #58Backup and Recovery
You are in a sharded cluster. What will you do prior to initiating backup in sharded cluster?
sharded cluster backupbalancersh.stopBalancerbackup procedure - Question #59Monitoring and Diagnostics
Which mongodb tool is used to report details on number of database operations in MongoDB?
mongostatmonitoring toolsdatabase operationsdiagnostics - Question #60Replication
The oplog (operations log) is a special capped collection that keeps a rolling record of all operations that modify the data stored in your databases. All the replica set members c...
oploglocal databasereplica setcapped collection - Question #61Monitoring and Diagnostics
What is the output of the following program?
query executionperformanceoperations timingMongoDB shell - Question #62Backup and Recovery
Which of the following needs to be performed prior to initiate backup on a sharded cluster?
sharded clusterbackupsh.stopBalancerbalancer - Question #63MongoDB Fundamentals
The difference between $push and $addToSet is:
$push$addToSetarray operatorsupdate operators - Question #64Performance Tuning
If the value of totalKeysExamined is 30000 and the value of totalDocsExamined is 0, which of the following option is correct?
explain outputindex usagetotalDocsExaminedtotalKeysExamined - Question #65MongoDB Fundamentals
We can insert multiple documents in bulk using which of the following operations:
bulk operationsinsertinitializeUnorderedBulkOp - Question #66Replication
In a sharded replica set environment, the w Option provides ability for write concern and j Option provides ability for the data to be written on disk journal. Consider that we hav...
write concernjournalsharded replica setw option - Question #67MongoDB Fundamentals
When should we consider representing a one-to-many relationship in an embedded collection instead of separate collection?
data modelingembedded documentsone-to-manyschema design - Question #68Performance Tuning
If you have created a compound index on (A,B, C) which of the following access pattern will not be able to utilize the index?
compound indexindex prefixquery optimizationleftmost prefix rule - Question #69MongoDB Fundamentals
Below is a sample document of "orders" collection
aggregation pipeline$projectfield selection - Question #70MongoDB Fundamentals
What does the output x of the following MongoDB aggregation query result into; db.posts.aggregate( [ { $group: { _id; "$author", x: { $sum: $likes } } } ] )
aggregation$group$sumaccumulator operators - Question #71Monitoring and Diagnostics
Which mongodb tools allow us to work with our data in a human readable format?
mongoexportmongoimporthuman readable formatJSON tools - Question #73Sharding
Which of the following is true about sharding?
shard keysharding limitationsimmutable shard key - Question #74MongoDB Fundamentals
JSON stands for
JSONdocument formatterminology - Question #75MongoDB Fundamentals
Which of the following is correct about MongoDB?
geospatial indexesMongoDB featuresindex types - Question #76Monitoring and Diagnostics
Which mongodb tool is used to report details on number of database operations in MongoDB?
mongostatdatabase operationsmonitoring tools - Question #77MongoDB Fundamentals
Which of the following operator can be used to limit the number of documents in an array field of a document after an update is performed?
$push$slicearray update operators$each - Question #78MongoDB Fundamentals
The________operator can be used to identify an element in the array to be updated without explicitly specifying the position of the element.
positional operatorarray update$ operator - Question #79Performance Tuning
Which command can be used to rebuild the indexes on a collection in MongoDB?
reIndexindex rebuildcollection maintenance - Question #80Security
Which of the following collections stores authentication credentials in MongoDB?
authenticationsystem.userscredentialssecurity collections - Question #81MongoDB Fundamentals
What does the following query do when performed on the posts collection? db.posts.update({_id:l},{Title:This is post with ID 1"})
document replacementupdate behavior$set operator - Question #82Sharding
Which of the following aggregation commands in MongoDB does not support sharded collections?
aggregation commandsgroup commandsharding compatibility - Question #83MongoDB Fundamentals
Which is the correct order (lowest to highest) in which MongoDB compares the BSON types?
BSONtype comparisonsort order - Question #84Performance Tuning
Which is the default mode in which the explain() command runs?
explainqueryPlannerexecution modesquery diagnostics - Question #85MongoDB Fundamentals
Which of the following operators is used to updated a document partially?
$set operatorpartial updateupdate operators - Question #86Replication
In a replica set, a_________number of members ensures that the replica set is always able to select a primary.
replica setprimary electionodd membersvoting - Question #87MongoDB Fundamentals
Consider that our posts collection contains an array field called tags that contains tags that the user enters. { Which of the following commands will find all the posts that have...
array field queryfindarray matching - Question #88MongoDB Fundamentals
What does the following $slice query return using the following command? db.posts.find( {}, { comments: { $slice: [ -10, 5 ] } } )
$slicearray projectionnegative indexfind projection - Question #89Performance Tuning
As per the aggregation pipeline optimization concepts, if you have a $sort followed by a $match:
aggregation pipeline$sort$matchpipeline optimization - Question #90MongoDB Fundamentals
Which of the following about Capped Collections is correct?
capped collectionsfixed sizeinsertion orderhigh throughput - Question #91MongoDB Fundamentals
Which option can be used with update command so that a new document gets created if no matching document is found based on the query condition?
upsertupdate optionsinsert if not exists - Question #92MongoDB Fundamentals
What is the equivalent command in MongoDB for the following SQL query? SELECT * FROM posts WHERE author like "%john%"
regex querySQL LIKE equivalentpattern matchingfind - Question #93Monitoring and Diagnostics
The MongoDB explain() method does not support which of the following verbosity mode:
explain methodverbosity modesqueryPlannerexecutionStats - Question #94Monitoring and Diagnostics
The MongoDB explain() method does not support which of the following verbosity mode:
explain methodverbosity modesqueryPlannerexecutionStats - Question #95Replication
Mongodb does provide high availability via which option?
high availabilityreplicationreplica set - Question #96Performance Tuning
Which of the following index would be optimum for the query? Select all valid. db.test.find( { a : 5, c : 2 })
index selectioncompound indexquery optimizationensureIndex - Question #97Replication
Which of the following node is used during election in a replication cluster?
arbiterprimary electionreplica setvoting member - Question #98Replication
Which of the following does MongoDB use to provide High Availability and fault tolerance?
high availabilityfault tolerancereplication - Question #99MongoDB Fundamentals
Which of the following is supported by MongoDB?
journalingACID transactionsMongoDB features - Question #100MongoDB Fundamentals
Consider a collection posts which has fields: Jd, post_text, post_author, post_timestamp, post_tags etc. Which of the following query retrieves ONLY the key named post_text from th...
findOneprojectionfield selection_id exclusion - Question #101MongoDB Fundamentals
A collection and a document in MongoDB is equivalent to which of the SQL concepts respectively?
collectiondocumentSQL equivalentsdata model - Question #102MongoDB Fundamentals
Which option can be used with update command so that a new document gets created if no matching document is found based on the query condition?
upsertupdate optionsinsert if not exists - Question #103Sharding
Write the command(s) are correct to enable sharding on a database "testdb" and shard a collection "testCollection" with _id as shard key. Answer: sh.enableSharding("testdb") & sh.s...
enableShardingshardCollectionshard keysh commands - Question #104MongoDB Fundamentals
Which of the following command is used to get all the indexes on a collection?
getIndexesindex listingcollection indexes - Question #105Replication
You have designed a web application with mongoDB. You have configured replication. The replica set is in place and function properly. What happens in case of failure?
replica setautomatic failoverhigh availability - Question #106Security
To add a new user and enable authentication in MongoDB, which of the following steps need be executed?
authenticationuser managementmongod startup options