Free COMPTIA Datasys+ DS0-001 Actual Exam Questions - Question 2 Discussion

Option C seems fine too if the focus is just on creating the table structure.

C imo, since it looks like it covers the basic table structure without overcomplicating things. Sometimes the question just wants the fundamental syntax to create the table, rather than all the bells and whistles. Options with constraints might be overkill if the question doesn’t specify them explicitly. Also, A and B don’t seem as complete as C does for a straightforward create table command. So, if we’re focusing on the essential SQL create syntax without extra constraints, C fits better.

Maybe D makes the most sense here since it covers the full picture with constraints, unlike A or B which might just be basic table creation. Ensuring data integrity with keys is pretty important for customer info. If the question is about creating a proper customer table, including things like primary keys, D fits better than just a barebones create statement.

Option D seems better because it not only uses the CREATE TABLE syntax but also includes constraints like PRIMARY KEY, which are important for ensuring unique customer records. Just creating a table isn’t enough; the structure has to support data integrity, and D covers that.

I’m leaning towards option A because it specifies the right data types for customer info, which is crucial. Even if C uses CREATE TABLE, without correct data types, it won't work properly. So, I think the choice isn’t just about the command but also how the table is structured.

Looks like option C fits best since it uses CREATE TABLE syntax, which is standard for making tables in SQL. Anyone else agree or see a catch?