Microsoft
98-361 · Question #95
You have a SQL Server database named MyDB that uses SQL Server Authentication. Which connection string should you use to connect to MyDB?
The correct answer is A. Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales. See the full explanation below for the reasoning.
Question
You have a SQL Server database named MyDB that uses SQL Server Authentication. Which connection string should you use to connect to MyDB?
Options
- AData Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales
- BData Source=MyDB; Integrated Security=SSPI; Initial Catalog=Sales
- CData Source=MyDB; Integrated Security=True; Initial Catalog=Sales
- DData Source=MyDB; Trusted_Connection=True; MultipleActiveResultSets=True; Initial
How the community answered
(36 responses)- A75% (27)
- B14% (5)
- C3% (1)
- D8% (3)
Community Discussion
No community discussion yet for this question.