SAP Certified Application Associate - SAP HANA (Edition 2014)

QUESTION NO: 1
When you load data from SAP ECC using SAP BusinessObjects Data Services, where would you create an ABAP data flow?

A. In the Job overview (transaction SM37) B. In a query transformation C. In the ABAP editor (transaction SE38) D. In a batch job

Correct Answer: D

QUESTION NO: 2
Which CE function do you use to implement the following SQL statement?
SELECT DATE, SHOP_ID, PRODUCT_ID, QUANTITY * COST AS "PRICE" FROM SALES_DATA;

A. CE_CONVERSION B. CE_AGGREGATION C. CE_CALC_VIEW D. CE_CALC

Correct Answer: D

QUESTION NO: 3
What can be used as a source for the data foundation of an analytic view? (Choose two)

A. A table that contains business facts or measures B. A table that contains surrogate IDs referring to primary keys in the attribute views C. A table that contains only descriptive attributes D. A table that contains foreign keys referring to primary keys in the attribute views

Correct Answer: A,D

QUESTION NO: 4
Which of the following tools use SQL to communicate with SAP HANA? (Choose three)

A. SAP BusinessObjects Web Intelligence B. SAP BusinessObjects Information Design Tool C. SAP BusinessObjects Analysis, edition for OLAP D. SAP BusinessObjects Dashboards E. SAP Lumira

Correct Answer: A,B,D

QUESTION NO: 5
You want to add a calculated column to an SAP BusinessObjects Web Intelligence report. In which application do you create the calculation to achieve best report performance?

A. SAP HANA Studio B. Information Design Tool C. Central Management Console D. Web Intelligence

Correct Answer: A

QUESTION NO: 6
Which of the following are direct outputs of an analytic view? (Choose three)

A. Hierarchies B. Measures C. Private attributes D. Restricted attributes E. Attribute views

Correct Answer: B,C,E

QUESTION NO: 7
Which application enables you to create a multisource universe in SAP BusinessObjects BI 4.0?

A. SAP HANA Studio B. Information Design Tool C. Information Engine D. Universe Design Tool

Correct Answer: B

QUESTION NO: 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. Remove the Target Currency property in CURR_CONV C. Maintain valid conversion rate entries in TCUR tables D. Set the Upon conversion failure parameter of CURR_CONV to Ignore

Correct Answer: C,D

QUESTION NO: 9
How can you assess the quality of the loaded data in SAP HANA? (Choose two)

A. Configure the SAP Landscape Transformation tool to implement the data quality process. B. Perform master data quality checks in SAP ERP prior to replication in SAP HANA. C. Compare reports in SAP BusinessObjects against source data for specific selections. D. Compare data from reports in SAP BusinessObjects against the SAP HANA _SYS_STATISTICS table.

Correct Answer: B,C

QUESTION NO: 10
Which of the following describes an SAP HANA analytic view?

A. It is a copy of data after transformation. B. It is a set of tables joined together in a star schema. C. It is a reusable object in attribute views. D. It is a materialized set of data.

Correct Answer: B

QUESTION NO: 11
Which of the following can be grouped when multiple schemas exist in an SAP HANA database?

A. Users B. Data tables C. Packages D. Information models

Correct Answer: B

SAP Certified Application Associate - SAP HANA (Edition 2014) - C_HANAIMP142 Exam Questions