C-BW4HANA-24 Exam Training Practice Tests (SAP Certified Application Associate - Reporting. Modeling and Data Acquisition with SAP BW/4HANA 2.x)]

Question 1

When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.

A. The query data will be restricted to a hierarchy node. B. The structure exists in the source system. C. The structure will depend on the order of the row characteristics. D. The structure will contain formulas. E. The hierarchical structure will be time-dependent.

Correct Answer: A,B,E

Question 2

What happens when you execute the Trigger Delta Merge operation for a given data target?

A. The data from the delta queue is extracted and merged into the data target. B. Data is transferred from the delta store to the main store. C. The before and after images of the delta queues are merged. D. The delta between the new data and the already loaded data is removed.

Correct Answer: B

Question 3

You want to model an SAP HANA calculation view by combining the sales orders with the corresponding customer status, which was assigned to the customer when the order was issued. Which join properties do you assign to the required join type?

A. Inner join with Temporal Join properties B. Referential join with Dynamic Join properties C. Referential join with Temporal Join properties D. Inner join with Dynamic Join properties

Correct Answer: C

Question 4

You need to restrict a sales report to the products that make up 50% of the total revenue. Which BW query feature do you use?

A. Restricted key figure B. Exception C. Calculated key figure D. Condition

Correct Answer: D

Question 5

What happens if a query with time-dependent attributes is executed but NO query key date is set?

A. The current date is used as key date. B. The system displays only NON-time-dependent attributes. C. The valid from date of the attribute is used as key date. D. The system displays an error message.

Correct Answer: A

Question 6

you create a new sap hana remote connection. How does sap hana smart data access(SDA) differ from sap hana smart data integration(SDI)? (2 answer)

A. SDI supports data replication in real timeSDA does not provide this capability" B. SDI is recommended for data source with limited changesin data structureSDA contains features to act as a full blown ETL tool" C. SDI is used only for sap hana native appsthe SDA interface is used for sap bw/4hana models" D. SDI requires an additional sap hana data provisioning serverSDA is integrated in the sap hana index server"

Correct Answer: A,B

Question 7

Which of the following are strengths of SAP S/4HANA embedded analytics? Note: There are 2 correct answers to this question.

A. Operational data is accessed in real time. B. Cross-system consistency is generated. C. Redundant data is reduced. D. Historical data for strategic decisions is stored.

Correct Answer: A,C

SAP Certified Application Associate - Reporting. Modeling and Data Acquisition with SAP BW/4HANA 2.x - C-BW4HANA-24 Exam Practice Test