A retail organization has moved all of their inventory data to a relational database in the cloud. What functionality does a relational database offer?

Question

Accepted Answer

B. It stores transactional data, which can then be accessed electronically Relational databases are purpose-built for storing structured transactional data - such as inventory records, orders, and product details - in rows and columns within related tables. This data can be queried, updated, and accessed electronically using SQL, making it ideal for operational workloads like inventory management. The relational model enforces data integrity through defined schemas and relationships between tables.

Answer

A. It stores large amounts of raw data in its original format Storing large amounts of raw data in its original format describes a data lake or object storage system, not a relational database.

Answer

C. It rapidly analyzes large and multi-dimensional datasets Rapidly analyzing large and multi-dimensional datasets describes an OLAP system or data warehouse, which is optimized for analytics rather than transactional record-keeping.

Answer

D. It analyzes unstructured data, which can then be accessed in multiple regions Analyzing unstructured data across multiple regions describes a NoSQL or distributed document store, not a relational database, which requires structured schema.

A retail organization has moved all of their inventory data to a relational database in the cloud. What functionality does a relational database offer?

Question

Options

How the community answered

Why each option

Topics

Community Discussion