SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 171:

  What is the purpose of the savepoint process in SAP HANA?

  A. Save changed data to the persistent storage when a transaction is committed.
  B. Save logs to persistent storage when a transaction is committed.
  C. Save changed data and logs to the persistent storage on a regular basis.
  D. Free-up memory by saving less used data to the persistent storage.
  C. Save changed data and logs to the persistent storage on a regular basis.

• Question 172:

  You want to aggregate the grand total sales amount into 1 currency.

  In which of the following cases would you select the Calculate Before Aggregation check- box? (Choose two)

  A. When an aggregate table by country contains sales values in 3 different currencies
  B. When a line item table contains sales values of 2 different currencies
  C. When a line item table contains sales values in 1 currency
  D. When an aggregate table by country contains sales values in 1 currency
  A. When an aggregate table by country contains sales values in 3 different currencies
  B. When a line item table contains sales values of 2 different currencies

• Question 173:

  Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA? (Choose three)

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

• Question 174:

  You have created two analytic views for actual and planned financial data. The data covers multiple years. You want to display the actual data, planned data, and their difference in three separate columns in a report. The difference column is a calculated column.

  How can you model this?

  A. Create an analytic view. Combine the analytic views in the new analytic view using a referential join.
  B. Create a calculation view. Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES.
  C. Create a calculation view. Combine the analytic views in the calculation view using a UNION.
  D. Create restricted columns for each year for the actual and planned columns in each analytic view. Combine the analytic views in a new calculation view using a UNION.
  B. Create a calculation view. Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES.

• Question 175:

  An SAP BusinessObjects Web Intelligence report throws an SQL error during query execution. Which of the following could you check to resolve the error? (Choose two)

  A. The business layer
  B. The business view
  C. The Web Intelligence report variables
  D. The SAP HANA information model
  A. The business layer
  D. The SAP HANA information model

• Question 176:

  Which of the following selection types are available when creating a variable in an analytic view? (Choose three)

  A. Single value
  B. Direct
  C. Interval
  D. Range
  E. Column
  A. Single value
  C. Interval
  D. Range

• Question 177:

  Two attribute views in the same analytic view contain the same column name (ID from attribute view Customer and ID from attribute view Product). In the output, the system automatically renamed one column to ID_1. Which of the following can you do to indicate that ID_1 originated from attribute view Product?

  A. Update the alias in the properties of ID_1.
  B. Change the label of ID_1.
  C. Create a restricted column with a different name based on ID_1.
  D. Create a derived attribute view with an alias for ID_1.
  A. Update the alias in the properties of ID_1.

• Question 178:

  Your customer wants to implement a SAP product that:

  Provides near real-time replication to SAP HANA Connects SAP HANA to a non-SAP source system and SAP BW Uses SAP extractors What do you recommend?

  A. SAP Legacy System Migration Workbench (LSMW)
  B. SAP Landscape Transformation (SLT)
  C. Sybase Replication Server
  D. SAP BusinessObjects Data Services 4.0
  D. SAP BusinessObjects Data Services 4.0

• Question 179:

  You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task? (Choose three)

  A. Define a projection.
  B. Write an SQL script.
  C. Save and activate the view.
  D. Define output fields.
  E. Choose a data source.
  C. Save and activate the view.
  D. Define output fields.
  E. Choose a data source.

• Question 180:

  In a fuzzy search, when would you perform a freestyle search?

  A. When you want to search with a high fuzziness threshold
  B. When you want to search in multiple columns
  C. When you want to search in only one column
  D. When you want to search with a low fuzziness threshold
  B. When you want to search in multiple columns