Data+ Concepts Quiz: Master Data Fundamentals

1. True or False: A NoSQL database always scales horizontally better than a relational database.

True

False

2. What does 'data lineage' track in a data ecosystem?

The chronological order of data creation

The origin, movement, transformation, and usage of data throughout its lifecycle

The physical location of data servers

The access permissions for different users

3. Which environment is best suited for exploratory data analysis and ad-hoc queries?

Production environment

Development environment

Sandbox environment

Staging environment

Submit

5. True or False: Data replication involves creating multiple copies of data for redundancy and disaster recovery.

True

False

6. In the context of big data, what does the 'velocity' dimension refer to?

The variety of data types

The volume of data generated

The speed at which data is generated and processed

The value extracted from data

7. What is the main advantage of using a star schema in data warehousing?

It eliminates the need for foreign keys

It simplifies queries and improves query performance

It requires less storage space than normalized schemas

It automatically handles data validation

8. Which of the following best describes metadata?

Data that has been transformed and cleaned

Data about data, including its source, quality, and structure

Raw, unprocessed information

Encrypted data for security purposes

Submit

10. Which term describes the ability of a system to handle increasing amounts of data?

Availability

Scalability

Reliability

Redundancy

11. What is the primary difference between structured and unstructured data?

Structured data is organized in rows and columns; unstructured lacks predefined format

Structured data is always in a database; unstructured is always in files

Structured data cannot be analyzed; unstructured data is easily queryable

Structured data is newer technology; unstructured is legacy

12. In cloud computing, what does IaaS stand for?

Information as a Service

Infrastructure as a Service

Integration as a Service

Internet as a Service

13. What is the primary purpose of data normalization in relational databases?

To increase query speed

To reduce data redundancy and improve data integrity

To encrypt sensitive information

To compress storage space

14. Which approach to data integration combines data from multiple sources into a unified view in real-time?

Extract, Transform, Load (ETL)

Extract, Load, Transform (ELT)

Enterprise Data Integration (EDI)

Data virtualization

Submit

16. What does ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

Access, Control, Integration, Distribution

Accuracy, Completeness, Integrity, Delivery

Aggregation, Compression, Indexing, Dependency

17. Which database model organizes data in a hierarchical tree structure?

Relational database

Hierarchical database

Graph database

Document database

18. What is a key characteristic of a data lake?

Stores only structured, processed data

Stores raw data in its native format with minimal preprocessing

Requires all data to be in a single format

Limited to small organizations only

19. In data warehousing, what does the term 'schema' refer to?

The physical storage location of data

The organizational structure and relationships of database objects

The encryption method for data security

The backup frequency schedule

20. Which of the following is an example of semi-structured data?

A relational database table

JSON or XML files

Free-form text documents

Raw sensor measurements

Data+ Concepts Quiz: Master Data Fundamentals

1. True or False: A NoSQL database always scales horizontally better than a relational database.

2.

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

2. What does 'data lineage' track in a data ecosystem?

3. Which environment is best suited for exploratory data analysis and ad-hoc queries?

4. A ____ is a database organized around a central fact table with surrounding dimension tables.

5. True or False: Data replication involves creating multiple copies of data for redundancy and disaster recovery.

6. In the context of big data, what does the 'velocity' dimension refer to?

7. What is the main advantage of using a star schema in data warehousing?

8. Which of the following best describes metadata?

9. Data governance refers to ____.

10. Which term describes the ability of a system to handle increasing amounts of data?

11. What is the primary difference between structured and unstructured data?

12. In cloud computing, what does IaaS stand for?

13. What is the primary purpose of data normalization in relational databases?

14. Which approach to data integration combines data from multiple sources into a unified view in real-time?

15. A data mart differs from a data warehouse primarily in its ____.

16. What does ACID stand for in database transactions?

17. Which database model organizes data in a hierarchical tree structure?

18. What is a key characteristic of a data lake?

19. In data warehousing, what does the term 'schema' refer to?

20. Which of the following is an example of semi-structured data?