SAP Certified Application Associate - SAP HANA (Edition 2016) - C_HANAIMP

Question 1

You are implementing the SAP CO-PA Accelerator to enable real-time profitability reporting. Which configuration steps must you do?

A. Configure the SAP BusinessObjects Data Services replication jobs. B. Activate continuous data replication of tables CE1xxxx, CE2xxxx, CE4xxxx. C. Build attribute and analytic views in SAP HANA. D. Install the SAP HANA database clients on all SAP ERP application servers. E. Create a secondary database connection in SAP ERP.

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 2

In SAP HANA, which join type yields the same results as a referential join when fields from both tables are selected?

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

Discussion 0

Correct Answer: B Vote an answer

Question 3

You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this?

A. Choose an attribute to define restricted values for it. B. Assign restricted values to the attribute view. C. Assign values to be restricted to a content table. D. Assign the analytic privilege to a user or role. E. Assign values to be restricted. Choose at least one information model to assign restrictions.

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 4

Which of the following should you try to implement as best practices for data modeling? (Choose two)

A. Execute calculated columns before any aggregation is performed. B. Use filters to restrict the number of rows on the tables that make up the analytic views. C. Use a UNION when combining analytic views in a calculation view. D. Perform aggregation in an attribute view.

Discussion 0

Correct Answer: B,C Vote an answer

Question 5

What are the consequences of executing the Stop activity on the Data Provisioning view in the SAP HANA studio for a table that is currently replicated?

A. Triggers and logging tables are deleted. B. The replication of the table is temporarily stopped and can be resumed. C. Triggers and logging tables are kept D. The table is dropped from the SAP HANA database.

Discussion 0

Correct Answer: A Vote an answer

Question 6

You have created an MS Excel report on SAP HANA data.
On which of the following could you store the Excel file and make it available for other users?

A. Shared network drive B. SAP HANA studio Content node C. SAP HANA database D. SAP BusinessObjects Information Design Tool

Discussion 0

Correct Answer: A Vote an answer

Question 7

Which of the following are restrictions of the SAP HANA flat file upload?

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

Discussion 0

Correct Answer: B,D Vote an answer

Question 8

A company loads data every night from several source systems into multiple tables in SAP HANA using complex transformation rules. The calculation view that joins these tables performs unexpectedly slow. Which of the following could you investigate to be able to improve performance?

A. Whether the calculation view needs to create large intermediate result sets. B. Whether savepoints are written during execution. C. Whether an InfoCube compression is running. D. Whether the joins and transformations of the tables can be moved to the data loading process of SAP BusinessObjects Data Services.

Discussion 0

Correct Answer: A,D Vote an answer

Question 9

What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA?

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 10

What is the advantage of creating analytic views in SAP HANA over reporting directly from column tables? (Choose two)

A. Eliminating the need for additional modeling. B. Supporting analytical privileges. C. Reporting directly from SAP BusinessObjects Web Intelligence. D. Shifting of complex calculations and logic to SAP HAN

Discussion 0

Correct Answer: B,D Vote an answer

Question 11

How can you improve the performance of an information model?

A. Use constraint filters. B. Use generated columns. C. Use attribute views wherever possible. D. Use analytic views wherever possible. E. Use indexes on all measures.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 12

You need real-time profitability reporting from an SAP ECC system running on a non-SAP database. Which of the following steps must you perform to implement the SAP CO-PA Accelerator? (Choose two)

A. Build attribute and analytic views in SAP HANA. B. Install SAP HANA as a secondary database. C. Create an SAP Landscape Transformation configuration. D. Configure an ABAP dataflow in SAP Data Services.

Discussion 0

Correct Answer: B,C Vote an answer

Question 13

A customer wants to report on large amounts of SAP HANA data. The users want to drill from the top aggregation level to the lowest granularity and try different types of graphical representations of the data on the fly.

A. SAP BusinessObjects Crystal Reports for Enterprise B. SAP BusinessObjects Dashboards C. SAP BusinessObjects Explorer D. SAP BusinessObjects Web Intelligence

Discussion 0

Correct Answer: C Vote an answer

SAP Certified Application Associate - SAP HANA (Edition 2016) - C_HANAIMP_11 FREE EXAM DUMPS QUESTIONS & ANSWERS