nerdexam
Microsoft

98-361 · Question #234

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; Integrated Security=SSPf; 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; Integrated Security=SSPf; Initial Catalog=Sales
  • BData Source=MyDB; Trusted_Connection=True; MultipleActiveResultSets=True;
  • CData Source=MyDB; Integrated Security=True; Initial Catalog=Sales
  • DData Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales

How the community answered

(27 responses)
  • A
    85% (23)
  • B
    7% (2)
  • C
    4% (1)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 98-361 Practice