EMT Practice Test

1. Question Content...

---

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

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

Question3: what is the effect of using the RODPS_REPL_TEST program to test sap erp operational data provisioning (ODP) data source? (2 answer)

Question4: what can you do in the sap bw/4hana cockpit? (3 answer)

Question5: what must you do if you want to use an object from business content in sap bw/4hana?

Question6: You loaded a 5 mb table from a non sap source system to sap bw/4hana.
How do you explain that the size of the table is reduce to 1 mb?

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

Question8: For which business requirement do you suggest an SAP BW/4HANA modeling focus rather than an SAP HANA modeling focus? (2 answer)

Question9: You define a temporal condition for a temporal join in a calculation view. Which column data types are supported?
Note: There are 3 correct answers to this question.

Question10: which are the additional tables for the enhanced master data update for the characteristic with technical name material? (3 answer)

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

Question12: You need to create a composit provider to combine data from an SAP HANA calculation view with a datastore object(advanced). Which user interface do you use to create a composit provider?

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

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

Question15: When modeling a characteristic, which SAP BW/4HANA feature are intended to reduce the physical data volume? (2 answer)

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

Question17: You need to combine master data (right table) and transactional data (left table) using a referential join.
How will this referential join behave?

Question18: How do you model plant-specific attributes for the characteristic material?

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

Question20: Which objects can you associate with a source field that is defined as a characteristic within an Open ODS view?
Note: There are 2 correct answers to this question.

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

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

Question23: In which sequence does SAP recommen

Question24: You need to consume remote HADOOP data in your SAP HANA Native App. Which components can you use? Note: There are 3 correct answers to this question.

Question25: You create a transformation from a DataSource to a DataStore object (advanced). The DataSource provides an after-image delta. Which key figure aggregation type do you select?

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

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

Question28: What must you do first if you need to define help cells for formulas in the cell editor?

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

Question30: Which properties determine the delta process within the Operational Data Provisioning (ODP) delta management for DataSources?
Note: There are 2 correct answers to this question.

Question31: You create a BW query. How can you check the navigational attributes of a basic characteristic?

Question32: Which type of BW variable do you use as a dynamic threshold for an exception in a BW query?

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

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

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

Question36: For which activity do you use the key figure matrix?

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

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