SAP Certified Application Associate - SAP HANA (Edition 2016) v7.0 (C_HANAIMP_11)

Page:    1 / 15   
Total 228 questions

What is the minimum requirement for a valid analytic view?

  • A. One fact table and one attribute view
  • B. One attribute view
  • C. One fact table and two attribute views
  • D. One fact table


Answer : D

A calculation view that joins one fact table with dimension tables performs slowly. Which of the following can you do to improve performance?

  • A. Turn the calculation view into an analytic view.
  • B. Turn the calculation view into a simple calculation view.
  • C. Load the calculation view into memory.
  • D. Load the calculation view into the_SYS_Bl schema.


Answer : A

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database?

  • A. Install SAP Business Warehouse Accelerator (BWA).
  • B. Perform a database migration from your current DB to SAP HANA DB.
  • C. Execute the report RS_BW_POST_MIGRATION.
  • D. Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5.
  • E. Recreate SAP BW indexes after SAP HANA database migration.


Answer : B,C,D

Which of the following modeling objects can you use with a Star Join node? (Choose two)

  • A. Aggregation node before the Star Join node
  • B. Aggregation node after the Star Join node
  • C. Calculation views of type dimension
  • D. Projection node after the Star Join node


Answer : B,C

You have created an MS Excel report on SAP HANA data.
On which of the following could you store the Excel file and make it available for other users?

  • A. Shared network drive
  • B. SAP BusinessObjects Information Design Tool
  • C. SAP HANA database
  • D. SAP HANA studio Content node


Answer : A

Which of the following is used to make hierarchies available to reporting tools?

  • A. CE Functions
  • B. MDX
  • C. SQLScript
  • D. SQL


Answer : B

You want to create a custom attribute in addition to your data model. How can you achieve this?

  • A. Create the attribute as a calculated attribute within the analytic view.
  • B. Create the attribute and add it to the appropriate system table manually.
  • C. Create the attribute as a calculated measure within the attribute view.
  • D. Create the attribute as a restricted attribute within the calculation view.


Answer : A

You have created an information space in SAP BusinessObjects Explorer but the information space is not available on the Home page.
How can you make the information space available on the Home page?

  • A. Drag the information space to the Home page
  • B. Refresh the list of information spaces on the Home page
  • C. Select the "Show on Home page" checkbox in the information space properties
  • D. Index the information space again


Answer : B,C

Which of the following are direct outputs of an analytic view?

  • A. Hierarchies
  • B. Private attributes
  • C. Restricted attributes
  • D. Measures
  • E. Attribute views


Answer : B,D,E

Which of the following operations can you use when you create a calculation view using the
SAP HANA studio graphical interface?

  • A. PROJECTION
  • B. UNION
  • C. INTERSECT
  • D. INSERT


Answer : A,B

Which information model can you use with measures from multiple fact tables?

  • A. Analytic privilege
  • B. Calculation view
  • C. Attribute view
  • D. Analytic view


Answer : B

Table SALES_TABLE contains the columns COUNTRY and SALES. Function calc_tax calculates sales tax based on input parameter SALES.
Using a scripted calculation view, how can you call the calc_tax function?

  • A. v_tax=CE_PROJECTION(SALES_TABLE, [“COUNTR”,”calc_tax(SALES)”]);
  • B. v tax = CE PROJECTION (SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]);
  • C. :V_tax = SELECT COUNTRY, CALL : calc_tax(SALES) AS TAX FROM :SALES_TABLE;
  • D. V_tax + SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;


Answer : D

Your data models use hierarchies.
In which of the following front end tools can you access these hierarchies? (Choose three)

  • A. SAP Lumira
  • B. SAP BusinessObjects Analysis, edition for Microsoft Office
  • C. SAP BusinessObjects Dashboards
  • D. SAP Crystal Reports 2011
  • E. SAP BusinessObjects Analysis, edition for OLAP


Answer : A,B,E

What must you configure to directly access an SAP HANA analytic view using SAP
BusinessObjects Analysis edition for Microsoft Office?

  • A. RFC connection
  • B. SAP HANA Direct Extractor Connection (DXC)
  • C. Pre-delivered MODELING role
  • D. System DSN


Answer : D

How can you import information models into SAP HANA using the Quick Launch view?

  • A. Choose the Redeploy button.
  • B. Choose Import -> SAP HANA Content -> Delivery Unit.
  • C. Choose Data Provisioning -> Load.
  • D. Choose Import -> SAP HANA Content -> Import Data From Local File.


Answer : B

Page:    1 / 15   
Total 228 questions