C-HANAIMP-18 Exam Training Practice Tests (SAP Certified Application Associate

Question 1

In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

A. Scalar function B. Procedure C. Anonymous block D. Table function

Correct Answer: D

Question 2

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

A. To provide a data source that is only consumed by other calculation views B. To provide a high performance model when only attributes are required C. To enable SQL access to your hierarchies D. To provide a data source that can only be consumed by a function or procedure

Correct Answer: A

Question 3

Which of the following are usually not required In the data model of SAP S/4HANA?Note: There are 2 correct answers to this question.

A. Partitions B. Stored aggregates C. Indexes D. Views

Correct Answer: B,C

Question 4

Why do we use Git when modeling calculation views?Note: There are 2 correct answers to this question.

A. To enable collaboration between developers B. To display dependencies in stacked scenarios C. To automate the build process D. To manage versions of source files

Correct Answer: A,D

Question 5

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?

A. Add an intersect node above the union node. B. In the union node, map both source customer name columns to one target column. C. Define a restricted column in a union node. D. Include an aggregation node above the union node.

Correct Answer: D

Question 6

What is a restricted measure?

A. A measure that cannot be referenced by a calculated column. B. A measure that can be consumed by a CUBE and not a DIMENSION. C. A measure that can only be displayed by those with necessary privileges. D. A measure that is filtered by one or more attribute values.

Correct Answer: D

Question 7

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.When you preview calculation view A, what data do you see?

A. US for P1 B. US for P1 and GE for P1 C. US for P1 and P2, and GE for P1 and P2 D. US for P1 and P2, and GE for P2

Correct Answer: A

Question 8

You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.How do you check if pruning occurs?Note:
There are 2 correct answers to this question.

A. Use the SQL Analyzer to identify the tables used B. Preview the data results in the calculation view C. Enable Debug Query mode to identify the columns used D. Explore the number of used columns in the Performance Analysis mode

Correct Answer: C,D

Question 9

Why might you use the Keep Flag property in an aggregation node?

A. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query B. To exclude columns that are NOT requested by a query to avoid incorrect results C. To retain the correct aggregation behavior in stacked views D. To include columns that are NOT requested by a query but are essential for the correct result

Correct Answer: D

SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C-HANAIMP-18 Exam Practice Test