CLRg 110g EXAMg WITHg COMPLETEg SOLUTIONSg 100%g VERIFIED
TruegorgFalse:gOnegrecordgingChroniclesgmayghavegseveralgClaritygtablesgextractinggda
tagfromgit. ANSWERgTrue
HowgoftengdoesgthegincrementalgtablesggetgextractgtogClarity.g- ANSWERgDaily
YougaregingthegRecordgViewergopenedgtogagpatientgencountergandgseegitemgEPTg10115g
asgshowngbelow.gForgthisgpatientgencountergwhatgwouldgbegstoredgingthegClaritygcolum
ngthatgextractsgthisgitem.gDischargedg[3]g- ANSWERg3
YougwantgtogaddgitemgSERg39:gPrimarygDepartmentgtogagreport.gWhichgofgthegfollowing
gisgthegquickestgwaygtogfindgwhatgClaritygtablegandgcolumngretrievesgthisgitem?g-
g ANSWERgItemgEditor
Yougareglookinggatgagcolleague'sgreportgandgyougnoticegagtablegyoughavegnevergusedgb
eforegnamedgCLARITY_ROM.gWhatgisgthegtoolgthatgyougcouldgusegtogresearchgthisgtable
?
-g g ANSWERgDatabasegObjectgSearch
ItemgHNOg1024:gNotesgLinkedgtogDocumentghasgangAddgtypegofgNo-
AddgandgagResponsegtypegofgMultiple.gWhatgisgthegprimarygkeygtogthegtablegthisgitemgis
gextractedgto?g-gANSWERgNOTE_IDgandgLINE
Aftergbeinggaskedgtogwritegagreport,gyouglookupgresourcesgingClarity,gsuchgasgClaritygCo
mpassgandgClaritygDictionary,gwithoutglookinggupgresourcesgingChronicles,gsuchgasgItem
gEditorgandgthegRecordgViewer.gWhatgaregsomegproblemsgyougcouldghave?g-
gANSWERgThosegaskinggforgreportsgcangonlygtellgyougwheregdataggoesgingHyperspace,ga
ndgwon'tgknowgwheregthegdatagisgstoredgingClarity.
AgjoingthatgisgnecessarygingyourgquerygmaygnotgbegagdocumentedgforeigngkeygofgthegClarityg
Dictionary.
ListgvaluesgforgangattributegofgagcustomgtypegaregnotgdocumentedgingthegClaritygCompa
ssgorgthegClaritygDictionary.
,Yougcannotgquerygattributesgofgthegsourcegobject.
Derivedgtablesgcomparegtogviewsginggeneralgrungfastergsincegthegdataghasgbeengstoredg
ongthegdatabase.g- ANSWERgTrue
TruegorgFalsegEpicgSQLgFunctionsgmustgbegusedgingplacegofgOraclegorgMicrosoftgS
QLgservergfunctionsgingordergtogreturngdatagfromgClarity.g-
ANSWERgFalse,gEpicgSQL
gFunctionsgaregnotgrequired.gYougmaygusegOraclegorgMicrosoftgSQLgServergfunctio
ns.
Whichgofgthegfollowinggisgthegbestgwaygtogdeterminegwhethergaggivengdatabasegobjectgis
gagderivedgtable?g- ANSWERgNONEgofgthegabove
IngthegClaritygCompass,gingthegsummarygtabgcheckgthegTypegfield.gDerivedgtablesgcang
startgwithglettersgothergthangD_gandgthegscriptsgtabegwillgalsogexistgforgEPICgSQLgFunct
ionsgandgviews.
WhichgofgthegfollowinggcangbegfoundgingthegClaritygcompassg-
ANSWERgWhetherga
gcolumngisgdeprecated.
Thegversiongwhengthegtablegwasgcreated.
WhichgofgthegfollowinggstatementsgisgagcorrectgdescriptiongofgContactgDategReal?g-
gANSWERgRecordsgcanghavegthegsamegContactgDategRealgbutgbegdifferent.
Itgisgthegnumbergofgdaysgsinceg12/31/1840gfollowedgbygagtwogdigitgdecimal.
ConsidergthegRawgdatagfieldgandgthegitemgcharacteristicsgofgEPTg110gingCtrlgClick.gBas
edgongprovidedginformationgwhengthisgdatagisgextractedgtogagcolumngingClaritygthatgco
lumngwillglikelyghavegagdatatypegof:g- ANSWERgdatetime.
WhatgwillgbegextractedgtogClaritygforgChroniclesgitemsgthatgaregnotgfilledgoutg(blanks)?g-
gANSWERgNULL
WhatgisgagCategorygList?g-
ANSWERgCategoryglistgisgagsystem,gorgEpicglist,gitgi
sguneditable.gWhengusinggagfiltergusegthegvaluegitselfgrathergthangthegname.
,Chroniclesgitemgcangstoregonegorgmoregoptionsgformgaglimitedglist.gWhichgofgthegfollowi
nggcouldgaccountgforgthisgbehavior?g-
ANSWERgMultiplegResponse,gNetworkedgandgCat
egory
AgChroniclesgitemgstoresgonegvalue,gbutgitgcangstoregagdifferentgvaluegforgeachgcontactg
ongagrecord.gWhichgofgthegfollowinggcouldgexplaingthis?g-
ANSWERgSinglegResponse,gOve
rtime
Aglabgmanagergtellsgyoughegneedsgagreportgaboutglabgspecimensgandgbringsgyougtogtheg
fieldgwhereghegcangfillgingvariousginformation.gWhatgwouldgyougdogtogdeterminegthegINIga
ndgitemgnumbersgofgthegdataghegisgrequesting?g- ANSWERgCTRLg&gClick
Agclinicalgadministratorgrequestsgagquerygtogincludegdatagforgagpatient'sgregistries.gSheg
isgnotgsuregofgthegINIgandgitemgnumbergbutgshegknowsgthegpatientgisgongthegLunggCan
cergScreeninggregistry.gWhatgtoolgwouldgyougusegtogfindgthegINIgandgitemgnumberggiv
engthisginformationg- ANSWERgRecordgViewer
IfgyougfindgagtablegingClaritygCompassgwillgitgnecessarilygbegingyourgClaritygdatabase?gAN
SWERgNotgalwaysgthegcase.gThegClaritygCompassgwillgshowgallgofgthegtablesgthatgaregpossi
blegbutgatgyourgorganizationgyougmightgnotghavegeverygtablegextracted.
Howgwouldgyougdeterminegthat?g-
ANSWERgWritegSQLgquery,greviewgCgrecordsgi
ngClaritygCompassgverifygexecutionsgappeargongsummarygform.
Openg SQLg Managementg Studio
CreategquerygtogoutputgresultsgfromgPAT_ENC
AskgforgthegprimarygkeygthegpatientgIDgandgthegcolumngthatgextractsgEPTg30
WhatgdogyougseegingthegcolumngtogextractgEPTg30?gHowgwouldgyougwantgthisgdatagpre
sentedgtogagreportgclient?g-
ANSWERgItgisgangattributegvalue,gyougshouldgpresentgth
egnamegtogyourgreportgclient.
Changegthegquerygtogpresentgthegencountergtypegname.
Hint:glookgatgthegforeigngkeyginformationgsectionsgofgPAT_ENCgingthegClaritygDictionary
, WhatgisgthegprimarygkeygofgPAT_ENCg - ANSWERgPAT_ENC_CSN_ID
WhatgcolumngingClaritygextractsgthegpatientgname?g- ANSWERgPATIENT.PAT_NAME
WhatgcolumngingClaritygextractsgthegpatientgsexgEPT130?g-
ANSWERgPATIENT.SEX_C,
gModifygyourgquerygtogdisplaygthegpatientgnamegandgpatientgsex.gYougwillgneedgtogjoingy
ourgtablesgtogdogso
WhatgisgthegprimarygkeygofgthegPATIENTgtable?g- ANSWERgPAT_ID
WhatgChroniclesgINIgandgitemgdoesgitgextract?g- ANSWERg1g EPT.1
IsgtheregagcolumngingPAT_ENCgthatgextractsgthegsamegChroniclesgitem?g-
ANSWER
gPAT_ENC.PAT_ID
TruegorgFalse:gThegClaritygConsolegstoresgdefinitionsgforgthegdatabasegobjectsgthatgc
angbegextractedgtogandgstoredgingthegClaritygdatabase.g-
ANSWERgFALSEgThegClarityg
Compassgstoresgthesegdefinitions.
Whichgofgthegfollowinggtoolsgwouldgyougutilizegingordergtogdeterminegthegtablegandgcolu
mngthatgextractsgEPTg18864gAttendinggProvider?gANSWERgColumngsearchgtogentergth
egClaritygCompass
WhatghappensgtogagcolumngthatgisgmarkedgDeprecated?gANSWERgNogmoregdatagwillgbegext
ractedgintogthatgcolumn
Forgwhichgofgthegfollowinggscenariosgwouldgyougwant
togcontactgyourgClaritygETLgAdministrator?g-
ANSWERgYougneedgtogusegCLARITY_DEP_CUST_FIELDSgongagrepor
t.gYoughaveglocatedgagtablegingClaritygCompass,gbutgyougaregunablegtogquerygthegtable
gongyourgdatabase.
Youghaveglocatedgagviewgthatgappearsgusefulgingyourgreports.
TruegorgFalse:gOnegrecordgingChroniclesgmayghavegseveralgClaritygtablesgextractinggda
tagfromgit. ANSWERgTrue
HowgoftengdoesgthegincrementalgtablesggetgextractgtogClarity.g- ANSWERgDaily
YougaregingthegRecordgViewergopenedgtogagpatientgencountergandgseegitemgEPTg10115g
asgshowngbelow.gForgthisgpatientgencountergwhatgwouldgbegstoredgingthegClaritygcolum
ngthatgextractsgthisgitem.gDischargedg[3]g- ANSWERg3
YougwantgtogaddgitemgSERg39:gPrimarygDepartmentgtogagreport.gWhichgofgthegfollowing
gisgthegquickestgwaygtogfindgwhatgClaritygtablegandgcolumngretrievesgthisgitem?g-
g ANSWERgItemgEditor
Yougareglookinggatgagcolleague'sgreportgandgyougnoticegagtablegyoughavegnevergusedgb
eforegnamedgCLARITY_ROM.gWhatgisgthegtoolgthatgyougcouldgusegtogresearchgthisgtable
?
-g g ANSWERgDatabasegObjectgSearch
ItemgHNOg1024:gNotesgLinkedgtogDocumentghasgangAddgtypegofgNo-
AddgandgagResponsegtypegofgMultiple.gWhatgisgthegprimarygkeygtogthegtablegthisgitemgis
gextractedgto?g-gANSWERgNOTE_IDgandgLINE
Aftergbeinggaskedgtogwritegagreport,gyouglookupgresourcesgingClarity,gsuchgasgClaritygCo
mpassgandgClaritygDictionary,gwithoutglookinggupgresourcesgingChronicles,gsuchgasgItem
gEditorgandgthegRecordgViewer.gWhatgaregsomegproblemsgyougcouldghave?g-
gANSWERgThosegaskinggforgreportsgcangonlygtellgyougwheregdataggoesgingHyperspace,ga
ndgwon'tgknowgwheregthegdatagisgstoredgingClarity.
AgjoingthatgisgnecessarygingyourgquerygmaygnotgbegagdocumentedgforeigngkeygofgthegClarityg
Dictionary.
ListgvaluesgforgangattributegofgagcustomgtypegaregnotgdocumentedgingthegClaritygCompa
ssgorgthegClaritygDictionary.
,Yougcannotgquerygattributesgofgthegsourcegobject.
Derivedgtablesgcomparegtogviewsginggeneralgrungfastergsincegthegdataghasgbeengstoredg
ongthegdatabase.g- ANSWERgTrue
TruegorgFalsegEpicgSQLgFunctionsgmustgbegusedgingplacegofgOraclegorgMicrosoftgS
QLgservergfunctionsgingordergtogreturngdatagfromgClarity.g-
ANSWERgFalse,gEpicgSQL
gFunctionsgaregnotgrequired.gYougmaygusegOraclegorgMicrosoftgSQLgServergfunctio
ns.
Whichgofgthegfollowinggisgthegbestgwaygtogdeterminegwhethergaggivengdatabasegobjectgis
gagderivedgtable?g- ANSWERgNONEgofgthegabove
IngthegClaritygCompass,gingthegsummarygtabgcheckgthegTypegfield.gDerivedgtablesgcang
startgwithglettersgothergthangD_gandgthegscriptsgtabegwillgalsogexistgforgEPICgSQLgFunct
ionsgandgviews.
WhichgofgthegfollowinggcangbegfoundgingthegClaritygcompassg-
ANSWERgWhetherga
gcolumngisgdeprecated.
Thegversiongwhengthegtablegwasgcreated.
WhichgofgthegfollowinggstatementsgisgagcorrectgdescriptiongofgContactgDategReal?g-
gANSWERgRecordsgcanghavegthegsamegContactgDategRealgbutgbegdifferent.
Itgisgthegnumbergofgdaysgsinceg12/31/1840gfollowedgbygagtwogdigitgdecimal.
ConsidergthegRawgdatagfieldgandgthegitemgcharacteristicsgofgEPTg110gingCtrlgClick.gBas
edgongprovidedginformationgwhengthisgdatagisgextractedgtogagcolumngingClaritygthatgco
lumngwillglikelyghavegagdatatypegof:g- ANSWERgdatetime.
WhatgwillgbegextractedgtogClaritygforgChroniclesgitemsgthatgaregnotgfilledgoutg(blanks)?g-
gANSWERgNULL
WhatgisgagCategorygList?g-
ANSWERgCategoryglistgisgagsystem,gorgEpicglist,gitgi
sguneditable.gWhengusinggagfiltergusegthegvaluegitselfgrathergthangthegname.
,Chroniclesgitemgcangstoregonegorgmoregoptionsgformgaglimitedglist.gWhichgofgthegfollowi
nggcouldgaccountgforgthisgbehavior?g-
ANSWERgMultiplegResponse,gNetworkedgandgCat
egory
AgChroniclesgitemgstoresgonegvalue,gbutgitgcangstoregagdifferentgvaluegforgeachgcontactg
ongagrecord.gWhichgofgthegfollowinggcouldgexplaingthis?g-
ANSWERgSinglegResponse,gOve
rtime
Aglabgmanagergtellsgyoughegneedsgagreportgaboutglabgspecimensgandgbringsgyougtogtheg
fieldgwhereghegcangfillgingvariousginformation.gWhatgwouldgyougdogtogdeterminegthegINIga
ndgitemgnumbersgofgthegdataghegisgrequesting?g- ANSWERgCTRLg&gClick
Agclinicalgadministratorgrequestsgagquerygtogincludegdatagforgagpatient'sgregistries.gSheg
isgnotgsuregofgthegINIgandgitemgnumbergbutgshegknowsgthegpatientgisgongthegLunggCan
cergScreeninggregistry.gWhatgtoolgwouldgyougusegtogfindgthegINIgandgitemgnumberggiv
engthisginformationg- ANSWERgRecordgViewer
IfgyougfindgagtablegingClaritygCompassgwillgitgnecessarilygbegingyourgClaritygdatabase?gAN
SWERgNotgalwaysgthegcase.gThegClaritygCompassgwillgshowgallgofgthegtablesgthatgaregpossi
blegbutgatgyourgorganizationgyougmightgnotghavegeverygtablegextracted.
Howgwouldgyougdeterminegthat?g-
ANSWERgWritegSQLgquery,greviewgCgrecordsgi
ngClaritygCompassgverifygexecutionsgappeargongsummarygform.
Openg SQLg Managementg Studio
CreategquerygtogoutputgresultsgfromgPAT_ENC
AskgforgthegprimarygkeygthegpatientgIDgandgthegcolumngthatgextractsgEPTg30
WhatgdogyougseegingthegcolumngtogextractgEPTg30?gHowgwouldgyougwantgthisgdatagpre
sentedgtogagreportgclient?g-
ANSWERgItgisgangattributegvalue,gyougshouldgpresentgth
egnamegtogyourgreportgclient.
Changegthegquerygtogpresentgthegencountergtypegname.
Hint:glookgatgthegforeigngkeyginformationgsectionsgofgPAT_ENCgingthegClaritygDictionary
, WhatgisgthegprimarygkeygofgPAT_ENCg - ANSWERgPAT_ENC_CSN_ID
WhatgcolumngingClaritygextractsgthegpatientgname?g- ANSWERgPATIENT.PAT_NAME
WhatgcolumngingClaritygextractsgthegpatientgsexgEPT130?g-
ANSWERgPATIENT.SEX_C,
gModifygyourgquerygtogdisplaygthegpatientgnamegandgpatientgsex.gYougwillgneedgtogjoingy
ourgtablesgtogdogso
WhatgisgthegprimarygkeygofgthegPATIENTgtable?g- ANSWERgPAT_ID
WhatgChroniclesgINIgandgitemgdoesgitgextract?g- ANSWERg1g EPT.1
IsgtheregagcolumngingPAT_ENCgthatgextractsgthegsamegChroniclesgitem?g-
ANSWER
gPAT_ENC.PAT_ID
TruegorgFalse:gThegClaritygConsolegstoresgdefinitionsgforgthegdatabasegobjectsgthatgc
angbegextractedgtogandgstoredgingthegClaritygdatabase.g-
ANSWERgFALSEgThegClarityg
Compassgstoresgthesegdefinitions.
Whichgofgthegfollowinggtoolsgwouldgyougutilizegingordergtogdeterminegthegtablegandgcolu
mngthatgextractsgEPTg18864gAttendinggProvider?gANSWERgColumngsearchgtogentergth
egClaritygCompass
WhatghappensgtogagcolumngthatgisgmarkedgDeprecated?gANSWERgNogmoregdatagwillgbegext
ractedgintogthatgcolumn
Forgwhichgofgthegfollowinggscenariosgwouldgyougwant
togcontactgyourgClaritygETLgAdministrator?g-
ANSWERgYougneedgtogusegCLARITY_DEP_CUST_FIELDSgongagrepor
t.gYoughaveglocatedgagtablegingClaritygCompass,gbutgyougaregunablegtogquerygthegtable
gongyourgdatabase.
Youghaveglocatedgagviewgthatgappearsgusefulgingyourgreports.
