SAP Exam C_HANAIMP_18 Topic 1 Question 34 Discussion

Actual exam question for SAP's C_HANAIMP_18 exam

Question #: 34
Topic #: 1

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.What is the correct approach?

ACombine the transaction tables using a star join node in a calculation view of type cube with star join.Use the same star join node to connect the dimensions to the fact table.

BCombine the transaction tables using a join node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table.

CCombine the transaction tables using an aggregation node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table.

DCombine the transaction tables using a star join node in a calculation view of type cube with star join.Use a join node to join the dimensions to the fact table.

Show Suggested Answer

Suggested Answer: B

by Kristeen at Mar 19, 2024, 01:55 AM

Limited Time Offer

25%

Off

Get Premium C_HANAIMP_18 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tawna

4 months ago

I think option C could also work. Using an aggregation node in a calculation view might provide some performance benefits.

upvoted 0 times

...

Eugene

4 months ago

I tend to agree with Elfrieda. Option A seems to provide a direct approach for connecting dimensions to the fact table.

upvoted 0 times

...

Elfrieda

4 months ago

But wouldn't using a star join node directly to connect the dimensions to the fact table be more efficient as in option A?

upvoted 0 times

...

Mattie

4 months ago

I disagree, I believe option B is the best approach. We should combine the transaction tables using a join node in a calculation view with star join.

upvoted 0 times

...

Elfrieda

4 months ago

I think the correct approach is option A. We should use a star join node in a calculation view of type cube with star join.

upvoted 0 times

...

Almeta

4 months ago

I see your point, but I still think using a join node as in option B is the most efficient way to connect the dimensions to the fact table.

upvoted 0 times

...

Daren

4 months ago

Haha, this question is a real star-studded affair! I'm going with A) - can't go wrong with the classic star join.

upvoted 0 times

Jamika

3 months ago

Combine the transaction tables using an aggregation node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table.

upvoted 0 times

...

Francene

3 months ago

Combine the transaction tables using a join node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table.

upvoted 0 times

...

Hana

4 months ago

Combine the transaction tables using a star join node in a calculation view of type cube with star join.Use the same star join node to connect the dimensions to the fact table.

upvoted 0 times

...

Micheline

4 months ago

I agree with using an aggregation node in a calculation view of type cube with star join sounds like a good approach.

upvoted 0 times

...

Natalie

4 months ago

But wouldn't it be better to use an aggregation node instead, like in option C?

upvoted 0 times

...

Karon

4 months ago

Ah, the good old star schema! D) seems like it could work, but I'm leaning towards A) for the clean star join setup.

upvoted 0 times

Eun

4 months ago

Let's go with A) then, for a clear star join structure.

upvoted 0 times

...

Brock

4 months ago

I agree, D) could work too but A) seems more straightforward.

upvoted 0 times

...

Cherilyn

4 months ago

I think A) is the way to go for a clean star join setup.

upvoted 0 times

...

Barney

5 months ago

C) Aggregation node for the transaction tables? Interesting, but I'm not convinced that's the correct approach.

upvoted 0 times

Elke

3 months ago

B) Combine the transaction tables using a join node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table.

upvoted 0 times

...

Bette

3 months ago

A) Combine the transaction tables using a star join node in a calculation view of type cube with star join.Use the same star join node to connect the dimensions to the fact table.

upvoted 0 times

...

Steffanie

3 months ago

B) I think using a join node in a calculation view of type cube with star join might be a better approach.

upvoted 0 times

...

Micheline

4 months ago

A) Combine the transaction tables using a star join node in a calculation view of type cube with star join.Use the same star join node to connect the dimensions to the fact table.

upvoted 0 times

...

Danica

4 months ago

B) Combine the transaction tables using a join node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table.

upvoted 0 times

...

Virgilio

4 months ago

A) Combine the transaction tables using a star join node in a calculation view of type cube with star join.Use the same star join node to connect the dimensions to the fact table.

upvoted 0 times

...

Almeta

5 months ago

I believe option B is the right choice, combining the transaction tables using a join node in a calculation view of type cube with star join.

upvoted 0 times

...

Tequila

5 months ago

B) Hmm, I'm not sure a regular join node would be the best option here. Shouldn't we be using a star join for the dimensions as well?

upvoted 0 times

...

Billye

5 months ago

A) Looks like the right approach to me. Star join is the way to go for a star schema.

upvoted 0 times

Penney

4 months ago

D) Combining the transaction tables using a star join node in a calculation view of type cube with star join seems like a good approach.

upvoted 0 times

...

Alex

4 months ago

B) You're right, a star join node is more suitable for this scenario.

upvoted 0 times

...

Kanisha

4 months ago

A) Aggregation node might not be the best choice for creating a star schema.

upvoted 0 times

...

Devora

4 months ago

C) I would go with combining the transaction tables using an aggregation node in a calculation view of type cube with star join.

upvoted 0 times

...

Alyssa

5 months ago

A) I agree, using a star join node for a star schema is the best practice.

upvoted 0 times

...

Amie

5 months ago

B) I think using a join node in a calculation view of type cube with star join is the correct approach.

upvoted 0 times

...

Cheryl

5 months ago

A) Combine the transaction tables using a star join node in a calculation view of type cube with star join.Use the same star join node to connect the dimensions to the fact table.

upvoted 0 times

...

Natalie

6 months ago

I think the correct approach is to use a star join node in a calculation view of type cube with star join to combine the transaction tables.

upvoted 0 times

...