C-HANAIMP-15 by SAP Valid Free Exam Practice Test

Question 1

What can you use SAP HANA smart data access for? Note: these are 2 correct answers to this question.

A. To replicate remote data sources B. To expose data from remote tables C. To load and harmonize data from disparate sources. D. To push down queries to data sources.

Correct Answer: B,D

Question 2

You have a calculation view which includes nodes as shown in the graphic. You decide to select the ''ignore multiple output for filters" checkbox on projection node. What might the effects of this be? 2 correctas:

A. The view will return the profit calculation for only the US B. Decreased performance C. A change to the data that is returned by the view D. Increased performance

Correct Answer: A,D

Question 3

Why do we use Git when modeling calculation views?

A. Develop conceptual prototypes B. Provide access to external schemas C. Enable collaboration between developers D. Control specifically object versioning

Correct Answer: C

Question 4

What does a graph neighborhood reveal? Please choose the correct answer.

A. Vertices that are closely connected B. Strongly connected Vertices C. Vertices that contain the same attributes D. Shortest path between vertices

Correct Answer: A

Question 5

You created a table function to remove previous records,sum the current total weekly working hours for each employee,and update the personnel table. The build of the table function fails.
Which of the following could be a valid reason?

A. You did not define at least one input parameter. B. Your function includes a TRUNCATE statement C. You did NOT define a valid table type. D. Your function refers to a scalar function.

Correct Answer: B

Question 6

What restrictions apply to a Graph mode that you include in a calculation view?

A. It must be the final mode in the data flow B. It must be the first mode in the data flow C. Its data source must be provided by a projection mode D. It cannot be included in a calculation view of type dimension

Correct Answer: B

Question 7

A calculation view includes a rank node that users the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the output of your query?

A. 6 rows B. 8 rows C. 9 rows D. 2 rows

Correct Answer: C

Question 8

Using a calculation view containing the projections shown in the graphic, how would you identify which companies sold products in January 2018 AND February 2018? Please choose the correct answer.

A. Use a union node B. Use an left outer join C. User an intersect node D. Use a full outer join

Correct Answer: C

Question 9

You have a table with two columns, CUSTOMER NAME and COUNTRY NAME, In which Italian customers are stored. You have an identical table in which you store French customers.
What type of calculation view should you create to combine the customers in to two columns that mirror the structure of the sources tables?
Please choose the correct answer.
Response:

A. Calculation view of dimension type with a join node B. Calculation view of cube type with a join node C. Calculation view of dimension type with a union node D. Calculation view of cube type with a union node

Correct Answer: C

SAP Certified Application Associate - SAP HANA 2.0 (SPS03) - C-HANAIMP-15 Exam Practice Test