SAP SAP Certifications C_HANAIMP_17 Questions & Answers

• Question 51:

  You want to join 2 tables in a calculation view. Why do you use a non-equijoin?

  A. The number of joined columns is different in both tables.

  B. Join columns do not have the same datatype.

  C. The join condition is not represented by matching values.

  D. The cardinality is impossible to determine.

  Correct Answer: C

• Question 52:

  When modeling in the Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?

  A. Synonym

  B. Association

  C. Virtual Table

  D. Alias

  Correct Answer: A

• Question 53:

  You want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameter of the calculation view B is not proposed to you as a source parameter.

  What might be the reason for this?

  

  A. You selected the wrong parameter mapping TYPE.

  B. The names of the input parameters do not match.

  C. You already mapped the input parameters in another calculation view.

  D. Your source calculation view is of the type SQL Access Only.

  Correct Answer: C

• Question 54:

  Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation view?

  

  A. Analytic Privileges and SELECT privileges on the CUBE Calculation view

  B. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view

  C. A SELECT privilege on the CUBE and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view

  D. SELECT or Privileges and Analytic Privileges on both views

  Correct Answer: C

• Question 55:

  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?

  A. You did NOT define a valid table type.

  B. Your function refers to a scalar function.

  C. You did not define at least one input parameter.

  D. Your function includes a TRUNCATE statement

  Correct Answer: D

• Question 56:

  Your calculation view consumes one data source which includes the following columns :

  SALES_ORDER_ID, PRODUCT_ID, QUANTITY and 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?

  A. Union

  B. Join

  C. Projection

  D. Aggregation

  Correct Answer: C

• Question 57:

  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.

  A. The imported calculation view and its data source have different namespaces.

  B. The name space used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

  C. The .hdinamespace file specifies a different name space property than the one in the identifier of the calculation view.

  D. The hdinamespace specifies "sub-folder": "append'', so calculation views can only be created in sub-folders.

  Correct Answer: AB

• Question 58:

  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?

  A. Show lineage

  B. Database Explorer

  C. Where used

  D. Auto-map byname

  Correct Answer: A

• Question 59:

  In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?

  A. You have a large row store table that is consumed in a view with a variable on COUNTRY column.

  B. You have a large column store table that is consumed in a view with a variable on COUNTRY column.

  C. You have a dedicated table lo generate the lists of help values for an input parameter.

  D. Your stacked model consists of multiple calculation views.

  Correct Answer: B

• Question 60:

  In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?

  A. Vertical disaggregation

  B. Horizontal disaggregation

  C. Vertical aggregation

  D. Horizontal aggregation

  Correct Answer: D