Python Institute 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

答えを確認する

正解: