D426 Data Management -
g i g i g i
Foundation Objective Assessment Practice Exa
g i g i g i g i g i
WGU C175: DATA MANAGEMENT FOUNDATIONS
QUESTIONS AND ANSWERS
datagi-gianswer--numeric,gitextual,givisualgiorgiaudiogiinformationgithatgidescribesgireal-worldgisystems
scopegiofgidatagi-gianswer--thegiamountgiofgidatagiproducedgiandgicollected
formatgiofgidatagi-gianswer--datagimaygibegiproducedgiasginumbers,gitext,giimage,giaudio,giorgivideo
accessgiofgidatagi-gianswer--somegidatagisourcesgiaregiprivategiwhilegiothersgiaregimadegipubliclygiavailable
databasegi-gianswer--agicollectiongiofgidatagiingiagistructuredgiformat
databasegisystemgiakagiDBMSgi-gianswer--
isgisoftwaregithatgireadsgiandgiwritesgidatagiingiagidatabase.giensuresgidatagiisgisecure,giinternallygiconsistent,giandgiavaila
egiatgiallgitimes
querygilanguagegi-gianswer--
agispecializedgiprogramminggilanguagegidesignedgispecificallygiforgidatabasegisystems.gireadsgiandgiwritesgidatagiefficie
ly,giandgidiffersgisignificantlygifromgigeneralgipurposegilanguagesgisuchgiasgipythongiorgijava
databasegiapplicationgi-gianswer--softwaregithatgihelpsgibusinessgiusersgiinteractgiwithgidatabasegisystems
databasegiadministratorgi-gianswer--
thegipersongiresponsiblegiforgisecuringgithegidatabasegisystemgiagainstgiunauthorizedgiusers.gienforcesgiproceduresgifo
sergiandgidatabasegisystemgiavailability
databasegidesignergi-gianswer--
thegipersongithatgideterminesgithegiformatgiofgieachgidatagielementgiandgithegioverallgidatabasegistructure.gimustgibalance
everalgiprioritiesgiincludinggistorage,giresponsegitime,giandgisupportgiforgirulesgithatgigoverngithegidata.
databasegiprogrammergi-gianswer--
thegipersongithatgidevelopsgicomputergiprogramsgithatgiutilizegiagidatabase.githeygiwritegiapplicationsgithatgicombinegidat
asegiquerygilanguagesgiandgigeneralgipurposegiprogramminggilanguages.
databasegiusergi-gianswer--
agiconsumergiofgidatagiingiagidatabase.girequest,giupdate,giorgiusegistoredgidatagitogigenerategireportsgiorgiinformation.
transactiongi-gianswer--agigroupgiofgiqueriesgithatgimustgibegieithergicompletedgiorgirejectedgiasgiagiwhole.
ensuregitransactionsgiaregiprocessedgicompletelygiorginotgiatgiall
preventgiconflictsgibetweengiconcurrentgitransactionsgi
ensuregitransactiongiresultsgiareginevergilostgi-gianswer--whengiprocessinggitransactions,gidatabasegisystemsgimust:
architecturegiofgiagidatabasegisystemgi(5)gi-gianswer--
describesgithegiinternalgicomponentsgiandgithegirelationshipsgibetweengicomponents:
querygiprocessor
1gi/gi7
, D426 Data Management -
g i g i g i
Foundation Objective Assessment Practice Exa
g i g i g i g i g i
storagegimanagergi
transactiongimanagergi
log
catalog
querygiprocessorgi-gianswer--
interpretsgiqueries,gicreatesgiagiplangitogimodifygithegidatabasegiorgiretrievegidata,giandgireturnsgiquerygiresultsgitogithegiap
cation.
storagegimanagergi-gianswer--translatesgithegiquerygiprocessorgiinstructionsgiintogilow-levelgifile-
systemgicommandsgithatgimodifygiorgiretrievegidata.
querygioptimizationgi-gianswer--
querygiprocessorgiperformsgi___________gitogiensuregithatgimostgiefficientgiinstructionsgiaregiexecutedgiongithegidata
indexesgi-gianswer--storagegimanagergiusesgi______gitogiquicklygilocategidata
transactiongimanagergi-gianswer--
Ensuresgitransactionsgiaregiproperlygiexecuted.giPreventsgiconflictsgibetweengiconcurrentgitransactions.giRestoresgithe
atabasegitogiagiconsistentgistategiingithegieventgiofgiagitransactiongiorgisystemgifailure.
loggi-gianswer--
agifilegicontaininggiagicompletegirecordgiofgiallgiinserts,giupdates,giandgideletesgiprocessedgibygithegidatabase.githegitransa
ongimanagergiwritesgithesegibeforegiapplyinggichangesgitogithegidatabase.
catalog/datagidictionarygi-gianswer--Agidirectorygiofgitables,gicolumns,giindexes,giandgiothergidatabasegiobjects.
relationalgidatabasegi-gianswer--storesgidatagiingitables,gicolumns,giandgirows,gisimilargitogiagispreadsheet.
SQLgi(StructuredgiQuerygiLanguage)gi-gianswer--
thegistandardgilanguagegiofgirelationalgidatabasegisystems.giincludesgistatementsgithatgireadgiandgiwritegidata,gicreategia
gideletegitables,giandgiadministergithegidatabasegisystem
NoSQLgi-gianswer--aginewerginon-relationalgisystemgithatgiisgioptimizedgiforgibiggidata
opengisourcegi-gianswer--softwaregithatgianyonegicangiinspect,gicopy,giandgimodifygiwithginogilicensinggifee
querygi-gianswer--
agicommandgiforgiagidatabasegithatgitypicallygiinsertsginewgidata,giretrievesgidata,giupdatesgidata,giorgideletesgidatagifromg
database
querygilanguagegi-gianswer--agicomputergiprogramminggilanguagegiusedgiforgiwritinggidatagibasegiqueries
4gicommongiqueriesgi-gianswer--Create
Read
Update
Delete
databasegidesigngi-gianswer--
Agispecificationgiofgidatabasegiobjectsgisuchgiasgitables,gicolumns,gidatagitypes,giandgiindexes.giAlsogirefersgitogithegiproc
sgiusedgitogidevelopgithegispecification.
2gi/gi7
g i g i g i
Foundation Objective Assessment Practice Exa
g i g i g i g i g i
WGU C175: DATA MANAGEMENT FOUNDATIONS
QUESTIONS AND ANSWERS
datagi-gianswer--numeric,gitextual,givisualgiorgiaudiogiinformationgithatgidescribesgireal-worldgisystems
scopegiofgidatagi-gianswer--thegiamountgiofgidatagiproducedgiandgicollected
formatgiofgidatagi-gianswer--datagimaygibegiproducedgiasginumbers,gitext,giimage,giaudio,giorgivideo
accessgiofgidatagi-gianswer--somegidatagisourcesgiaregiprivategiwhilegiothersgiaregimadegipubliclygiavailable
databasegi-gianswer--agicollectiongiofgidatagiingiagistructuredgiformat
databasegisystemgiakagiDBMSgi-gianswer--
isgisoftwaregithatgireadsgiandgiwritesgidatagiingiagidatabase.giensuresgidatagiisgisecure,giinternallygiconsistent,giandgiavaila
egiatgiallgitimes
querygilanguagegi-gianswer--
agispecializedgiprogramminggilanguagegidesignedgispecificallygiforgidatabasegisystems.gireadsgiandgiwritesgidatagiefficie
ly,giandgidiffersgisignificantlygifromgigeneralgipurposegilanguagesgisuchgiasgipythongiorgijava
databasegiapplicationgi-gianswer--softwaregithatgihelpsgibusinessgiusersgiinteractgiwithgidatabasegisystems
databasegiadministratorgi-gianswer--
thegipersongiresponsiblegiforgisecuringgithegidatabasegisystemgiagainstgiunauthorizedgiusers.gienforcesgiproceduresgifo
sergiandgidatabasegisystemgiavailability
databasegidesignergi-gianswer--
thegipersongithatgideterminesgithegiformatgiofgieachgidatagielementgiandgithegioverallgidatabasegistructure.gimustgibalance
everalgiprioritiesgiincludinggistorage,giresponsegitime,giandgisupportgiforgirulesgithatgigoverngithegidata.
databasegiprogrammergi-gianswer--
thegipersongithatgidevelopsgicomputergiprogramsgithatgiutilizegiagidatabase.githeygiwritegiapplicationsgithatgicombinegidat
asegiquerygilanguagesgiandgigeneralgipurposegiprogramminggilanguages.
databasegiusergi-gianswer--
agiconsumergiofgidatagiingiagidatabase.girequest,giupdate,giorgiusegistoredgidatagitogigenerategireportsgiorgiinformation.
transactiongi-gianswer--agigroupgiofgiqueriesgithatgimustgibegieithergicompletedgiorgirejectedgiasgiagiwhole.
ensuregitransactionsgiaregiprocessedgicompletelygiorginotgiatgiall
preventgiconflictsgibetweengiconcurrentgitransactionsgi
ensuregitransactiongiresultsgiareginevergilostgi-gianswer--whengiprocessinggitransactions,gidatabasegisystemsgimust:
architecturegiofgiagidatabasegisystemgi(5)gi-gianswer--
describesgithegiinternalgicomponentsgiandgithegirelationshipsgibetweengicomponents:
querygiprocessor
1gi/gi7
, D426 Data Management -
g i g i g i
Foundation Objective Assessment Practice Exa
g i g i g i g i g i
storagegimanagergi
transactiongimanagergi
log
catalog
querygiprocessorgi-gianswer--
interpretsgiqueries,gicreatesgiagiplangitogimodifygithegidatabasegiorgiretrievegidata,giandgireturnsgiquerygiresultsgitogithegiap
cation.
storagegimanagergi-gianswer--translatesgithegiquerygiprocessorgiinstructionsgiintogilow-levelgifile-
systemgicommandsgithatgimodifygiorgiretrievegidata.
querygioptimizationgi-gianswer--
querygiprocessorgiperformsgi___________gitogiensuregithatgimostgiefficientgiinstructionsgiaregiexecutedgiongithegidata
indexesgi-gianswer--storagegimanagergiusesgi______gitogiquicklygilocategidata
transactiongimanagergi-gianswer--
Ensuresgitransactionsgiaregiproperlygiexecuted.giPreventsgiconflictsgibetweengiconcurrentgitransactions.giRestoresgithe
atabasegitogiagiconsistentgistategiingithegieventgiofgiagitransactiongiorgisystemgifailure.
loggi-gianswer--
agifilegicontaininggiagicompletegirecordgiofgiallgiinserts,giupdates,giandgideletesgiprocessedgibygithegidatabase.githegitransa
ongimanagergiwritesgithesegibeforegiapplyinggichangesgitogithegidatabase.
catalog/datagidictionarygi-gianswer--Agidirectorygiofgitables,gicolumns,giindexes,giandgiothergidatabasegiobjects.
relationalgidatabasegi-gianswer--storesgidatagiingitables,gicolumns,giandgirows,gisimilargitogiagispreadsheet.
SQLgi(StructuredgiQuerygiLanguage)gi-gianswer--
thegistandardgilanguagegiofgirelationalgidatabasegisystems.giincludesgistatementsgithatgireadgiandgiwritegidata,gicreategia
gideletegitables,giandgiadministergithegidatabasegisystem
NoSQLgi-gianswer--aginewerginon-relationalgisystemgithatgiisgioptimizedgiforgibiggidata
opengisourcegi-gianswer--softwaregithatgianyonegicangiinspect,gicopy,giandgimodifygiwithginogilicensinggifee
querygi-gianswer--
agicommandgiforgiagidatabasegithatgitypicallygiinsertsginewgidata,giretrievesgidata,giupdatesgidata,giorgideletesgidatagifromg
database
querygilanguagegi-gianswer--agicomputergiprogramminggilanguagegiusedgiforgiwritinggidatagibasegiqueries
4gicommongiqueriesgi-gianswer--Create
Read
Update
Delete
databasegidesigngi-gianswer--
Agispecificationgiofgidatabasegiobjectsgisuchgiasgitables,gicolumns,gidatagitypes,giandgiindexes.giAlsogirefersgitogithegiproc
sgiusedgitogidevelopgithegispecification.
2gi/gi7
