Data Models and Query Languages - Questions

Easy Question

1. Which data model typically uses tables, rows, and columns?

A. Document model

B. Relational model

C. Graph model

D. Key-value model

Correct Answer: B
Medium Question

2. What is an advantage of using a document data model for certain applications?

A. Built-in relationship enforcement with foreign keys

B. Supports dynamic schemas and nesting for complex data

C. Guarantees no duplicated data

D. Ensures strict ACID transactions across multiple collections

Correct Answer: B
Hard Question

3. Which of the following is most commonly associated with graph databases?

A. OLAP workloads for large-scale reporting

B. Pattern matching queries on nodes and edges

C. Complex joins with multiple normalized tables

D. One fixed query language with no extensions

Correct Answer: B
Very Hard Question

4. In a polyglot persistence architecture, how can consistency be maintained across different data models?

A. By never allowing the same data to exist in more than one system

B. Using a coordination layer or event-based approach to synchronize updates

C. Disabling schemas entirely for maximum flexibility

D. Only running write queries at designated times

Correct Answer: B