SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 41:

  You need to create an SAP HANA data model based on a star schema. Which SAP HANA engine is recommended for analytical purposes?

  A. Calculation engine
  B. OLAP engine
  C. Row store engine
  D. Join engine
  B. OLAP engine

• Question 42:

  Where can you create a restricted column in a graphical calculation view?

  A. Aggregation node
  B. Join node
  C. Union node
  D. Projection node
  A. Aggregation node

• Question 43:

  Which of the following sequences of steps is required before you can create a report on an analytic view using replicated SAP ERP data?

  A. Set up replication from ERP Create an analytic view Create analytic privileges Create a business layer
  B. Create a business layer Set up replication from ERP Create an analytic view Create analytic privileges
  C. Create an analytic view Create analytic privileges Set up replication from ERP Create a business layer
  D. Create an analytic view Set up replication from ERP Create analytic privileges Create a business layer
  A. Set up replication from ERP Create an analytic view Create analytic privileges Create a business layer

• Question 44:

  Which of the following can be grouped when multiple schemas exist in an SAP HANA database?

  A. Information models
  B. Data tables
  C. Packages
  D. Users
  B. Data tables

• Question 45:

  You have created an MS Excel report on SAP HANA data.

  On which of the following could you store the Excel file and make it available for other users?

  A. Shared network drive
  B. SAP BusinessObjects Information Design Tool
  C. SAP HANA database
  D. SAP HANA studio Content node
  A. Shared network drive

• Question 46:

  What do you have to define in an attribute view to reduce the initial amount of data selected from the data foundation tables?

  A. A static filter value on any column in the data foundation tables
  B. A column marked as "Hidden" in the output structure
  C. A restricted column in the output structure
  D. A dynamic filter value on a measure in the attribute view
  A. A static filter value on any column in the data foundation tables

• Question 47:

  You want to add a column to a calculation view that displays the year-to-date revenue of the current fiscal year. How can you achieve this? (Choose two)

  A. Use a calculated attribute.
  B. Use a calculated measure.
  C. Use a variable.
  D. Use a CE function.
  B. Use a calculated measure.
  D. Use a CE function.

• Question 48:

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

  A. Copy the attribute view.
  B. Create a derived analytic view.
  C. Create a derived attribute view.
  D. Rename the attribute view.
  A. Copy the attribute view.
  C. Create a derived attribute view.

• Question 49:

  Which types of calendar are available for time attribute views in SAP HANA? (Choose two)

  A. Fiscal
  B. Factory
  C. Gregorian
  D. Julian
  A. Fiscal
  C. Gregorian

• Question 50:

  Which of the following privileges do you need to activate views?

  A. SELECT option on the _SYS_BIC schema
  B. SELECT option on the _SYS schema
  C. SELECT option on the _SYS_BI schema
  D. SELECT option on the _SYS_REPO schema
  D. SELECT option on the _SYS_REPO schema