C-HANAIMP-17 試験問題を無料オンラインアクセス

Your calculation view consumes one data source which includes the following columns :
SALES_ORDER_ID, PRODUCT_ID, QUANTITY & PRICE.
In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.
In which type of node do you define the calculation to display the correct result?

• A.Join
• B.Projection
• C.Union
• D.Aggregation

Why does query performance decrease when the data volume of the delta storage is large?
Note: There are 2 correct answers to this question.

• A.The data is NOT sorted.
• B.The data is uncompressed.
• C.The data is unstructured.
• D.The data is stored in the warm tier.

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

You import a project that includes an SAP HANA database(HDB) module to your workspace. You need to create a calculation view that uses data from one table located in an external schema. Which of the following items must you build?
Note: There are 2 correct answers to this question.

• A..hdinamespacefile
• B.Authorization
• C.Synonym
• D.Project

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 includes a TRUNCATE statement
• D.Your function refers to a scalar function.