DP-203 · Question #9
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:
The correct answer is C. [ManagerEmployeeKey] [int] NULL. We need an extra column to identify the Manager. Use the data type as the EmployeeKey column, an int column. https://docs.microsoft.com/en-us/analysis-services/tabular-models/hierarchies-ssas-tabular
Question
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?
Exhibit
Options
- A[ManagerEmployeeID] [int] NULL
- B[ManagerEmployeeID] [smallint] NULL
- C[ManagerEmployeeKey] [int] NULL
- D[ManagerName] varchar NULL
How the community answered
(28 responses)- A18% (5)
- B7% (2)
- C71% (20)
- D4% (1)
Explanation
We need an extra column to identify the Manager. Use the data type as the EmployeeKey column, an int column. https://docs.microsoft.com/en-us/analysis-services/tabular-models/hierarchies-ssas-tabular
Topics
Community Discussion
No community discussion yet for this question.