SQL Server DBA quiz medium level

TAKE THE TEST

Test description

This test assesses your medium knowledge of SQL Server Administration, as well as your ability to work directly on installing, configuring, and administering Microsoft SQL Server 2014.

Sample questions

1 You are the DBA at your company. One of the database developers announces you that he can no longer connect to a given SQL Server instance trying to use the server/instance naming format. He tells you that he receives the error "Cannot connect to server/instance". You check if the SQL Server instance is running and you find out that it does. What could be causing the problem?