Free SAP Certified Application Associate – Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x Exam C_BW4HANA_24 Exam Practice Test

You create a DataStore object (advanced) using model template Standard DataStore Object. Which flags areset?Note: There are 2 correct answers to this question.

• Activate Data
• Write Change Log
• All Characteristics are Key
• Unique Data Records

In which sequence does SAP recommen

• 1. Transformations i---I 2. Reporting requirements3. Sources of data4. Storage requirements
• 1. Reporting requirements 2. Sources of data 3. Transformations4. Storage requirements
• 1. Storage requirements2. Transformations3. Sources of data4. Reporting requirements
• 1. Transformations i---I 2. Sources of data3. Reporting requirements4. Storage requirementsfor the data model design concept?

You need to integrate data from several SAP systems and non-SAP systems to support real-time analytics. Why do you recommend the SAP Landscape Transformation (SLT) Replication Server for real-time data replication into SAP HANA?

• The SLT Replication Server provides flexible multisystem support to manage data replication from SAP and non-SAP source systems.
• The SLT Replication Server provides log reader adapters for SAP and non-SAP sources.
• The SLT Replication Server installed on a productive SAP BW/4HANA system improves the data transfer process.
• Replication Server installation and configuration is always identical for SAP and non-SAP source systems.

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

• 1. Create a DataSource.2. Replicate the DataSource.3. Activate the DataSource.4. Run job RODPS_OS_EXPOSE.
• 1. Create a DataSource.2. Replicate the DataSource.3. Run job RODPS_OS_ EXPOSE.4. Activate the DataSource.
• 1. Create a DataSource.2. Run job RODPS_OS_EXPOSE.3. Replicate the DataSource.4. Activate the DataSource.
• 1. Create a DataSource.2. Activate the DataSource.3. Run job RODPS_OS_EXPOSE.4. Replicate the DataSource.

Your customer is using a pure SAP HANA native data warehouse approach. Which tools should the customerinstall?Note: There are 2 correct answers to this question.

• SAP solutions for enterprise information management
• BW Modeling Tools
• SAP Information Steward
• Process Chain Monitoring app

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

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

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

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

You want to validate your SAP HANA data model. What must you ensure to use the data preview functionality?

• The _SYS_BIC user is created in the system and the runtime information is written to_SYS STATISTICS.
• You are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user.
• The _SYS_REPO user must have sufficient object privileges assigned to your desired schema.
• Your content package is assigned with sufficient repository privileges to the SYS REPO user.

Which SAP BW/4HANA objects can keep persistent data? Note: There are 2 correct answers to this question.

• Key figure InfoObjects
• InfoSource
• Characteristics InfoObjects
• DataStore object (advanced)

which advantages can you leveragewhile importing data into a new sap hana table using a flat file? (2 answer)

• adjustement for column, type, lenght, and name is possible
• easiness of loading
• trasformation capabilities
• availability of delta logic