nerdexam
Google

CLOUD-DIGITAL-LEADER · Question #366

What is a defining feature of a non-relational database?

The correct answer is C. A flexible data model. Non-relational (NoSQL) databases are defined by their flexible data models, which allow data to be stored without a fixed, predefined schema unlike relational databases.

Data Management and Databases

Question

What is a defining feature of a non-relational database?

Options

  • AReporting across multiple data sources
  • BA strictly enforced schema
  • CA flexible data model
  • DQueries that join multiple tables

How the community answered

(27 responses)
  • A
    7% (2)
  • B
    4% (1)
  • C
    89% (24)

Why each option

Non-relational (NoSQL) databases are defined by their flexible data models, which allow data to be stored without a fixed, predefined schema unlike relational databases.

AReporting across multiple data sources

Reporting across multiple data sources is a feature of data warehouses and BI tools, not a defining characteristic of non-relational databases specifically.

BA strictly enforced schema

A strictly enforced schema is a defining characteristic of relational databases, which is the opposite of the flexible schema approach used by non-relational databases.

CA flexible data modelCorrect

NoSQL databases use flexible data models such as document, key-value, wide-column, or graph structures that do not require a fixed schema, allowing different records to have different fields and data types. This flexibility enables developers to iterate quickly and store varied or hierarchical data without costly schema migration operations. It is the fundamental characteristic that differentiates NoSQL from relational databases.

DQueries that join multiple tables

Joining multiple tables using SQL is a core feature of relational databases and is not a characteristic of non-relational databases, which typically avoid joins in favor of denormalized document structures.

Concept tested: Non-relational NoSQL database flexible data model

Source: https://cloud.google.com/discover/what-is-nosql

Topics

#Non-relational Databases#NoSQL#Data Models#Schema Flexibility

Community Discussion

No community discussion yet for this question.

Full CLOUD-DIGITAL-LEADER Practice