SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 91:

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

  A. Select an analytic view using the Data Connection wizard.
  B. Create a ODBC connection between SAP HANA and MS Excel.
  C. Select an attribute view using the Data Connection wizard.
  D. Create an ODBO connection between SAP HANA and MS Excel.
  A. Select an analytic view using the Data Connection wizard.
  D. Create an ODBO connection between SAP HANA and MS Excel.

• Question 92:

  What tool generates files to help configure SL T table replication? Please choose the correct answer. Response:

  A. Authorization Assistant
  B. SAP HANA Live Extension Assistant
  C. SAP HANA Live Browser
  D. SAP HANA studio
  C. SAP HANA Live Browser

• Question 93:

  Which of the following can you use to implement currency conversion in an information model? (Choose two)

  A. A calculated column in a calculation view
  B. A calculated column in an attribute view
  C. A calculated column in an analytic view
  D. A restricted column in an analytic view
  A. A calculated column in a calculation view
  C. A calculated column in an analytic view

• Question 94:

  Schema mapping is used during which process?

  Please choose the correct answer.

  Response:

  A. Validation
  B. Activation
  C. Importing
  D. Exporting
  C. Importing

• Question 95:

  Look at Figure You are selling books that have been translated into various languages. What join type should you use?

  

  Please choose the correct answer. Response:

  A. Referential join
  B. Text join
  C. Left outer join
  D. Temporal join
  B. Text join

• Question 96:

  What node uses a special configuration table to optimize performance? Please choose the correct answer. Response:

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

• Question 97:

  You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data?

  A. Remove ALTER SYSTEM in the system privileges for the modeling users.
  B. Use randomized data for the development of data models.
  C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.
  D. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.
  B. Use randomized data for the development of data models.
  C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.

• Question 98:

  What should you keep in mind about user-defined functions? Please choose the correct answer. Response:

  A. They can call procedures.
  B. They can commit transactions.
  C. They can use dynamic SQL.
  D. They can use imperative logic.
  D. They can use imperative logic.

• Question 99:

  During loading of data into SAP HANA you want to filter the source data. Where can you apply the filters?

  A. In a query transformation in SAP BusinessObjects Data Services
  B. In a row generation transformation in SAP BusinessObjects Data Services
  C. In a SQL WHERE clause in SAP Landscape Transformation (SLT)
  D. In an ABAP code rule in SAP Landscape Transformation (SLT)
  A. In a query transformation in SAP BusinessObjects Data Services
  D. In an ABAP code rule in SAP Landscape Transformation (SLT)

• Question 100:

  Prior to modeling in SAP HANA, you want to validate referential integrity between two very large tables in the SAP HANA database. Which SAP HANA tool would you use?

  A. Data preview
  B. View contents
  C. View log
  D. SQL console
  D. SQL console