SAP Certified Development Associate - SAP HANA 2.0 SPS02 Sample Questions:
1. You discover row count discrepancies between source data and
SAP HANA information models.
Which of the following can you investigate to find the source of
the discrepancies? (Choose two)
A) Client filtering in the Delivery unit view.
B) Joins in information models.
C) Memory leaks.
D) Client filtering in SAP Landscape Transformation (SLT).
2. What must you configure to directly access an SAP HANA
analytic view using SAP BusinessObjects Analysis edition for
Microsoft Office?
A) RFC connection
B) System DSN
C) SAP HANA Direct Extractor Connection (DXC)
D) Pre-delivered MODELING role
3. You want to aggregate the grand total sales amount into one
currency.
In which of the following cases would you perform the calculation
before aggregation? (Choose two)
A) When an aggregate table by country contains sales values in
one currency.
B) When a line item table contains sales values of two
different currencies.
C) When a line item table contains sales values in one currency.
D) When an aggregate table by country contains sales values
in three different currencies.
4. Which of the following are required to create an attribute
view? (Choose two)
A) Data Foundation
B) Key Attribute
C) Join
D) Default Schema
5. Which of the following privileges do you need to activate
views?
A) SELECT option on the _SYS_REPO schema
B) SELECT option on the _SYS_BIC schema
C) SELECT option on the _SYS schema
D) SELECT option on the _SYS_BI schema
Solutions:
| Question # 1 Answer: B,D | Question # 2 Answer: B | Question # 3 Answer: B,D | Question # 4 Answer: A,B | Question # 5 Answer: A |
We're so confident of our products that we provide no hassle product exchange.


By Tiffany

