C_HANADEV_16

Which of the following SQLScript elements do you use to transform a set of arrays into an intermediate table variable?A . SETB . UNSETC . ARRAYD . UNNESTView AnswerAnswer: D

You develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced). What are some of the advantages compared to developing in SAP HANA extended application services, classic model (XS classic)? Note: There are 3 correct answers to this question.A . No additional SAP HANA components...

Which of the following SQL Script elements do you use to transform a set of arrays into an intermediate table variable? Please choose the correct answer.A . ARRAYB . SETC . UNSETD . UNNESTView AnswerAnswer: D

Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.A . Temporal joinB . Dynamic joinC . Text joinD . Multi joinView AnswerAnswer: B

What are some of the advantages of SQLScript compared to plain SQL queries? Note: There are 2 correct answers to this question.A . It retrieves a high data volume from a database.B . It increases performance by parallel execution of complex SQL statements.C . It contains a well-defined ANSI standard.D...

Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.A . Entity setB . Join conditionC . Table variableD . Filter conditionView AnswerAnswer: C,D

What are the characteristics of the calculation view of type "SQL Access Only"? There are 2 correct answers to this question.A . Can be directly used for multidimensional analysisB . Can be direct y accessed via SQLC . Can be directly exposed to all client toolsD . Can be directly...

Your team develops an application using SAP Web IDE for SAP HANA. How can you share the application source code with other team users? A. Share the project in the application project settings. B. Assign a shared workspace to users in XS Advanced Administration. C. Store the source code in...

You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements. On which objects can you apply the filter? Note: There are 2 correct answers to this question.A . Database tablesB . Intermediate table variablesC . Virtual tablesD . Scalar variablesView AnswerAnswer: A,B

You configure an OData service for a transactional SAPUI5 application What is the default data access behavior of the OData service?A . Read: Yes Create: No Update. Yes Delete NoB . Read: Yes Create: Yes Update: Yes Delete. NoC . Read: Yes Create: No Update: No Delete: NoD . Read:...