C_HANADEV_17 Online Practice Questions and Answers

In an SQLScript procedure, which feature do you use to initialize IN/OUT table parameters?

A. IS_EMPTY

B. DEFAULT EMPTY

C. DEFAULT

D. SET

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 codes

B. Specific SQL conditions

C. Generic SQL conditions

D. Generic SQL exceptions

Which services can you use in SAP HANA 2.0, express edition? Note: There are 3 correct answers to this question.

A. Text analytics

B. Dynamic tiering

C. System replication

D. Columnar OLTP and OLAP

E. Multi-core and parallelization

Which are the artifacts that are contained in an SAP HANA Deployment Infrastructure (HDI) container? Note: There are 2 correct answers to this question.

A. JavaScript programs

B. Data services

C. SQLScript procedures

D. Table definitions

Which parameter do you adapt to change the file that is initially delivered by an HTML5 module? Please choose the correct answer.

A. Service_url parameter of the mta.xml file

B. Start parameter of the package.json file

C. Runners parameter of the projectjson file

D. Welcome file parameter of the xs-app.json file

What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.

A. Aggregation

B. Union

C. Rank

D. Star join

You need to synchronize all unsynchronized changes in your local Git branch to a remote Git branch.Which operation do you use?

A. Pull

B. Rebase

C. Push

D. Reset

Which of the following are characteristics of database procedures?

A. Database procedures can have both input and output parameters; however, a parameter CANNOT be both input and output.

B. Database procedures can have several output parameters, and a mix of both scalar and table types is possible.

C. If, in the database procedure header, you use the READS SQL DATA option, then INSERT statements are prohibited; however, dynamic SQL is allowed.

D. If, in the database procedure header, you use the SQL SECURITY INVOKER option, then only the owner of the procedure can start it.

What types of user-defined functions are supported by SAP HANA? Note: There are 2 correct answers to this question.

A. Table

B. Scalar

C. Aggregate

D. Hierarchy

What are the different types of graphical calculation views that can handle measures? There are 2 correct answers to this question.

A. Cube

B. Dimension

C. SQL Access Only

D. Cube with star join