⚡️ Pass with Confidence Sale - 40% off ALL packages! ⚡️

2 days, 0 hour remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

A reporting analyst is trying to refresh a dashboard that uses an ODBC DSN to connect to the production SQL Server named SQLPROD01. The connection fails immediately with the driver message "TCP Provider: No connection could be made because the target machine actively refused it." The analyst can successfully ping SQLPROD01 by host name, and teammates on the same subnet can query the server without problems. The DBA confirms that the SQL instance is listening on its default port (1433). Which action should the analyst take first to determine whether a local firewall rule on her workstation is blocking the required port?

  • Run the PowerShell cmdlet Test-NetConnection SQLPROD01 -Port 1433 to verify TCP connectivity to the database port.

  • Append the port number to the DSN's server field (for example, SQLPROD01,1433) and attempt to reconnect.

  • Remove any saved passwords for the DSN in Windows Credential Manager and test the connection again.

  • Flush the local DNS resolver cache with ipconfig /flushdns and retry the connection.

CompTIA Data+ DA0-002 (V2)
Data Analysis
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot