PCAD-31-02 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

Question No : 1
In a scatter plot showing the relationship between advertising spend and sales revenue, the points form a tight upward-sloping pattern.
What conclusion can be drawn?

A.The correlation is weak and likely negative
B.The data shows no apparent relationship
C.There is a strong positive correlation
D.Advertising has no effect on sales

正解:

Question No : 2
Which method in the pandas library allows efficient loading of large datasets in chunks to conserve memory?

A.read_csv(chunksize=...)
B.load_dataset()
C.import_csv()
D.fetch_chunks()

正解:

Question No : 3
What is the primary difference between the == operator and the is operator in Python when used in a data pipeline?

A.== checks identity, while is compares memory addresses
B.is checks value equality, while == checks for data type compatibility
C.== compares values for equality, while is checks for object identity
D.is compares dictionary keys, while == compares keys and values

正解:

Question No : 4
Which of the following statements best describes the structural relationship between Pandas Series and DataFrames?

A.A Series contains multiple DataFrames
B.A DataFrame is a one-dimensional array of Series
C.A DataFrame is a two-dimensional container of Series objects
D.A Series can only be created from a DataFrame

正解:

Question No : 5
Why might using a pie chart to represent category proportions be less effective than a bar chart?

A.Pie charts display individual data points more clearly
B.Pie charts cannot be created using Seaborn
C.Human perception is less accurate at judging angles than lengths
D.Bar charts are limited to one variable only

正解:

Question No : 6
Which file formats are commonly used for hierarchical or nested data structures in data acquisition? (Choose two)

A.XML
B.JSON
C.CSV
D.TSV

正解:

Question No : 7
When performing bootstrapping on a dataset with 500 observations, what is a typical procedure?

A.Creating samples by removing all duplicates
B.Generating multiple datasets of the same size by randomly sampling with replacement
C.Scaling all values between 0 and 1 before resampling
D.Drawing one sample and calculating the mean only once

正解:

Question No : 8
Which techniques are commonly used to manage type conversion between SQL and Python when importing database values? (choose two)

A.Using a mapping function to convert SQL types into Python objects
B.Ignoring data types and treating everything as strings
C.Defining column types in Python using sqlite3.register_converter()
D.Automatically casting Python variables to SQL column types without validation

正解:

Question No : 9
Which method is best suited to transform inconsistent entries such as "N/A", "missing", and empty strings into a standard missing value representation in a Pandas DataFrame?

A.df.dropna()
B.df.rename()
C.df.replace()
D.df.sort_values()

正解:

Question No : 10
What is the primary reason for converting all categorical labels to lowercase during the data cleaning process?

A.To reduce memory usage in the dataset
B.To improve data visualization aesthetics
C.To avoid treating the same category as different due to case differences
D.To make string comparison operations slower

正解:

Question No : 11
Which practices are considered part of professional Python scripting standards? (Choose two)

A.Including in-line comments and docstrings
B.Avoiding error handling to keep code clean
C.Using consistent indentation and naming conventions
D.Avoiding use of modules and libraries

正解:

Question No : 12
Which packages are most commonly used together in a data science workflow for data manipulation and visualization? (Choose two)

A.pandas
B.NumPy
C.Pygame
D.flask

正解:

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

A.To avoid using charts altogether
B.To simplify all metrics to percentages only
C.To ensure the data is understood and supports actionable insights
D.To include as many technical terms as possible

正解:

Question No : 14
Which SQL command should a data analyst use to modify existing records in a database table based on specific conditions?

A.INSERT
B.UPDATE
C.SELECT
D.CREATE

正解:

Question No : 15
Which Python library is most commonly used to establish a connection to a SQLite database and perform SQL operations?

A.pymysql
B.psycopg2
C.sqlite3
D.sqlalchemy

正解:

Python Institute PCAD-31-02 問題練習