SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 71:

  Which of the following can you use as sources for the vocabulary in a decision table?

  A. Calculation views
  B. Table types
  C. OData models
  D. Procedures
  E. Physical tables
  A. Calculation views
  B. Table types
  E. Physical tables

• Question 72:

  How can you improve the performance of a report that is based on SAP HANA data?

  A. Ensure that all SAP HANA tables are in the same schema.
  B. Maintain appropriate constraint filters in SAP HANA.
  C. Ensure that all calculations are pushed down to the SAP HANA database.
  D. Gather new database statistics.
  B. Maintain appropriate constraint filters in SAP HANA.
  C. Ensure that all calculations are pushed down to the SAP HANA database.

• Question 73:

  You want to run a report on data with multiple currencies. You want to allow end users to select the target currency at run time. Which option does SAP recommend for defining the currency conversion?

  A. A calculated column in an analytic view
  B. Currency conversion during data load
  C. Measures enabled for conversion in an analytic view
  D. A CE_CONVERSION function in a calculation view
  C. Measures enabled for conversion in an analytic view

• Question 74:

  How can you restrict SAP HANA modeling users from viewing sensitive data?

  A. Use scrambled source data.
  B. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.
  C. Use the pre-delivered MODELER role.
  D. Remove ALTER SYSTEM in the system privileges for the modeling users.
  A. Use scrambled source data.

• Question 75:

  In a calculation view you define a calculated column and set the Calculate Before Aggregation flag. Which of the following activities is mandatory to activate the view?

  A. Set the column type to Attribute
  B. Add a new aggregation node
  C. Mark the column as hidden
  D. Select the aggregation type
  D. Select the aggregation type

• Question 76:

  Where is the physical data stored, on which a calculation view is based?

  A. In the _SYS_BI schema
  B. In a schema
  C. In the _SYS_BIC schema
  D. In a package
  B. In a schema

• Question 77:

  You have to design a report that shows actual, planned, and variance values. How do you implement this requirement if you want to achieve the best performance?

  A. Use a calculation view based upon two analytic views using a union.
  B. Use a calculation view based upon two analytic views using a join.
  C. Use a single source data foundation in the Universe Design Tool and include the two analytic views.
  D. Use a multisource-enabled data foundation in the Universe Design Tool for each analytic view.
  A. Use a calculation view based upon two analytic views using a union.

• Question 78:

  Which of the following can be grouped when multiple schemas exist in an SAP HANA database?

  A. Information models
  B. Data tables
  C. Packages
  D. Users
  B. Data tables

• Question 79:

  You discover row count discrepancies between source data and SAP HANA information models. Which of the following can you investigate to find the source of the discrepancies?

  A. Client filtering in the Delivery unit view.
  B. Joins in information models.
  C. Memory leaks.
  D. Client filtering in SAP Landscape Transformation (SLT).
  B. Joins in information models.
  D. Client filtering in SAP Landscape Transformation (SLT).

• Question 80:

  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