SAP Certified Application Associate - SAP HANA 2.0 (SPS03)

QUESTION NO: 1
You join two tables using a referential join and set the cardinality to 1..n. What type of join is executed at runtime if your query does NOT request columns from the right table?

A. Right outer join B. Inner join C. Left outer join D. Full outer join

Correct Answer: B

QUESTION NO: 2
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 hide individual patients in groups of similar records B. To add noise to the data to hide the actual values C. To restrict data access for specific users or roles D. To provide partial value such as #3434 3#34##

Correct Answer: A,B

QUESTION NO: 3
why do you create calculation views of data category DIMENSION with type TIME?

A. To provide additional time-related navigation possibilities B. To apply automatic adjustments to unequal time snapshots on series data C. To provide the time intervals required by time-dependent parent-child hierarchies D. To enable time-dependent master data attributes to be consumed in a star schema

Correct Answer: A

QUESTION NO: 4
What do you use in the definition of a dynamic SOL analytic privilege?

A. A procedure that returns the data access condition as an SQL expression. B. An organization hierarchy that provides role-based access to data. C. A table function that returns a list of allowed values. D. A scalar function that returns a list of the allowed values for each attribute.

Correct Answer: C

QUESTION NO: 5
Which of the following approaches improve the performance of joins in a cube calculation view? Note:There are 2 correct answers to this question.

A. Implement pruning rules. B. Specify the join cardinality. C. Limit the number of joined columns. D. Use an inner join.

Correct Answer: B,C

QUESTION NO: 6
When using the CONTAINS predicate, what are the restrictions you must you keep in mind? 2 correctas.

A. Wild cards * and ? are supported for text columns but not string columns. B. If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only of the tables. C. The NOT (-) operator can only be specified directly after the OR operator. D. Non-physical columns, such as calculated columns, are not search relevant.

Correct Answer: B,D

QUESTION NO: 7
You want to expose a hierarchy that is defined in a calculation view for access to SQL which of the following conditions must be met?
Note:There are 2 correct answers .

A. The hierarchy must be a shared hierarchy. B. The hierarchy must be defined in a calculation view of type SOL ACCESS ONLY. C. The hierarchy must be exposed by a calculation view of type CUBE with star join. D. The hierarchy must be a local hierarchy.

Correct Answer: B,C

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