Microsoft Exam DP-203 Topic 2 Question 20 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 20
Topic #: 2

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 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

Show Suggested Answer

Suggested Answer: A

Use the same definition as the EmployeeID column.

by Malinda at May 10, 2022, 02:49 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!