SQL Server DBA quiz medium level

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?

The user does not have the necessary privileges to connect to the SQL Server instance.

The SQL Server Browser service is not running.

The SQL Server Integration Services service is not running.

The user is not member of the admin group on the server.

The Login used by the user is temporary blocked due to multiple unsuccessful authentication attempts.

Results between 1-7 / 25	59.5%
Results between 8-14 / 25	30.43%
Results between 15-21 / 25	8.33%
Results between 22-25 / 25	1.74%
Average results 7 / 25

SQL Server DBA quiz medium level

Test description

Sample questions

Related tests

PostgreSQL quiz medium level

PostgreSQL DBA quiz medium level

SQL quiz advanced level

MySQL Development quiz advanced level

SQL Development quiz medium level