SAP Certified Application Associate - SAP HANA 2.0 (SPS03)

Question 1

Which of the following views can be extended by using the SAP HANA Live extension assistant? 2 correctas

A. A custom view

B. A query view

C. A reuse view

D. A private view

Correct Answer: B,C

Question 2

You are building a new calculation view B that uses calculation view A as a data source. In the Semantics node of calculation view A,you define a mask for the first 10 digits of a 15 digit Account Number. When you preview calculation view B, the Account Number is not masked.
Why do you see the Account Number unmasked?

A. You did not define masking in calculation view B.

B. The UNMASKED privilege for calculation view A has been granted.

C. The masking is based on the column of a row table.

D. The Account Number is based on the Integer data type.

Correct Answer: B

Question 3

You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
Note:There are 2 correct answers to this question.

A. To provide partial value such as #3434 3#34##

B. To hide individual patients in groups of similar records

C. To add noise to the data to hide the actual values

D. To restrict data access for specific users or roles

Correct Answer: B,C

Question 4

Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge?
Please choose the correct answer.
Response:

A. Creating a report in SAP Crystal Reports for Enterprise

B. Creating a CompositeProvider in SAP BW

C. Creating a REST web service in the SAP HANA XS engine

D. Creating business intelligence content with SAP Lumira, designer edition

Correct Answer: D

Question 5

What are properties of domain fix values?
There are 2 correct answers to this question.
Response:

A. They ask end users for input at runtime.

B. They are based on the ABAP Data Dictionary.

C. They are static values.

D. They are based on SQLScript functions.

Correct Answer: B,C

Question 6

When modeling in the Web IDE for SAP HANA,which object do you build to provide access to tables in external schemas?

A. Synonym

B. Virtual Table

C. Alias

D. Association

Correct Answer: A

Question 7

Why does SAP issue warnings about the use of imperative of procedural SQL Script statements?

A. They introduce security risks due to SQL injection

B. NOT all reporting tools can consume the results

C. They are deprecated

D. They can ham SQL optimization

Correct Answer: A

Question 8

How could you improve the performance of joins in cube calculation views? Note: these are 2 correct answers to this question.

A. Join on calculated columns

B. Avoid the use of referential joins

C. Reduce the number of columns used in the join

D. Specify the cardinally of the join

Correct Answer: C,D

SAP Certified Application Associate - SAP HANA 2.0 (SPS03) - C-HANAIMP-15 Exam Practice Test

Latest Update

Useful Links

Contact Us