A retail application currently uses a single relational database for product catalogue, customer accounts, and the operational metrics that the engineering team monitors. The metrics workload is growing rapidly: tens of millions of timestamped readings are inserted each day and the database is increasingly slow on every workload. The most appropriate architectural response is to:

Question

Accepted Answer

Move the metrics data into a time-series database that suits the append-heavy timestamp workload, while keeping the catalogue and accounts in the existing relational database.

Answer

Reduce the metrics ingestion rate by sampling every tenth reading so that the existing relational database can keep up with the load.

Answer

Move all three workloads (catalogue, accounts, metrics) into a single document database that handles every type of data within one engine.

Answer

Increase the size of the database server until the inserts and the catalogue queries both fit comfortably within the new capacity envelope.

Crowdly

A retail application currently uses a single relational database for product cat...

Want instant access to all verified answers on moodle.polytechnic.bh?