SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 211:

  An analytic view has a long runtime.

  Which of the following can be a root cause for the bad performance? (Choose two)

  A. The Execute In option is set to SQL Engine.
  B. The analytic view uses calculated columns.
  C. The analytic view uses generated columns.
  D. The Calculation Before Aggregation flag is set.
  B. The analytic view uses calculated columns.
  D. The Calculation Before Aggregation flag is set.

• Question 212:

  Which of the following remote data sources can you access with SAP HANA smart data access? (Choose three)

  A. XML file
  B. SAP Adaptive Server Enterprise
  C. SAP NetWeaver Business Warehouse
  D. Apache Hadoop
  E. Teradata Database
  B. SAP Adaptive Server Enterprise
  D. Apache Hadoop
  E. Teradata Database

• Question 213:

  Which SAP tool would you use for data cleansing before data is loaded into SAP HANA?

  A. SAP BusinessObjects Information Steward
  B. SAP BusinessObjects Data Services
  C. SAP Landscape Transformation
  D. SAP NetWeaver Master Data Management
  B. SAP BusinessObjects Data Services

• Question 214:

  When must you create a calculation view in SAP HANA? (Choose two)

  A. When you need to perform join operations.
  B. When you need calculations before aggregations.
  C. When key figures span across tables.
  D. When you need to perform a union of base tables.
  C. When key figures span across tables.
  D. When you need to perform a union of base tables.

• Question 215:

  Which view in SAP HANA studio do you use to add additional users?

  A. Properties View
  B. Quick launch View
  C. Console View
  D. Navigator View
  D. Navigator View

• Question 216:

  Which connectivity options can you use to create a SAP BusinessObjects universe on SAP HANA? (Choose two)

  A. OLAP connection using MDX
  B. Relational connection using BICS
  C. Relational connection using ODBC
  D. Relational connection using MDX
  E. Relational connection using JDBC
  C. Relational connection using ODBC
  E. Relational connection using JDBC

• Question 217:

  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 Console.
  C. Set the Array Fetch Size parameter to the maximum in the relational connection.
  D. Deactivate the Limit Size of Result Set parameter in the business layer.
  D. Deactivate the Limit Size of Result Set parameter in the business layer.

• Question 218:

  You develop a disaster recovery plan. What do you have to consider in case of a disk failure? (Choose three)

  A. Configuration files can be restored automatically.
  B. Savepoints can be backed up.
  C. Log volumes can be backed up.
  D. Non-committed transactions can be recovered.
  E. Committed transactions can be recovered.
  B. Savepoints can be backed up.
  C. Log volumes can be backed up.
  E. Committed transactions can be recovered.

• Question 219:

  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 220:

  How can you improve the performance of an information model? (Choose three)

  A. Use generated columns.
  B. Use analytic views wherever possible.
  C. Use indexes on all measures.
  D. Use attribute views wherever possible.
  E. Use constraint filters.
  A. Use generated columns.
  B. Use analytic views wherever possible.
  E. Use constraint filters.