You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement.

You need to alter the table to meet the following requirements:
▶ Ensure that users can identify the current manager of employees.
▶ Support creating an employee reporting hierarchy for your entirecompany.
▶ Provide fast lookup of the managers' attributes such as name and job title.
Which column should you add to the table?

Question

Examsnet · Accepted Answer

Correct Answer is : [ManagerEmployeeKey] [int] NULL

Data Engineering on Microsoft Azure DP-203 Practice Test 1