Data Processing Fundamentals — Questions and Answers

Question 1: What is a partitioning strategy in big data storage?

Encrypting data segments individually for security
Sorting data alphabetically before archiving
Dividing a large dataset into smaller subsets based on a key for parallel processing efficiency (Correct answer)
Creating backup copies of data across regions

Correct answer: Dividing a large dataset into smaller subsets based on a key for parallel processing efficiency

Partitioning splits large datasets into smaller chunks based on a key (like date or region) so that queries and processing can target only the relevant subset.

Question 2: What is Apache Kafka primarily used for?

Storing structured relational data
Generating PDF reports from databases
Distributed real-time data streaming and messaging (Correct answer)
Running machine learning model training

Correct answer: Distributed real-time data streaming and messaging

Apache Kafka is a distributed event-streaming platform used for high-throughput, fault-tolerant messaging and real-time data pipeline construction.

Question 3: What does the GDPR 'right to erasure' (right to be forgotten) allow individuals to do?

Request that an organization permanently delete their personal data (Correct answer)
Hide browsing history and online activity from third parties
Force organizations to delete all backups when a user closes their account
Require companies to erase data after a government-mandated retention period

Correct answer: Request that an organization permanently delete their personal data

The right to erasure allows individuals to request that an organization permanently delete their personal data under certain circumstances defined by GDPR.

Question 4: What is data replication in database systems?

Encrypting data and storing the key separately
Maintaining copies of the same data on multiple servers or locations for availability and fault tolerance (Correct answer)
Duplicating database schemas without copying the data
Creating read-only snapshots for reporting purposes

Correct answer: Maintaining copies of the same data on multiple servers or locations for availability and fault tolerance

Data replication copies and maintains synchronized data across multiple servers or geographic locations to ensure availability, fault tolerance, and load distribution.

Question 5: What does GDPR stand for?

Government Data Processing Rules
General Data Protection Regulation (Correct answer)
General Database Protection Rights
Global Data Privacy Requirements

Correct answer: General Data Protection Regulation

GDPR stands for General Data Protection Regulation, a comprehensive EU data privacy law that governs how organizations collect, store, and process personal data.

Question 6: What does 'data tiering' mean in storage management?

Organizing database tables into logical groups by department
Encrypting data at multiple security levels
Creating multiple backups in different geographic locations
Automatically moving data between different storage classes based on access frequency and cost (Correct answer)

Correct answer: Automatically moving data between different storage classes based on access frequency and cost

Data tiering moves data across storage tiers — hot (fast/expensive SSD), warm (standard), and cold (cheap/slow) — based on how frequently it is accessed, optimizing cost and performance.

Question 7: What is a null value in a database?

The absence of any value — unknown or missing data (Correct answer)
An encrypted placeholder
A negative integer
A value of zero

Correct answer: The absence of any value — unknown or missing data

NULL represents the absence of a value in a field — it is different from zero or an empty string and means the data is unknown or missing.

Question 8: What is Apache Spark used for in big data?

Scraping web pages for SEO analysis
Fast, in-memory distributed data processing for batch and streaming workloads (Correct answer)
Monitoring network traffic in real time
Managing relational database schemas

Correct answer: Fast, in-memory distributed data processing for batch and streaming workloads

Apache Spark is a unified analytics engine that processes large-scale data in memory, making it significantly faster than disk-based MapReduce for iterative operations.

Question 9: What is Apache Kafka primarily used for?

High-throughput distributed event streaming and message queuing (Correct answer)
Running SQL queries on relational databases
Building REST APIs
Generating machine learning models

Correct answer: High-throughput distributed event streaming and message queuing

Apache Kafka is a distributed event streaming platform that handles millions of events per second for real-time data pipelines and stream processing.

Question 10: Which of the following best describes personally identifiable information (PII)?

Any data that can be used to identify a specific individual (Correct answer)
Information accessed using personal login credentials
Encrypted data belonging to registered users
Data stored on personal computers and mobile devices

Correct answer: Any data that can be used to identify a specific individual

PII refers to any information that can be used alone or combined with other data to identify, contact, or locate a specific individual.

Question 11: Which framework is widely used for real-time stream processing in the US?

