SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 61:

  Which of the following are advantages of running SAP HANA Live embedded in the SAP Business Suite?

  A. It uses the generic capabilities of SAP HANA such as the XS Engine
  B. It provides real-time operational reporting
  C. It allows using generic virtual data models
  D. It provides real-time replication
  E. It runs in older versions of the SAP Business Suite
  A. It uses the generic capabilities of SAP HANA such as the XS Engine
  B. It provides real-time operational reporting
  C. It allows using generic virtual data models

• Question 62:

  Which CE function do you use to implement an inner join between two tables on a list of join attributes?

  A. CE_COLUMN_TABLE
  B. CE_JOIN_VIEW
  C. CE_OLAP_VIEW
  D. CE_JOIN
  D. CE_JOIN

• Question 63:

  Company needs to load external data from a flat file into SAP HANA. How can you do this?

  A. SAP HANA Direct Extractor Connection (DXC)
  B. SAP System Landscape Transformation (SLT)
  C. SAP HANA SQL Import statement
  D. SAP BusinessObjects Data Services
  C. SAP HANA SQL Import statement
  D. SAP BusinessObjects Data Services

• Question 64:

  In which of the following can you use a FOR loop over your data?

  A. Monitoring View
  B. Calculation View
  C. Analytic View
  D. Analytic View
  B. Calculation View

• Question 65:

  A calculation view that joins one fact table with dimension tables performs slowly. Which of the following can you do to improve performance?

  A. Turn the calculation view into an analytic view.
  B. Turn the calculation view into a simple calculation view.
  C. Load the calculation view into memory.
  D. Load the calculation view into the _SYS_BI schema.
  A. Turn the calculation view into an analytic view.

• Question 66:

  You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?

  A. In the universe
  B. In the Web Intelligence report
  C. In the analytic view
  D. In the calculation view using an attribute value variable
  C. In the analytic view

• Question 67:

  When building a business layer to report on SAP HANA, what do you have to do if you want to display more than 5,000 rows?

  A. Remove all filters from the analytic views.
  B. Deactivate the Limit Size of Result Set parameter in the Central Management
  C. Console.
  D. Set the Array Fetch Size parameter to the maximum in the relational connection.
  E. Deactivate the Limit Size of Result Set parameter in the business layer.
  D. Set the Array Fetch Size parameter to the maximum in the relational connection.

• Question 68:

  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.

• Question 69:

  For which SAP HANA data types is a FULLTEXT index created automatically during table creation?

  A. TEXT
  B. SHORTTEXT
  C. VARCHAR
  D. NCLOB
  A. TEXT
  B. SHORTTEXT

• Question 70:

  Which of the following tools can you use to monitor the query time from SAP HANA?

  A. Central Management Console
  B. Performance tab of the System Monitor
  C. Event Viewer
  D. SQL Trace
  D. SQL Trace