Microsoft Data Engineering on Microsoft Azure DP-203 Question # 26 Topic 3 Discussion

Microsoft Data Engineering on Microsoft Azure DP-203 Question # 26 Topic 3 Discussion

DP-203 Exam Topic 3 Question 26 Discussion:
Question #: 26
Topic #: 3

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

DP-203 Question 26

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 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] [int] NULL


B.

[ManagerEmployeeID] [smallint] NULL


C.

[ManagerEmployeeKey] [int] NULL


D.

[ManagerName] [varchar](200) NULL


Get Premium DP-203 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.