You work in ATR company as Azure Data Engineer.
You have been assigned a task to create and manage the hierarchies in Azure Analysis Services.
Here is the list of some tasks: Change the name of a hierarchy Change the name of a child level Change the order of a child level in a hierarchy Add a child level to the given hierarchy Remove a child level from the given hierarchy Choose the tasks that you can perform while editing the hierarchies.
Click on the arrows to vote for the correct answer
A. B. C. D. E.Correct Answer: E
Hierarchies can be created, edited, or even deleted in Azure Analysis Services.
While editing the hierarchies, Azure Analysis Services allows renaming a hierarchy, changing the order for the child levels, renaming a child level, removing/deleting a child level from a hierarchy, adding extra columns as child levels, displaying the source name of a child level (the column name), and hiding a child level if it has the same name as the hierarchy parent level.
Option A is incorrect.
Not only I, II, and III, but all the given tasks can be performed while editing the hierarchies.
Option B is incorrect.
Not only I, IV, and V, but all the given tasks can be performed while editing the hierarchies.
Option C is incorrect.
Not only II and III, but all of the given tasks can also be performed while editing the hierarchies.
Option D is incorrect.
Not only IV and V, but all the given tasks can also be performed while editing the hierarchies.
Option E is correct.
All of the given tasks can be performed while editing the hierarchies.
To know more about creating and managing hierarchies, please visit the below-given link:
As an Azure Data Engineer, you are responsible for creating and managing hierarchies in Azure Analysis Services. The task at hand requires you to perform certain edits to the hierarchies. The list of tasks given includes changing the name of a hierarchy, changing the name of a child level, changing the order of a child level in a hierarchy, adding a child level to the given hierarchy, and removing a child level from the given hierarchy.
Let's look at each task and determine whether it can be performed while editing the hierarchies:
I. Change the name of a hierarchy: Yes, this task can be performed while editing the hierarchy. You can rename a hierarchy to make it more descriptive or meaningful.
II. Change the name of a child level: Yes, this task can be performed while editing the hierarchy. You can rename a child level to make it more descriptive or meaningful.
III. Change the order of a child level in a hierarchy: Yes, this task can be performed while editing the hierarchy. You can change the order of child levels to modify the hierarchy's structure.
IV. Add a child level to the given hierarchy: Yes, this task can be performed while editing the hierarchy. You can add a new child level to an existing hierarchy to extend its structure.
V. Remove a child level from the given hierarchy: Yes, this task can be performed while editing the hierarchy. You can remove a child level from an existing hierarchy to modify its structure.
Therefore, the answer is E. All of the above tasks can be performed while editing the hierarchies. As an Azure Data Engineer, you have the ability to manage and manipulate hierarchies in Azure Analysis Services to meet the business requirements.