EMT Practice Test

1. Question Content...

---

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

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

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

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

Question5: You want to use the SAP HANA concept of semantic types as part of the currency conversion mechanism. You decide to use semantic type Amount with Currency Code within your SAP HANA calculation view. Which currency reference can be assigned to the measure? Note: There are 3 correct answers to this question.

Question6: Which sources types can you select when you create an Open ODS view? Note: There are 3 correct answers to this question.

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

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

Question9: What must you do if you want to use an object from BI Content?

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

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

Question12: Which SAP Landscape Transformation Replication Server cockpit operation removes all data from the trigger table?

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

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

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

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

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

Question18: Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question.

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

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

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

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

Question23: You use the wizard to create an SAP BW/4HANA Big Data source system. Which activities are mandatory? Note: There are 3 correct answers to this question.

Question24: Which layers are part of the layered scalable architecture for SAP BW/4HANA (LSA++)? Note: There are 2 correct answers to this question.

Question25: Which tables belong to the hierarchy for characteristic OCOUNTRY? Note: There are 3 correct answers to this question.

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

Question27: How do you enable streaming mode for a process chain?

Question28: How many SAP BW/4HANA trasformations and delta dtp can you define for the same source target?

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

Question30: "You created two structures that are defined without key figures. Afterwards, you use both structures in your query definition. How many key figures can the query contain?"

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

Question32: Why do you recommend the virtual data mart layer? Note: There are 2 correct answers to this question.

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

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