Conflicting Answers to Basic Hana Questions

[Former Member]

Hello All,

I have read conflicting answers to below questions . I would appreciate some experts advice or answers

Q1)What privileges do i need in order to do modelling for SQL Privileges on _SYS_BIC While importing (4 Answers

Options

1)update 2)insert 3)delete 4)select 5)create any

Answers conflict  one answer says   1)update 2)insert 3)delete 4)select   and other says 1)update 2)insert 3)delete 4)create any

Q2)You have created a balances report with data from SAP HANA and want to check that the values on the report are correct. With which of the following would you compare the balances on the report?

1) With the balances stored in the SAP BusinessObjects universe

2)With the calculated measures stored in SAP HANA

3)With the aggregate values stored in SAP HANA

4)With the sums of the individual values stored in SAP HANA or in in the source System

Conflict Answers  : Correct Answer  4 or  3

Q3)Which Connection technologhy nativly supports Hierarchies in SAP HANA?

Options 1)MDX  2)SQL 3)BICS 4)JDBC

Answer is BICS , but i was reading something which says

Hierarchies in HANA could only be used by reporting tools using MDX connectivity

Please clarify as which answers are in deed correct

Thanks in advacne

[Former Member]

Not sure about security privileges.

MDX natively supports hierarchies.

Regarding checking report figures - aggregates shouldn't be stored in HANA, no data is stored in universes (they only generate SQL) and calculated measures aren't 'stored' in HANA, so to me answer 4 makes the most sense. But it's not the clearest questions/answers...

[Former Member]

Any Advice