SAP Certified Application Associate - SAP HANA (Edition 2014) - C_HANAIMP142 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You want to test the quality of SAP HANA data by using a set of results from the source system. How can you retrieve the required data from SAP HANA? (Choose three)

A. Use the data preview in SAP HANA studio. B. Write and execute an appropriate SQL statement. C. Use SAP Landscape Transformation (SLT). D. Use an SAP BusinessObjects client tool (such as Explorer or Web Intelligence). E. Use the database schema _SYS_REPO.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 2

You create a graphical calculation view that is based on analytic views.
What do you use to combine the data from the analytic views?

A. Projection node B. Referential join C. Union D. Aggregation node

Discussion 0

Correct Answer: C Vote an answer

Question 3

What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA? (Choose three)

A. You do not need to create your own queries to access information. B. You can access information for data discovery intuitively. C. You can easily create your own queries to access information. D. You can easily create an IDT business layer. E. You can execute ad-hoc business analytics quickly.

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 4

Which of the following are restrictions of the SAP HANA flat file upload? (Choose two)

A. The upload does not allow changes to the column names of new tables. B. A table must have the same column order as the flat file when you append data. C. A new table always has a 1:1 mapping between the flat file columns and the table columns. D. The upload prevents data type changes when appending data.

Discussion 0

Correct Answer: C,D Vote an answer

Question 5

What is the advantage of reporting directly from column tables?

A. It provides multi-language support B. It supports analytical privileges C. It shifts complex calculations and logic to SAP HANA D. It eliminates the need for additional modeling

Discussion 0

Correct Answer: D Vote an answer

Question 6

Your customer wants to use SAP BusinessObjects Data Services to migrate and transform large volumes of data to SAP HANA. What do you recommend?

A. Use ABAP data flows. B. Use the RFC_READ_TABLE. C. Use IDOCs. D. Use RFC/BAPI function calls.

Discussion 0

Correct Answer: A Vote an answer

Question 7

In an aggregation node of a calculation view, which is the default aggregation type for an aggregated measure?

A. MAX B. MIN C. COUNT D. SUM

Discussion 0

Correct Answer: D Vote an answer

Question 8

Which of the following can be grouped inside a single schema in an SAP HANA database?

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

Discussion 0

Correct Answer: B Vote an answer

Question 9

You have created two analytic views for actual and planned financial data. 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. Create a calculation view.
Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES. B. Create restricted columns for each year for the actual and planned columns in each analytic view.
Combine the analytic views in a new calculation view using a UNION. C. Create an analytic view.
Combine the analytic views in the new analytic view using a referential join. D. Create a calculation view.
Combine the analytic views in the calculation view using a UNION.

Discussion 0

Correct Answer: A Vote an answer

Question 10

Which of the following objects can you use when you build an analytic view? (Choose three)

A. Hierarchies B. Attribute Views C. Analytic Views D. Projections E. Variables

Discussion 0

Correct Answer: A,B,E Vote an answer