What service should a database administrator consider using to resolve connectivity issues by checking the database server address?

• A. Domain Name Service (DNS)
• B. Active Directory
• C. File Transfer Protocol (FTP)
• D. Network Time Protocol (NTP)

Answer: (A)

A database administrator encountering connectivity issues often needs to ensure that the database server address is correct and reachable. The Domain Name Service (DNS) plays a crucial role in this scenario. DNS translates human-readable domain names into IP addresses, which is fundamental for connecting to servers over a network.

If the database server's address is specified by a domain name (e.g., dbserver.example.com), the DNS service will resolve that name into its corresponding IP address. Any misconfiguration or failure in the DNS can result in connectivity issues, which is why checking DNS is essential when troubleshooting access to a database server.

The other options do not serve the same function in this context. Active Directory is primarily used for directory services and managing user permissions and authentication within a network, not specifically for resolving server addresses. File Transfer Protocol (FTP) is utilized for transferring files between a client and a server and does not assist in addressing connectivity. Network Time Protocol (NTP) is used for synchronizing time across devices on a network, which, while essential for data synchronization, does not resolve connectivity issues tied to server address resolution.