SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C_HANAIMP

Question 1

Why would you partition a table in an SAP HANA Cloud database?Note: There are 2 correct answers to this question.

A. To improve query performance when accessing large column tables B. To improve data replication performance on large row tables C. To overcome the 2 billion record limit D. To improve response time when multiple users access the same table

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

Using the table in the diagram, you need to create a cube calculation view.What is the simplest approach to create the output from the screenshot?

A. Create a restricted column for each country. B. Create a filter expression that uses an OR operator. C. Implement a union node and map each year as a separate column. D. Create 3 calculated columns.

Discussion 0

Correct Answer: C Vote an answer

Question 3

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. 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 fails.The second build is successful. B. The first build fails.The second build fails. C. The first build is successful.The second build fails. D. The first build is successful.The second build is successful.

Discussion 0

Correct Answer: D Vote an answer

Question 4

You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views all belong to the same project.Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

A. Build the project -> Build the HDB module B. Export the HDB module -> Export the project C. Activate the project -> Build the HDB module D. Build the HDB module -> Build the project

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which of the following are capabilities of SAP HANA smart data access?Note: There are 2 correct answers to this question.

A. Exposure of real-time data from remote tables B. Replication of remote data C. Cleansing and harmonization of data from disparate sources D. Push-down of queries to remote data sources

Discussion 0

Correct Answer: A,D Vote an answer

Question 6

A calculation view includes a rank node that uses 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 B. 9 C. 2 D. 5

Discussion 0

Correct Answer: B Vote an answer

Question 7

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

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

Discussion 0

Correct Answer: A Vote an answer

Question 8

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

A. Partition large tables. B. Implement union pruning. C. Limit the number of stacked calculation views. D. Avoid aggregating data early in the data flow.

Discussion 0

Correct Answer: A,C Vote an answer

Question 9

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. 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. Define a restricted column in a union node.

Discussion 0

Correct Answer: A Vote an answer

SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C_HANAIMP_18 FREE EXAM DUMPS QUESTIONS & ANSWERS