Which type of synthetic transaction would you configure to verify that a SQL Server database was responding to remote queries?



Question:

Which type of synthetic transaction would you configure to verify that a SQL Server database was responding to remote queries?
A. Windows Service.
B. TCP Port.
C. OLE DB data source.
D. Web application availability.

Correct answer: C


A. Incorrect: You use this type of synthetic transaction to verify that a service is running.
B. Incorrect: You use this type of synthetic transaction to verify that a TCP Port is available.
C. Correct: You can use this type of synthetic transaction to verify that an OLE DB compatible database is responding to remote queries.
D. Incorrect: You use this type of synthetic transaction to verify that a web application is responding to requests.