C_

BW4HANA_
27
Questi
on.1
InanSAPHANAsmar tdat
aint
egrat
ionfl
owgr
aph,whi
chtransf
ormat
ionopt
ionsar
e
avai
labl
e?Not
e:Ther
eare2corr
ectanswerst
othi
squest
ion.

SAPHANAanal
ysi
spr
ocess

Adv
ancedSQL

Dat
afl
owobj
ectgener
ati
on

Codeexecut
ion

Answer
sBD

Questi
on.2
Whichofthefol
l
owi ngarev
ali
ddatadel
eti
onopt
ionsforast
andar
dDat
aSt
oreobj
ect
(adv
anced)?Note:Ther
eare3corr
ectanswer
stothi
squesti
on.

Sel
ect
iondel
eti
oni
ncl
udi
ngsubsequentt
arget
s

Del
eti
onofdat
afr
om al
ltabl
es

Del
eti
onofal
ldat
afr
om act
ivet
abl
eonl
y

Request
-baseddat
adel
eti
on

Sel
ect
ivedel
eti
onofdat
a

Answer
sBDE

Questi
on.3
Yourcompanydeci
dedtouseaHadoopcl usterasadat
astor
agelocat
ion.Whi
ch
componentscanbeusedtoconsumeremot eHadoopdatai
nyourSAPHANAnat i
veapp?
Note:Ther
eare3corr
ectanswerst
othisquestion.

SAPHANASQLcont
rol
l
er

SAPHANAsmar
tdat
aaccess

SAPHANAsmar
tdat
aint
egr
ati
on

Spar
kSQLadapt
er
SAPVor
aODBCadapt
er

Answer
sBCD

Quest
ion.4
Youwanttoactiv
ateanSAPHANAcal cul
ationvi
ewofdatacat
egoryCUBE,buty
ougetthe
"nomeasuredefi
ned"err
or.Fort
hebusi
nessrequi
rement,
ameasuredoesnotmakesense.
Besi
deschangingthecategor
ytoDI
MENSI ON,whatdoyouhavet
odo?

Swi
tchf
rom apr
oject
ionnodet
oanaggr
egat
ionnode.

Swi
tchf
rom anaggr
egat
ionnodet
oar
anknode.

Swi
tchf
rom anaggr
egat
ionnodet
oast
arj
oinnode.

Swi
tchf
rom anaggr
egat
ionnodet
oapr
oject
ionnode.

Answer
sD

Quest
ion.5
I
nwhichODPcont
exti
stheoper
ati
onaldel
taqueue(
ODQ)managedbyt
het
argetsy
stem?

ODP_
HANA

ODP_
CDS

ODP_
BW

ODP_
SAP

Answer
sC

Questi
on.6
Youarerequir
edtoprovi
deananal
ysi
sall
owingsel
ect
ionsamongspeci
fi
cmonths(for
seasonalr
easons)
.Theref
oreyouwantt
oprefi
l
lavari
ablef
orpr
ocessi
ngthi
srequest.
Whichprocessi
ngtypeshoul
dyouuse?

Cust
omerExi
t

Manual
Ent
rywi
thdef
aul
tval
ue

Repl
acementPat
h
Aut
hor
izat
ion

Answer
sA

Questi
on.7
Youexpecttohavemor ethan2bil
li
onr
ecor
dsasmast
erdatarefer
encesfora
char
acter
ist
icinyourdatamodelandwantt
ouset
hehighcar
dinali
tyopt
ion.Whatdoy
ou
needtoconsideri
nreport
ing?

TheSI
Dtabl
eref
erencei
sval
i
dfornav
igat
ional
att
ri
but
esonl
y.

Local
SIDv
aluesar
ecr
eat
edaut
omat
ical
l
ydur
ingr
epor
ti
ng,
whi
chcani
mpactt
her
esponse
ti
me.

TheHi
ghCar
dinal
i
typr
oper
tyneedst
obedef
inedi
ntheComposi
tePr
ovi
der
.

Usi
ngahi
erar
chyoft
hischar
act
eri
sti
cfornav
igat
ionwi
l
limpactr
esponset
ime.

Answer
sD

Quest i
on.8
Youar einvol
vedi
nanSAPBW/ 4HANAprojectf
ocusingonGener al
Ledgerrepor
ti
ngand
wantt ousetheSAPERPStandardDat
aSource0FI_GL_
14( NewGLI tems)
.Which
transacti
oncanbeusedt
oactivat
ethi
sDataSource?Note:Ther
eare2cor r
ectanswer
sto
thisquesti
on.

Tr
ansact
ionRSO2(
Mai
ntai
nGener
icDat
aSour
ce)i
ntheSAPsour
cesy
stem

Tr
ansact
ionRSA1(
BICont
ent
)int
heSAPBW/
4HANAsy
stem

Tr
ansact
ionODQMON(
Moni
torDel
taQueues)i
ntheSAPsour
cesy
stem

Tr
ansact
ionRSA5(
Inst
all
ati
onofDat
aSour
cef
rom Busi
nessCont
ent
)int
heSAPsour
ce
sy
stem

Answer
sBD

Quest
ion.9
Wit
hwhi chquer
yconsi
derat
ionscany
ouopt
imi
zet
hequer
yper
for
mance?Not
e:Ther
ear
e
3corr
ectanswerst
othisquesti
on.

Usei
ncl
udef
unct
ionsi
nther
est
ri
ctedkeyf
igur
es
Usemandat
orychar
act
eri
sti
cval
uev
ari
abl
es

Usechar
act
eri
sti
cfi
l
ter
sthatov
erl
ap

Useexcl
udef
unct
ionsi
nther
est
ri
ctedkeyf
igur
es

Usef
ewerdr
il
l-
downchar
act
eri
sti
csi
nthei
nit
ial
view

Answer
sABE

Question.10
Toachi eveanur gentbusi
nessrequirement,y
ouchooset hefiel
d-basedmodeli
ng
approachbecausenocompl exhar monizat
ionisneeded.Assumingt heLSA++archi
tect
ure
i
sconsi dered,andy ouwanttoleverageacharacter
ist
ichier
archy,onwhichlev
eldoy ou
havetoassi gnanI nfoObj
ectl
ast?

I
ntheSAPHANAcal
cul
ati
onv
iew

I
ntheSAPBW OpenODSv
iew

I
ntheSAPBW Dat
aSt
oreobj
ect(
adv
anced)

I
ntheSAPBW Composi
tePr
ovi
der

Answer
sD

Quest
ion.11
I
naDat aStor
eobj
ect(
adv
anced)oft
ypeDat
aMar
t,whi
chr
equest
scanbedel
eted?

Anyol
derr
equesti
ntheact
ivedat
atabl
e

Anyol
deract
ivat
edr
equesti
nthei
nboundt
abl
e

Thel
atestr
equesti
ntheact
ivedat
atabl
e

Thel
atestnot
-yet
-act
ivat
edr
equesti
nthei
nboundt
abl
e

Answer
sD

Questi
on.12
Whatarebenefi
tsofseparat
ingmast
erdat
afrom t
ransact
ionaldat
ainSAPBW/
4HANA?
Note:Ther
eare2correctanswer
stothi
squesti
on.
I
mpr
over
unt
imeofst
agi
ngpr
ocesses

Av
oidgener
ati
onofSI
Dval
ues

Ensur
ehi
ghcar
dinal
i
tyony
ourdat
a

Ensur
eref
erent
ial
int
egr
it
yony
ourdat
a

Answer
sCD

Quest
ion.13
Youuseameasur ewithsemanti
ctype"AmountwithCur
rencyCode"inyourSAPHANA
cal
cul
ationvi
ew.Whichkindofcurr
encyrefer
encecanbeassignedt
ot hemeasur
e?Not
e:
Ther
eare2cor r
ectanswerst
othisquesti
on.

Af
ixedcur
rencyf
rom t
abl
eTCURC

Anot
hercol
umnoft
hesameSAPHANAv
iew

Acol
umnf
rom anot
herSAPHANAv
iew

Av
ari
abl
eint
hesameSAPHANAv
iew

Answer
sAB

Questi
on.14
Whichfeatur
esdoesSAPAnal
ysi
sforMi
crosof
tOf
fi
cepr
ovi
de?Not
e:Ther
ear
e3cor
rect
answerstothi
squest
ion.

I
ncl
udi
ngmor
ethanonedat
asour
ce

Cr
eat
ingbookmar
ksf
oranav
igat
ionst
ate

Di
spl
ayi
ngdat
asi
mul
taneousl
yinat
abl
eandachar
t

Dr
aggi
ngmeasur
esi
nandoutoft
her
epor
t

Changi
ngcont
extmenuent
ri
es

Answer
sACD

Quest
ion.15
YouopenanSAPAnal
ysi
sforMi
crosof
tOf
fi
cewor
kbook.Onwhi
chDesi
gnPanel
tabscan
y
ouv
eri
fyt
hef
il
terv
alues?Not
e:Ther
ear
e2cor
rectanswer
stot
hisquest
ion.

I
nfor
mat
ion

Component
s

Anal
ysi
s

Desi
gnRul
es

Answer
sAC

Questi
on.16
Whichfeat
uresofanSAPBW/4HANAI nf
oObj
ectar
eint
endedt
oreducet
hephy
sicaldat
a
vol
ume?Not e:Ther
ear
e2cor
rectanswerst
othi
squesti
on.

Enhancedmast
erdat
aupdat
e

Compoundi
ng

Ref
erencechar
act
eri
sti
c

Tr
ansi
ti
veat
tri
but
e

Answer
sCD

Questi
on.17
WithSAPBW/ 4HANA, t
henewHANA- opt
imi
zedbusi
nesscont
enti
sdesignedaccor
dingt
o
theLSA++fr
amewor k.Whicht
echni
calnamespacei
sassi
gnedtoi
dent
if
yt henewSAP
ERP-r
elat
edbusinesscont
ent?

/
IMO/

/
SFA/

/
BW4/

/
0SAP/

Answer
sA

Quest
ion.18
Youwouldli
ket
ohi
ghl
ightt
hedev
iat
ionsbet
weenbudgetandact
ualr
evenuei
nthequer
y.
Whi
chBW f
eat
uredoy
ouuse?

For
mul
avar
iabl
e

Except
ions

Cal
cul
atedkeyf
igur
es

Condi
ti
ons

Answer
sB

Questi
on.19
Whichlayer
soff
ert
hevi
rt
ual
izati
onapproachforthel
ayer
edscal
abl
earchi
tect
ure(
LSA++)
ofSAPBW/ 4HANA?Not
e:Thereare3correctanswer
stothi
squest
ion.

Agi
l
edat
amar
t

Openoper
ati
onal
dat
ast
orel
ayer

Openhubl
ayer

Dat
aacqui
sit
ionl
ayer

Vi
rt
ual
dat
amar
tlay
er

Answer
sABE

Question.20
Youcr eat
edagener icDat
aSour ce,ZWEATHER_
DATA, i
nSAPERPusi ngaf unctionmodul
e.
Youtriedtorepl
icatetheDataSourceinSAPBW/4HANA, butiti
snotavail
abl
ei nthe
ODP_ SAPcontext.Whichprerequisit
emustbef
ulf
il
ledforthi
sDataSourcebeforeyoucan
useitinSAPBW/ 4HANA?

I
tmustber
eleasedf
orODPwi
thpr
ogr
am RODPS_
OS_
EXPOSE.

I
tmustber
eleasedf
orODPwi
thpr
ogr
am BS_
ANLY_
DS_
RELEASE_
ODP.

I
tmusthav
eadel
taqueueent
ryi
ntr
ansact
ionODQMON.

I
tmustbedef
inedwi
thadel
ta-
speci
fi
cfi
elddur
ingdat
asour
cecr
eat
ion.

Answer
sA
Question.21
Youcr eat
eat r
ansfor
mati
onfr
om aDataSourcetoaDataStor
eobject(adv
anced).The
DataSourceprovi
desanaddi
ti
ve-
imagedelt
af ordat
a.Whichkeyf
igureaggregat
ionty
pe
doy ouselect
?

Maxi
mum

Summat
ion

Mi
nimum

Ov
erwr
it
e

Answer
sB

Questi
on.22
Whenloadingmasterdataforamateri
al,
y ouwantt
ohavealookatthenewv al
uesbefore
theyar
ereleasedf
orreport
ing.Whatcouldyoudousingmodel
ingf
eatures?
.Note:There
are2corr
ectanswerstothi
squestion.

Whenyoudefi
nethedat
atr
ansf
erpr
ocess,
chooset
he“
Setmanual
l
y”set
ti
ngf
or“
Over
all
st
atusofr
equest
”.

Whenyoudef
inet
hedat
atr
ansf
erpr
ocess,
sel
ectt
he“
Loadr
ecor
dswi
thnewkeyonl
y”
set
ti
ng.

Whenyoudef
inet
hemat
eri
alchar
act
eri
sti
c,sel
ectt
he“
EnhancedMast
erdat
aupdat
e”
set
ti
ng.

Wheny
oudef
inet
heat
tr
ibut
esofmat
eri
al,
sel
ectt
he“
TimeDependent
”set
ti
ng.

Answer
sBC

Questi
on.23
Whichusergroupi
stheDi
git
alBoar
droom desi
gnedf
or?

Busi
nessexecut
ives

I
Tuser
s

BIar
chi
tect
s

Busi
nessuser
s

Answer
sD
Quest
ion.24
Whataresomeoftheadv
antagesofusi
ngSAPBW/
4HANAbusi
nesscont
ent
?Not
e:Ther
e
ar
e2cor r
ectanswer
stot
hisquest
ion.

Adj
ust
ment
stoact
ivat
edcont
entobj
ect
swi
l
lbedel
i
ver
edbySAPi
nanewnamespace

Aut
omat
icact
ivat
iondur
ingi
nst
all
ati
onofSAPBW/
4HANA

Abi
l
ityt
omodi
fyact
ivat
edbusi
nesscont
entobj
ect
s

Accel
erat
edi
mpl
ement
ati
onusi
ngr
eady
-mademodel
s

Answer
sAD

Question.25
Youhav ecreatedanSAPHANAcal culat
ionviewoftheSAPHANAextendedappl
icati
on
ser
vices,advancedmodel (
XSA)andwantt oint
egrat
eiti
ntoanSAPBW/ 4HANAmodel .
 
Which" Set
ti
ngsf orHANAConsumpt ion"intr
ansacti
onSPROcanyouuse?Note:Thereare
2correctanswerst ot
hisquest
ion.

Hy
bri
dMode

HANADepl
oymentI
nfr
ast
ruct
ure

SAPHANAReposi
tor
y

Ext
ernal
SAPHANAVi
ew

Answer
sAB

Questi
on.26
Youwanttoexecuteaquer y
,butdonothavetheauthori
zationfort
hecompl
etesel
ect
ion
defi
nedinthequeryforaut
hori
zati
on-
rel
evantcharact
eri
stics.Whatwoul
doccuri
nthi
s
scenar
io?Note:Ther
ear e2corr
ectanswerstothi
squestion.

Youwi
l
lnotgetaquer
yresul
t.

Youcannotr
unt
hequer
y.

Youwi
l
lgetonl
ytheaut
hor
izeddat
a.

Youwi
l
lgetaner
rormessage.
Answer
sAD

Quest
ion.27
Whatisthebenef
itofusi
nganI
nfoSour
cei
nadat
afl
ow?

Pr
ovi
deani
nter
facef
orext
ract
ingdat
afr
om aquer
y

Connectmul
ti
plesequent
ial
transf
ormat
ions

Per
sisti
nter
medi
ater
esul
ts

Av
oidusi
ngaDat
aSour
ce

Answer
sB

Questi
on.28
Whichobject
scanbeusedintheBW quer
y“Fi
xedVal
ues”ar
eat
orest
ri
ctt
hedat
a?Not
e:
Thereare2corr
ectanswer
stothi
squesti
on.

Keyf
igur
es

Di
spl
ayat
tr
ibut
esofachar
act
eri
sti
c

Nav
igat
ionat
tri
but
esofachar
act
eri
sti
c

Char
act
eri
sti
cs

Answer
s CD

Questi
on.29
Whichfeat
uresprev
enttheSAPHANA- opt
imizat
ionoftr
ansfor
mat
ionsi
ntheSAPHANA
dat
abase?Note:Thereare2cor
rectanswer
st ot
hisquesti
on.

Tr
ansf
err
out
ineont
hechar
act
eri
sti
clev
el

ABAPexper
trout
inei
nthet
ransf
ormat
ion

Lookupmast
erdat
aint
het
ransf
ormat
ion

ABAPendr
out
inei
nthet
ransf
ormat
ion

Answer
sBD
Questi
on.30
Whichofthefol
lowi
ngaref
eat
uresoft
heSt
artpr
ocessi
napr
ocesschai
n?Not
e:Ther
e
ar
e2cor r
ectanswerst
othi
squesti
on.

I
tcanber
e-usedi
not
herpr
ocesschai
ns.

I
tist
heonl
ypr
ocesst
hatcanbeschedul
edwi
thoutapr
edecessor
.

Onl
yonest
artpr
ocessi
sal
l
owedf
oreachpr
ocesschai
n.

I
tcanbeasuccessorofanot
herpr
ocess.

Answer
sBC

Questi
on.31
Whichofthefol
lowi
ngarepossibl
esour
cet
ypesf
oranOpenODSv
iew?Not
e:Ther
ear
e3
cor
rectanswerstot
hisquest
ion.

Dat
aSt
oreobj
ect(
adv
anced)

Openhubdest
inat
ion

Composi
tePr
ovi
der

Tr
ansf
ormat
ions

Dat
abaset
abl
eorv
iew

Answer
sADE

Questi
on.32
Whatisthemaximum numberofobj
ect
sthatcanbeusedf
oramul
ti
-di
mensi
onal
except
ionaggr
egati
on?

10

Answer
sD
Quest
ion.33
YoudevelopedaBW i
nfor
mati
onmodelandwantt
ore-useagenerat
edexternal
SAP
HANAv iew.Whi
chobject
sar
esuppor
ted?Not
e:Ther
ear e3cor
rectanswerstothi
s
quest
ion.

SAPBW/
4HANAquer
y

Quer
yasI
nfoPr
ovi
der

Semant
icgr
oupobj
ect

OpenODSv
iew

Composi
tePr
ovi
der

Answer
sABE

Questi
on.34
Whichfi
letypesaresuppor
tedforanuploadint
oSAPBW/ 4HANAusi
ngsour
cesy
stem
FI
LE?Not e:Ther
eare3correctanswer
st othi
squest
ion.

ASCI
I

HTML

XML

XLSX

CSV

Answer
sADE

Questi
on.35
Youwanttointegr
atedat
afrom di
ff
erentsour
cesusi
ngSAPHANASolut
ionsfor
Ent
erpri
seInf
ormationManagement.Whichot
herobj
ectt
ypewoul
dyouusetocont
inue
wit
hthesamemodel i
ngf
ocus?

St
oredpr
ocedur
es

Funct
ionmodul
es

AMDP(
ABAPManagedDat
abasePr
ocedur
es)
BAPI
s(Busi
nessAppl
i
cat
ionPr
ogr
ammi
ngI
nter
face)

Answer
sA

Questi
on.36
YoucreatedanOpenODSv i
ewbasedonadat abasetablei
nSAPHANAt ovi
rt
uall
ydisplay
thedatai
nSAPBW/ 4HANA.Real-t
imereport
ingrequirementshavenowchangedandy ou
areaskedtopersistthedatainSAPBW/ 4HANA.Whi chobjectswil
lbecr
eatedwhenusi ng
theGenerateDatafl
owf unct
ionvi
at heOpenODSv i
ew?Not e:Ther
eare3corr
ectanswer s
tothi
squestion.

SAPHANAcal
cul
ati
onv
iew

Composi
tePr
ovi
der

Dat
asour
ce

Dat
aSt
oreobj
ect
s(adv
anced)

Tr
ansf
ormat
ion

Answer
sCDE

Questi
on.37
Whichobjectscanyouassoci
atewithasour
cefi
eldint
hecharacter
isti
csfol
derofan
OpenODSv i
ewt y
pe“Fact
s”?Note:Ther
eare2corr
ectanswer
st othisquest
ion.

OpenODSv
iewt
ypeMast
erDat
aforAt
tri
but
es

OpenODSv
iewt
ypeMast
erDat
aforHi
erar
chi
es

SAPBW I
nfoObj
ect
sty
peChar
act
eri
sti
c

SAPBW I
nfoObj
ect
sty
peKeyFi
gur
e

Answer
sAC

Quest
ion.38
Whatcany oul
ever
ageusingt
heli
vedataconnecti
onsofSAPAnaly
ticsCl
oudwi
thSAP
BW/4HANA?Not e:Ther
eare2cor
rectanswer
st othi
squest
ion.

BW dat
amodel
sforanal
ysi
s
BW dat
amodel
sforpl
anni
ngscenar
ios

Exi
sti
ngaut
hor
izat
ionconcept
s

Pr
ocesschai
nst
reami
ngf
unct
ional
i
ty

Answer
sAC

Questi
on.39
Youdefinearemot
esubscr i
ptionoftypeINSERTinanSAPHANASmartDataInt
egrat
ion
(SDI
)real-
ti
meupdatescenario.Whichfiel
dsareaddedt
otheDat
aSour
ceautomati
cal
ly?
Note:Therear
e3correctanswerstothisquesti
on.

SDI
_RECORD_
SEQUENCE

SDI
_CHANGE_
TYPE

SDI
_CHANGE_
TIME

SDI
_RECORD_
MODE

SDI
_CHANGE_
SEQUENCE

Answer
sBCE

Quest
ion.40
Whatarethepr
erequisi
tesf
ordel
etingmasterdata(f
orexample,
costcent
ers)i
nSAP
BW/4HANA?Not e:Therear
e2correctanswerstothi
squesti
on.

Ther
emustbenot
ransact
iondat
aref
err
ingt
othecostcent
ers.

Ther
emustbenoBW quer
ythatusescostcent
erasaf
reechar
act
eri
sti
c.

Ther
emustbenoBW anal
ysi
saut
hor
izat
ionsdef
inedt
hatuseanyoft
hecostcent
ers.

Ther
emustbenohi
erar
chyf
ort
hecostcent
ers.

Answer
sAD

Questi
on.41
Whatkindofcolddatati
eri
ngopt
ionsdoy
ouhav
ewi
thSAPBW/
4HANA?Not
e:Ther
ear
e2
cor
rectanswerstothi
squesti
on.
SAPDat
aWar
ehouseCl
oud

Hadoopcl
ust
er

SAPHANAext
ensi
onnode

SAPI
Qdat
abase

Answer
sBD

Quest
ion.42
Consi
deri
ngthemixedmodel
ingappr
oach,
whatcany
oudoi
nanSAPHANAcal
cul
ati
on
vi
ewexclusi
vel
y?

Combi
nedat
aset
sbyUni
on

Gener
ateaRankcol
umn

Sel
ectadat
asetbyPr
oject
ion

Compr
essdat
aset
sbyAggr
egat
ion

Answer
sC

Questi
on.43
Youwantt oi
ntegr
ateanSAPHANAinfor
mat
ionv
iewformasterdatai
ntoanotheronefor
tr
ansacti
ondata.Whatdoyouneedt
odobef
oreyoucani
ntegrat
ethemasterdataview?

Act
ivat
ethedesi
gnt
imev
ersi
onoft
hemast
erdat
avi
ewt
otur
niti
ntoaComposi
tePr
ovi
der
.

Act
ivat
ethedesi
gnt
imev
ersi
onoft
hemast
erdat
avi
ewt
ogener
atear
unt
imev
ersi
on.

I
ntegr
atet
hedesi
gnt
imev
ersi
onoft
het
ransact
iondat
avi
ewi
ntoaComposi
tePr
ovi
der
.

I
ntegr
atet
hedesi
gnt
imev
ersi
onoft
hemast
erdat
avi
ewi
ntoaComposi
tePr
ovi
der
.

Answer
sB

Questi
on.44
YoucreateaDat aSt
oreobject(advanced)usi
ngt
he"dat
amar tDataSt
oreobject
"model
ing
proper
ty.Whichbehavior
sar especif
ictothi
smodel
i
ngpr oper
ty?Note:Ther
eare2corr
ect
answerstothisquesti
on.
Thechangel
ogt
abl
ewi
l
lonl
ybef
il
ledaf
teract
ivat
ion.

Repor
ti
ngi
sdonebasedonauni
onoft
hei
nboundandact
ivet
abl
es.

Quer
yresul
tsar
eonl
yshownwhendat
ahasbeenact
ivat
ed.

Al
lchar
act
eri
sti
csar
eaut
omat
ical
l
ydef
inedaskey
.

Answer
sBD

Quest
ion.45
Wherecanyouaut
omat
ical
lygener
ateapr
ocesschai
n?

Fr
om adat
afl
owobj
ect

Wi
thi
nthePr
ocessChai
nEdi
torapp

Wi
thi
nthepr
ocesschai
nmai
ntenance

Fr
om aComposi
tePr
ovi
der

Answer
sA

Quest
ion.46
Whatisthepur
poseofani
nit
ialar
chi
tect
ureov
erv
iewmodel
?

Toi
dent
if
yther
equi
reddat
asour
ces

Toi
dent
if
ytheusergr
oupsandr
equi
redaut
hor
izat
ions

Topr
epar
ether
equi
redkeyf
igur
emat
ri
x

Topr
esentt
het
echni
cal
over
viewoft
heSAPl
andscape

Answer
sC

Questi
on.47
Whichjoi
ntypescany
ouusei
naComposi
tePr
ovi
der
?Not
e:Ther
ear
e3cor
rectanswer
s
t
othisquesti
on.

Ref
erent
ial
joi
n

Ful
lOut
erj
oin
Hi
erar
chyj
oin

I
nnerj
oin

Textj
oin

Answer
sABD

Questi
on.48
Whatarethekeybenefi
tsofusi
ngt
heSAPLandscapeTransformati
onRepl
icati
onServer
fordat
aprovi
sioni
ngint
oSAPHANA?Note:Ther
ear e2correctanswer
stothisquest
ion.

Real
-t
imeandschedul
eddat
arepl
i
cat
ion

Log-
basedr
epl
i
cat
ion

Suppor
tofcl
ust
erandpool
tabl
es

Vi
rt
ual
i
zat
ioncapabi
l
iti
es

Answer
sAC

Questi
on.49
TheSAPS/ 4HANAvir
tualdatamodel(VDM)isbui
ltwi
thABAP-managedCDSv i
ews.What
aresomeoftheprer
equisi
tesforusi
ngtheseSAPS/4HANAABAPCDSv i
ewsfor
extr
act
ionint
oSAPBW/ 4HANAi nanODPcont ext
?Note:Ther
ear
e2cor r
ectanswerst
o
thi
squesti
on.

ABAPCDSv
iewsmustbedef
inedwi
tht
heappr
opr
iat
edat
aex
tract
ionannot
ati
ons.

TheOper
ati
onal
Dat
aPr
ovi
sioni
ngFr
amewor
kmustbeconf
igur
edi
nSAPBW/
4HANA.

ABAPCDSv
iewsmustber
eleasedv
iapr
ogr
am RODPS_
OS_
EXPOSEf
orBW ex
tract
ion.

AnODPsour
cesy
stem wi
tht
ypeODP_
CDSmustbecr
eat
edi
nSAPBW/
4HANA.

Answer
sAD

Questi
on.50
Whichint
erf
acedoy
ouuset
ocr
eat
eaBW I
nfoObj
ectwi
thaccesst
ype"
SAPHANAv
iew"
?

SAPHANAmodel
erper
spect
ivei
nSAPHANAst
udi
o
EmbeddedSAPGUIi
nSAPHANAst
udi
o

BW model
i
ngper
spect
ivei
nSAPHANAst
udi
o

SAPWebI
DEf
orSAPHANA

Answer
sC

Questi
on.51
Whataresomeoft hereasonst
ochoosetheCUBEdatacategor
yinst
eadofDIMENSION
datacategor
yforanSAPHANAcal cul
ati
onvi
ew?Note:Therear
e3cor r
ectanswer
stothi
s
questi
on.

Cr
eat
erest
ri
ctedcol
umns.

Aggr
egat
emeasur
esasasum.

Per
sistt
ransact
ional
dat
a.

Pr
ovi
dedef
aul
tti
mechar
act
eri
sti
cs.

Combi
nemast
erdat
aandt
ransact
ional
dat
a.

Answer
sABE

Quest
ion.52
SAPHANAst udi
oprovi
desadat
afi
lei
mportwizar
dtocreat
eandf
il
ltabl
esi
nSAPHANA
fr
om f
latfi
les.Whatisanadv
ant
ageofusi
ngthefi
lewi
zard?

I
mmedi
ateassi
gnmentofdel
tal
ogi
c

Opt
iont
oadj
ustt
hesuggest
edcol
umnt
ype,
lengt
h,andname

Aut
omat
icf
iel
dmappi
ngst
oInf
oObj
ect
s

Combi
ningdi
ff
erentsour
cef
iel
dsi
ntoasi
ngl
etabl
ecol
umn

Answer
sB

Quest
ion.53
I
naquer ywit
hcell
syouneedtooverr
idesomeoftheautomati
cal
lycr
eat
edcellval
ues
wit
hot herval
ues.Whi
chCellty
pesdoy ouusei
nsteadoftheaut
omati
cal
ly-
creat
edcel
l?
Note:Thereare2corr
ectanswerst
othisquest
ion.
Ref
erencecel
l
s

Hel
pcel
l
s

Sel
ect
ioncel
l
s

For
mul
acel
l
s

Answer
sCD

Quest
ion.54
I
nSAPBW/ 4HANA, youreali
zethatstandardcontentdatasour ce0FI
_ GL_10(NewGL
Bal
ances)isdel
iver
ingincorr
ectvaluesintothefi
rstpersist
entdatalay eri
nSAP
BW/4HANA.Whi choptionsdoy ouhav etoanaly
zeapot entialextr
actorissuei
ntheSAP
ERPsourcesyst
em?Not e:Ther
ear e2cor r
ectanswerst othisquesti
on.

Uset
ransact
ionRSA3(
Ext
ract
orchecker
)inSAPERP.

Checkent
ri
esi
ntabl
eRSDDSTATEXTRACTi
nSAPERP.

Uset
hePSAmai
ntenancei
nSAPBW/
4HANA.

Usepr
ogr
am RODPS_
REPL_
TESTi
nSAPERP.

Answer
sAD

Quest
ion.55
Youwanttogetinsi
ght
saboutthestr
uctureandcont
entofy
oursour
cedat
a.Whi
ch
appr
oachy oushoul
dconsi
derf
orrapidprotot
ypi
ng?

I
nfoObj
ectbasedmodel
i
ng

Busi
nesscont
entact
ivat
ion

Fl
atf
il
egener
ati
on

Fi
eld-
basedmodel
l
ing

Answer
sD

Questi
on.56
Youdefinedacondit
ioninaqueryforthetop10customersbasedonsal
esrevenue(key
fi
gureofaggregat
iontypeSum).I
fy oukeepthedef
aultset
ti
ngsofthequer
y,whatisthe
t
otaloft
hesal
esr
evenueont
her
esul
tli
ne?

Sal
esr
evenuet
otal
ofal
lcust
omer
s

Sal
esr
evenuev
alueoft
he1stcust
omer

Sal
esr
evenuet
otal
oft
he10cust
omer
s

Sal
esr
evenuev
alueoft
he10t
hcust
omer

Answer
sA

Quest
ion.57
SAPprovidest
hreedatawarehousi
ngsolut
ionst
opr
ovi
decust
omer
smor
efl
exi
bil
i
ty.How
i
sSAPDat aWarehouseCl
oudposit
ioned?

Toempowerbusi
nessuser
stocr
eat
eandmai
ntai
nrequi
reduser
s

Tosuppor
tcl
i
ent
susi
ngt
hiscl
oud-
basedsuccessorofSAPBW/
4HANA

Toempowerbusi
nessuser
stocr
eat
eandmai
ntai
naut
hor
izat
ion

Tosuppor
tbusi
nessuser
swi
thanewsel
f-
ser
vicet
ool

Answer
sD

Quest
ion.58
Whyshouldyour
unanSAPHANAdel
tamer
ge?Not
e:Ther
ear
e2cor
rectanswer
stot
his
quest
ion.

Tocl
eart
heBW quer
ycache

Tomov
emostr
ecentdat
afr
om di
skt
omemor
y

Toi
mpr
ovet
her
eadper
for
manceofI
nfoPr
ovi
der
s

Todecr
easememor
yconsumpt
ion

Answer
sCD

Quest
ion.59
Youwanttodefi
nearest
ri
ctedcol
umninanSAPHANAcalculat
ionvi
ew.Whatdoy
ou
needt
odef i
ne?Not
e:Therear
e2corr
ectanswer
stot
hisquesti
on.
Ar
efer
encet
oanex
ist
ingmeasur
e

Anaggr
egat
ionmet
hod

Acondi
ti
oncr
it
eri
a

AnSAPHANAdat
aty
pe

Answer
sAC

Questi
on.60
Howcany ouensur
ethatt
hedelt
amer
gepr
ocesswi
llbei
nit
iat
ed?Not
e:Ther
ear
e3
cor
rectanswer
stothi
squest
ion.

Byusi
ngSAPHANAsmar
tmer
get
echnol
ogy

Byset
ti
ngaspeci
fi
cfl
agi
nthet
ransf
ormat
ion

Byusi
ngt
heSAPBW/
4HANAdat
aloadmoni
tor

Byset
ti
ngaspeci
fi
cfl
agi
nthedel
tadat
atr
ansf
erpr
ocess

Byusi
ngaspeci
fi
cpr
ocesst
ypei
napr
ocesschai
n

Answer
sADE

Questi
on.61
WhichSAPBW/ 4HANAobj
ectsarepossi
blesour
cesf
ordat
aloadpr
ocesses?Not
e:Ther
e
ar
e3cor rectanswer
stot
hisquesti
on.

Char
act
eri
sti
cs

OpenODSv
iews

I
nfoSour
ces

Composi
tePr
ovi
der
s

Dat
aSt
oreObj
ect
s(adv
anced)

Answer
sCDE

Quest
ion.62
Wit
hSAPHANA2.
x,y
oucanmodeli
nfor
mat
ionv
iewsi
ntheSAPWebI
DEf
orSAPHANA
withSAPHANAext endedappli
cationserv
ices,
adv
ancedmodel(XSA).
Whi
chnodetypes
foranat
iveSAPHANAi nf
ormationv i
ewareONLYavai
labl
eint
hisfr
amework?Not
e:There
are2corr
ectanswerstothisquestion.

Gr
aph

I
nter
sect

Rank

Aggr
egat
ion

Answer
sAB

Questi
on.63
Youneedtodefi
neanSAPHANAcalcul
ationvi
ewwithnumberst
hatr
epr
esentcodes
i
nsteadofaggr
egat
edval
ues.Whi
chset
tingsshoul
dyouchoose?

Chooset
heDI
MENSI
ONdat
acat
egor
yanduset
henumber
sasat
tri
but
es.

Chooset
heDI
MENSI
ONdat
acat
egor
yanduset
henumber
sasmeasur
es.

Chooset
heCUBEdat
acat
egor
yanduset
henumber
sasat
tri
but
es.

Chooset
heCUBEdat
acat
egor
yanduset
henumber
sasmeasur
es.

Answer
sA

Questi
on.64
Youneedt ocombi
neattributesdat
a(l
eftt
abl
e)andthedata’
slanguage-dependenttext
s
(r
ightt
able)usi
ngatextjoin.Youwantt
orest
ri
cttheresul
tsettothelogonlanguage.
Whatdoy ouneedtoselect?

Thel
anguagecol
umni
nthel
eftt
abl
e

Thel
ogonl
anguagei
nthel
eftt
abl
e

Thel
anguagecol
umni
nther
ightt
abl
e

Thej
oincar
dinal
i
tybet
weenbot
htabl
es

Answer
sC
Quest
ion.65
Youcreat
ear epor
twithSAPCry
stalRepor
tsforEnt
erpri
seandneedananal
ysi
svi
ewasa
dat
asource.Whichtoolcany
ouusetocreatethi
sanaly
sisvi
ew?

SAPCr
yst
alRepor
tsf
orEnt
erpr
ise

SAPAnal
ysi
sforMi
crosof
tOf
fi
ce

SAPBusi
nessObj
ect
sWebI
ntel
l
igence

SAPLumi
ra,
desi
gneredi
ti
on

Answer
sB

Questi
on.66
Whichobject
scanbeaffect
edbyt
hekeydat
einaBW quer
y?Not
e:Ther
ear
e3cor
rect
answerstothi
squest
ion.

Keyf
igur
es

Di
spl
ayat
tr
ibut
es

Nav
igat
ionat
tri
but
es

Hi
erar
chi
es

Condi
ti
ons

Answer
sBCD

Questi
on.67
Forwhichbusi
nessr
equi
rement
sdoyousuggestanSAPHANAmodel ingf
ocusrat
her
thananSAPBW/ 4HANAmodeli
ngf
ocus?Note:Ther
eare2cor
rectanswer
stothis
questi
on.

Loadsnapshot
sordel
tasf
rom di
ff
erentsour
cesonaper
iodi
cbasi
s

Repor
tonahar
moni
zedsetofmast
erdat
a

Enhanceexi
sti
ngSAPHANAcont
entmodel
s

Lev
erageSQLi
n-houseknowl
edge

Answer
sCD
Quest
ion.68
Whatarethereasonsfori
mpl
ement
ingComposi
tePr
ovi
der
s?Not
e:Ther
ear
e2cor
rect
answerstot
hisquesti
on.

Touset
heRankf
unct
ional
i
ty

Topr
ovi
deani
nter
facef
ort
hequer
ies

Tol
oaddat
aint
otheComposi
tePr
ovi
derf
orr
epor
ti
ng

Topr
ovi
deav
irt
ual
dat
amar
tlay
er

Answer
sBD

Questi
on.69
Whichofthefol
lowingar
ethepossi
bledel
ta-r
elevantf
iel
dtypesf
oradelt
apr
ocesswi
tha
gener
icDataSource?Not
e:Ther
eare3correctanswerstothi
squest
ion.

Quant
it
y

Ti
mest
amp

Cal
endarday

Amount

Numer
icpoi
nter

Answer
sBCE

Questi
on.70
Whichfeat
urescanbelever
agedusingaComposi
tePr
ovi
deri
nSAPBW/
4HANA?Not
e:
Thereare3corr
ectanswerstot
hisquest
ion.

Combi
neI
nfoPr
ovi
der
susi
ngJoi
nsandUni
ons.

I
ntegr
ateSAPHANAcal
cul
ati
onv
iews.

Def
inenewr
est
ri
ctedkeyf
igur
es.

Def
inenewcal
cul
atedf
iel
ds.

I
ntegr
ateaBW quer
yasanI
nfoPr
ovi
der
.

Answer
sABE
Questi
on.71
YoucanNOTt ur
nadisplayatt
ri
buteint
oanav i
gat
ionattr
ibut
e.Whichset
ti
ngofthis
at
tri
butecoul
dbethereason?Note:Therear
e2cor r
ectanswerst
ot hi
squest
ion.

Case-
Sensi
ti
ve

At
tri
but
eOnl
y

Hi
ghCar
dinal
i
ty

Useabl
easI
nfoPr
ovi
der

Answer
sBC

Quest
ion.72
Whataresomeofthepossi
blev
ariabl
ety
pesfort
hepr
ocessi
ngt
ypeSAPHANAExi
t?Not
e:
Ther
eare2corr
ectanswerstot
hisquest
ion.

Text

Hi
erar
chynode

Char
act
eri
sti
cval
ue

For
mul
a

Answer
sCD

Quest
ion.73
Youwanttobui
ldWeb-
baseddashboar
dswi
thi
nter
act
ivev
isual
izat
ions.Whi
chSAPt
ool
doyousuggest
?

SAPAnal
ysi
sforOLAP

SAPAnal
ysi
sforMi
crosof
tOf
fi
ce

SAPLumi
ra,
desi
gneredi
ti
on

SAPCr
yst
alRepor
tsf
orEnt
erpr
ise

Answer
sC
Questi
on.74
Whichexter
nalhi
erar
chyproper
ti
escanbechangedi
nthequer
ydef
ini
ti
on?Not
e:Ther
e
ar
e3cor r
ectanswerstot
hisquesti
on.

Sor
tdi
rect
ion

Expandt
olev
el

Posi
ti
onofchi
l
dnodes

Ti
medependency

Suppr
essunassi
gnednode

Answer
sABC

Questi
on.75
Whatarethepossi
blewaystofil
lapr
e-cal
cul
atedv
alueset(
bucket
)?Not
e:Ther
ear
e3
cor
rectanswer
stothisquest
ion.

Byent
eri
ngt
hev
aluesmanual
l
y

Byr
efer
enci
ngat
abl
e

Byaccessi
ngacal
cul
ati
onv
iewofdat
acat
egor
yDi
mensi
on

Byusi
ngat
ransf
ormat
ionanddat
atr
ansf
erpr
ocess(
DTP)

Byusi
ngaquer
y

Answer
sABE

Questi
on.76
Yourcompanyi
susingSAPS/ 4HANAasabusi
nessoperat
ionalsy
stem andy
ouhaveto
prov
ideoper
ati
onal
analy
ticalr
epor
ts.Whymi
ghtyouconsi
derSAPS/ 4HANAembedded
anal
yti
cs?

Makeuseoft
heSAPHANADepl
oymentI
nfr
ast
ruct
ure.

Makeuseoft
hev
irt
ual
dat
amodel
.

Makeuseoft
heSAPHANALi
vecont
ent
.

Makeuseoft
heSAPHANAopt
imi
zedbusi
nesscont
ent
.
Answer
sB

Questi
on.77
Wit
hSAPBW/ 4HANA2. 0,SAPint
roducedanewcapabi
li
tycal
ledWr i
teInt
erf
acefor
DataStor
eobject
s(advanced)
.WhichSAPsoluti
oncanl
everagethi
sinterf
acetopushdata
i
ntotheinboundtabl
eofaDSOsi nSAPBW/ 4HANA2.0vi
aHTTP- basedconnecti
on(REST)
?
Note:Therear
e2correctanswerstothi
squest
ion.

SAPPr
ocessI
ntegr
ati
on

SAPCl
oudPl
atf
ormI
ntegr
ati
on

SAPDat
aSer
vices

SAPDat
aWar
ehouseCl
oud

Answer
sBC

Questi
on.78
Whichsourcet
ypesar
eavail
ablet
ocr
eat
eagener
icDat
aSour
ce?Not
e:Ther
ear
e3
cor
rectanswer
stothi
squesti
on.

ABAPcl
assmet
hod

SAPHANAcal
cul
ati
onv
iew

Dat
abasev
iew

SAPquer
y

ABAPf
unct
ionmodul
e

None

None

Answer
sACE

Questi
on.79
Youplantoregularl
ytransf
erchangesf
rom anSAPERPcustom t
ablet
oSAPBW/ 4HANA.
Anadditi
onalcustom devel
opmentmayNOTbei mplement
edinthesourcesy
stem.Which
Operat
ionalDataProvisi
oning(
ODP)sourcesyst
em t
ypedoyourecommend?Choosethe
cor
rectanswer.

ODP-
SLT
ODP-
SAP

ODP-
BW

ODP-
CDS

Answer
sA

Quest
ion.80
Whatarekeycapabi
li
ti
esofSAPAgi
leDat
aPr
epar
ati
onNot
e:Ther
ear
e3cor
rectanswer
s
t
othisquesti
on.

Dat
aret
ent
ion

Dat
aexpor
ti
ng

Dat
acl
eansi
ng

Dat
acompl
i
ance

Dat
aacqui
sit
ion

Answer
sBCE