C_HANAIMP_1 Online Practice Questions and Answers

Which of the following are benefits of implementing SAP HANA? (Choose three)

A. SAP HANA provides real-time analytics.

B. SAP HANA performs much faster than the standard SAP ERP.

C. SAP HANA provides pre-configured BI Content.

D. SAP HANA combines OLTP and OLAP in one system.

E. SAP HANA replaces SAP BW.

Which of the following are direct outputs of an analytic view? (Choose three)

A. Hierarchies

B. Private attributes

C. Restricted attributes

D. Measures

E. Attribute views

What is one of the advantages of using SAP BusinessObjects Analysis, edition for Microsoft Office?

A. Direct access to attribute views in SAP HANA

B. Direct access to column tables in SAP HANA

C. Direct connection to SAP HANA via MDX

D. Direct connection to SAP HANA via BICS

How can you evaluate the speed of a calculation within the database? (Choose two)

A. Use the Data Preview function in the SAP HANA studio.

B. Execute a Web Intelligence report and check the duration of the previous refresh.

C. Execute an information space using SAP BusinessObjects Explorer.

D. Write and execute an appropriate SQL statement.

Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)? (Choose two)

A. Ensure that replicated changes are kept within the logging tables.

B. Record relevant changes in logging tables.

C. Include only relevant tables for DB recording.

D. Decluster table classes into a transparent format.

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

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.

When must you create a calculation view in SAP HANA?

A. When you need to create a star schema

B. When key figures span across tables

C. When you need calculations before aggregations

D. When you need analytic operations like aggregation

Which of the following tasks must you perform before you build a business layer within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA? (Choose three)

A. Publish the connection to CMS.

B. Build a query to test the connection.

C. Build a relational connection to SAP HANA.

D. Build an OLAP connection to SAP HANA.

E. Build a data foundation.

What is the behavior of a Text Table Join where language column SPRAS is available?

A. Left Outer Join

B. Right Outer Join

C. Inner Join

D. Referential Join

You want to retrieve data from SAP HANA and restrict access to certain data columns for specific user groups. Where can you implement this?

A. In the analytic privileges

B. In the data foundation

C. In the business layer

D. In the SQL privileges

Which view in SAP HANA studio do you use to add additional users?

A. Properties View

B. Quick launch View

C. Console View

D. Navigator View

You want to broadcast reports that use data from SAP HANA.Which SAP BusinessObjects tool do you use?

A. Analysis, edition for OLAP

B. Dashboards

C. Crystal Reports

D. Explorer

Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?

A. Crystal Reports

B. Dashboards

C. Explorer

D. WebIntelligence

Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?

A. Analytic view

B. Calculation view using SQL

C. Calculation view using SQL Script

D. Attribute view