EMT Practice Test

1. Question Content...

---

Question1: Which Of the following are valid data deletion options for a standard DataStore Object (advanced)? (3)

Question2: You want to build an SAP HANA calculation view of data category CUBE, but you get the "no measure defined" error. For the business requirement, a measure does not make sense. Besides changing the data category to DIMENSION, what do you have to do?

Question3: You define a remote subscription Of type INSERT in an SAP RANA Smart Data Integration (SOI) real-tine update scenario. Which fields are added to the DataSource automatically? (3)

Question4: What are benefits of using an InfoSource in a data flow? Note: There are 2 correct Answers to this question.

Question5: You use SAP HANA to integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join). What do you need to do before you can integrate the HDI Calculation View (data category Dimension)?

Question6: In a Datastore Object (advanced) of type Data Mart, which request can be deleted? (1)

Question7: You have created an SAP HANA Calculation View in SAP Web IDE for SAP HANA and want to integrate it into an SAP BW/4HANA CompositeProvider. Which "Settings for HANA Consumption in BW" in transaction SPRO can you use in this scenario? Note: There are 2 correct Answers to this question.

Question8: What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question.

Question9: Which development object needs to be built to generate an HDI Container?

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

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

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

Question13: You need to create a CompositeProvider to combine data from an SAP HANA calculation view with a DataStore object (advanced). Which of the following Eclipse perspectives do you use?

Question14: For which SAP BW/4HANA objects is it possible to create an external SAP HANA view?
There are 2 correct answers to this question.

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

Question16: You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? (2)

Question17: You want to define a restricted column in an SAP HANA calculation view. What do you need to define? Note: There are 2 correct answers to this question.

Question18: Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct Answers to this question.

Question19: You are required to provide an analysis allowing selections among specific months (for seasonal reasons). Therefore you want to prefil a variable for processing this request. Which processing type should you use? (1)

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

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

Question22: You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? Note: There are 2 correct answers to this question.

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

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

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

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

Question27: Which of the following are posible delta-specific field for a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.

Question28: Which join types can you use in a CompositeProvider? Note: There are 3 correct Answers to this question.

Question29: What are benefits of separating master data from transactional data in SAP BW/4HANA? Note: There are 2 correct Answers to this question.

Question30: Which of the following is the core workflow when working with SAP Analytics Cloud?
Please choose the correct answer.

Question31: Your company is using SAP S/4HANA as a business operational system and you have to provide operational anatytical reports. Why might you consider SAP SAHANA embedded analytcs? (1)

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

Question33: You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first persistent data layer in SAP BW/4HANA. Which options do you have to analyze a potential extractor issue? Note:
There are 2 correct Answers to this question.

Question34: You create a report with SAP Crystal Reports for Enterprise and need an analysis view as a data source.
Which tool can you use to create this analysis view?

Question35: For a BW query, you want to have the first month of the current quarter as a default value for an input- ready BW variable for the characteristic 0CALMONTH. Which processing type do you use?

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

Question37: Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?

Question38: You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum) If you keep the default settings of the BW query, what is presented regarding the result rows?

Question39: What are the prerequisites for deleting master data (for example, cost centers) SAP BWZHANA? (2)

Question40: Which external hierarchy properties can be changed the query definition? (3)

Question41: You create a DataStore object (advanced) using the "Data Mart DataStore Objetc" modeling property. Which behaviors are specific to this modeling property? Note: There are 2 correct answers to this question.

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

Question43: For which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus? Note: There are 2 correct Answers to this question.

Question44: In a DataStore object (advanced) of type Data Mart, which request-based deletion is possible?

Question45: For which table type does SAP HANA compress data?
Please choose the correct answer.

Question46: What are some of the prerequesites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? Note: There are 2 correct answers to this question.

Question47: You need to combine attributes data (left table) and the datas language-dependent texts (right table) using a text join. You want to restrict the result set to the logon language. What do you need to select? (1)

Question48: Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP) ? Note: There are 3 correct answers to this question.

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

Question50: What kind of cold data tiering options do you have with SAP BW/4HANA? Note: There are 2 correct Answers to this question.

Question51: In a BW query with cells, you need to overwrite the initial definition of a cell. With which cell types can this be achieved? Note: There are 2 correct Answers to this question.

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

Question53: You would like to highlight the deviation from predefined theshold values for key figures actual revenue. Which BW feature do you use?

Question54: In the Web IDE for SAP HANA workspace, you have imported a project including an HDB module with calculation views. What do you need to do in the project sittings before you can successfully build the HDB module?

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

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

Question57: What are the possible ways to fill a pre-calculated value set (bucket)? (3)

Question58: The SAP S/4HANA virtual data model (VDM) is buit with ABAP-managed COS views.
What are some of the prerequisites for using these SAP S4HANA ABAP COS views for eextraction into SAP BW/4HANA in an ODP
context? (2)

Question59: With SAP BW/4HANA 2.0, SAP introduced a new capability called Write Interface for DataStore objects (advanced). Which SAP solutions can leverage this interface to push data into the inbound table of DataStore objects (advanced)? Note: There are 3 correct Answers to this question.

Question60: Which SAP BW/4HANA objetcs can be used as sources of a data transfer process (DTP)? Note: There are 3 correct answers to this question.

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

Question62: You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP Standard DataSource 0FI_GL_14 (New GL Items). Which transactions can be used to activate this DataSource? Note: There are 2 correct Answers to this question.

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

Question64: What are the reasons for implementing CompositeProviders? (2)

Question65: In which ODP context is the operational delta queue (ODQ) managed by the target system?

Question66: Which data deletion options are offered for a standard DataStore object (advanced)? Note: There are 3 correct Answers to this question.

Question67: You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note: There are 2 correct Answers to this question.

Question68: Why should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question.

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

Question70: How can you ensure that the delta merge process will be initiated? (3)

Question71: What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA?
Note: There are 2 correct Answers to this question.

Question72: You want to build Web-based dashboards with interactive visualizations. Which SAP tool would you use?

Question73: Considering the mixed modeling approach, what can you do an SAP HANA calculation view exclusively?

Question74: You create a transformation from a DataSource to a DataStore Object (advanced). The DataSource provides an additive-image delta for dat
a. Which key figure aggregation type do you select? (1)

Question75: You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP Standard DataSource 0FI_GL_ 14 (New GL Items). Which transaction can be used to activate this DataSource? (2)