You merge data from Sales_Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?
A.
Create a DAX calculated column that retrieves the region manager from the Weekly_Returns table based on the sales_region_id column.
B.
Apply row-level security (RLS) to the Region table based on the sales manager username.
C.
Configure a bi-directional relationship between Region and Sales_Region.
D.
In the Region table, create a hierarchy that has the manager name, and then the sales manager name.
We should assume we've linked "Weekly_returns" and "sales" table with the new table resulting from the merge and first visual (sales by region) it's a simple one from all this data.
I guess the tricky part in this question is about second requirement showing returns by "Region_manager" and "Sales managers" reporting to them as now this information is not split in two dimension tables but in the same table so we should build the suggested hierarchy from option D
The question is...
What should you do next to meet the reporting requirements of the executives?
There seem to be two requirements?
1) Executives require a visual that shows sales by region.
2) Executives require a visual that shows returns by region manager and the sales managers that report to them.
They don't say to look at requirement 1???
D seems to be correct because the Executives will only be able to see Region managers and Sales managers that report to them in a hierarchy, besides there is nothing to measure there so A is actually wrong
The given answer is not correct but the explanation is correct.
The answer should be D
upvoted 2 times
...
...
This section is not available anymore. Please use the main Exam Page.PL-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ThariCD
Highly Voted 2 years, 7 months agoManikom
Highly Voted 2 years, 7 months agojaume
Most Recent 5 months, 1 week ago1CY1
7 months, 1 week agoSophieeeeee
9 months, 3 weeks agosummmmercxxxx
1 year, 10 months agoEbenanatalo
2 years, 3 months agosvg10gh
2 years, 3 months agolukelin08
2 years, 5 months agoTin123
2 years, 6 months agoiccent2
2 years, 4 months ago