FTP Server
Apache Kafka Streams (Correct answer)
Microsoft Access
Apache Subversion

Correct answer: Apache Kafka Streams

Apache Kafka Streams is a widely adopted library for building real-time stream processing applications on top of Apache Kafka.

Question 12: What is a SQL injection attack?

Injecting test data into a production database during development
Encrypting SQL databases to block unauthorized access attempts
Overloading a database server with an excessive number of SQL queries
Inserting malicious SQL code into input fields to manipulate database queries (Correct answer)

Correct answer: Inserting malicious SQL code into input fields to manipulate database queries

SQL injection involves embedding malicious SQL code into application input fields, manipulating the resulting database queries to expose, modify, or delete data.

Question 13: What distinguishes batch processing from stream processing?

Batch processing only works with unstructured data
Stream processing stores data permanently; batch processing does not
Batch processing handles data in large collected groups at scheduled intervals; stream processing handles data continuously as it arrives (Correct answer)
Batch processing is faster than stream processing

Correct answer: Batch processing handles data in large collected groups at scheduled intervals; stream processing handles data continuously as it arrives

Batch processing accumulates data over a period and processes it all at once on a schedule, while stream processing ingests and analyzes data continuously in near-real-time.

Question 14: What is a columnar storage format?

Data stored column by column rather than row by row, optimized for analytical queries (Correct answer)
A way to encrypt each column separately for security
A method of sorting rows by column values before storage
A format that stores only text in database columns

Correct answer: Data stored column by column rather than row by row, optimized for analytical queries

Columnar storage organizes data by columns rather than rows, allowing analytical queries to read only the columns they need rather than entire rows.

Question 15: What is the purpose of a connection pool in database applications?

To maintain a set of reusable database connections that can be shared by multiple application threads (Correct answer)
To encrypt all data transmissions between the app and database
To cache query results for frequently run SQL statements
To distribute database tables across multiple servers automatically

Correct answer: To maintain a set of reusable database connections that can be shared by multiple application threads

A connection pool maintains a collection of pre-established database connections that application threads can borrow and return, reducing the overhead of creating new connections for every request.

Question 16: A checksum is primarily used in data processing to:

Encrypt data for secure storage
Compress data before transmission
Index data for faster retrieval
Detect errors in transmitted or stored data (Correct answer)

Correct answer: Detect errors in transmitted or stored data

A checksum is a computed value appended to data so the receiver can verify integrity by recomputing it.

Question 17: What is the role of a NameNode in Hadoop HDFS?

It stores the actual data blocks on local disk
It manages the file system namespace and tracks where data blocks are stored across DataNodes (Correct answer)
It handles user authentication and authorization
It runs MapReduce job computations

Correct answer: It manages the file system namespace and tracks where data blocks are stored across DataNodes

The NameNode is the HDFS master server that maintains the file system namespace, directory tree, and metadata about where each file's blocks are stored on DataNodes.

Question 18: What is phishing?

A method of bypassing firewall rules using specially crafted network packets
A network technique used to intercept data packets in transit
An attack that floods a server with traffic to cause a denial of service
A social engineering attack that tricks users into revealing sensitive information via fraudulent communications (Correct answer)

Correct answer: A social engineering attack that tricks users into revealing sensitive information via fraudulent communications

Phishing involves sending fraudulent communications — typically emails — that appear to come from legitimate sources to trick individuals into revealing passwords or sensitive information.

Question 19: What does CRUD stand for in data management?

Create, Read, Update, Delete (Correct answer)
Compress, Retrieve, Upload, Download
Cache, Replicate, Update, Deduplicate
Copy, Restore, Undo, Deploy

Correct answer: Create, Read, Update, Delete

CRUD represents the four basic operations for persistent data storage: Create (insert), Read (query), Update (modify), and Delete (remove).

Question 20: What are the three Vs traditionally used to define big data?

Volume, Verification, Visualization
Value, Validity, Visibility
Volume, Velocity, Variety (Correct answer)
Virtual, Vertical, Variable

Correct answer: Volume, Velocity, Variety

The three Vs of big data are Volume (large amounts of data), Velocity (high speed of data generation), and Variety (diverse data types and sources).

Question 21: The object set is defined in the relational database model by the _________.

