C_HANAIMP142 Exam Questions

Which of the following are mandatory to create a decision table? (Choose two)

Which best practices should you apply when you use SQL script in SAP HANA? (Choose three)

Which of the following can be grouped inside a single schema in an SAP HANA database?

Which of the following nodes do you use to implement filters in a graphical calculation view? (Choose two)

You want to aggregate the grand total sales amount into 1 currency. In which of the following cases would you select the Calculate Before Aggregation check-box? (Choose two)

You plan to migrate your existing SAP NetWeaver landscape with a non-SAP HANA database. Which of the following are key considerations for the migration of your database to SAP HANA...

Your data models use hierarchies. In which of the following front end tools can you access these hierarchies? (Choose three)

You have created an analytic view and an analytic privilege that filters on 3 attributes: - Sales region = "West" - Sales channel = "Online", "Retail" - Product category = "Electro...

Which of the following are benefits of using accelerators with SAP HANA? (Choose two)

Which of the following selection types are available when creating a variable in an analytic view? (Choose three)

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

You want to investigate the runtime of a SELECT statement against an analytic view. Which of the following tools do you use to analyze the model performance, including transferred...

You implemented SAP-delivered business content on SAP HANA. When you try to activate the business content the activation fails. What could be a reason for this?

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)

How can you analyze a performance issue in the execution of an SQL statement using the SQL Console? (Choose two)

Your SAP BusinessObjects report runs slowly. Which of the following actions could improve the performance? (Choose two)

Which SAP BusinessObjects reporting tool can you use to create a report as shown in the attached screenshot?

You have created several information models. A colleague of yours needs to be able to work on your information models. Which privileges do you give your colleague?

How can you define conditions and actions in a decision table? (Choose three)

You have created an input parameter in an information model. In which of the following can you use the input parameter?

What does SAP recommend to improve performance of data models in SAP HANA?

Which of the following are included in a rapid-deployment solution (RDS) implemented on SAP HANA? (Choose three)

Which statement best describes an analytic view as a multidimensional view?

What is the function of an aggregation node in a calculation view?

What is the minimum requirement for a valid analytic view?

In a left outer join, the left table has one record and the right table has three records. What is the maximum number of records that you expect in the join result?

Table SALES_TABLE contains the columns COUNTRY and SALES. Function calc_tax calculates sales tax based on input parameter SALES. Using a scripted calculation view, how can you call...

Which of the following are recommended SAP HANA modeling principles? (Choose two)

Which of the following should you try to implement as best practices for data modeling? (Choose two)

How many result tables can a calculation view generate per session?

What can be used as a source for the data foundation of an analytic view? (Choose two)

Which CE function do you use to implement the following SQL statement? SELECT DATE, SHOP_ID, PRODUCT_ID, QUANTITY * COST AS "PRICE" FROM SALES_DATA;

Which of the following can you check to investigate the query time in SAP HANA? (Choose three)

You want to improve query performance by introducing filters into the SAP HANA information model. Which of the following can you use to reduce data transfer between views? (Choose...

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

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

What is the purpose of the savepoint process in SAP HANA?

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database?

Which application enables you to create a multisource universe in SAP BusinessObjects BI 4.0?

Which of the following are restrictions of the SAP HANA flat file upload? (Choose two)

What outputs can you create in an attribute view? (Choose two)

Which of the following actions can you do with a derived attribute view? (Choose two)

How can you add an existing attribute view to the logical view of your analytic view twice? (Choose two)

You work with an information model on SAP HANA that contains sales data for all regions. Which of the following modeling techniques can you use to define re-usable columns per regi...

You created a model on a table XYZ.PRODUCTS. You successfully activated the model. When you run the data preview you receive an error message "Insufficient privilege. Not authorize...

You are using SAP BusinessObjects Data Services as your ETL tool. What is the next step required after you have created the DataStore and imported the metadata from an SAP ERP syst...

On which of the following servers can you configure SAP HANA Direct Extractor Connection (DXC) data sources? (Choose two)

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

What does the following SQL statement do? SELECT SCORE() as SCORE, PRODUCT_NAME, * FROM PRODUCT_ITEMS WHERE CONTAINS(*,'Paper', FUZZY(0.8)) ORDER BY PRODUCT_NAME

You want to allow another developer to access the information models in one of your packages. What privilege do you have to assign to this user to allow access?