SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 31:

  You model hierarchies in attribute views. Which of the following technologies do you use to make these hierarchies available for reporting tools?

  A. JDBC
  B. BICS
  C. ODBO
  D. ODBC
  C. ODBO

• Question 32:

  User A has to set up tables and views in a database schema that is owned by user B. Which of the following privilege must you grant?

  A. CREATE ANY to user A
  B. REFERENCES to user A
  C. CREATE ANY to user B
  D. REFERENCES to user B
  A. CREATE ANY to user A

• Question 33:

  A company wants to use SAP BusinessObjects reporting tools. They cannot use Adobe Flash. They require scheduled, ready-made reports. Which reporting tool do you recommend? (Choose two)

  A. Dashboards
  B. Web Intelligence
  C. Explorer
  D. Crystal Reports
  B. Web Intelligence
  D. Crystal Reports

• Question 34:

  How can you evaluate the speed of a calculation within the database? (Choose two)

  A. Use the Data Preview function in the SAP HANA studio.
  B. Execute a Web Intelligence report and check the duration of the previous refresh.
  C. Execute an information space using SAP BusinessObjects Explorer.
  D. Write and execute an appropriate SQL statement.
  A. Use the Data Preview function in the SAP HANA studio.
  D. Write and execute an appropriate SQL statement.

• Question 35:

  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, ["COUNTRY","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;
  D. v_tax = SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;

• Question 36:

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

  You want to run a report on data with multiple currencies. You want to allow end users to select the target currency at runtime. Which options does SAP recommend for defining the currency conversion? (Choose two)

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

• Question 38:

  Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)

  A. Define an output structure for the attribute view.
  B. Define the data foundation.
  C. Choose the type of hierarchy.
  D. Define calculated attributes for the nodes of the hierarchy.
  E. Define an analytic view.
  A. Define an output structure for the attribute view.
  B. Define the data foundation.
  C. Choose the type of hierarchy.

• Question 39:

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

  Which of the following can be grouped inside a single schema in an SAP HANA database?

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