SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 41:

  What is the purpose of a template table in SAP BusinessObjects Data Services?

  A. To create pre-designed information models
  B. To fill an existing target table with new data
  C. To read source data and perform data transformations
  D. To create a target table and fill this table with data
  D. To create a target table and fill this table with data

• Question 42:

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

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

• Question 43:

  What do you call the data displayed in the data foundation of an SAP HANA information view? Please choose the correct answer. Response:

  A. Facets
  B. Key figures
  C. Characteristics
  D. Measures
  D. Measures

• Question 44:

  When working with your data models, which of the following do you use to get detailed information about tables, number of rows, and partitioning?

  A. Performance analysis mode
  B. Catalog node of your system
  C. Visualize plan
  D. Explain plan
  A. Performance analysis mode
  B. Catalog node of your system

• Question 45:

  Which of the following terms are associated with an operational system? There are 2 correct answers to this question. Response:

  A. OLTP
  B. OLAP
  C. Transactional
  D. Data warehouse
  A. OLTP
  C. Transactional

• Question 46:

  You rename a field in the semantics node to add clarity for end users. What does SAP HANA use to keep track of what the original field name is? Please choose the correct answer. Response:

  A. The label column property
  B. The label property
  C. The mapping property
  D. The name property
  C. The mapping property

• Question 47:

  You want to call a procedure in a SELECT statement (like a table function). Which clauses do you have to specify?

  There are 2 correct answers to this question.

  Response:

  A. READS SQL DATA
  B. LANGUAGE SQLSCRIPT
  C. SEQUENTIAL EXECUTION
  D. WITH RESULTS VIEW
  A. READS SQL DATA
  D. WITH RESULTS VIEW

• Question 48:

  You have to build a parent-child hierarchy. What type of join do you expect to use? Please choose the correct answer. Response:

  A. Temporal join
  B. Dynamic join
  C. Relational join
  D. Self-join
  D. Self-join

• Question 49:

  In which package in SAP HANA will you find the SAP HANA Live views? Please choose the correct answer. Response:

  A. /public
  B. /sap/hana/democontent
  C. /sap/be
  D. /sap/hba
  D. /sap/hba

• Question 50:

  You are writing a mobile application for the World Series. You have details about all the baseball players and the baseball scores for all the previous matches.

  How do you use the data of the player information and the scores? Please choose the correct answer.

  Response:

  A. Both the player information and the scores are used as transactional data.
  B. The player information is used as master data, and the scores are used as transactional data.
  C. Both the player information and the scores are used as master data.
  D. The player information is used as transactional data, and the scores are used as master data.
  B. The player information is used as master data, and the scores are used as transactional data.