SAP Certified Application Associate - SAP HANA 2.0 (SPS04) - C_HANAIMP

Question 1

Why do you use a hierarchy function node in a calculation view?

A. To generate additional Meta data that can be used for analysis of a hierarchy structure B. To display value help using hierarchies C. To assist the developer by visualizing hierarchies D. To enable hierarchical navigation in reporting tools

Discussion 0

Correct Answer: A Vote an answer

Question 2

You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
Note: There are 2 correct answers to this question.

A. To provide partial value such as #34343#34## B. To hide individual patients in groups of similar records C. To restrict data access for specific users or roles D. To add noise to the data to hide the actual values

Discussion 0

Correct Answer: B,D Vote an answer

Question 3

A calculation view consumes the data sources shown in the graphic. You want to identify which companies SQLd products in January 2018 AND February 2018. What is the optimal way to do this?

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

Discussion 0

Correct Answer: C Vote an answer

Question 4

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

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

Discussion 0

Correct Answer: A Vote an answer

Question 5

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 retain the correct aggregation behavior in stacked views. C. To cache the results of the aggregation node for drill-down D. To include columns that are NOT requested by a query but are essential for the correct result

Discussion 0

Correct Answer: D Vote an answer

Question 6

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

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

Discussion 0

Correct Answer: B,C Vote an answer

Question 7

Why do you use the debug query mode in a calculation view?

A. To measure the overall run-time of the query B. To observe the generated SQL for each node C. To highlight potential performance issues at design-time D. To check which database engines will be invoked by each node

Discussion 0

Correct Answer: B Vote an answer

Question 8

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 at least one input parameter. B. You did NOT define a valid table type. C. Your function refers to a scalar function. D. Your function includes a TRUNCATE statement

Discussion 0

Correct Answer: D Vote an answer

SAP Certified Application Associate - SAP HANA 2.0 (SPS04) - C_HANAIMP_16 FREE EXAM DUMPS QUESTIONS & ANSWERS