Bash, the Crucial Exams Chat Bot
AI Bot
Data Management Basics (DataSys+ DS0-001) Flashcards
CompTIA DataSys+ DS0-001 Flashcards
| Front | Back |
| What are the main types of data storage? | Primary storage, secondary storage, and tertiary storage. |
| What does the data lifecycle include? | Phases such as creation, storage, usage, archiving, and deletion. |
| What is a data schema? | The structure or layout that defines how data is organized in a database. |
| What is a data silo? | A collection of data that is not easily accessible to other parts of an organization. |
| What is a data warehouse? | A large storage system used for reporting and data analysis purposes. |
| What is a foreign key in a database? | A column that creates a relationship between two tables. |
| What is a popular file format for storing unstructured data? | JSON (JavaScript Object Notation). |
| What is a relational database? | A database that organizes data into tables with rows and columns. |
| What is an example of primary storage? | RAM (Random Access Memory). |
| What is an example of secondary storage? | Hard drives or SSDs (Solid-State Drives). |
| What is an example of tertiary storage? | Backup tapes or cloud archives. |
| What is data archiving? | The process of storing data no longer actively used but kept for legal, regulatory, or historical reasons. |
| What is data backup? | Creating copies of data to protect against loss or corruption. |
| What is data governance? | The management of data availability, usability, integrity, and security in an organization. |
| What is data integrity? | Maintaining and assuring data accuracy and consistency over its lifecycle. |
| What is data migration? | The process of moving data from one system, format, or location to another. |
| What is data redundancy? | The unnecessary repetition of data within a database or system. |
| What is ETL in data management? | Extract, Transform, and Load — a process used to move and preprocess data. |
| What is metadata? | Data about data, such as file creation date or author. |
| What is one example of a file format used for structured data? | CSV (Comma-Separated Values). |
| What is one factor to consider when planning data storage? | Capacity, performance, or security requirements. |
| What is one key benefit of cloud storage? | Scalability and remote access to stored data. |
| What is semi-structured data? | Data that has a loose structure, such as JSON or XML files. |
| What is structured data? | Data organized in a predefined format like tables in a database. |
| What is the difference between a database and a data lake? | A database is structured and optimized for query performance, while a data lake stores raw and unprocessed data for future analysis. |
| What is the primary language used to manage data in relational databases? | SQL (Structured Query Language). |
| What is the primary purpose of data management? | To ensure data is accurately stored, organized, and accessible while maintaining quality and security. |
| What is the role of a primary key in a database? | To uniquely identify each record in a table. |
| What is unstructured data? | Data that does not follow a specific format, such as videos, images, or emails. |
| Why is data normalization important? | To reduce redundancy and improve data consistency in databases. |
This deck covers fundamental principles of data management, including data storage types, formats, and lifecycle processes.