You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. A Domain.com user named Mia Hamm was complaining that she is waiting
forever for a search to finish. You need to make sure if the query is blocked.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. However, recently CK_Prod has
produced deadlock problems. You have received instructions from management to get the
deadlocks on the SQL Server error log.

What should you do? (Choose TWO)

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You need to use the Windows System Monitor and process the output of how
many users access the SQL Server instance.

What should you do?

You work as a database administrator at Domain.com. Domain.com contains a SQL Server
2008 computer named CERTKILLER-DB01. CERTKILLER-DB01 contains three examples of SQL
Server that is supposed to have the ability to connect to the dedicated administrative connection to
have a disaster recovery plan. During testing you can connect to the connection on CERTKILLER-DB01’s
default example to test its ability; however, you cannot connect to the dedicated
connection on the two other examples. You have received instructions to do the following:
* Make sure that the examples are implementing.
* Make sure that the client applications can approach them.
* Ensure that the other administrators cannot connect to any dedicated connections on CERTKILLER-DB01.
* Ensure that you could connect to the dedicated connection on all three examples.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. One morning you have received numerous complaints from the Domain.com
users that they cannot connect to the default instance or the named instances. You need to make
sure that the users can access the entire SQL instances.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. Domain.com is using the following to
join two tables on a column called CK_Cmn.

SELECT P.*, PD.*FROM Products
AS PINNER JOIN Products AS PD ON PD.CK_Cmn = PD.CK_Cmn

However, when you run the search you received the following error:

"Msg 468, Level 16, State 9, Line 17Cannot resolve the collation conflict between
‘SQL_Latin1_General_CP1_CS_AS’ and ‘SQL_Latin1_General_CP1_CI_AS’ in the equal to
operation."

You need to ensure that you can change the ON clause of the search to perform a join. What
should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. CK_DB contains a table named CK_Prod
that contains several indexes and numerous rows. However, 40 % of the indexes on CK_DB are
fragmented. You have received instructions to ensure that the effect on database availability is
minimized.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a Microsoft SQL
Server 2008 Analysis Services (SSAS) instance. You have received instruction to deploy a data
mining structure that has the Microsoft Clustering mining model "From Scalable K-Means to Non-scalable K-Means". You need to modify the attribute of the mining model.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. CK_DB also contains spatial data types.
You have received instructions to run a database consistency check on CK_DB to hold the spatial
indexes and to make the effect on the database concurrency minimized.

What should you do?