CompTIA Data+ (DA0-001) — Question 364

Given a database with the following fields:

• Item_Name
• First_Name
• Item_Price
• Customer_ID

Which of the following is the best primary key?

Answer options

• A. Item_Name
• B. First_Name
• C. Item_Price
• D. Customer_ID

Correct answer: D

Explanation

The best primary key is Customer_ID because it uniquely identifies each customer in the database. Item_Name, First_Name, and Item_Price may not be unique, as multiple items or customers could share the same name or price, leading to potential conflicts.