CREST Practitioner Security Analyst (CPSA) Practice

Disable ads (and more) with a membership for a one time $2.99 payment

Master the CREST Practitioner Security Analyst Exam. Prepare with quizzes and comprehensive study guides that include tips and explanations. Excel in your certification journey!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

What is the primary protocol associated with port 1434?

MySQL
Oracle
MS-SQL
RDP

The correct answer is: MS-SQL

The primary protocol associated with port 1434 is indeed linked to MS-SQL, or Microsoft SQL Server. When SQL Server services are running, port 1434 is utilized primarily for the SQL Server Resolution Protocol (SSRP). This protocol helps clients discover SQL Server instances running on a network, assisting in the process of resolving instance names to the corresponding ports they are listening on. This port is crucial for the functionality of SQL Server, particularly in environments where multiple instances may be hosted on the same machine. By using port 1434, SQL Server can facilitate the dynamic resolution of instances, which allows clients to connect without needing explicit port number details, thereby streamlining database connectivity. Other protocols, such as MySQL, Oracle, and RDP, operate on separate, well-defined ports that are not associated with the SQL Server designation, highlighting why MS-SQL is the correct association with port 1434.