C_HANAIMP_1 Online Practice Questions and Answers

You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?

A. In the universe

B. In the Web Intelligence report

C. In the analytic view

D. In the calculation view using an attribute value variable

You want to use an extractor to build a model in SAP HANA. Which table can you use to view detailed information about the extractor?

A. BSEG

B. RODELTAM

C. ROOSOURCE

D. RSOLTPSOURCE

You model hierarchies in attribute views. Which of the following technologies do you use to make these hierarchies available for reporting tools?

A. JDBC

B. BICS

C. ODBO

D. ODBC

Which of the following properties of a derived attribute view can you modify?

A. Description

B. Description mapping

C. Calculated attributes

D. Filters

You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view? (Choose three)

A. Join types

B. Attribute views

C. User privileges

D. Tables

E. Analytic views

Where does SAP recommend you create calculated measures?

A. In a column view

B. In a business layer

C. In an attribute view

D. In an analytic view

You have to design a report that shows actual, planned, and variance values. How do you implement this requirement if you want to achieve the best performance?

A. Use a calculation view based upon two analytic views using a union.

B. Use a calculation view based upon two analytic views using a join.

C. Use a single source data foundation in the Universe Design Tool and include the two analytic views.

D. Use a multisource-enabled data foundation in the Universe Design Tool for each analytic view.

Your customer wants to implement a SAP product that:

Provides near real-time replication to SAP HANA Connects SAP HANA to a non-SAP source system and SAP BW Uses SAP extractors

What do you recommend?

A. SAP Legacy System Migration Workbench (LSMW)

B. SAP Landscape Transformation (SLT)

C. Sybase Replication Server

D. SAP BusinessObjects Data Services 4.0

What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?

A. SAP Landscape Transformation (SLT)

B. SAP BW extractors

C. SAP BusinessObjects Data Services

D. SAP Legacy System Migration Workbench (LSMW)

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