CompTIA DataSys+ (DS0-001) — Question 1

A database administrator set up a connection for a SQL Server instance for a new user, but the administrator is unable to connect using the user's workstation. Which of the following is the most likely cause of the issue?

Answer options

• A. The SQL Server codes are performing badly.
• B. The SQL Server has not been tested properly.
• C. The SQL Server ports to the main machine are closed.
• D. The SQL Server has many concurrent users.

Correct answer: C

Explanation

The correct answer is C because if the SQL Server ports are closed, the user's workstation will not be able to establish a connection. Options A and D do not directly relate to connectivity issues, and option B is too vague and does not address the specific connection problem.