Python Institute Certified Associate Data Analyst with Python (PCAD-31-02)

QUESTION NO: 1
Which element is essential to justify a conclusion drawn from a dataset?

A. The origin of the dataset B. Logical reasoning and supported metrics C. File format of the source data D. The use of color in plots

Correct Answer: B

QUESTION NO: 2
Which method is commonly used to handle missing numerical data in a dataset?

A. Multiplying all missing values by zero B. Dropping all columns C. Filling with the mean or median D. Replacing with text labels

Correct Answer: C

QUESTION NO: 3
When merging two Pandas DataFrames using a common key, which parameters are essential to ensure accurate and conflict-free results?
(Choose two)

A. dropna B. on C. suffixes D. ignore_index

Correct Answer: B,C

QUESTION NO: 4
Which characteristics are typically associated with unstructured data formats?
(Choose two)

A. Lacks predefined data schema B. Stored using fixed-width fields and records C. Highly tabular and query-friendly D. Requires parsing or transformation before analysis

Correct Answer: A,D

QUESTION NO: 5
Which transformation method adjusts the mean of the dataset to 0 and the standard deviation to 1?

A. Log transformation B. Z-score normalization C. Min-max normalization D. One-hot encoding

Correct Answer: B

QUESTION NO: 6
Which Pandas methods are commonly used to extract central tendency and dispersion insights from a DataFrame?
(Choose two)

A. sort_values() B. median() C. pivot_table() D. var()

Correct Answer: B,D

QUESTION NO: 7
What is the key difference between the .iloc[] and .loc[] accessors when working with Series or DataFrames?

A. .iloc[] allows label-based selection B. .iloc[] is position-based, while .loc[] is label-based C. .loc[] does not allow slicing D. .loc[] can only be used on Series

Correct Answer: B

QUESTION NO: 8
What is the main purpose of using the bootstrapping technique in inferential statistics?

A. To increase the number of features in a model B. To estimate the sampling distribution by resampling with replacement C. To filter outliers from a dataset D. To validate the syntax of SQL queries in Python

Correct Answer: B

QUESTION NO: 9
Which practices help maintain data integrity across large datasets in Pandas workflows?
(Choose two)

A. Using assertions to enforce domain-specific rules B. Automatically converting all text to uppercase C. Defining and enforcing schema constraints D. Sorting columns alphabetically

Correct Answer: A,C

QUESTION NO: 10
What is the primary purpose of using annotations in a data visualization?

A. To enhance interactivity in static plots B. To ensure faster rendering in large datasets C. To replace the need for axes D. To highlight important data points and provide contextual information

Correct Answer: D

Python Institute Certified Associate Data Analyst with Python (PCAD-31-02) - PCAD-31-02 Exam Questions