Free SAP C_HANAIMP131 Exam Dumps Questions & Answers

You have two analytic views. One contains actual data and the other one contains plan data. You want to combine the two result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?

• A.  UNION in a calculation view
• B.  JOIN in a calculation view
• C.  PROJECTION in a calculation view
• D.  JOIN in an analytic view

You would like to authorize a user to see data in an analytic view only for company code 1000 and fiscal year 2000 or for company code 1005 and fiscal year 2005.
Which of the following achieves this requirement?

• A.  One analyticprivilege:company codes = 1000 and 1005
  One analyticprivilege:fiscal years = 2000 and 2005
• B.  One analyticprivilege.the combination of company code = 1000 and fiscal year = 2000, and the combination of company code = 1005 and fiscal year = 2005
• C.  One analyticprivilege:company code = 1000, fiscal year = 2000
  One analyticprivilege:company code = 1005, fiscal year = 2005
• D.  One analyticprivilege:company codes = 1000 and 1005, and fiscal years = 2000 and 2005

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

Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) whenmigrating it to run on SAP HANA?(Choose three)

• A.  It eliminates the need to upgrade to the latest SAP BW application version.
• B.  The system usage is the same as an equivalent SAP BW on non-SAP databases.
• C.  It allows co-deployment of the SAP BW application server on the SAP HANA database hardware.
• D.  It allows re-use of your available SAP BW application servers.
• E.  The sizing of your current SAP BW application servers remains valid.

What is the lowest level of granularity you can use in an analytic privilege?

• A.  An attribute value
• B.  A column
• C.  A view
• D.  An attribute