You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.

What could be the problem?Note: There are 2 correct answers to this question.

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.

What options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?