Attribute
Tuple
Entity (Correct answer)
Relation

Correct answer: Entity

In the relational database model, an 'entity' represents a real-world object or concept about which data is stored, such as a customer, product, or order. The 'object set' refers to the collection of these entities. Each entity type is then typically represented as a relation (or table) in the database, with its attributes defining its characteristics.

Question 22: What is a hash index in database storage?

A compressed index used only for text search
An index that stores only the last 10% of rows in a table
An index that uses a hash function to map keys directly to storage locations for O(1) equality lookups (Correct answer)
An index sorted alphabetically by hash values

Correct answer: An index that uses a hash function to map keys directly to storage locations for O(1) equality lookups

A hash index applies a hash function to key values to compute direct storage addresses, enabling extremely fast equality lookups but not supporting range queries.

Question 23: What is Apache Hadoop primarily used for?

Building real-time web applications
Creating data visualization dashboards
Managing relational database transactions
Distributed storage and processing of large datasets across clusters of computers (Correct answer)

Correct answer: Distributed storage and processing of large datasets across clusters of computers

Apache Hadoop is an open-source framework that enables distributed storage (HDFS) and parallel processing (MapReduce) of massive datasets across computer clusters.

Question 24: What is a materialized view in database storage?

A type of view visible only to database administrators
A virtual table that is computed on demand each time it is queried
A precomputed and physically stored result of a query that is refreshed periodically (Correct answer)
A compressed snapshot of a table stored for archival

Correct answer: A precomputed and physically stored result of a query that is refreshed periodically

A materialized view stores the precomputed result of a query as a physical table that can be queried directly, improving performance at the cost of storage and periodic refresh overhead.

Question 25: What is the primary role of a firewall in data security?

Monitoring and controlling incoming and outgoing network traffic based on security rules (Correct answer)
Authenticating users before they can access the network
Backing up databases to protect against data loss
Encrypting the contents of hard drives to prevent unauthorized access

Correct answer: Monitoring and controlling incoming and outgoing network traffic based on security rules

A firewall monitors and controls network traffic based on predetermined security rules, acting as a barrier between trusted internal networks and untrusted external networks.

Question 26: What is the primary function of SSL/TLS in data security?

Providing encrypted communication channels to protect data transmitted over networks (Correct answer)
Hashing user passwords before they are stored in authentication databases
Adding digital watermarks to data files to track unauthorized copies
Automatically scanning transmitted files for malware before delivery

Correct answer: Providing encrypted communication channels to protect data transmitted over networks

SSL/TLS protocols establish encrypted communication channels that protect data in transit from eavesdropping and man-in-the-middle attacks.

Question 27: What is the difference between structured and unstructured data?

Structured data is organized in predefined formats like tables; unstructured data has no predefined format (Correct answer)
Structured data is stored on hard drives; unstructured data is stored in the cloud
Structured data is always numeric; unstructured data is always text
Structured data is encrypted; unstructured data is not

Correct answer: Structured data is organized in predefined formats like tables; unstructured data has no predefined format

Structured data conforms to a predefined schema (like rows in a database), while unstructured data lacks a formal structure (like emails, images, or video files).

Question 28: What does 'exactly-once semantics' guarantee in a data streaming system?

Each message is processed exactly one time, with no duplicates and no data loss (Correct answer)
Each message is delivered at least once but possibly more
Messages are processed in strict chronological order
Each consumer receives a unique copy of every message

Correct answer: Each message is processed exactly one time, with no duplicates and no data loss

Exactly-once semantics ensure every record is processed precisely one time, preventing both data loss and duplicate processing.

Question 29: In the data lifecycle cycle, 'data archival' typically occurs at which stage?

After data is no longer frequently accessed (Correct answer)
After ingestion but before processing
During active transformation
Before data quality checks

Correct answer: After data is no longer frequently accessed

Archival moves data to cheaper, slower storage once it is no longer actively needed but must be retained for compliance or reference.

Question 30: What is a VPN primarily used for in the context of data security?

Authenticating remote users through biometric verification methods
Blocking malicious websites and preventing phishing attacks on endpoints
Scanning incoming data for viruses before it enters a corporate network
Creating an encrypted tunnel for secure data transmission over public networks (Correct answer)

