Sample Questions

Q) You want to test the quality of SAP HANA data by using a set of results from the source system. How can you retrieve the required data from SAP HANA? (Choose three)

a) Use SAP Landscape Transformation (SLT).

b) Use the data preview in SAP HANA studio

c) Use an SAP BusinessObjects client tool (such as Explorer or Web Intelligence).

d) Use the database schema _SYS_REPO.

e) Write and execute an appropriate SQL statement.

Q) What are benefits of using a business layer on top of SAP HANA? (Choose two)

a) An extra layer of granular security

b) Improved database calculation speed

c) Fast throughput via BICS connectivity

d) Users can use business names instead of technical names

Q) You want to report on data from SAP HANA using MS Excel. How can you achieve this? (Choose two)

a) Select an analytic view using the Data Connection wizard.

b) Create a ODBC connection between SAP HANA and MS Excel.

c) Select an attribute view using the Data Connection wizard.

d) Create an ODBO connection between SAP HANA and MS Excel.

Q) You are building a calculation view and want to select data from an analytic view. How can you achieve better performance for this requirement?

a) Use CE functions

b) Use SQL statements

c) Use L programming

d) Use table indexing

Q) Which connectivity options can you use to create a SAP BusinessObjects universe on SAP HANA? (Choose two)

a) OLAP connection using MDX

b) Relational connection using BICS

c) Relational connection using ODBC

d) Relational connection using MDX

e) Relational connection using JDBC