Correct Answer: A
This error occurs due to one cause only. If the AD user is trying to connect to the master database and that user does not exist in the master, there are two ways to mitigate this error. One, we should specify the dedicated SQL pool to which we are trying to connect at the connection time. Second, add the user to master.
Option A is correct:It is the cause of the error.
Option B is incorrect: This error is caused when the user does not exist in the master and not any other specific database in the pool.
Option C is incorrect: There will be a connection timeout or related error if the firewall is blocking.
Option D is incorrect: It`s an error that can occur when a login has been created on the SQL Database master database, but not in the specific SQL database.
Reference:
To know more, please refer to the docs below:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-troubleshoot#connecting