C-HANAIMP-17 by SAP Actual Free Exam Q&As

Question 1

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view.
Afterward, you perform the following build operations:
*Build the dimension calculation view as a single object.
*Build the entire SAP HANA database module. What is the outcome of the build operations?

A. The first build is successful.
The second build fails. B. The first build fails.
The second build fails. C. The first build fails.
The second build is successful. D. The first build is successful.
The second build is successful.

Discussion 0

Correct Answer: D Vote an answer

Question 2

How can you optimize performance when writing SQL for use with calculation views?
Note: There are 2 correct answers to this question.

A. Use declarative language instead of cursors B. Control the flow logic using IF-THEN-ELSE conditions C. Increase parallelization by using variables to break up statements D. Use calculation engine (CE) functions instead of plain SQL

Discussion 0

Correct Answer: A,C Vote an answer

Question 3

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 CANNOT be mixed in the same star join node with other join types. C. Full outer joins require cardinality to beset. D. Full outer joins are NOT available in the star join node.

Discussion 0

Correct Answer: A Vote an answer

Question 4

In a calculation view, what is the purpose of a variable?

A. To pass values between procedures and calculation views B. To break up complex SQL into smaller steps C. To provide a dynamic value in a calculated column D. To provide a run-time attribute filter based on a user input

Discussion 0

Correct Answer: B,D Vote an answer

Question 5

After importing a project in the workspace of the Web IDE, you try to build the HDB module. The build fails.
What could be the reason?
Note: There are 2 correct answers.

A. You have not built the project. B. You have assigned the project to a space that you do not have developer authorizations for. C. The HDB module references a user-provided service that does not exist. D. The project is not assigned to a space.

Discussion 0

Correct Answer: B,C Vote an answer

Question 6

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

A. You have a dedicated table lo generate the lists of help values for an input parameter. B. You have a large column store table that is consumed in a view with a variable on COUNTRY column. C. Your stacked model consists of multiple calculation views. D. You have a large row store table that is consumed in a view with a variable on COUNTRY column.

Discussion 0

Correct Answer: B Vote an answer

Question 7

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. Auto-map byname C. Where used D. Database Explorer

Discussion 0

Correct Answer: A Vote an answer

Question 8

How can you define a variable that presents its value help hierarchically?
Note: There are2 correct answers to this question.

A. Create a level hierarchy and assign it to the variable.
Ensure the variable's reference column is the leaf level of the hierarchy. B. Create a parent-child hierarchy and assign it to the variable.
Ensure the variable's reference column is the child attribute of the hierarchy. C. Create a parent-child hierarchy and assign it to the variable.
Ensure the variable's reference column is the parent attribute of the hierarchy. D. Create a level hierarchy and assign it to the variable.
Ensure the variable's reference column is the top level of the hierarchy.

Discussion 0

Correct Answer: A Vote an answer

Question 9

Which is the correct syntax when you refer to an input parameter in a calculation view expression?

A. :Choose_Country B. $$Choose_Country$S C. ..Choose_Country" D. @Choose_Country

Discussion 0

Correct Answer: B Vote an answer

SAP Certified Application Associate - SAP HANA 2.0 (SPS05) - C-HANAIMP-17 Exam Practice Test