C_HANAIMP_1 Online Practice Questions and Answers

You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task? (Choose three)

A. Define a projection.

B. Write an SQL script.

C. Save and activate the view.

D. Define output fields.

E. Choose a data source.

You modify an existing view. How can you determine which models are affected by this change?

A. Use the audit trail.

B. Use the History feature for the changed model.

C. Use the "Where-Used List" feature for the changed model.

D. Use the "Auto Documentation" to compare the object version of the changed model.

When building a business layer to report on SAP HANA, what do you have to do if you want to display more than 5,000 rows?

A. Remove all filters from the analytic views.

B. Deactivate the Limit Size of Result Set parameter in the Central Management Console.

C. Set the Array Fetch Size parameter to the maximum in the relational connection.

D. Deactivate the Limit Size of Result Set parameter in the business layer.

In SAP ERP there are more than 50,000 application tables. How do you determine the relevant SAP ERP tables to replicate in SAP HANA and their dependencies?

A. Use SAP ERP Data Modeler (transaction SD11).

B. Use SAP ERP ABAP Dictionary Maintenance (transaction SE11).

C. Use the SAP ERP Tables and Indexes Monitor(transaction DB02).

D. Use SAP ERP Data Browser (transaction SE16).

Which reporting tool can you use to display native parent-child hierarchies from SAP HANA?

A. Microsoft Excel

B. SAP BusinessObjects WebIntelligence

C. SAP BusinessObjects Analysis, edition for OLAP

D. SAP BusinessObjects Analysis, edition for Microsoft Office

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

Which tool do you use for complex data transformation of SAP ERP data?

A. SAP Landscape Transformation (SLT)

B. Sybase Replication Server

C. SAP BusinessObjects Data Services

D. SAP BusinessObjects Explorer

If you want to create or drop tables in a schema, which privilege type do you need?

A. SYSTEM

B. ANALYTIC

C. PACKAGE

D. SQL

You have imported models from the development system. What is the recommended way to activate dependent models in SAP HANA?

A. Use the Activate with History function.

B. Use the Where-Used List function.

C. Use the Cascade Activate function.

D. Activate each view manually.

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