In which package in SAP HANA will you find the SAP HANA Live views?
Please choose the correct answer.
Response:

• A./sap/hana/democontent
• B./public
• C./sap/hba
• D./sap/bc

Comment: *

Name: *

Email: *

Verification: *

You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view. Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?

• A.Database Explorer
• B.Where used
• C.Show lineage
• D.Auto-map byname

Comment: *

Name: *

Email: *

Verification: *

in a calculation view of type cube with star join,you want to join three dimensions to the facts. Two of the dimensions use full outerjo ins and one dimension uses a left outerjo in. You did NOT set cardinality of the data sources.
Why will this NOT work?

• A.Full outer joins are restricted to one dimension in a star join node.
• B.Full outer joins require cardinality to be set.
• C.Full outer joins CANNOT be mixed in the same star join node with other join types.
• D.Full outer joins are NOT available in the star join node.

Comment: *

Name: *

Email: *

Verification: *

In which key areas can we expect there to be improvements when running SAP BW on SAP HANA?
There are 2 correct answers to this question.
Response:

• A.Superior data quality
• B.Reporting performance
• C.Data loading performance
• D.Tighter security

Comment: *

Name: *

Email: *

Verification: *

Which of the following are correct statements relating to the flat file import function of SAP HANA Studio?
There are 3 correct answers to this question.
Response:

• A.The new table always has a 1:1 mapping between the file and table columns
• B.Renaming of columns and changing data types is allowedwhen loading data to new HANA tables
• C.When loading new data in a table that already contains data, the new data is appended to the existing data
• D.The supported file types for upload are .csv, and .txt

Comment: *

Name: *

Email: *

Verification: *