PCAD-31-02 試験問題を無料オンラインアクセス

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

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

Which of the following correctly demonstrates the use of parameterized queries using Python's sqlite3 module?

• A.cursor.execute("SELECT * FROM users WHERE id = ':id'", {'id': user_id})
• B.cursor.execute("SELECT * FROM users WHERE id = ?", (user_id,))
• C.cursor.execute("SELECT * FROM users WHERE id = ?", user_id)
• D.cursor.execute("SELECT * FROM users WHERE id = " + user_id)

What is the most efficient way to handle missing values in a Pandas DataFrame when preparing a dataset for analysis that must maintain original index structure and avoid row deletions?

• A.Apply interpolate() method
• B.Use fillna() with a constant value
• C.Use drop() to remove null rows
• D.Use dropna() with axis=1

Which Python construct allows you to iterate over a list of dictionary values and apply conditional logic to accumulate numerical values that meet a certain threshold?

• A.while loop with try block
• B.lambda expression with reduce
• C.filter() function with map
• D.for loop with if condition

Which best practices help enhance database security when building Python data analysis pipelines?
(Choose two)

• A.Sanitize input by replacing dangerous characters with asterisks
• B.Limit database user permissions to only necessary operations
• C.Store credentials securely using environment variables
• D.Construct queries using f-strings for readability