SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 51:

  What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement? Please choose the correct answer. Response:

  A. LIKE
  B. IN
  C. ANY
  D. CONTAINS
  D. CONTAINS

• Question 52:

  In what type of view can you use fuzzy text search directly? Please choose the correct answer. Response:

  A. Analytic views
  B. Attribute views
  C. Calculation views of type cube
  D. Calculation views of type dimension
  B. Attribute views

• Question 53:

  Your customer has the following reporting requirements:

  Real-time profitability reporting on large-scale data volumes On-the-fly analysis of profitability data at any level of granularity, aggregation, and dimension

  Cost allocation reports with significantly faster processing time

  Which application do you recommend?

  A. SAP Bank Analyzer with SAP HANA
  B. SAP Deposits Management with SAP HANA
  C. SAP HANA CO-PA Accelerator
  D. SAP HANA for Banking
  C. SAP HANA CO-PA Accelerator

• Question 54:

  Which of the following database terms are used when providing OLAP data with hierarchies? There are 3 correct answers to this question. Response:

  A. BICS
  B. ODBC
  C. MDX
  D. JDBC
  E. ODBO
  A. BICS
  C. MDX
  E. ODBO

• Question 55:

  What do you use a Transient Provider for? Please choose the correct answer. Response:

  A. To expose an SAP BW information object inside SAP HANA
  B. To use an SAP HANA calculation view in the SAP BW application
  C. To use an SAP HANA calculation view in Microsoft Excel
  D. To expose an SAP HANA calculation view as an 0Data web service
  A. To expose an SAP BW information object inside SAP HANA

• Question 56:

  You want to rename an information view with the SAP HANA Modeler without losing its existing behavior. What are the next steps after the renaming utility has finished? There are 2 correct answers to this question. Response:

  A. Adjust references to the information view in graphical calculation views.
  B. Adjust references to the information view in analytic views.
  C. Adjust references to the information view in procedures.
  D. Adjust references to the information view in table functions.
  C. Adjust references to the information view in procedures.
  D. Adjust references to the information view in table functions.

• Question 57:

  You are loading data into SAP HANA using DXC. Which of the following are executed in the embedded SAP BW system?

  There are 3 correct answers to this question.

  Response:

  A. IMDSO
  B. Extractor
  C. Info Package
  D. Activation
  E. Transformation
  C. Info Package
  D. Activation
  E. Transformation

• Question 58:

  You want to use a web-based transport system on your Apple iPad. What tool do you use? Please choose the correct answer. Response:

  A. Developer mode
  B. SAP HANA Application Lifecycle Manager
  C. SAP Solution Manager
  D. CTS
  B. SAP HANA Application Lifecycle Manager

• Question 59:

  In which deployment scenarios does security stay in the application server, and end users do not log into the SAP HANA system?

  There are 2 correct answers to this question.

  Response:

  A. SAP HANA as a database
  B. SAP HANA as a sidecar solution
  C. SAP HANA as a platform with an SAP HANA XS application
  D. SAP HANA as an accelerator
  A. SAP HANA as a database
  D. SAP HANA as an accelerator

• Question 60:

  You want to pause the SLT replication in SAP HANA studio. What do you select to achieve this? Please choose the correct answer. Response:

  A. Quick View Data Provisioning Stop
  B. Quick View Configure Import Server
  C. Quick View Data Provisioning Suspend
  D. Quick View Import Selected Import of Metadata
  C. Quick View Data Provisioning Suspend