New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

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.