
Ultimate access to all questions.
You have a table in an Azure Synapse Analytics dedicated SQL pool that was created using the following Transact-SQL statement:
You need to alter the table to meet these requirements:
Ensure users can identify the current manager of employees
Support creating an employee reporting hierarchy for the entire company
Provide fast lookup of the managers' attributes such as name and job title
Which column should you add to the table?

A
[ManagerEmployeeID] [smallint] NULL
B
[ManagerEmployeeKey] [smallint] NULL
C
[ManagerEmployeeKey] [int] NULL
D
[ManagerName] varchar [blocked] NULL