IBM Exam Questions

Which steps must be performed if the data types of several columns in the SQL Server data source are

A database administrator created all of the necessary federated objects for an SQL Server data
source in a federated system. Which steps must be performed if the data types of several columns
in the SQL Server data source are changed?

A.
Drop the current data type mapping.
Create the new data type mapping.

B.
Drop the nickname to the table.
Create the new data type mapping.
Recreate the nickname to the table.

C.
Drop the current data type mapping.
Create the new data type mapping.
Drop the nickname to the table.
Recreate the nickname to the table.

D.
Drop the current user mapping.
Drop the current data type mapping.
Create the new user mapping.
Create the new data type mapping.
Recreate the nickname to the table.

Explanation: