SAP c-bw4hana-24 practice test

SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x Exam

Last exam update: Feb 26 ,2024
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
C
D
E
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
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
vote your answer:
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
C
D
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
vote your answer:
A
B
C
D
E
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
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2