SAP C_HANADEV_17 Online Practice Questions and Exam Preparation

SAP C_HANADEV_17 Online Questions & Answers

• Question 1:

  You created an HDI database role, using the SAP Web IDE for SAP HANA and deployed your project. Afterward, you made some modifications to the runtime role.

  What happens when you change and re-build the design-time role? Please choose the correct answer.

  A. The runtime modifications are overwritten.
  B. The deployment of the role fails.
  C. The runtime modifications are kept.
  D. You need to confirm the runtime modifications
  A. The runtime modifications are overwritten.

• Question 2:

  Which trace do you use to create a graphical representation of an individual SQL Statement? Please choose the correct answer.

  A. Expensive statements trace
  B. Performance trace
  C. Plan trace
  D. SQL trace
  A. Expensive statements trace

• Question 3:

  Which rules apply to declarative logic in SQL Script? There are 2 correct answers to this question.

  A. It supports the full set of SQL Script.
  B. It defines how data is processed.
  C. It is free of side effects.
  D. lt declares the flow of data.
  C. It is free of side effects.
  D. lt declares the flow of data.

• Question 4:

  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
  B. Dimension
  D. Cube with star join

• Question 5:

  Which OData capacity do you use when you need to restrict the number or selection of exposed columns? Please choose the correct answer.

  A. Parameter entity sets
  B. Aggregation
  C. Key specification
  D. Property projection
  D. Property projection

• Question 6:

  Which of the following can be used when implementing transaction management logic in SQLScript using savepoints? Note: There are 3 correct answers to this question.

  A. Release savepoint
  B. Rollback to savepoint
  C. Savepoint
  D. Reverse savepoint
  E. Alter system savepoint
  A. Release savepoint
  B. Rollback to savepoint
  C. Savepoint

  ---

  explanation:

  Explanation/Reference:

• Question 7:

  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
  A. Table
  B. Scalar

  ---

  explanation:

  Explanation/Reference:

• Question 8:

  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.
  B. Database procedures can have several output parameters, and a mix of both scalar and table types is possible.

  ---

  explanation:

  Explanation/Reference:

• Question 9:

  You need to edit a database procedure. You are concerned that the version of the database procedure file you have in your local Git repository may not be synchronized with the latest version in the remote Git repository, but at this time, you do NOT want to sync the file. You only want to see the commits applied to the file in the remote repository.Which command must you use?

  A. Git stash
  B. Git fetch
  C. Git merge
  D. Git pull
  A. Git stash

  ---

  explanation:

  Explanation/Reference:

• Question 10:

  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
  C. Push

  ---

  explanation:

  Explanation/Reference: