SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 21:

  If you want to create or drop tables in a schema, which privilege type do you need?

  A. SYSTEM
  B. ANALYTIC
  C. PACKAGE
  D. SQL
  D. SQL

• Question 22:

  You modified an active analytic view in the SAP HANA studio and saved it without activating it. What is the consequence?

  A. The inactive view is available for reporting.
  B. The active view is in "read-only" mode.
  C. The inactive view is in "read-only" mode.
  D. The active view is not available for reporting.
  B. The active view is in "read-only" mode.

• Question 23:

  How can you import information models into SAP HANA using the Quick Launch view?

  A. Choose the Redeploy button.
  B. Choose Import -> SAP HANA Content -> Delivery Unit.
  C. Choose Data Provisioning -> Load.
  D. Choose Import -> SAP HANA Content -> Import Data From Local File.
  B. Choose Import -> SAP HANA Content -> Delivery Unit.

• Question 24:

  Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three)

  A. The sizing of your current SAP BW application servers remains valid.
  B. It allows co-deployment of the SAP BW application server on the SAP HANA database hardware.
  C. It allows re-use of your available SAP BW application servers.
  D. It eliminates the need to upgrade to the latest SAP BW application version.
  E. The system usage is the same as an equivalent SAP BW on non-SAP databases.
  A. The sizing of your current SAP BW application servers remains valid.
  C. It allows re-use of your available SAP BW application servers.
  E. The system usage is the same as an equivalent SAP BW on non-SAP databases.

• Question 25:

  In which engines is an analytic view executed that contains a calculated column? (Choose two)

  A. Calculation engine
  B. Row store engine
  C. OLAP engine
  D. Join engine
  A. Calculation engine
  C. OLAP engine

• Question 26:

  What is an advantage of using CE functions over regular SQL?

  A. CE functions offer row store operations.
  B. CE functions enforce parallel execution.
  C. CE functions include more functions than regular SQL.
  D. CE functions can be used in any other database.
  B. CE functions enforce parallel execution.

• Question 27:

  Which of the following SAP HANA schemas contains the runtime objects of activated views?

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

• Question 28:

  You need real-time profitability reporting from an SAP ECC system running on a non-SAP database. Which of the following steps must you perform to implement the SAP CO-PA Accelerator? (Choose two)

  A. Configure an ABAP dataflow in SAP Data Services.
  B. Create an SAP Landscape Transformation configuration.
  C. Build attribute and analytic views in SAP HANA.
  D. Install SAP HANA as a secondary database.
  B. Create an SAP Landscape Transformation configuration.
  D. Install SAP HANA as a secondary database.

• Question 29:

  Which information model can you use with measures from multiple fact tables?

  A. Analytic privilege
  B. Calculation view
  C. Attribute view
  D. Analytic view
  B. Calculation view

• Question 30:

  Which of the following objects would SAP HANA identify as the left object of a join in the graphical calculation view?

  A. The object that has its field identified first in the join output.
  B. The object that is displayed on the left hand side in the join details panel.
  C. The object that is connected to the join node first.
  D. The object that is displayed on the left hand side in the graphical calculation view.
  C. The object that is connected to the join node first.