You want to exclusively use declarative logic in an SQL Script procedure. Which of the following operators can you use? There are 2 correct answers to this question.A . IF conditionB . MAP_REDUCE functionC . TABLE variableD . COMM IT statement View Answer Answer: B,C...
Continue readingWhich metadata declarations can you specify in an SQLScript procedure when you use the SAP HANA Deployment Infrastructure? Note: There are 2 correct answers to this question.
Which metadata declarations can you specify in an SQLScript procedure when you use the SAP HANA Deployment Infrastructure? Note: There are 2 correct answers to this question.A . AuthorizationB . Default schemaC . SecurityD . Language View Answer Answer: C,D...
Continue readingWhich HTTP commands can you use to define the operations on the resources?
You develop an OData service using XSODATA. Which HTTP commands can you use to define the operations on the resources? There are 3 correct answers to this question. A. INSERT B. POST C. GET D. READ E. PUT View Answer Answer: B,C,E...
Continue readingWhat must you append to the service URL?
You need to view the data model exposed by an OData V2 service. What must you append to the service URL?A . $servicedefinitionB . $schemaC . $metadataD . $format View Answer Answer: C...
Continue readingWhich new components can you use to develop native SAP HANA applications in SAP HANA extended application services; advanced model (XS advanced)? Note: There are 2 correct answers to this question.
Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services; advanced model (XS advanced)? Note: There are 2 correct answers to this question.A . SAP HANA studioB . SAP HANA repositoryC . GIT repositoryD . SAP Web IDE for SAP HANA View Answer Answer: C,D...
Continue readingAfter reviewing the SQL Analyzer results, which of the following would you consider for optimizing the performance? There are 2 correct answers to this question
After reviewing the SQL Analyzer results, which of the following would you consider for optimizing the performance? There are 2 correct answers to this questionA . Re-prioritize with Workload Management.B . Change the data model.C . Use CE functions.D . Modify SQL hints. View Answer Answer: B,D...
Continue readingFor what do you use the RESIGNAL statement in SQLScript?
For what do you use the RESIGNAL statement in SQLScript?A . System exceptionsB . Specific SQL error codesC . Generic SQL exceptionsD . User-defined exceptions View Answer Answer: D...
Continue readingWhich GIT commands are available with the SAP Web IDE for SAP HANA? Note: There are 3 correct answers to this question.
Which GIT commands are available with the SAP Web IDE for SAP HANA? Note: There are 3 correct answers to this question.A . Redeploy the codeB . Clone a repositoryC . Merge changesD . Push codeE . Test changes View Answer Answer: B,C,D...
Continue readingWhat can you use declare exit handlers for?
You define exception handling in a SQLScript procedure. What can you use declare exit handlers for? Note: There are 2 correct answers to this question.A . Specific SQL error codesB . Specific SQL conditionsC . Generic SQL conditionsD . Generic SQL exceptions View Answer Answer: A,B...
Continue readingWhich of the following activities are performed automatically?
A Node.js module is executed for the first time in SAP HANA extended application services, advanced model (XS advanced). Which of the following activities are performed automatically? There are 2 correct answers to this question.A . A new SAP HANA Deployment Infrastructure (HDI) container is created.B . A new service is executed on the...
Continue reading