EMT Practice Test

1. Question Content...

---

Question1: What can you do when you use process chains? Note: There are 2 correct answers to this question.

Question2: Which actions can you perform with an SAP HANA calculation view that has the DIMENSION data category assigned?
Note: There are 2 correct answers to this question.

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

Question4: With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework. Which technical namespace is assigned to identify the new SAP ERP-related business content?

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

Question6: Which of the following use cases is classified as operational reporting?

Question7: You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter. Which offset do you need to retrieve the corresponding quarter of the previous year?

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

Question9: Which variables types allow filter values to be determined based on the user's authorizations? Note:
There are 2 correct answers to this question.

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

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

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

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

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

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

Question16: Which SAP tool do you suggest to create a pixel-precise formatted report?

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

Question18: Which objects can you combine using a CompositeProvider? Note: There are 2 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 properties determine the delta process within the Operational Data Provisioning (ODP) delta management for DataSources?
Note: There are 2 correct answers to this question.

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

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

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

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

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

Question26: You expect to have more than 2 billion records as master data references for a characteristic in your data model and want to use the high cardinality option.
What do you need to consider in reporting?

Question27: For which of the following revenue reporting requirements do you create restricted key figures?

Question28: Which action can you perform with an SAP HANA calculation view dimension data category assigned? (2 answer)

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

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

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

Question32: you need to determinate the number of customers that have revenue in 2018 for each countries. What is the reference infoobject in an exception aggregate?

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

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

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

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

Question37: Which objects of an SAP HANA calculation view of DIMENSION data category can you re-use if you define an SAP calculation view of CUBE data category with star join? Note: There are 2 correct answers to this question.

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