Question

Point out the correct statement.

(a) High query rates can exhaust the CPU capacity of the server

(b) Database systems with small data sets and high throughput applications can challenge the capacity of a single server

(c) Smaller data sets exceed the storage capacity of a single machine

(d) All of the mentioned

I have been asked this question in a job interview.

I need to ask this question from Sharding Introduction topic in portion Sharding Concepts, Mechanics and Sharded Cluster of MongoDB

Answer 1

The correct option is (a) High query rates can exhaust the CPU capacity of the server

Explanation: Working set sizes larger than the system’s RAM stress the I/O capacity of disk drives.