Microsoft Azure Data Fundamentals — Question 238

What is a primary characteristic of a relational database?

Answer options

• A. a flexible data structure
• B. data is queried and manipulated by using a variant of the SQL language
• C. a lack of dependencies between tables
• D. a large amount of duplicate data

Correct answer: B

Explanation

The correct answer is B because relational databases use SQL for querying and managing data, which is a defining characteristic. Option A is incorrect as relational databases have a structured schema, option C is wrong because there are often dependencies between tables, and option D is inaccurate as relational databases aim to minimize duplicate data through normalization.