About This Flashcard Deck
This flashcard deck contains 10 cards covering key Data+ concepts for the DATAPLUS exam. Test your data analytics knowledge. Use active recall by attempting to answer each question before revealing the answer.
Question
What is ETL?
Click to reveal answer
Answer
Extract, Transform, Load — process of moving data from sources, cleaning/transforming it, and loading into a target (data warehouse).
Click to flip back
All Data+ Flashcards
Q: What is ETL?
A: Extract, Transform, Load — process of moving data from sources, cleaning/transforming it, and loading into a target (data warehouse).
Q: What is a star schema?
A: Data warehouse design: central fact table (measures/metrics) connected to dimension tables (descriptive attributes). Fast for queries.
Q: What is the difference between OLTP and OLAP?
A: OLTP: optimized for transactions (INSERT/UPDATE), normalized, current data. OLAP: optimized for analytics (SELECT), denormalized, historical data.
Q: What is standard deviation?
A: Measure of data spread from the mean. Low SD = data clustered near mean. High SD = data spread out.
Q: What is a data lake?
A: Storage for raw data in native format (structured, semi-structured, unstructured). Schema applied at read time. Highly scalable.
Q: What is data lineage?
A: Tracking data from origin through all transformations to final destination. Shows where data came from and how it changed.
Q: When should you use a bar chart vs line chart?
A: Bar: comparing categories/discrete values. Line: showing trends over time (continuous data).
Q: What is data governance?
A: Framework of policies, procedures, and standards for managing data assets: quality, security, privacy, compliance, and lifecycle.
Q: What is correlation?
A: Statistical measure of relationship between two variables (-1 to +1). Does NOT imply causation.
Q: What is PII?
A: Personally Identifiable Information — data that can identify an individual (name, SSN, email, biometrics). Protected by privacy regulations.
CompTIA Flashcard Study Technique
CompTIA exams cover broad domains with hundreds of concepts. Use these flashcards in short, focused sessions of 15–20 minutes rather than marathon study sessions. Group cards by domain and track which domains have the lowest recall rates — allocate extra study time to those areas. CompTIA exams weight domains differently, so match your flashcard focus to the domain percentages listed in the exam objectives.