Azure Data Fundamentals: Relational vs Non-Relational Quiz

Submit

2. True or False: Azure Cosmos DB supports only one API model for data access.

True

False

3. True or False: Horizontal scalability is easier to achieve with traditional relational databases.

True

False

4. True or False: Azure SQL Database automatically enforces ACID properties for transactions.

True

False

5. True or False: Non-relational databases cannot handle complex queries.

True

False

6. True or False: Azure Cosmos DB provides multi-region write capability and global distribution.

True

False

7. True or False: Relational databases are always the best choice for all application scenarios.

True

False

Submit

11. What is the primary characteristic of a relational database?

Data stored in tables with rows and columns organized by schemas

Data stored as unstructured documents without predefined structure

Data stored as key-value pairs only

Data stored in files without any organization

12. Which Azure service provides a distributed, NoSQL database with global replication?

Azure SQL Managed Instance

Azure Database for PostgreSQL

Azure Cosmos DB

Azure Synapse Analytics

13. What does normalization achieve in relational databases?

Increases query speed by duplicating data

Reduces data redundancy and improves data integrity

Converts tables into JSON documents

Encrypts all sensitive information

14. In Azure, which service is best for storing semi-structured JSON documents?

Azure SQL Database

Azure Cosmos DB

Azure Data Lake Storage

Azure Queue Storage

15. Which statement about NoSQL databases is true?

They require strict schema definition before data insertion

They provide flexible schema and horizontal scalability

They enforce foreign key relationships by default

They are slower than relational databases

16. What is a primary key in a relational database?

A column that uniquely identifies each row in a table

A column that stores foreign references

A column used only for sorting data

A column that encrypts sensitive data

17. Azure Cosmos DB supports which type of data model?

Only relational

Only document storage

Multiple models: document, key-value, graph, and column-family

Only key-value pairs

18. Which data model is best for highly unstructured or rapidly changing data?

Relational

Non-relational (NoSQL)

Hierarchical

Network

19. What does ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

Accuracy, Compatibility, Integration, Delivery

Analysis, Computation, Input, Data

Access, Connectivity, Index, Distribution

20. Which Azure service is a fully managed relational database?

Azure Cosmos DB

Azure SQL Database

Azure Blob Storage

Azure Table Storage

Azure Data Fundamentals Relational vs Non Relational Data Quiz

1. A ____ is a relationship between two tables in a relational database using a foreign key.

2.

What first name or nickname would you like us to use?

2. True or False: Azure Cosmos DB supports only one API model for data access.

3. True or False: Horizontal scalability is easier to achieve with traditional relational databases.

4. True or False: Azure SQL Database automatically enforces ACID properties for transactions.

5. True or False: Non-relational databases cannot handle complex queries.

6. True or False: Azure Cosmos DB provides multi-region write capability and global distribution.

7. True or False: Relational databases are always the best choice for all application scenarios.

8. A ____ is a NoSQL data structure that stores data as key-value pairs without predefined schema.

9. Relational databases enforce data integrity through ____ and constraints.

10. NoSQL databases typically use ____ as their consistency model instead of strict ACID.

11. What is the primary characteristic of a relational database?

12. Which Azure service provides a distributed, NoSQL database with global replication?

13. What does normalization achieve in relational databases?

14. In Azure, which service is best for storing semi-structured JSON documents?

15. Which statement about NoSQL databases is true?

16. What is a primary key in a relational database?

17. Azure Cosmos DB supports which type of data model?

18. Which data model is best for highly unstructured or rapidly changing data?

19. What does ACID stand for in database transactions?

20. Which Azure service is a fully managed relational database?