Which sentence best describes SAP HANA Live?
Please choose the correct answer.
Response:

• A.Analytical reporting moving back to the OLTP system
• B.Operational reporting moving back to the OLAP system
• C.Operational reporting moving back to the OLTP system
• D.Analytical reporting moving back to the OLAP system

Comment: *

Name: *

Email: *

Verification: *

Referring to the diagram which privileges would a user require to view United States data when querying the CUBE Calculation view?
Please choose the correct answer.

Response:

• A.A SELECT privilege on the CUBE and an analytic privilege (Country = United States) on the DIMENSION calculation view
• B.ASELECT privilege and an analytic privilege (Country = United States) on the DIMENSION calculation view
• C.Analytic Privilege and SELECT privilege on the CUBE calculation view
• D.SELECT privileges and Analytic Privileges on both views

Comment: *

Name: *

Email: *

Verification: *

What variable type do you use if you want to allow the user to choose the years from 2011 to 2014?
Please choose the correct answer.
Response:

• A.Single value
• B.Interval
• C.Multiple entries
• D.Range

Comment: *

Name: *

Email: *

Verification: *

What performance techniques should you implement to improve the performance of SAP HANA information views?
There are 3 correct answers to this question.
Response:

• A.Investigate partitioning of large tables.
• B.Minimize the transfer of data between the execution engines.
• C.Push down aggregations to SAP HANA.
• D.Apply filters as late as possible.
• E.Perform calculation before aggregation in your analytic views.

Comment: *

Name: *

Email: *

Verification: *

You create a full-text index. For what text feature clause do you need to specify a configuration?
Response:

• A.SEARCH ONLY
• B.FUZZY SEARCH INDEX
• C.TEXT ANALYSIS
• D.TEXT MINING

Comment: *

Name: *

Email: *

Verification: *