Bash, the Crucial Exams Chat Bot
AI Bot
Core Data Concepts (DP-900) Flashcards
Microsoft Azure Data Fundamentals DP-900 Flashcards
| Front | Back |
| Give an example of a non-relational database | MongoDB or Cassandra |
| Give an example of a relational database | MySQL or PostgreSQL |
| Give an example of semi-structured data | JSON or XML files |
| Give an example of structured data | A database table |
| Give an example of unstructured data | Emails or social media posts |
| What are the 4 Vs of big data | Volume, Velocity, Variety, and Veracity |
| What are the two main types of data | Quantitative data and qualitative data |
| What is a data lake | A storage solution that holds enormous amounts of raw data in its native format |
| What is a data schema | A blueprint that defines how data is structured and stored |
| What is a data warehouse | A centralized repository designed for analytical query and reporting |
| What is a non-relational database | A database not based on the relational model, often optimized for unstructured or semi-structured data |
| What is a relational database | A database structured to recognize relationships among stored data |
| What is big data | Extremely large datasets that are difficult to process using traditional tools |
| What is data mining | The process of extracting useful patterns or insights from large data sets |
| What is data redundancy | Duplicating data at multiple locations for backup and fault tolerance purposes |
| What is data storage | A method of saving data for future access and use |
| What is metadata | Data that describes other data such as file size, file type, or creation date |
| What is qualitative data | Non-numerical data that describes qualities or characteristics |
| What is quantitative data | Data that is measurable and expressed in numerical terms |
| What is semi-structured data | Data that has some organizational structure but does not adhere to strict schema rules |
| What is structured data | Data that is organized into rows and columns with clear labels and formats |
| What is the function of data indexing | Facilitates faster retrieval of data by creating a structured access path |
| What is the key advantage of data lakes over data warehouses | Data lakes allow raw data storage for broader processing possibilities |
| What is the main difference between structured and unstructured data | Structured data is organized and easily searchable while unstructured data lacks organization |
| What is the role of ETL in data management | Extract, Transform, and Load processes for data movement between systems |
| What is unstructured data | Data that does not have a predefined format such as text or multimedia content |
Front
Give an example of a non-relational database
Click the card to flip
Back
MongoDB or Cassandra
Front
What is structured data
Back
Data that is organized into rows and columns with clear labels and formats
Front
What is quantitative data
Back
Data that is measurable and expressed in numerical terms
Front
What is semi-structured data
Back
Data that has some organizational structure but does not adhere to strict schema rules
Front
Give an example of a relational database
Back
MySQL or PostgreSQL
Front
What is the function of data indexing
Back
Facilitates faster retrieval of data by creating a structured access path
Front
What is the key advantage of data lakes over data warehouses
Back
Data lakes allow raw data storage for broader processing possibilities
Front
What is metadata
Back
Data that describes other data such as file size, file type, or creation date
Front
What is data storage
Back
A method of saving data for future access and use
Front
What are the 4 Vs of big data
Back
Volume, Velocity, Variety, and Veracity
Front
What is unstructured data
Back
Data that does not have a predefined format such as text or multimedia content
Front
Give an example of unstructured data
Back
Emails or social media posts
Front
What is a non-relational database
Back
A database not based on the relational model, often optimized for unstructured or semi-structured data
Front
What is data redundancy
Back
Duplicating data at multiple locations for backup and fault tolerance purposes
Front
What is big data
Back
Extremely large datasets that are difficult to process using traditional tools
Front
What is a relational database
Back
A database structured to recognize relationships among stored data
Front
What is qualitative data
Back
Non-numerical data that describes qualities or characteristics
Front
What is a data warehouse
Back
A centralized repository designed for analytical query and reporting
Front
What are the two main types of data
Back
Quantitative data and qualitative data
Front
What is a data schema
Back
A blueprint that defines how data is structured and stored
Front
What is the main difference between structured and unstructured data
Back
Structured data is organized and easily searchable while unstructured data lacks organization
Front
Give an example of semi-structured data
Back
JSON or XML files
Front
Give an example of structured data
Back
A database table
Front
What is a data lake
Back
A storage solution that holds enormous amounts of raw data in its native format
Front
What is data mining
Back
The process of extracting useful patterns or insights from large data sets
Front
What is the role of ETL in data management
Back
Extract, Transform, and Load processes for data movement between systems
1/26
This deck covers fundamental concepts of data such as types of data, structured vs unstructured data, and data storage technologies.