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

Question 1

Which method is typically used in Pandas to check if a column contains only values within an expected range?

A. df.isin()

B. df.clip()

C. df.sample()

D. df.sort_values()

Correct Answer: A

Question 2

Why is it important to adjust data presentations based on the audience's background?

A. To simplify all metrics to percentages only

B. To avoid using charts altogether

C. To ensure the data is understood and supports actionable insights

D. To include as many technical terms as possible

Correct Answer: C

Question 3

What is the primary reason for using parameterized queries instead of directly formatting SQL strings in Python?

A. To prevent SQL injection vulnerabilities

B. To reduce the number of SQL statements

C. To simplify data encryption

D. To allow dynamic table creation

Correct Answer: A

Question 4

Which practices help ensure secure and effective execution of SQL queries in Python scripts?
(Choose all that apply)

A. Wrapping SQL commands in try-except blocks

B. Using string formatting to build SQL queries dynamically

C. Using string concatenation to insert variables into SQL

D. Employing parameterized statements for user-supplied data

Correct Answer: A,D

Question 5

Which method is appropriate for combining two DataFrames based on a shared key column where non-matching rows should be excluded from the result?

A. concat()

B. merge(..., how='inner')

C. append()

D. join(..., how='outer')

Correct Answer: B

Question 6

Why is min-max scaling applied before using algorithms like K-Nearest Neighbors or SVM?

A. To make all features interpretable as binary values

B. To prevent features with larger scales from dominating distance calculations

C. To compress all values into integers

D. To convert strings into numeric values

Correct Answer: B

Question 7

Which features are commonly supported by both Matplotlib and Seaborn for customizing visualizations?
(Choose two)

A. Automatic plot animations

B. Inserting audio annotations

C. Changing plot color palettes

D. Adding plot titles and axis labels

Correct Answer: C,D

Welcome to TestSimulate

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