SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x Exam
Last exam update: May 13 ,2025
Page 1 out of 7. Viewing questions 1-15 out of 97
Question 1
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"
Answer:
A, B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 2
you loaded a 5 mb table from a non sap source system to sap bw/4han a. How do you explain that the size of the table is reduce to 1 mb?
A.
the target is defined as a row store without delta merge execution
B.
the target is defined as a column store and a delta merge was executed
C.
the target is defined as a column store without delta merge execution
D.
the target is defined as a row store and a delta merge was executed
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 3
which are the additional tables for the enhanced master data update for the characteristic with technical name material? (3 answer)
A.
/bic/ematerial
B.
/bic/fmaterial
C.
/bic/hmaterial
D.
/bic/gmaterial
E.
/bic/pmaterial
Answer:
A, B, D
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 4
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
Answer:
A
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 5
For which business requirement do you suggest an SAP BW/4HANA modeling focus rather than an SAP HANA modeling focus? (2 answer)
A.
Report on harmonized set of master data
B.
Leverage SQL in house knowledge
C.
Enhance existing SAP HANA content models
D.
Load snapshots or deltas from different source on a periodic basis
Answer:
C, D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 6
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
Answer:
B, D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 7
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
Answer:
A, C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 8
"You created two structures that are defined without key figures. Afterwards, you use both structures in your query definition. How many key figures can the query contain?"
A.
Exactly two key figures
B.
Up to 10 key figures
C.
Any number of key figures
D.
Exactly one key figures
Answer:
D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 9
you need to use a graphical calculation view with the dimension data category. Which constraint applies?
A.
only time dependent attributes are considered
B.
default node aggregation is required
C.
only different record will be visible
D.
the output cannot be used by other calculation view, only in reporting
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 10
To gather the requirements for data model design, which is the logical sequence? (indico solo la risposta corretta)
A.
a
B.
Reporting requirment Source of data Trasformation Storage requirement
Answer:
B
User Votes:
A
50%
B
50%
Discussions
0/ 1000
Question 11
How many SAP BW/4HANA trasformations and delta dtp can you define for the same source target? A. "One SAP BW/4HANA trasformation Multiple delta dtp with different filter" B. "Multiple SAP BW/4HANA trasformation Multiple delta dtp with different filter" C. "One SAP BW/4HANA trasformation One delta dtp" D. "One SAP BW/4HANA trasformation Multiple delta dtp without filter"
Answer:
C
User Votes:
Discussions
0/ 1000
Question 12
Which type of BW variable do you use as a dynamic threshold for an exception in a BW query?
A.
Hierarchy variable
B.
Text variable
C.
Characteristic value variable
D.
Formula variable
Answer:
D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 13
Which action can you perform with an SAP HANA calculation view dimension data category assigned? (2 answer)
A.
Join several table
B.
Define text join
C.
Aggregate measures
D.
Persist master data
Answer:
A, B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 14
what can you do in the sap bw/4hana cockpit? (3 answer)
A.
model, schedule and monitor process chain
B.
manage request in infoobjects and datastore object
C.
model and trasport data flow
D.
model and schedule replication task
E.
maintain data tiering setting
Answer:
A, B, C
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 15
You need to create a composit provider to combine data from an SAP HANA calculation view with a datastore object(advanced). Which user interface do you use to create a composit provider?
A.
Embedded SAP GUI in SAP HANA Studio
B.
SAP BW/4HANA Cockpit
C.
BW modeling perspective in SAP HANA Studio
D.
SAP HANA modeler perspective in SAP HANA Studio