SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 1:

  For which data types does SAP HANA automatically create full-text indexes? There are 3 correct answers to this question. Response:

  A. NVARCHAR
  B. CLOB
  C. BINTEXT
  D. TEXT
  E. SHORTTEXT
  C. BINTEXT
  D. TEXT
  E. SHORTTEXT

• Question 2:

  A new user has implemented an SAP HANA data model.

  Which technical user requires select rights on the new user's schema?

  A. _SYS_REPO
  B. _SYS_BIC
  C. _SYS_BI
  D. _SYS_SECURITY
  A. _SYS_REPO

• Question 3:

  Which of the following can be part of an analytic view? (Choose three)

  A. Query transformation
  B. Unions
  C. Logical joins
  D. Data foundation
  E. Attributes
  C. Logical joins
  D. Data foundation
  E. Attributes

• Question 4:

  What information can you find in the Visualize Plan tool? There are 2 correct answers to this question. Response:

  A. The SQL Plan Cache
  B. The execution engines used
  C. The number of records returned in each step
  D. The time taken for each step
  C. The number of records returned in each step
  D. The time taken for each step

• Question 5:

  Which connection type is required from the SAP ERP system to SAP HANA to enable CO- PA side by side scenario?

  A. HTTP connection
  B. JDBC
  C. Secondary database connection
  D. Remote Function Call
  C. Secondary database connection

• Question 6:

  Which of the following are benefits of implementing SAP HANA?

  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.
  A. SAP HANA provides real-time analytics.
  B. SAP HANA performs much faster than the standard SAP ERP.
  D. SAP HANA combines OLTP and OLAP in one system.

• Question 7:

  You want to build a hierarchy on a time-based data structure. What type of hierarchy do you use? Please choose the correct answer. Response:

  A. Parent-child hierarchy
  B. Ragged hierarchy
  C. Level hierarchy
  D. Unbalanced hierarchy
  A. Parent-child hierarchy

• Question 8:

  What join type should you use to see all the suppliers? Please choose the correct answer. Response:

  A. Referential join
  B. Right outer join
  C. Inner join
  D. Left outer join
  B. Right outer join

• Question 9:

  Which programming language do you use for SAP Landscape Transformation based transformation rules?

  A. SQLScript
  B. Java
  C. ABAP
  D. JavaScript
  C. ABAP

• Question 10:

  You created a user-defined function with the INVOKER security option. Which user's authorizations are checked when the function is executed? Please choose the correct answer. Response:

  A. The user calling the function
  B. The SYS REPO user
  C. The owner of the function
  D. The SYSTEM user
  A. The user calling the function