SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 101:

  What is the correct sequence for loading data with SAP Data Services? Please choose the correct answer. Response:

  A. Extract Transform Load
  B. Load Transform Extract
  C. Extract Load Transform
  D. Load Extract Transform
  A. Extract Transform Load

• Question 102:

  Prior to modeling in SAP HANA, you want to check whether a table is row-based or column-based. How can you do this in the SAP HANA studio?

  There are 2 correct answers to this question.

  Response:

  A. Select the Open Content option.
  B. Select the Open Definition option.
  C. Select the Open Data Preview option.
  D. View the icon of the table.
  B. Select the Open Definition option.
  D. View the icon of the table.

• Question 103:

  Which of the following authentication methods are supported for Single Sign-On for SAP HANA?

  A. Kerberos
  B. LDAP over SSL
  C. Secure Network Communication (SNC)
  D. SAML CAS (Central Authentication Service)
  A. Kerberos

• Question 104:

  You want to show a male and female option to users. What feature do you use? There are 3 correct answers to this question. Response:

  A. Input parameters
  B. Expressions
  C. Value help
  D. Domain fix values
  E. Variables
  A. Input parameters
  C. Value help
  E. Variables

• Question 105:

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

  A. A table that contains surrogate IDs referring to primary keys in the attribute views
  B. A table that contains foreign keys referring to primary keys in the attribute views
  C. A table that contains business facts or measures
  D. A table that contains only descriptive attributes
  B. A table that contains foreign keys referring to primary keys in the attribute views
  C. A table that contains business facts or measures

• Question 106:

  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 107:

  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 108:

  Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA?

  A. SAP Landscape Transformation (SLT)
  B. SAP Landscape Directory (SLD)
  C. SAP Direct Extractor Connection (DXC)
  D. SAP BusinessObjects Data Services
  C. SAP Direct Extractor Connection (DXC)
  D. SAP BusinessObjects Data Services

• Question 109:

  What are benefits of using a business layer on top of SAP HANA?

  A. An extra layer of granular security
  B. Improved database calculation speed
  C. Fast throughput via BICS connectivity
  D. Users can use business names instead of technical names
  A. An extra layer of granular security
  D. Users can use business names instead of technical names

• Question 110:

  Global session variables can be used in SQLScript to share a scalar value between procedures and functions that are running in the same session.

  The value of a global session variable is not visible from another session.

  Please choose the correct answer.

  Response:

  A. SET = ;
  B. SET = ;
  C. SET = ;
  D. SET = ;
  A. SET = ;