Online Access Free C-HANADEV-14 Exam Questions

In regards to the SQLScript in the screenshot, which table insert statements are committed at database level when the SQLScript procedure PROC1 is executed?

• A.INSERT INTO hdb_table1 ...
  INSERT INTO hdb_table2 ...
• B.INSERT INTO hdb_table1 ...
  INSERT INTO hdb_table2 ...
  INSERTINTO hdb_table4 ...
• C.INSERT INTO hdb_table2 ...
• D.INSERT INTO hdb_table2 ...
  INSERT INTO hdb_table4 ...

Which of the following are required to build a SQLScript
calculation view? (Choose two)

• A.Define a measurE.
• B.Define a data foundation.
• C.Add columns to the var_out output parameter.
• D.Set the MultiDimensional Reporting property to falsE.

You want to allow another developer to access the information
models in one of your packages. What privilege do you have to
assign to this user to allow access?

• A.REPO.MAINTAIN_NATIVE_PACKAGES for the package
• B.REPO.READ for the package
• C.SELECT on _SYS_REPO with the grant option
• D.SELECT on _SYS_REPO

What must you do to enable currency conversions with a
fixed currency in an analytic view?

• A.Base the target currency on a currency column
• B.Create the target currency using an input parameter
• C.Create a measure with the measure type Snipe
• D.Set the Enable for Conversion option

You want to retrieve data from SAP HANA and restrict access
to certain data columns for specific user groups. Where can you
implement this?

• A.In the business layer
• B.In the data foundation
• C.In the SQL privileges
• D.In the analytic privileges