Microsoft
70-450 · Question #140
70-450 Question #140: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #140. The question stem and answer options stay visible for context.
Question
Your manager is trying to create a new SQL login using a T-SQL script. This is the command that he is trying to run: CREATE LOGIN users\temp1 FROM WINDOWS MUST CHANGE However, the command fails when he tries to run it in SQL Management Studio. What is wrong with his SQL statement?
Options
- AHe needs to use WITH SUBJECT as well
- BHe can't use MUST CHANGE with a windows login
- CHe needs to use CHECK POLICY = ON
- DHe needs to use the HASHED argument for windows logins
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.