CREST Practitioner Security Analyst (CPSA) 2026 – 400 Free Practice Questions to Pass the Exam

Question: 1 / 485

What does MS-SQL monitor on port 1434?

Remote access

Database connections

The correct answer, involving what MS-SQL monitors on port 1434, is related to its role in handling database connections. Port 1434 is primarily utilized by the SQL Server Resolution Protocol (SSQL-RP), which allows clients to discover SQL Server instances running on a machine. When a client attempts to connect to SQL Server, it sends a request to port 1434, which responds with the appropriate database service instance's connection details. This highlights the significance of port 1434 in facilitating the establishment of database connections, making it essential for the operation of SQL services.

This monitoring ensures clients can accurately find and connect to available SQL Server instances, which is crucial for effective database management and user access. Therefore, the primary function of port 1434 is to monitor and manage the connections between clients and the MS-SQL databases.

Get further explanation with Examzify DeepDiveBeta

Network traffic

Session initiations

Next Question

Report this question

Download CREST Practitioner Security Analyst (CPSA) Practice PDF Study Guide
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy