EMT Practice Test

1. Question Content...

---

Question1: You need to determine the number of customers in each country that have revenue in 2018. What is the reference InfoObject in an exception aggregation?

Question2: Your main BW query contains a characteristic value variable with a replacement path from a query.
When is the pre-query executed?

Question3: Which settings can you define in a data transfer process (DTP) if you load data into a DataStore object (advanced)?
Note: There are 3 correct answers to this question.

Question4: Where can you apply a currency conversion? Note: There are 3 correct answers to this question.

Question5: You need to use an SAP ERP standard DataSource to load data into SAP BW/4HANA. Which prerequisite must be fulfilled to use the DataSource in the Operational Data Provisioning context?

Question6: What are key capabilities of SAP Agile Data Preparation Note: There are 3 correct answers to this question.

Question7: You need to enable real-time streaming using SAP HANA smart data integration (SDI) to load data into a DataStore object (advanced). What are prerequisites for this requirement? Note: There are 2 correct answers to this question.

Question8: You set up the 2LIS_02_ITM (Purchasing Line Item) data source in SAP ERP using the logistics cockpit.
Afterward, you successfully run the initialization into SAP BW/4HANA. Your delta load into SAP BW/4HANA shows zero records even though new purchase orders were created. How do you explain that the delta records do NOT appear in SAP BW/4HANA?

Question9: You plan to regularly transfer changes from an SAP ERP custom table to SAP BW/4HANA. An additional custom development may NOT be implemented in the source system. Which Operational Data Provisioning (ODP) source system type do you recommend?

Question10: You model a second SAP BW/4HANA CompositeProvider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider. What must you do first?

Question11: Which objects can you use as components in a CompositeProvider in SAP BW/4HANA? Note: There are 2 correct answers to this question.

Question12: Which reporting object do you use to combine data from different SAP BW InfoProviders?

Question13: You load a DataStore object (advanced) every night. Where can you delete the request you loaded two nights ago without deleting the last request?

Question14: What must you do to define an Inventory InfoProvider in SAP BW/4HANA? Note: There are 3 correct answers to this question.

Question15: 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.

Question16: For which InfoProvider types can you select navigation attributes? Note: There are 2 correct answers to this question.

Question17: Which condition must you ensure if you want to replicate data based on a view with SAP Landscape Transformation Replication Server?

Question18: Which object is a target of an SAP BW transformation?

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

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

Question21: Which property settings can you assign for a characteristic? Note: There are 3 correct answers to this question.

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

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

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

Question25: In which sequence can you create a reusable key figure structure? Note: There are 2 correct answers to this question.

Question26: What can you create within the SAP BW data flow object? Note: There are 2 correct answers to this question.

Question27: Where can you integrate an analysis view from SAP Analysis for Microsoft Office? Note: There are 3 correct answers to this question.

Question28: 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?