C_HANADEV_14 by SAP Actual Free Exam Questions And Answers

Question 1

A corporation with over 15 000 cost centers would like to ensure
that only the person responsible for the cost center may view salary
information for individuals assigned to their cost center.
How can the corporation achieve this in SAP HANA?

A. Create an analytic privilege using the cost center and the salary
measure

B. Create a dynamic analytic privilege using the cost center and
employee master data

C. Create an object privilege on the cost center and employee master
data schema

D. Create an analysis authorization using the cost center and employee
master data

Discussion 0

Correct Answer: B Vote an answer

Question 2

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. SELECT on _SYS_REPO

B. REPO.READ for the package

C. REPO.MAINTAIN_NATIVE_PACKAGES for the package

D. SELECT on _SYS_REPO with the grant option

Discussion 0

Correct Answer: B Vote an answer

Question 3

What does the save point process in SAP HANA do?

A. It frees up memory by saving non-active data to disk.

B. It saves changed data to disk at regular intervals.

C. It saves changed data to disk when transactions are committeD.

D. It synchronizes changed data to the disaster recovery system.

Discussion 0

Correct Answer: D Vote an answer

Question 4

Consider the differences between OLTP and OLAP
system, which of the below statement is incorrect about an
OLAP system?

A. It has Normalized data as compared to an OLTP database

B. It has more indexes as compared to an OLTP system

C. It process historical data

D. It has less number of joins compared to an OLTP system

Discussion 0

Correct Answer: A Vote an answer

Question 5

Your customer requests a module to expose database
information to the UI layer in SAP HANA extended
application services, advanced model (XS advanced).
Which language do you use to write this module?

A. HTML5

B. ABAP

C. CSS

D. JavaScript

Discussion 0

Correct Answer: A Vote an answer

Question 6

You created a model on a table XYZ.PRODUCTS. You
successfully activated the model. When you run the data preview you
receive an error message "Insufficient privilegE. Not authorized".
Which of the following 4 statements do you execute to resolve the
error before you reactivate the model?

A. GRANT SELECT on SCHEMA XYZ to _SYS_REPO

B. GRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH
GRANT OPTION

C. GRANT SELECT on PRODUCTS to _SYS_BIC

D. GRANT SELECT on PRODUCTS to _SYS_REPO WITH
GRANT OPTION

Discussion 0

Correct Answer: D Vote an answer

Question 7

You have created two analytic views for actual and planned financial data each. The data covers multiple years. You want to display the actual data, planned data, and their difference in three separate columns in a report. The difference column is a calculated column.
How can you model this?

A. - Combine the analytic views in a new calculation view using a UNION

B. - Combine the analytic views in the calculation view using a UNION
WITH CONSTANT VALUES

C. - Combine the analytic views in the new analytic view using a referential join

D. - Combine the analytic views in the calculation view using a UNION

Discussion 0

Correct Answer: B Vote an answer

Question 8

You define a measure CURR_CONV to perform a currency
conversion in an analytic view.
When you query the analytic view it fails with a currency/unit
conversion error messagE.
What can you do to ensure that the query runs without error message?
(Choose two)

A. Unselect the Enable for decimal shifts property in CURR_CONV

B. Set the Upon conversion failure parameter of CURR_CONV to
Ignore

C. Remove the Target Currency property in CURR_CONV

D. Maintain valid conversion rate entries in TCUR tables

Discussion 0

Correct Answer: B,D Vote an answer

SAP Certified Development Associate - SAP HANA 2.0 SPS02 - C_HANADEV_14 Exam Practice Test

Contact Us

Useful Links

Latest Updated