Correct answer: Creating an encrypted tunnel for secure data transmission over public networks

A VPN (Virtual Private Network) creates an encrypted tunnel between a device and a server, securing data transmission over potentially insecure public or shared networks.

Question 31: Which process automatically corrects or standardizes data to meet quality standards?

Data replication
Data partitioning
Data archiving
Data cleansing (Correct answer)

Correct answer: Data cleansing

Data cleansing identifies and corrects errors, inconsistencies, and formatting issues to improve overall data quality.

Question 32: What is a distributed cache in big data frameworks?

A backup of HDFS data stored in cloud storage
A mechanism to make read-only files available locally on all worker nodes during a job (Correct answer)
A distributed in-memory database for user sessions
A shared disk accessible by all nodes in a cluster

Correct answer: A mechanism to make read-only files available locally on all worker nodes during a job

A distributed cache distributes read-only files (like lookup tables or configuration files) to all worker nodes at the start of a job, reducing repeated network transfers.

Question 33: Which data quality dimension measures how up-to-date data is?

Consistency
Timeliness (Correct answer)
Completeness
Accuracy

Correct answer: Timeliness

Timeliness measures whether data is available and up-to-date when needed for processing or decision-making.

Question 34: What is data anonymization?

Storing data without assigning ownership or metadata attributes
Encrypting data with an anonymous key pair for secure transmission
Removing or altering personally identifiable information so individuals cannot be identified (Correct answer)
Routing data through anonymous network proxies for privacy

Correct answer: Removing or altering personally identifiable information so individuals cannot be identified

Data anonymization removes or modifies PII from datasets so that individuals can no longer be identified, enabling data to be used for analysis while protecting privacy.

Question 35: What does fault tolerance mean in a distributed big data system?

The system automatically scales down during low traffic
The system continues operating correctly even when individual nodes fail (Correct answer)
The system rejects any data containing errors
The system encrypts all data to prevent unauthorized access

Correct answer: The system continues operating correctly even when individual nodes fail

Fault tolerance means a distributed system can detect and recover from failures of individual components without losing data or stopping overall processing.

Question 36: When a virus is present on a computer,

The hard drive is filling up (Correct answer)
Battery is not lasting long
A program has not been installed
A mouse is easily destroyed

Correct answer: The hard drive is filling up

Computer viruses often replicate themselves, creating numerous copies or generating large log files, which can rapidly consume disk space. This activity leads to the hard drive filling up, causing the computer to slow down, exhibit errors, or even crash. While viruses have various effects, consuming disk space is a common symptom of their presence and malicious activity.

Question 37: What is the primary disadvantage of real-time stream processing compared to batch?

Higher system complexity and infrastructure cost to achieve low-latency guarantees (Correct answer)
It only works with structured data
It cannot handle any data
Output is always less accurate

Correct answer: Higher system complexity and infrastructure cost to achieve low-latency guarantees

Real-time stream processing requires more sophisticated infrastructure, fault tolerance mechanisms, and operational expertise than simple batch pipelines.

Question 38: What is RAID in the context of data storage?

Remote Access Integrated Database for distributed systems
Real-time Automated Indexing Daemon for fast data retrieval
Redundant Array of Independent Disks — a method of combining multiple drives for redundancy or performance (Correct answer)
Replicated Archive for Indexed Data storage

Correct answer: Redundant Array of Independent Disks — a method of combining multiple drives for redundancy or performance

RAID (Redundant Array of Independent Disks) combines multiple physical drives to improve data redundancy, fault tolerance, or read/write performance depending on the RAID level.

Question 39: Which approach is used to fill in missing values in a dataset?

Data sharding
Data imputation (Correct answer)
Data indexing
Data partitioning

Correct answer: Data imputation

Data imputation is the process of replacing missing or null values with estimated values using statistical or algorithmic methods.

Question 40: What is stream processing in big data?

Storing data in sequential log files
Processing only structured data from relational systems
Importing data in large batches overnight
Continuously processing data as it arrives in real time (Correct answer)

Correct answer: Continuously processing data as it arrives in real time

Stream processing handles data continuously as it is generated, enabling real-time analysis and immediate actions on incoming data.

Question 41: What does the term 'data skew' mean in distributed processing?

