PCAD-31-02 by Python Institute Valid Free Exam Practice Test

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

Question 1

What is the primary reason to use .head() and .tail() methods in pandas when exploring datasets?

A. To preview the first and last few rows of data B. To create visualizations C. To rename columns D. To delete missing values

Correct Answer: A

Question 2

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

A. Employing parameterized statements for user-supplied data B. Wrapping SQL commands in try-except blocks C. Using string formatting to build SQL queries dynamically D. Using string concatenation to insert variables into SQL

Correct Answer: A,B

Question 3

Which metric is most appropriate for evaluating the accuracy of a classification model?

A. Mean squared error B. R-squared C. Precision D. Confusion matrix

Correct Answer: C

Question 4

Which methods can be used to validate data types and structure in a Pandas DataFrame?
(Choose two)

A. df.info() B. df.memory_usage() C. df.to_csv() D. df.dtypes

Correct Answer: A,D

Question 5

Which of the following practices contributes most to making Python scripts modular and maintainable?

A. Using global variables freely B. Structuring code with reusable functions and modules C. Hard-coding file paths in every function D. Writing all logic in the global scope

Correct Answer: B

Question 6

What result will the following Pandas expression return: df['Age'].notnull().all()?

A. Returns True if all values in 'Age' are not NULL B. Returns True if at least one value in 'Age' is not NULL C. Returns True if all values in 'Age' are NULL D. Returns the number of NULL values in 'Age'

Correct Answer: A