Associate Big Data Analyst (ABDA) Latest Practice
Exam (Updated Edition)
Q1. In the context of the Hadoop Ecosystem, which component is specifically designed to provide
low-latency, real-time read/write access to large datasets sitting on top of HDFS?
A) Apache Hive
B) Apache Pig
C) Apache HBase
D) Apache Spark (Core)
Answer: C
Explanation: While HDFS is optimized for batch processing and high throughput, HBase is a NoSQL,
column-oriented database that allows for random, real-time access to data in the Hadoop ecosystem.
Q2. A retail company is processing 5 terabytes of streaming data daily. The data arrives in
inconsistent formats and requires immediate sentiment analysis. Which "V" of Big Data is the
primary challenge here?
A) Volume
B) Velocity
C) Variety
D) Veracity
Answer: C
Explanation: The mention of "inconsistent formats" points directly to Variety, which refers to the
structural diversity of data (structured, semi-structured, and unstructured).
Q3. When performing Exploratory Data Analysis (EDA), you observe a high degree of "Kurtosis" in
your distribution. What does this specifically indicate about your data?
A) The degree of asymmetry in the distribution.
B) The presence of outliers or the "tailedness" of the distribution.
C) The correlation between two independent variables.
D) The central tendency of the dataset.
Answer: B
Explanation: Kurtosis measures the "fatness" of the tails. High kurtosis indicates that the data has
frequent outliers, whereas skewness measures asymmetry.
,Associate Big Data Analyst (ABDA) Latest Practice
Exam (Updated Edition)
Q4. In a Spark application, what is the primary advantage of using a DataFrame over an RDD
(Resilient Distributed Dataset)?
A) DataFrames allow for manual memory management.
B) DataFrames use the Catalyst Optimizer for query optimization.
C) RDDs are only compatible with Python, while DataFrames work with Scala.
D) DataFrames are strictly for small datasets.
Answer: B
Explanation: DataFrames provide a higher-level abstraction and benefit from Spark's Catalyst
Optimizer and Tungsten execution engine, making them more efficient than raw RDDs for most tasks.
Q5. You are using SQL to join two tables: Sales and Products. You want to return all products even
if they haven't been sold yet. Which join should you use?
A) INNER JOIN
B) LEFT JOIN (assuming Products is the left table)
C) CROSS JOIN
D) NATURAL JOIN
Answer: B
Explanation: A LEFT JOIN returns all records from the left table and matched records from the right;
unmatched records from the right table appear as NULL, ensuring all products are listed.
Q6. Which statistical measure is most sensitive to extreme outliers in a dataset?
A) Median
B) Mode
C) Mean
D) Interquartile Range (IQR)
Answer: C
Explanation: The Mean (average) incorporates the value of every data point; therefore, a single
extremely high or low value will significantly shift the result.
Q7. In a NoSQL environment, which data model is most suitable for representing highly
interconnected data, such as a social network's "friend-of-a-friend" relationships?
,Associate Big Data Analyst (ABDA) Latest Practice
Exam (Updated Edition)
A) Key-Value Store
B) Document Store
C) Column-Family Store
D) Graph Database
Answer: D
Explanation: Graph databases (like Neo4j) are designed specifically to handle relationships and
interconnectedness through nodes and edges.
Q8. When designing a BI Dashboard for executive leadership, what is the most important principle
of "Data Storytelling"?
A) Including every available metric to ensure transparency.
B) Using complex 3D charts to show technical depth.
C) Focusing on actionable insights that align with Key Performance Indicators (KPIs).
D) Using as many different colors as possible to differentiate data.
Answer: C
Explanation: Executives need high-level, actionable data. Overcrowding a dashboard with non-
essential metrics (Data Ink) reduces its effectiveness.
Q9. Which of the following best describes "Veracity" in Big Data?
A) The speed at which data is generated.
B) The scale of the data in petabytes.
C) The uncertainty or trustworthiness of the data.
D) The financial value derived from the data.
Answer: C
Explanation: Veracity refers to data quality, cleanliness, and how much trust can be placed in the
information for decision-making.
Q10. In Excel, which function would you use to find a specific value in a large table and return a
value from a different column in the same row, but is more flexible than VLOOKUP?
A) HLOOKUP
B) INDEX/MATCH
, Associate Big Data Analyst (ABDA) Latest Practice
Exam (Updated Edition)
C) CONCATENATE
D) COUNTIF
Answer: B
Explanation: INDEX/MATCH is more flexible than VLOOKUP because it doesn't require the lookup
value to be in the first column and is generally faster for large datasets.
Q11. A "Skewed Right" (Positively Skewed) distribution typically shows which relationship
between the Mean and Median?
A) Mean = Median
B) Mean < Median
C) Mean > Median
D) Mean = Mode
Answer: C
Explanation: In a right-skewed distribution, the long tail on the right pulls the Mean toward the
higher values, making it larger than the Median.
Q12. What is the role of the "Resource Manager" in Hadoop YARN?
A) To store data across the cluster.
B) To act as the ultimate authority in arbitrating resources among all applications.
C) To execute specific tasks within a container.
D) To track the status of HDFS blocks.
Answer: B
Explanation: YARN (Yet Another Resource Negotiator) uses the Resource Manager to manage cluster
resources and schedule applications.
Q13. In Business Analytics, what is "Descriptive Analytics" primarily used for?
A) Predicting future trends using machine learning.
B) Recommending a specific course of action.
C) Summarizing historical data to understand what happened.
D) Identifying the root cause of an unexpected event.
Exam (Updated Edition)
Q1. In the context of the Hadoop Ecosystem, which component is specifically designed to provide
low-latency, real-time read/write access to large datasets sitting on top of HDFS?
A) Apache Hive
B) Apache Pig
C) Apache HBase
D) Apache Spark (Core)
Answer: C
Explanation: While HDFS is optimized for batch processing and high throughput, HBase is a NoSQL,
column-oriented database that allows for random, real-time access to data in the Hadoop ecosystem.
Q2. A retail company is processing 5 terabytes of streaming data daily. The data arrives in
inconsistent formats and requires immediate sentiment analysis. Which "V" of Big Data is the
primary challenge here?
A) Volume
B) Velocity
C) Variety
D) Veracity
Answer: C
Explanation: The mention of "inconsistent formats" points directly to Variety, which refers to the
structural diversity of data (structured, semi-structured, and unstructured).
Q3. When performing Exploratory Data Analysis (EDA), you observe a high degree of "Kurtosis" in
your distribution. What does this specifically indicate about your data?
A) The degree of asymmetry in the distribution.
B) The presence of outliers or the "tailedness" of the distribution.
C) The correlation between two independent variables.
D) The central tendency of the dataset.
Answer: B
Explanation: Kurtosis measures the "fatness" of the tails. High kurtosis indicates that the data has
frequent outliers, whereas skewness measures asymmetry.
,Associate Big Data Analyst (ABDA) Latest Practice
Exam (Updated Edition)
Q4. In a Spark application, what is the primary advantage of using a DataFrame over an RDD
(Resilient Distributed Dataset)?
A) DataFrames allow for manual memory management.
B) DataFrames use the Catalyst Optimizer for query optimization.
C) RDDs are only compatible with Python, while DataFrames work with Scala.
D) DataFrames are strictly for small datasets.
Answer: B
Explanation: DataFrames provide a higher-level abstraction and benefit from Spark's Catalyst
Optimizer and Tungsten execution engine, making them more efficient than raw RDDs for most tasks.
Q5. You are using SQL to join two tables: Sales and Products. You want to return all products even
if they haven't been sold yet. Which join should you use?
A) INNER JOIN
B) LEFT JOIN (assuming Products is the left table)
C) CROSS JOIN
D) NATURAL JOIN
Answer: B
Explanation: A LEFT JOIN returns all records from the left table and matched records from the right;
unmatched records from the right table appear as NULL, ensuring all products are listed.
Q6. Which statistical measure is most sensitive to extreme outliers in a dataset?
A) Median
B) Mode
C) Mean
D) Interquartile Range (IQR)
Answer: C
Explanation: The Mean (average) incorporates the value of every data point; therefore, a single
extremely high or low value will significantly shift the result.
Q7. In a NoSQL environment, which data model is most suitable for representing highly
interconnected data, such as a social network's "friend-of-a-friend" relationships?
,Associate Big Data Analyst (ABDA) Latest Practice
Exam (Updated Edition)
A) Key-Value Store
B) Document Store
C) Column-Family Store
D) Graph Database
Answer: D
Explanation: Graph databases (like Neo4j) are designed specifically to handle relationships and
interconnectedness through nodes and edges.
Q8. When designing a BI Dashboard for executive leadership, what is the most important principle
of "Data Storytelling"?
A) Including every available metric to ensure transparency.
B) Using complex 3D charts to show technical depth.
C) Focusing on actionable insights that align with Key Performance Indicators (KPIs).
D) Using as many different colors as possible to differentiate data.
Answer: C
Explanation: Executives need high-level, actionable data. Overcrowding a dashboard with non-
essential metrics (Data Ink) reduces its effectiveness.
Q9. Which of the following best describes "Veracity" in Big Data?
A) The speed at which data is generated.
B) The scale of the data in petabytes.
C) The uncertainty or trustworthiness of the data.
D) The financial value derived from the data.
Answer: C
Explanation: Veracity refers to data quality, cleanliness, and how much trust can be placed in the
information for decision-making.
Q10. In Excel, which function would you use to find a specific value in a large table and return a
value from a different column in the same row, but is more flexible than VLOOKUP?
A) HLOOKUP
B) INDEX/MATCH
, Associate Big Data Analyst (ABDA) Latest Practice
Exam (Updated Edition)
C) CONCATENATE
D) COUNTIF
Answer: B
Explanation: INDEX/MATCH is more flexible than VLOOKUP because it doesn't require the lookup
value to be in the first column and is generally faster for large datasets.
Q11. A "Skewed Right" (Positively Skewed) distribution typically shows which relationship
between the Mean and Median?
A) Mean = Median
B) Mean < Median
C) Mean > Median
D) Mean = Mode
Answer: C
Explanation: In a right-skewed distribution, the long tail on the right pulls the Mean toward the
higher values, making it larger than the Median.
Q12. What is the role of the "Resource Manager" in Hadoop YARN?
A) To store data across the cluster.
B) To act as the ultimate authority in arbitrating resources among all applications.
C) To execute specific tasks within a container.
D) To track the status of HDFS blocks.
Answer: B
Explanation: YARN (Yet Another Resource Negotiator) uses the Resource Manager to manage cluster
resources and schedule applications.
Q13. In Business Analytics, what is "Descriptive Analytics" primarily used for?
A) Predicting future trends using machine learning.
B) Recommending a specific course of action.
C) Summarizing historical data to understand what happened.
D) Identifying the root cause of an unexpected event.
