You have been hired by a company named ABC.com to manage their Microsoft Dynamics NAV
2013 infrastructure.
The Microsoft Dynamics NAV 2013 infrastructure has multiple Microsoft Dynamics NAV 2013
servers and multiple Microsoft Dynamics NAV databases.
One Microsoft Dynamics NAV database named NAVDB01 contains multiple companies.
NAVDB01 uses a case sensitive collation.
You attempt to change the collation on NAVDB01 but receive the following error message:
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the
object name..
How can you change the collation without receiving the error message?

A.
Remove all active users and detach the database before changing the collation.

B.
Change to a collation that is case insensitive.

C.
Change to a collation that is case sensitive.

D.
Remove all duplicate primary keys from the database before attempting to change the collation.

Explanation: