Given the diagram below: Which of the following data schemas shown?

The correct answer is D. Relational database. A relational database organizes data into structured tables (relations) with defined columns and data types, and uses primary/foreign keys to establish relationships between tables. This is the structure typically depicted in entity-relationship (ER) or schema diagrams showing…

Data Concepts and Environments

Question

Given the diagram below:

Which of the following data schemas shown?

Options

AKey-value pairs
BOnline transactional processing
CData lake
DRelational database

How the community answered

(44 responses)

A
2% (1)
B
7% (3)
C
5% (2)
D
86% (38)

Explanation

A relational database organizes data into structured tables (relations) with defined columns and data types, and uses primary/foreign keys to establish relationships between tables. This is the structure typically depicted in entity-relationship (ER) or schema diagrams showing linked tables. Key-value pairs are a NoSQL structure with simple paired entries, OLTP is a processing model not a schema, and a data lake stores raw unstructured or semi-structured data - none of these match a tabular, relationship-driven diagram.

Topics

#Relational databases#Data schemas#Database types

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice