Free C_HANAIMP_17 Exam Braindumps

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.

What is the correct approach?

  1. Combine the transaction tables using a join node in a calculation view of type cube. Use the multi-join capability of the join node to connect the transactional tables with the dimension calculation views.
  2. Combine the transaction tables using a star join node in a calculation view of type cube with star join.
    Use a join node to join the dimensions to the fact table.
  3. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join.
    Use a star join node to join the dimensions to the fact table.
  4. Combine the transaction tables using a join node in a calculation view of type cube with star join.
    Use a star join node to join the dimensions to the fact table.

Answer(s): D



You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view. Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?

  1. Show lineage
  2. Database Explorer
  3. Where used
  4. Auto-map byname

Answer(s): A



You have imported a new calculation view in a folder that contains a .hdinamespace file. This calculation view consumes one data source which is a table. When trying to build the calculation view, there is a

namespace-related issue and the build fails.

What could be the reason? Note: There are 2 correct answers.

  1. The imported calculation view and its data source have different namespaces.
  2. The name space used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.
  3. The .hdinamespace file specifies a different name space property than the one in the identifier of the calculation view.
  4. The hdinamespace specifies "sub-folder": "append'', so calculation views can only be created in sub-folders.

Answer(s): A,B



Your calculation view consumes one data source which includes the following columns :
SALES_ORDER_ID, PRODUCT_ID, QUANTITY & PRICE.

In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY · PRICE.

In which type of node do you define the calculation to display the correct result?

  1. Union
  2. Join
  3. Projection
  4. Aggregation

Answer(s): C



You created a table function to remove previous records, sum the current total weekly working hours for each employee, and updated the personnel table. The build of the table function fails.

Which of the following could be a valid reason?

  1. You did NOT define a valid table type.
  2. Your function refers to a scalar function.
  3. You did not define at least one input parameter.
  4. Your function includes a TRUNCATE statement

Answer(s): D