SAP SAP Certifications C_HANAIMP_17 Questions & Answers

• Question 61:

  Which type of join supports a temporal condition in a calculation view?

  A. Left outer join

  B. Text join

  C. Referential join

  D. Inner join

  Correct Answer: D

• Question 62:

  Why do we use Git when modeling calculation views?

  A. Develop conceptual prototypes

  B. Enable collaboration between developers

  C. Provide access to external schemas

  D. Control specifically object versioning

  Correct Answer: D

• Question 63:

  In a calculation view, where can you insert SQL code?

  Note: There are 3 correct answers to this question.

  A. Hierarchy

  B. Filter expression

  C. Calculated column expression

  D. Input parameter

  E. Currency conversion

  Correct Answer: BCD

• Question 64:

  You are building a new calculation view B that uses calculation view A as a data source. In the Semantics node of calculation view A, you define a mask for the first 10 digits of a 15 digit Account Number. When you preview calculation view B, the Account Number is not masked.

  Why do you see the Account Number unmasked?

  A. The masking is based on the column of a row table.

  B. You did not define masking in calculation view B.

  C. The UNMASKED privilege for calculation view A has been granted.

  D. The Account Number is based on the Integer datatype.

  Correct Answer: C

• Question 65:

  Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?

  

  A. D

  B. C

  C. A

  D. B

  Correct Answer: A

• Question 66:

  Which of the following allows data replication?

  A. SAP HANA smart data access

  B. SAP HANA streaming analytics

  C. SAP HANA smart data integration

  D. SAP HANA smart data quality

  Correct Answer: C

• Question 67:

  In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join. You did NOT set cardinality of the data sources. Why will this NOT work?

  A. Full outer joins are restricted to one dimension in a star join node.

  B. Full outer joins require cardinality to beset.

  C. Full outer joins CANNOT be mixed in the same star join node with other join types.

  D. Full outer joins are NOT available in the star join node.

  Correct Answer: A

• Question 68:

  What is the disk storage layer used for?

  Note: There are 2 correct answers to this question.

  A. To unload the least-used data when the memory is full

  B. To improve the parallel processing of queries

  C. To store the data primarily used for transactional processing

  D. To enable data to be recovered if hardware fails

  Correct Answer: AD

• Question 69:

  In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?

  A. Table function

  B. CDS view

  C. Procedure

  D. Virtual Table

  Correct Answer: A

• Question 70:

  Why do you build a calculation view of type SQL Access only?

  A. To enable SQL access to your hierarchies

  B. To provide a high-performance model when only attributes are required

  C. To provide a data source that can only be consumed by a function or procedure

  D. To provide a data source that is only consumed by other calculation views

  Correct Answer: D