Data that grows faster than storage capacity
Data that is stored in the wrong geographic region
An imbalanced distribution of data across processing nodes, causing some nodes to work much harder than others (Correct answer)
Corrupted data caused by network transmission errors

Correct answer: An imbalanced distribution of data across processing nodes, causing some nodes to work much harder than others

Data skew occurs when data is unevenly distributed across partitions or nodes, causing certain nodes to process far more data and creating bottlenecks.

Question 42: What is a data lake?

A type of normalized relational database
A central repository that stores raw data in its native format until needed (Correct answer)
A cloud service for streaming video
A backup system for transactional databases

Correct answer: A central repository that stores raw data in its native format until needed

A data lake is a large-scale storage repository that holds raw, unprocessed data in its native format — structured, semi-structured, or unstructured — until it is needed for analysis.

Question 43: What is the purpose of data archiving?

Moving infrequently accessed data to lower-cost storage for long-term retention (Correct answer)
Compressing active databases during business hours
Encrypting production data for compliance
Deleting old data to free up disk space

Correct answer: Moving infrequently accessed data to lower-cost storage for long-term retention

Data archiving moves historical or rarely accessed data from primary storage to cheaper long-term storage, reducing costs while preserving data for compliance or future reference.

Question 44: What is the purpose of a checksum in data validation?

To sort records in ascending order
To compress large files before transfer
To detect errors or corruption in transmitted or stored data (Correct answer)
To speed up data retrieval

Correct answer: To detect errors or corruption in transmitted or stored data

A checksum is a computed value derived from data that is compared after transmission or storage to detect any corruption or tampering.

Question 45: What is 'data masking' used for in data processing?

Hiding processing errors from end users
Compressing data during network transmission
Encrypting database indexes
Replacing sensitive data with realistic but fictitious values (Correct answer)

Correct answer: Replacing sensitive data with realistic but fictitious values

Data masking replaces sensitive information with anonymized values to protect privacy while preserving data format and usability.

Question 46: Which security principle states that users should only have access to the minimum data required for their job?

Defense in Depth
Separation of Duties
Role-Based Access Control
Principle of Least Privilege (Correct answer)

Correct answer: Principle of Least Privilege

The Principle of Least Privilege ensures users have only the minimum access rights necessary to perform their job, reducing the risk of accidental or malicious data exposure.

Question 47: What is a data anomaly?

An unexpected or inconsistent value that deviates from normal patterns (Correct answer)
A foreign key relationship between tables
A scheduled data backup
A correctly formatted record

Correct answer: An unexpected or inconsistent value that deviates from normal patterns

A data anomaly is a value or pattern that deviates unexpectedly from norms, often indicating data entry errors, fraud, or system issues.

Question 48: What is a data warehouse?

A distributed file system for unstructured data
A temporary cache for raw incoming data
A centralized repository of integrated, structured data optimized for reporting and analysis (Correct answer)
A tool for monitoring ETL job performance

Correct answer: A centralized repository of integrated, structured data optimized for reporting and analysis

A data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of data designed to support business intelligence and decision-making.

Question 49: Which method is commonly used to standardize data from multiple sources into a uniform format?

Data compression
Data archiving
Data normalization (Correct answer)
Data encryption

Correct answer: Data normalization

Data normalization reorganizes data into a consistent, standardized format to reduce redundancy and improve data quality across sources.

Question 50: What is MapReduce in big data processing?

A programming model that processes large datasets in parallel using map and reduce functions (Correct answer)
A tool for creating geographic data visualizations
A compression algorithm for large files
A type of NoSQL database schema

Correct answer: A programming model that processes large datasets in parallel using map and reduce functions

MapReduce is a parallel processing framework where the Map phase splits and processes data, and the Reduce phase aggregates the results across distributed nodes.

Question 51: What is the CAP theorem in distributed systems?

A distributed system can guarantee at most two of three properties: Consistency, Availability, and Partition tolerance (Correct answer)
A rule that limits database tables to a maximum of three columns
A principle requiring all caches to clear after three minutes
A constraint that caps storage growth at a set percentage per year

Correct answer: A distributed system can guarantee at most two of three properties: Consistency, Availability, and Partition tolerance

