EMT Practice Test

1. Question Content...

---

Question1: For which SAP BW/4HANA objects can you generate SAP HANA calculation views?

Question2: why can tasks be executed faster if the application uses SAP HANA as a database? Please choose the correct answer.

Question3: Where does monitoring and scheduling take place in SAP BW/4HANA as of SP 08?

Question4: What do you have to consider when you create a query with multiple structures?

Question5: you loaded a 5 mb table from a source system to SAP BW/4HANA. How do you explain that the size of the tables is reduced to 1 MB?
Please choose the correct answer.

Question6: you set up the 2LIS_02_iTM(Purchasing line item) data source in SAP ERP using the logistics cockpit.
afteward,you successfully run the initialization into SAP BW/4HANA.
Your delta load into SAP BW/4HANAShows zero records even through new purchase orders were created.
How do you explain that the delta records do NOT appear in SAP BW/4HANA?
Please choose the correct answer.

Question7: Identify issue affecting query performance that you, as a BI administrator, are responsible for.

Question8: Where can you use flowgraphs?

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

Question10: In which of the following elements can data transformation take place in Data Flow 3.X?

Question11: filter is defined to apply to the whole querybut a restricted key figure only filters a single key figure value.
Determine whether this statement is true or false.

Question12: Where should queries be modeled when the ADSO is partitioned semantically?

Question13: What are the characteristics of a data warehouse?
Note: There are 2 correctanswers to this question.

Question14: which SAP Tool do yousuggest to create a pixel-precise formatted report? Please choose the correct answer.

Question15: For which table type does SAP HANA compress data?

Question16: why do you recommend the virtual data mart layer? there are 2 correct answers to this question.

Question17: Is it possible to extend SAP HANA EIM with custom adapters?

Question18: 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? Please choose the correct answer.

Question19: you need to consume remote HADOOP data in your SAP HANA Native App. which components can you use? there are 3 correct answers to this question.

Question20: What is used to develop BW queries in SAP BW/4HANA?

Question21: Which properties determine the delta process within the operational Data provisioning(ODP)delta management for Datasources?
There are 2 correct answers to this question.

Question22: What are the modeling objects for persistency in SAP BW/4HANA?
Note: There are 2 correct answers to this question.

Question23: Whatmust you do to define an inventory infoprovider in SAP BW/4HANA? there are 3 correct answers to this question.

Question24: How many hierarchies can be created for a key figure?

Question25: which objects can be affected by the key date in a BW query? there are 2 correct answers to this question.

Question26: for which business requirements do you suggest an SAP BW/4HANA Modeling focus rather than an SAP HANA modeling focus?

Question27: you need to use an SAP ERP standards Datasource to load into SAP BW/4HANA.Which prerequisite mustbe fulfilled to use the Datasource in the operational Data provisioning context? Please choose the correct answer.

Question28: What is the in-app help for the SAP BW/4HANA cockpit?

Question29: Which SAP BW/4HANA objects can keep persistent data? there are 2 correct answers to this question.

Question30: you create a Datasource object(advanced)using model template standard datastore object.which flags are set?
there are 2 correct answers to this question.

Question31: How can you use formula variables? Choose the correct answers.

Question32: What are desired outcomes of an SAP BW/4HANA pilot project? There are 3 correct answers to this question.

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

Question34: which objects can you associate with a source field that is defined as a characteristic within an open ODS View? there are 2 correct answers tothis question.

Question35: which source types can you use for a generic Datasource? There are 2 correct answers to this question.

Question36: which objects can you combine using a Compositeprovider? there are 2 correct answers to this question.

Question37: Some advantages of BI Content are: Choose the correct answer(s):

Question38: How can you persist data from any SAP HANA database table to a table in the SAP BW Schema? There are 2 correct answers to this question.

Question39: Your main BW Query contains a characteristic value variable with areplacement path from a query when is the pre-query executed?
Please choose the correct answer.

Question40: you need to load data from a generic Datasource using operational Data provisioning(ODP).In which sequence do you perform the activities? Please choose the correct answer.

Question41: you need to inetrgrate data from serveral SAP systems and non-SAP Systems to support real-time analytics.
why do you recommend the SAPlandscape transformation(SLT)REPLICATION SERVER FOR real-time data replication into SAP HANA?
Please choose the correct answer.

Question42: Implementation in support of a targeted business process?

Question43: The InfoCube stores transaction data on a detailed level.Determine whether this statement is true or false.

Question44: Non-SAP data sources can load data into SAP BW via which of the following elements?

Question45: Where are the partitions for Data Tiering Optimization (DTO) with SAP BW/4HANA created?

Question46: 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? There are 2 correct answers to this question.

Question47: why do you define a custom table as a row store table? there are 2 correct answers to this question.

Question48: What can you achieve with rule groups in an SAP BW transformation?
Note: There are 2 correct answers to this question.

Question49: Should the usage of InfoObjects generally be avoided in a state-of-the-art data model in SAP BW/4HANA?

Question50: 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? there are 2 correct answers to this question.

Question51: Which of the following are ways in whichjoins can be made using SAP BW on SAP HANA?

Question52: You need to ensure that authorizations for thecharacteristic company code are checked before data from a BW query is displayed. What must you define?

Question53: Which statement for field-based modeling in SAP BW/4HANA is true?

Question54: whencan you NOT use a characteristic with the high cardinality property? there are 3 correct answers to this question.

Question55: Which functionality does the SAP Landscape Transformation Replication Server support?
Please choose the correct answer.

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

Question57: where can you apply a currency conversion? there are 3 correct answers to this question.

Question58: for which infoprovider types can you selectnavigation attributes? there are 2 correct answers to this question.

Question59: On which of the following devices does the SAP BW/4HANA cockpit run?
Note: There are 2 correct answers to this question.

Question60: Which of the following is required to perform currency conversion in an SAP HANA information model?

Question61: which of the following are strengths of SAP S/4HANA embedded analytics? there are 2 correct answers to this question.

Question62: Which of the following is a key consideration when implementing a modern data warehouse with SAP BW/4HANA?

Question63: 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?
Please choose the correct answer.

Question64: What is the central point of entry for all modeling tasks in SAP BW/4HANA?

Question65: For which of the followingrevenue reporting requirements do you create restricted key figures? Please choose the correct answer.

Question66: When youselect a query for translation in the Data Warehousing Workbench, you must also manually select the query objects for translation. Determine whether this statement is true or false.

Question67: On which of the following objects can you restrict a characteristic?

Question68: InfoProviders are technical tables joined in some way. They are constructed using fields in BI that we call________. Choose the correct answer(s).

Question69: You load a Datastore object(advanced)every night, where can you delete the request you loaded two nights ago without deleting the last request? Please choose the correct answer.

Question70: What are key capabilities of SAP Agile Data preparation? There are 3 correct answers to this question.

Question71: how do you model plant-specific attributes for the characteristic material? Please choose the correct answer.