問題一覧
1
"How does SAP position SAP Data Warehouse Cloud in supporting business users?"
Business users can create agile models from different sources
2
You want to run a BW query, but you only have partial authorization for the data selection. What happens related to the BW query in this scenario?
The BW query starts and only the authorized data is displayed
3
You create an SAP HANA HDI Calculation View. What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension?
Provide default time characteristics, Combine master data and transactional data, Aggregate measures as a sum
4
Where can you automatically generate a process chain?
Form a data flow object
5
What does a Composite Provider allow you to do in SAP BW/4HANA?
Combine Infoprovider using Join and Unions, Create new calculated fields Integrate, Integrate SAP HANA HDI calculation views.
6
You use InfoObject B as a display attribute for InfoObject A. Which object properties prevent you from changing InfoObject B into a navigational attribute for InfoObject A?
Attribute Only is set in InfoObject B, InfoObject B is defined as a Key Figure., High Cardinality is set in InfoObject B
7
In a DataStore object (advanced) of type Data Mart, which request-based deletion is possible?
The lastest not-yet-activated request in the inbound table
8
Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)?
DataStore Object (advanced), CompositeProvider, SAP HANA Analysis Process
9
You want to build an SAP HANA HDI 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?
Switch from an aggregation node to a projection node
10
What is the purpose of an architecture overview model?
To identify the required data sources.
11
When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features?
When you define the data transfer process, choose the "Set Manually" setting for "Overrall status of request", When you define the material characteristic, select the "Enhanced Master data update" setting
12
For which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus??
Enhance existing SAP HANA content models, Leverage SQL in-house knowledge
13
Which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP BW/4HANA project?
Check the availability of data, Specify necessary data conversion, Design the data layer concept
14
Which interface do you use to create a BW InfoObjet with access type "SAP HANA view!?
BW modelling perspective in SAP HANA studio
15
What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context?
An ODP source system with contest ODP_CDS must be created in SAP BW/4HANA, The ABAP CDS views must be defined with the appropriate data extraction annotations
16
Which of the following are possible delta-specific field for a generic DataSource in SAP ERP?
Calendar day, Time stamp, Numeric pointer
17
You would like to highlight the deviation from predefined threshold values for key figures actual revenue. Which BW feature do you use?
Exceptions
18
You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different attribute values assigned. How do you design the model?
Compound characteristic "COSTOBJ" with the characteristic for Controlling Area
19
The Database Explorer in the Web IDE for SAP HANA provides a data file import wizard to create a table in SAP HANA from a flat file. What are possible actions after the system suggests the target structure??
Change the order of the fields in the target table, Switch the table type between row store and column store, Adjust the suggested data type of the target table fileds
20
What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA?
There must be no transaction data referring to the cost centers, There must be no hierarchy for the cost centers
21
You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder?
Open ODS view of type Master Data, InfoObject of type Characteristic
22
Which external hierarchy properties can be changed in the query definition?
Expand to level, Sort direction, Position of child nodes
23
You want to build a web-based dashboard with interactive visualizations using Javascript. Which SAP tool can you use to create this?
SAP Analytics Cloud analytics designer
24
Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View?
Composite Provider, BW query
25
You create a transformation from a DataSource to a DataMart Data Store object (advanced) All key figures are updated as Sum. Which Delta methods indicate that the DataSource provides consistent information for this target?
ADD, ABR
26
What are some of the variable types n a BW query that can use the processing type SAP HANA Exit.
Characteristic value, Formula
27
What are some of advantages of using SAP BW/4HANA business content?
Accelerated SAP BW/4HANA implementation using ready-made models, Ability to combine business content objects with custom-defined objects.
28
For InfoObject ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the high Cardinality flag. What is the effect on SID values in this scenario?
SID values are not stored for InfoObject ADDRESS
29
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 settings before you can successfully build the HDB module?
Assign a space
30
What is required before you can integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join) of the same HDI container?
Build the design time file of the HDI Calculation View (data category Dimension) to generate a runtime object.
31
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?
/IMO/
32
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?
SAP Analysis for Microsoft Office
33
Which disadvantages should you keep in mind when you set the High Cardinality flag for a characteristic?
You cannot use navigation attributes for this characteristic, SID numbers are created at runtime which might negatively affect the reporting performance
34
You create a generic DataSource in SAP ERP. "How can you enable your generic DataSource to be used as an ODP_SAP DataSource in SAP BW/4HANA in case it is not available by default?"
Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource
35
Which recommendations should you follow to optimize BW query performance?
Use fewer drill-down characteristics in the initial view, Use mandatory characteristic value variables, Use include functions in the restricted key figures.
36
Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?
Smart Discovery
37
Which features does SAP Analysis for Microsoft Office provide?
Dragging measures in and out of the report, Displaying data simultaneously in a table and a chart, Including more than one data source
38
In a BW query with cells, you need to overwrite the initial definition of a cell. With which cell types can this be achieved??
Selection cell, Formula cell
39
"You have already loaded data from a non-sap system into SAP Data Warehouse Cloud. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA system" What do you need to use to combine data?
SAP ABAP Connection
40
"You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA. Which objects are created when using the ""Generate Data Flow"" function in the Open ODS View editor?
Data source, Transformation, Data Store object (advanced)
41
What are the possible ways to fill a pre-calculated value set (bucket)?
By entering the values manually, By referencing a table, By using a query
42
Why should you run an SAP HANA delta merge?
To decrease memory consumption, To improve the read performance of InfoProviders
43
You are following a top-down method for your SAP BW/4HANA modeling project. What would be your first task?
Collect reporting requirements
44
What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?
5
45
InfoObject CITY is defined as a display attribute for InfoObject CUSTOMER, and InfoObject COUNTRY is defined as a display attribute for InfoObject CITY. In a master data report you want to display the COUNTRY of a CUSTOMER. Which options do you have to realize the scenario?
Combine CUSTOMER, CITY and COUNTRY in a Open ODS View using a sequence of associations., Generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view., Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.
46
How can the delta merge process be initiated in SAP BW/4HANA?
By using a specific process type in a process chain, By using the SAP BW/4HANA data load monitor.
47
You use a measure with semantic type "Amount with Currency Code" in your SAP HANA HDI calculation view. Which kind of currency reference can be assigned to the measure?
Another column of the same SAP HANA view, A fixed currency from table TCURC
48
Which layer of the layered scalable architecture (LSA++) of SAP BW/4HANA is designed as the main storage for harmonized consistent data?
Flexible Enterprise Data Warehouse Core layer.
49
Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (Advanced)?
SAP Data Services, SAP Landscape Transformation Replication Server
50
You have an existing field-based data flow that follows the LSA++ concept with all of its layers. To meet a new urgent business requirement, you want to leverage a characteristic hierarchy with the least amount of effort to change your data flow. Which object do you use to associate an InfoObject?
Open ODS view
51
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?
Only one result row with the sales revenue sum of the top 10 customers
52
In which ODP context is the operational delta queue (ODQ) managed by the target system?
ODP_BW
53
Which join types can you use in a CompositeProvider?
Referential join, Full outer join, Inner join
54
What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?
Request is canceled, records are not tracked, and target is not updated
55
Which source types are available to create a generic DataSource in SAP ERP?
SAP query, Database view, ABAP function module
56
Which data deletion options are offered for a standard DataStore object (advanced)?
Request-based data deletion, Selective deletion of data, Deletion of data from all tables
57
You want to add a Source System of type Big Data in SAP BW/4HANA. Which adapters can you use to reference the remote source system?
Spark SQL Adapter, SAP Vora ODBC adapter
58
Which node types are only available for graphical modeling of SAP HANA HDI Calculation Views (XS Advanced), but not for SAP HANA Calculation Views (XS Classic)?
Intersect, Graph
59
You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values?
Analysis, Information
60
Using SAP HANA as modeling focus, you want to combine data from different sources. Which techniques can you use?
Calculation views, Stored procedures
61
You want to define a restricted column in an SAP HANA calculation view. What do you need to define?
A reference to an existing measure, An aggregation method
62
Which features of an SAP BW/4HANA InfoObject are intended to reduce the physical data volume?
Reference characteristic, Transitive attribute
63
What are benefits of separating master data from transactional data in SAP BW/4HANA?
Allowing different data load frequency, Ensuring referential integrity on your transactional data, Providing language dependent master data texts
64
You want to set up the replication process for the SAP Landscape Transformation Replication Server. Which actions can you define for a specific table?
Apply mapping rules during the replication, Set the reading type and portion sizes
65
What are the key benefits of using the SAP Landscape Transformation Replication Server for data provisioning into SAP HANA?
Real-time and scheduled data replication, Support of cluster and pool tables
66
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?
Use transaction RSA3 (Extractor checker) in SAP ERP, Use program RODPS_REPL_TEST in SAP ERP
67
What foundation is necessary to use SAP S/4HANA embedded analytics?
ABAP CDS view based virtual data model.
68
Why is the start process a special type of process in a process chain?
Only the start process can be scheduled without a predecessor process., The start process cannot be a successor of another process., Only one start process is allowed for each process chain., A start process can only be used in a single process chain.
69
In an SAP HANA HDI Calculation View, you need to combine attributes data (left table) and the data's language-dependent text (right table) using a text join. What should you select to restrict the result set to the logon language?
the language column in the right table
70
You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP standard DataSource oFI_GL_14 (New GL Items). Which transactions can be used to activate this DataSource?
Transaction RSA1 (BI Content) in the SAP BW/4HANA system, Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system
71
You want to combine an existing SAP BW/4HANA Data Model with virtual data from a new non-SAP source system for test purposes. Which approach should you consider for rapid prototyping?
Field-based modeling
72
What can you leverage using the live data connections of SAP Analytics Cloud with SAP BW/4HANA?
Existing authorization concepts, BW data models for analysis
73
What are the reasons for implementing CompositeProviders?
To provide an interface for BW queries, To provide a virtual data mart layer
74
You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time update scenario. Which fields are added to the DataSource automatically?
SDI_CHANGE_TIME, SDI_RECORD_MODE, SDI_CHANGE_TYPE
75
SAP provides three data warehouse solutions to provide customers more flexibility. How is SAP Data Warehouse Cloud positioned?
To support business user with a new self-service tool to model their own data flows
76
You create a DataStore Object(advanced) using the Data Mart DataStore Object modeling property. Which behaviors are specific to this modeling property?
Reporting is done based on a union of the inbound and active tables, The records are treated as if all characteristics are in the key.
77
In an SAP HANA smart data integration flowgraph, which transformation options are available?
Split datasets, Execute a stored procedure, Combine datasets
78
Which development object needs to be built to generate an HDI Container?
HDB module
79
What are benefits of using an InfoSource in a data flow?
Reducing the number of transformations for scenarios with many sources and targets, Connecting sequential transformations in the data flow without storing the data again
80
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 OCALMONTH. Which processing type do you use?
Customer Exit
81
Which objects can be affected by the key date in a BW query?
Navigation attributes, Hierarchies, Display attributes