Which objects can you combine using a CompositeProvider? Note: There are 2 correct answers to this question.
- A . SAP HANA calculation views
- B . CompositeProvider
- C . InfoSources
- D . Key figures
When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.
- A . The hierarchical structure will be time-dependent.
- B . The structure will contain formulas.
- C . The structure will depend on the order of the row characteristics.
- D . The structure exists in the source system.
- E . The query data will be restricted to a hierarchy node.
you create a new sap hana remote connection .
How does sap hana smart data access (SDA) differ from sap hana smart data integration (SDI)? (2 answer)
- A . SDI is recommended for data source with limited changesin data structure SDA contains features to act as a full blown ETL tool"
- B . SDI supports data replication in real time SDA does not provide this capability"
- C . SDI requires an additional sap hana data provisioning server SDA is integrated in the sap hana index server"
- D . SDI is used only for sap hana native apps the SDA interface is used for sap bw/4hana models"
You want to validate your SAP HANA data model .
What must you ensure to use the data preview functionality?
- A . The _SYS_BIC user is created in the system and the runtime information is written to_SYS STATISTICS.
- B . You are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user.
- C . The _SYS_REPO user must have sufficient object privileges assigned to your desired schema.
- D . Your content package is assigned with sufficient repository privileges to the SYS REPO user.
What can you do when you use process chains? Note: There are 2 correct answers to this question.
- A . Trigger delta merge.
- B . Activate requests in DataStore objects (advanced).
- C . Generate transformations.
- D . Activate data transfer processes (DTPs).
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
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.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
How do you enable streaming mode for a process chain?
- A . Navigate to Process Chain Maintenance (RSPC).
Select Streaming Mode in the process chain attributes. - B . Navigate to Customizing (SPRO).
Change the general settings for SAP BW/4HANA. - C . Navigate to Modeling DW Workbench (RSA1).
Activate streaming mode on the Current Settings Folder tab. - D . Navigate to Process Chain Maintenance (RSPC).
Add a new process variant for streaming mode.
Where can you integrate an analysis view from SAP Analysis for Microsoft Office? Note: There are 3 correct answers to this question.
- A . In another SAP Analysis for Microsoft Office workbook
- B . In an SAP BusinessObjects Web Intelligence report
- C . In a BW query
- D . In a Projection node of an SAP HANA calculation view
- E . In an SAP Crystal Reports for Enterprise report
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.
- A . A fixed currency
- B . A currency from a currency conversion
- C . A currency from another column
- D . A currency from an SAP HANA content calculation view
- E . A currency from SAP BW customizing
Which of the following are strengths of SAP S/4HANA embedded analytics? Note: There are 2 correct answers to this question.
- A . Operational data is accessed in real time.
- B . Redundant data is reduced.
- C . Cross-system consistency is generated.
- D . Historical data for strategic decisions is stored.
Which SAP BW/4HANA objects can keep persistent data? Note: There are 2 correct answers to this question.
- A . Key figure InfoObjects
- B . InfoSource
- C . Characteristics InfoObjects
- D . DataStore object (advanced)
What must you do to define an Inventory InfoProvider in SAP BW/4HANA? Note: There are 3 correct answers to this question.
- A . Select the All Characteristics are Key model property.
- B . Select the Unique Data Records model property.
- C . Assign at least one non-cumulative key figure.
- D . Assign at least one cumulative key figure.
- E . Select the Inventory model property.
what must you do if you want to use an object from business content in sap bw/4hana?
- A . activate the object in data warehousing workbench
- B . identify the business content object in sap hana studio
- C . copy the business content object into customer name space
- D . convert the object from A version to D version
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?
- A . Counter
- B . Customer
- C . Country
- D . Year
what is the effect of using the RODPS_REPL_TEST program to test sap erp operational data provisioning (ODP) data source? (2 answer)
- A . the reset delta fuction affects all ODP delta queues
- B . the program behaves as an additional subscriber
- C . the program behaves like the sap rsa3 extractor checker
- D . the application data is physically written to the queue
What happens if a query with time-dependent attributes is executed but NO query key date is set?
- A . The current date is used as key date.
- B . The system displays only NON-time-dependent attributes.
- C . The valid from date of the attribute is used as key date.
- D . The system displays an error message.
Which sources types can you select when you create an Open ODS view? Note: There are 3 correct answers to this question.
- A . SAP BW DataSource
- B . Characteristic
- C . Virtual table using SAP HANA smart data access
- D . Transformation
- E . InfoSource
Why do you recommend the virtual data mart layer? Note: There are 2 correct answers to this question.
- A . To build an interface for queries and reports
- B . To combine different InfoProviders using Join operations or Union operations
- C . To combine centrally managed data with local files
- D . To build corporate memory for reconstructions
Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question.
- A . SAP HANA models as part providers in CompositeProviders
- B . ABAP Managed Database Procedures in an SAP BW/4HANA transformation
- C . Query settings fo read near-line storage data
- D . Activation of a DataStore object (advanced)
- E . Global transfer routines for master data harmonization
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?
- A . A reinitialization for sales orders in SAP ERP was triggered using the logistics cockpit, which deleted the purchase order item initialization.
- B . All old purchase orders in SAP ERP were archived overnight before the delta loads.
- C . Purchasing extractors in SAP ERP were set up with Queued Delta update mode and the collective run job was NOT scheduled.
- D . Another SAP BW/4HANA system already picked up the new purchase orders using a delta load
Why do you recommend modeling a data layer in SAP BW/4HANA? Note: There are 2 correct answers to this question.
- A . To pre-define a data layout
- B . To fulfill snapshot requirements
- C . To immediately display changed entries
- D . To homogenize and cleanse data from different sources
Which condition must you ensure if you want to replicate data based on a view with SAP Landscape Transformation Replication Server?
- A . View-based data result sets must be kept persistent first until data replication can take place.
- B . An SAP HANA source system must be defined to consume the view.
- C . Each table of the view requires a defined trigger to enable data replication.
- D . One table as part of the view has to be defined as primary table and is used to trigger data replication.
You need to restrict a sales report to the products that make up 50% of the total revenue .
Which BW query feature do you use?
- A . Condition
- B . Calculated key figure
- C . Restricted key figure
- D . Exception
Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question.
- A . The table will be integrated into a native SAP HANA calculation view.
- B . Aggregation and fast search is required for query execution.
- C . When the table is accessed, all columns of a single record are processed.
- D . The values in the columns are different. Therefore, data compression would NOT have much effect.
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?
- A . JavaScript perspective
- B . BW modeling perspective
- C . ABAP perspective
- D . SAP HANA modeler perspective
which advantages can you leveragewhile importing data into a new sap hana table using a flat file? (2 answer)
- A . adjustement for column, type, lenght, and name is possible
- B . easiness of loading
- C . trasformation capabilities
- D . availability of delta logic
Which of the following use cases is classified as operational reporting?
- A . Year-to-date comparison reports containing prior and actual year numbers
- B . Evaluation of trends over several years
- C . Reporting requirements with monthly data refreshes
- D . Near-real-time access to original transactional values
Which property settings can you assign for a characteristic? Note: There are 3 correct answers to this question.
- A . Useable as InfoProvider
- B . Authorization-Relevant
- C . High Precision
- D . Stock Coverage
- E . Attribute Only
Where can you apply a currency conversion? Note: There are 3 correct answers to this question.
- A . In an SAP BW/4HANA InfoSource
- B . In an SAP BW/4HANA transformation
- C . In an SAP HANA calculation view
- D . In an SAP BW/4HANA data transfer process (DTP)
- E . In a BW query