What can you do with shared hierarchies? Note: There are 2 correct answers to this question.
Suggested Answer: A, D
Get Premium C_HAMOD_2404 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
22 comments · newest first
SA
Salley
10 months ago
I thought D was a thing too, but I guess not!
VA
Van
10 months ago
Wait, can you really access external schemas like that? Sounds off.
TE
Teddy
11 months ago
Totally agree with A and B!
MA
Maryln
11 months ago
I think C is also a valid option, though.
DO
Domingo
12 months ago
A and B are definitely the right answers!
JE
Jerilyn
12 months ago
I feel like enabling SQL SELECT statements to access hierarchies is a common feature, so option D seems likely, but I can't recall if it’s specifically related to shared hierarchies.
MO
Mollie
1 year ago
I’m a bit confused about the difference between star join and no star join in this context. I might lean towards option A and D, but I’m not entirely sure.
JU
Juan
1 year ago
I remember practicing a question about accessing hierarchies in external schemas, so I feel like option B could be one of the correct answers.
MA
Maryann
1 year ago
I think shared hierarchies can definitely provide reusable hierarchies for drilldown in a CUBE, but I'm not sure about the star join part.
AN
Antione
1 year ago
I'm a bit confused on the difference between a CUBE with and without a star join. I'll need to make sure I understand that before I can confidently answer this question.
CL
Clarinda
1 year ago
Okay, I've got this. Shared hierarchies can be used to provide reusable hierarchies for drilldown in a CUBE with a star join, and they can also be used to access hierarchies created in external schemas.
GI
Gilberto
1 year ago
Hmm, this one seems tricky. I'll need to carefully read through the options and think about how shared hierarchies could be used for drilldown and accessing data from external sources.
CL
Clarence
1 year ago
I think the key here is understanding what shared hierarchies are and how they can be used in a CUBE. I'll need to review my notes on CUBE structures and hierarchy management.
SH
Shawna
1 year ago
Hmm, I think C is also a valid answer. Shared hierarchies can be used for drilldown even without a star join, right? Although I'm not sure if that's as common as the other use cases.
EU
Eura
10 months ago
D is also important for accessing hierarchies.
SU
Sue
11 months ago
C is less common, but still possible.
DO
Dortha
11 months ago
I agree, C seems valid for drilldown.
CA
Catalina
11 months ago
But A and B are definitely the main uses.
GE
Geraldo
1 year ago
A and B seem like the correct answers here. Shared hierarchies are definitely useful for reusable drilldown in cubes, and accessing external schemas is a great feature.
LO
Louis
1 year ago
Yes, shared hierarchies are great for drilldown in cubes.
SH
Sherell
1 year ago
I think A and B are the correct answers.
AV
Avery
1 year ago
I think A and C are the correct answers.