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

Option C since you need to create the user before any authentication setup.

It’s C because you can’t authenticate without the user existing first. ALTER USER changes details but doesn’t create the account needed for login. So creating the user is step one.

C, since creating the user is the essential first step for authentication.

D imo, because ALTER USER usually handles changing passwords or enabling login right after the user is created. Just creating the user (C) might not be enough for authentication.

Yeah, INSERT USER isn’t a thing in SQL, so A’s out. ALTER USER usually changes existing accounts, so creating a new user with C is the only real start here. C

A imo, INSERT USER doesn't seem like a valid command in standard SQL. So it’s probably not A. Between C and D, creating the user first (C) sounds like the logical starting point.

Maybe C, since you need to create the user before they can authenticate.

I’m pretty sure it’s C. CREATE USER since that’s the standard command to set up a new user account for database access. The others don’t sound right for creating authentication credentials.