SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 131:

  A company loads data every night from several source systems into multiple tables in SAP HANA using complex transformation rules. The calculation view that joins these tables performs unexpectedly slow. Which of the following could you investigate to be able to improve performance?

  A. Whether the joins and transformations of the tables can be moved to the data loading process of SAP BusinessObjects Data Services.
  B. Whether an InfoCube compression is running.
  C. Whether the calculation view needs to create large intermediate result sets.
  D. Whether savepoints are written during execution.
  A. Whether the joins and transformations of the tables can be moved to the data loading process of SAP BusinessObjects Data Services.
  C. Whether the calculation view needs to create large intermediate result sets.

• Question 132:

  You have created SAP HANA information models from replicated SAP ECC data.

  How can you compare the data of the replicated tables with the underlying ECC source data?

  A. Use the SAP ERP Data Browser (transaction SE16).
  B. Use the Catalog node to open table contents.
  C. Use transaction IUUC_REPL_CONTENT.
  D. Use the Data Provisioning view from the Quick Launch.
  A. Use the SAP ERP Data Browser (transaction SE16).
  B. Use the Catalog node to open table contents.

• Question 133:

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

  Which of the following criteria indicate that you should store data in row tables?

  A. The tables have a large number of columns.
  B. The tables require frequent write access.
  C. The information models search the table based on the values of a few columns.
  D. The information models frequently needs to access complete records.
  B. The tables require frequent write access.
  D. The information models frequently needs to access complete records.

• Question 135:

  A new user has implemented an SAP HANA data model.

  Which technical user requires select rights on the new user's schema?

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

• Question 136:

  You want to restrict access to SAP HANA information models based on user groups. The models are accessed through an SAP BusinessObjects report. In which of the following can you implement these restrictions?

  A. The schema mapping
  B. The restricted measures
  C. The analytic privileges
  D. The universe
  C. The analytic privileges
  D. The universe

• Question 137:

  In an aggregation node of a calculation view, which is the default aggregation type for an aggregated measure?

  A. COUNT
  B. MAX
  C. SUM
  D. MIN
  C. SUM

• Question 138:

  Which of the following are characteristics of an operational data mart based on SAP HANA?

  A. It is based on analytic denormalized data models
  B. It uses real-time replication of time-critical data
  C. It runs directly on top of the operational data
  D. It persists transformed data
  B. It uses real-time replication of time-critical data
  C. It runs directly on top of the operational data

• Question 139:

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

  Which of the following CE functions can you use to query an analytic view directly?

  A. CE_CALC
  B. CE_AGGREGATION
  C. CE_OLAP_VIEW
  D. CE_JOIN_VIEW
  C. CE_OLAP_VIEW