Latest C100DBA Study Guides 2022 - With Test Engine PDF
Get New C100DBA Practice Test Questions Answers
NEW QUESTION 26
Which mongodb tools allow us to work with our data in a human readable format?
- A. mongodump
- B. mongoexport
- C. mongoimport
- D. mongostat
Answer: B,C
NEW QUESTION 27
What does the following query do when performed on the posts collection? db.posts.update({_id:l},{Title:This is post with ID 1"})
- A. Replaces the complete document with _id as 1 with the document specified in second parameter
- B. Syntax error
- C. Updates the Title of the post
- D. Updating a document is possible only with $set
Answer: A
NEW QUESTION 28
Given a replica set with five data-bearing members, suppose the primary goes down with operations in its oplog that have been copied from the primary to only one secondary. Assuming no other problems occur, which of the following describes what is most likely to happen?
- A. reads will be stale until the primary comes back up
- B. the primary may roll back the operations once it recovers
- C. the most current secondary will roll back the operations following the election
- D. missing operations will need to be manually re-performed
- E. the secondary with the most current oplog will be elected primary
Answer: E
NEW QUESTION 29
Which of the following about Capped Collections is correct?
- A. High-throughput operations that insert and retrieve documents based on insertion order
- B. Fixed Size
- C. If the allocated space for a capped collection exceeds, it stops inserting new documents
- D. Only "Fixed Size" and "High-throughput operations that insert and retrieve documents based on insertion order"
Answer: D
NEW QUESTION 30
Which mongodb tool is used to report details on number of database operations in MongoDB?
- A. mongorestore
- B. mongotop
- C. mongodump
- D. mongostat
Answer: D
NEW QUESTION 31
What does the output x of the following MongoDB aggregation query result into; db.posts.aggregate( [ {
$group: { _id; "$author", x: { $sum: $likes } } } ] )
- A. Number of posts by an author
- B. Average of likes on all the posts of an author, grouped by author
- C. Sum of likes on all the posts by all the authors
- D. Sum of likes on all the posts by an author, grouped by author
Answer: D
NEW QUESTION 32
Which option should be used to update all the documents with the specified condition in the MongoDB query?
- A. updateAII instead of update
- B. specify {updateAII: true} as the third parameter of update command
- C. specify {multi : true} as the third parameter of update command
- D. specify {all: true} as the third parameter of update command
Answer: C
NEW QUESTION 33
Which operations add new documents to a collection?
- A. update
- B. insert
- C. Create
- D. delete
Answer: B,C
NEW QUESTION 34
Which command is used to determine storage capacity of specific database?
- A. dbstats
- B. mongotop
- C. constats
- D. mongostat
Answer: A
NEW QUESTION 35
What is the equivalent command in MongoDB for the following SQL query?
SELECT * FROM posts WHERE author like "%john%"
- A. db.posts.find( { author: /John/ } )
- B. db.posts.find( { $like: {author: /John/} } )
- C. db.posts.find( { author: /AjohnA/ > )
- D. db.posts.find( { author: {$like: /John/} } )
Answer: A
NEW QUESTION 36
Which of the following is a valid Replica Set configuration if you want:
1-Have 3 copies of everything
2- That RS3 is never primary
2- That RSI and RS2 can be primary?
You had to see the different configurations, RS3 could be hidden or priority 0 (But not a referee because we need
3 replicas), while RSI and RS2 could NOT have priority 0 or be hidden or anything like that In a 4-member RS RSO , RSI, RS2 and RS3 + Referee, RSO (primary) falls after some write operations that have replicated RSI and RS2 (but NOT RS3), who can get up as the new primary?
The configuration comes and in it we see that RS2 has a hidden: true (or a priority: 0, (I don't remember)
- A. O arbiter
- B. RSO
- C. ORS3
- D. ORS1
- E. ORS2
Answer: D
NEW QUESTION 37
A collection and a document in MongoDB is equivalent to which of the SQL concepts respectively?
- A. Table and Column
- B. Database and Table
- C. Column and Row
- D. Table and Row
Answer: D
NEW QUESTION 38
In a sharded replicas set environment with multiple mongos servers, which of the following would decide the mongos failover?
- A. mongod
- B. mongo shell
- C. individual language drivers
- D. mongos
Answer: C
NEW QUESTION 39
Which of the following is supported by MongoDB?
- A. ACID Transactions
- B. Relationships between Collections (Primary Key Foreign Key)
- C. Journaling
- D. Transaction Management
Answer: C
NEW QUESTION 40
In what format does mongodump creates backup files?
- A. JSON
- B. XML
- C. BSON
- D. SOAP
Answer: C
NEW QUESTION 41
Consider that you have a collection called population which has fields state and city. Which of the following query will calculate the population grouped by state and city?
- A. db.population.aggregate( [{ $group: { _id: { state: "$state", city: "$city" },pop: { $pop: 1 } } }] )
- B. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $sum: 1 > > >] )
- C. db.population.aggregate( [{ $group: { _id: { city: "$city" },pop: { $sum: "$pop" } } }] )Multi Document Transaction is not supported by MongoDB
- D. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $sum: "$pop" } } }] )
Answer: D
NEW QUESTION 42
What does the following aggregate query perform?
- A. Groups the posts by number of likes (101, 102, 103.) by adding 1 every time
- B. Fetches the posts with likes between 100 and 200, sets the _id of the first document as null and then increments it 1 every time
- C. Fetches the posts with likes between 100 and 200 and sets their _id as null
- D. Calculates the number of posts with likes between 100 and 200
Answer: D
NEW QUESTION 43
Which of the tags in a replica set configuration specify the operations to be read from the node with the least network latency?
- A. secondaryPreferred
- B. nearest
- C. netLatency
- D. primaryPreferred
Answer: B
NEW QUESTION 44
You have a replicated cluster with 1 primary, 3 secondary, 1 arbiter. One of the secondary is hidden. What is the replication factor of this replicated cluster?
- A. 06
- B. 04
- C. 0
- D. 03
Answer: B
NEW QUESTION 45
Which of the following is true about sharding?
- A. We cannot change a shard key directly/automatically once it is set up
- B. Sharding is enabled at the database level
- C. Creating a sharded key automatically creates an index on the collection using that key
- D. A sharded environment does not support sorting functionality since the documents lie on various mongod instances
Answer: A
NEW QUESTION 46
Which features of relational database management systems were deliberately omitted in MongoDB and help us to obtain horizontal scalability? Check all that apply.
- A. Joins
- B. Authentication
- C. Multi-statement transactions
Answer: A,C
NEW QUESTION 47
In which of the following scenarios is sharding not the correct option. Select all that apply.
- A. The working set in the collection is expected to grow very large in size
- B. The write operations on the collection are very high
- C. The write operations on the collection are low
- D. The collection is a read intensive collection with less working set
Answer: C,D
NEW QUESTION 48
What tool would you use if you want to save a gif file in mongo?
Answer:
Explanation:
mongofile
NEW QUESTION 49
What is the maximum size of a MongoDB document
- A. 16 MB
- B. 2 MB
- C. There is no maximum size. It depends on the RAM.
- D. 12 MB
Answer: A
NEW QUESTION 50
What tool do you use if you want to extract a CSV from mongo?
Answer:
Explanation:
mongoexport
NEW QUESTION 51
......
C100DBA Dumps and Exam Test Engine: https://www.exam4free.com/C100DBA-valid-dumps.html
MongoDB C100DBA DUMPS WITH REAL EXAM QUESTIONS: https://drive.google.com/open?id=1Q1Nb6wx-3oIlvLCLV4bS1w3Ci7IRdztA
