SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x - C_BW4HANA

Question 1

You loaded a 5 MB table from a source system to SAP BW/4HANA. How do you explain that the size of the table is reduced to 1 MB?

A. The target is defined as row store without delta merge execution. B. The target is defined as row store and a delta merge job was executed. C. The target is defined as column store and a delta merge job was executed. D. The target is defined as coiumn store without delta merge execution.

Discussion 0

Correct Answer: C Vote an answer

Question 2

You define a new generic DataSource in SAP ERP with
Atime stamp as the delta characteristic
A value for the Safety interval Lower Limit
A new status for changed records.
How does this impact how you model the data target in SAP BW/4HANA?
Note: There are 2 correct answers to this question.

A. The data target can be a DataStore object (advanced) of the Standard DataStore Object model template. B. The data target can be a DataStore object (advanced) of the InfoCube model template. C. The data target must be modeled with a characteristic for the safety interval. D. The data target must be able to manage duplicate records.

Discussion 0

Correct Answer: A,D Vote an answer

Question 3

For which business requirements do you suggest an SAP BW/4HANA modeling focus rather than an SAP HANA modeling focus?
Note: There are 2 correct answers to this question.

A. Leverage SQL in-house knowledge. B. Use existing HANA content models. C. Load snapshots or deltas on a periodic basis. D. Report on a harmonized set of master data.

Discussion 0

Correct Answer: A,B Vote an answer

Question 4

Which objects can you combine using a CompositeProvider? Note: There are 2 correct answers to this question.

A. CompositeProvider B. SAP HANA calculation views C. InfoSources D. Key figures

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

Which query property do you set to minimize the initial run time for the query read mode?

A. Read data when you navigate or expand hierarchies. B. Read all data at once. C. Read data individually from InfoProvider. D. Cache is inactive.

Discussion 0

Correct Answer: A Vote an answer

Question 6

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

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

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 7

You need to load data from a generic DataSource using Operational Data Provisioning (ODP). In which sequence do you perform the activities?

A. 1. Create a DataSource.
2. Run job RODPS_OS_EXPOSE.
3. Replicate the DataSource.
4. Activate the DataSource. B. 1. Create a DataSource.
2. Activate the DataSource.
3. Run job RODPS_OS_EXPOSE.
4. Replicate the DataSource. C. 1. Create a DataSource.
2. Replicate the DataSource.
3. Activate the DataSource.
4. Run job RODPS_OS_EXPOSE. D. 1. Create a DataSource.
2. Replicate the DataSource.
3. Run job RODPS_OS_ EXPOSE.
4. Activate the DataSource.

Discussion 0

Correct Answer: A Vote an answer

Question 8

Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question.

A. The table will be integrated into a native SAP HANA calculation view. B. The values in the columns are different. Therefore, data compression would NOT have much effect. C. Aggregation and fast search is required for query execution. D. When the table is accessed, all columns of a single record are processed.

Discussion 0

Correct Answer: B,D Vote an answer

SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x - C_BW4HANA_20 FREE EXAM DUMPS QUESTIONS & ANSWERS