The CAP theorem states that a distributed data system cannot simultaneously guarantee consistency, availability, and partition tolerance — only two can be fully achieved at once.

Question 52: Which scenario best illustrates 'late-arriving data' in a streaming processing cycle?

A batch job runs 10 minutes before its scheduled time
An event with a timestamp from 10 minutes ago arrives after the processing window for that period has already closed (Correct answer)
A data file is delivered to the wrong storage bucket
A sensor sends data ahead of the scheduled window

Correct answer: An event with a timestamp from 10 minutes ago arrives after the processing window for that period has already closed

Late-arriving data has an event timestamp that falls within a past window that the system has already finalized, requiring special handling like watermarks.

Question 53: What is access control in data security?

Tools that automatically log and audit every data access event
Software that regulates the speed of data transfer between systems
Policies that determine how long data must be retained before deletion
Mechanisms that restrict who can view or use resources in a computing environment (Correct answer)

Correct answer: Mechanisms that restrict who can view or use resources in a computing environment

Access control mechanisms determine who is authorized to access specific data or systems and under what conditions, forming a foundational component of data security.

Question 54: What does a format check validate in data processing?

That data has been backed up
That data is within numeric limits
That data matches an expected pattern or structure (Correct answer)
That data is unique across records

Correct answer: That data matches an expected pattern or structure

A format check ensures that data conforms to a predefined pattern, such as a phone number or date format.

Question 55: What is a data warehouse's key characteristic compared to an operational database?

It only stores real-time streaming data
It is updated continuously every millisecond
It is optimized for read-heavy analytical queries rather than transactional write operations (Correct answer)
It is always stored on a single machine for simplicity

Correct answer: It is optimized for read-heavy analytical queries rather than transactional write operations

Data warehouses are designed for OLAP (Online Analytical Processing), optimizing complex read queries across large historical datasets, unlike OLTP databases built for fast transactional writes.

Question 56: What does HDFS stand for?

High Definition File Storage
Hybrid Data Flow Service
Hadoop Distributed File System (Correct answer)
Hierarchical Data Format System

Correct answer: Hadoop Distributed File System

HDFS (Hadoop Distributed File System) is Hadoop's storage layer that splits large files into blocks and distributes them across multiple nodes for fault tolerance.

Question 57: What is a data breach?

The process of migrating data between two systems
A backup failure that results in permanent data loss
A scheduled maintenance window that interrupts data processing
An incident where unauthorized individuals gain access to confidential data (Correct answer)

Correct answer: An incident where unauthorized individuals gain access to confidential data

A data breach occurs when unauthorized individuals access, steal, or expose confidential data without permission from the data owner.

Question 58: What is the purpose of database caching?

Storing frequently accessed data in fast memory to reduce retrieval time (Correct answer)
Creating backup copies of the entire database
Sorting query results before returning them
Encrypting data before writing it to disk

Correct answer: Storing frequently accessed data in fast memory to reduce retrieval time

Database caching stores query results or frequently accessed data in fast in-memory storage, dramatically reducing database load and response times for repeated requests.

Question 59: What is write-ahead logging (WAL) in databases?

A technique where changes are first written to a log before being applied to the database, ensuring durability (Correct answer)
A log that records only failed write operations for debugging
A strategy that buffers all writes in memory until a threshold is reached
A method that writes data to all replicas before acknowledging success

Correct answer: A technique where changes are first written to a log before being applied to the database, ensuring durability

Write-ahead logging records every change to a log file before applying it to the actual data, ensuring that committed transactions can be recovered after a crash.

Question 60: What is eventual consistency in distributed data storage?

A backup policy that runs nightly to sync all nodes
A model where all replicas will eventually converge to the same value given no new updates (Correct answer)
A storage strategy that prioritizes speed over durability
A guarantee that all replicas are always identical at every moment

Correct answer: A model where all replicas will eventually converge to the same value given no new updates

Eventual consistency guarantees that if no new writes occur, all replicas of a distributed data store will eventually return the same value, trading immediate consistency for availability.

Data Processing Fundamentals

A foundational certification covering core data processing concepts including batch and real-time processing, big data technologies, data storage and retrieval systems, and data security and privacy practices.

Questions

75 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds