What happens when you execute the Trigger Delta Merge operation for a given data target?
A. The data from the delta queue is extracted and merged into the data target.
B. The delta between the new data and the already loaded data is removed.
C. Data is transferred from the delta store to the main store.
D. The before and after images of the delta queues are merged.
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
Which SAP Landscape Transformation Replication Server cockpit operation removes all data from the trigger table?
A. Suspend Replication and Resume Replication
B. Stop Replication and Resume Replication
C. Suspend Replication and Start Replication
D. Stop Replication and Start Replication
You define a temporal condition for a temporal join in a calculation view. Which column data types are
supported?
Note: There are 3 correct answers to this question.
A. Integer
B. Date
C. Decimal
D. Boolean
E. Timestamp
Which objects can you associate with a source field that is defined as a characteristic within an Open ODS
view?
Note: There are 2 correct answers to this question.
A. SAP BW InfoObject
B. Open ODS view type Master Data for Attributes
C. Open ODS view type Facts
D. Open ODS view type Master Data for Hierarchies
Which SAP tool do you suggest to create a pixel-precise formatted report?
A. SAP Lumira, discovery edition
B. SAP Analysis for OLAP
C. SAP Crystal Reports for Enterprise
D. SAP Analytics Cloud
Which advantages does the SAP Lumira template for generic analysis provide? Note: There are 2 correct answers to this question.
A. You can create a bookmark to a navigation state and link it on any Web page.
B. You can use Visual Basic for Applications to improve the design.
C. You can compare two DataSources in one report.
D. You can use it for any BW query or SAP HANA calculation view.
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
Which objects can you use as components in a CompositeProvider in SAP BW/4HANA? Note: There are 2 correct answers to this question.
A. BW query
B. Open ODS view
C. CompositeProvider
D. Semantic group
Which query property do you set to minimize the initial run time for the query read mode?
A. Read all data at once.
B. Read data individually from InfoProvider.
C. Cache is inactive.
D. Read data when you navigate or expand hierarchies.
You need to view the SAP HANA calculation views, SAP BW DataSources, and InfoAreas in the same SAP HANA studio perspective. What should you do?
A. Attach an SAP BW project to an SAP HANA system.
B. Attach an SAP HANA system to an SAP BW project.
C. Attach an ABAP project to an SAP BW project.
D. Attach an SAP BW project to an ABAP project.
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/4HAN
A. 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?
B. A reinitialization for sales orders in SAP ERP was triggered using the logistics cockpit, which deleted the purchase order item initialization.
C. All old purchase orders in SAP ERP were archived overnight before the delta loads.
D. Purchasing extractors in SAP ERP were set up with Queued Delta update mode and the collective run job was NOT scheduled.
E. Another SAP BW/4HANA system already picked up the new purchase orders using a delta load
Which SAP HANA objects are automatically generated if you set the External SAP HANA Calculation View
flag for an SAP BW/4HANA object?
Note: There are 2 correct answers to this question.
A. SAP HANA attribute views
B. SAP HANA calculation views
C. SAP HANA privileges
D. SAP HANA analytic views
For which activity do you use the key figure matrix?
A. Structure the information from the requirement analysis.
B. Provide information on the relations between characteristics.
C. List properties of the data sources.
D. Allocate project resources.
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?
A. -12
B. -4
C. -1
D. -3