WGU D075 Final Exam (New 2024/ 2025 Update) Information Technology Management Essentials | Qs & As| 100% Correct| Grade A

WGUID075IFinalIExamI(NewI2024/I2025I
Update)IInformationITechnologyI
ManagementIEssentialsI|IQsI&IAs|I100%I
Correct|IGradeIA
QUESTION
AIdataIanalystIwantsItoIuseIsoftwareItoIlookIforIusefulIpatternsIandIhiddenIrelationshipsIinIthi
sIlargeIsetIofIsocialImediaIdata.
WhichIprocessIcanIbeIusedItoIlookIforItheseIpatternsIandIrelationships?

Answer:
IDataImining



QUESTION
AIbusinessIanalystIwantsItoIuseItheIsocialImediaIdataItoIcreateIandIpresentIbusinessIintelligen
ce.ISheIwillIcreateIvisualizationsIthatIwillIbeIusedIbyItheIexecutiveIteam.
I
WhichItoolIisIappropriateIforIcreatingIandIpresentingIthisIbusinessIintelli-Igence?

Answer:
ITableau



QUESTION
TheIdataIwarehouseIisIveryIcostlyIandItime-
consumingItoImanage,IandItheIdataIanalystInoticesIthatItheIdataIwarehouseIonlyIusedI20Iperce
ntIofIitsIcapacityIduringIdiscovery.
HowIcanItheIcompanyIreduceItheIcostIandItimeIassociatedIwithImanagingItheIdataIwarehouse
?

Answer:
ISwitchItoIaIdataImart



QUESTION

,TrueIorIFalse:IStructuredIQueryILanguageI(SQL)IcanIbeIusedItoIqueryIdataIinInearlyIeveryIty
peIofIdatabase.

Answer:
I
True



QUESTION
AIdataIanalystIwantsItoIsearchIthoughIunstructuredIdataIfromIsocialImediaIpostsItoIlookIforIu
sefulIcustomerIbehaviorIpatternsIandIsentiments.
WhichItypeIofIanalyticsIareIappropriateIforIthisItask?

Answer:
ITextIanalytics



QUESTION
WhichItermIrefersItoImanagingItheIavailability,Iintegrity,IandIsecurityIofIanIorganization'sIdata
ItoIensureIthatItheIdataIremainIhighIqualityIandIvalid?

Answer:
IDataIgovernance



QUESTION
ByIsegmentingIdataIinIaIdataImanagementIsystem,IaIbusinessIachievesIaIsignificantIadvantage
IoverInonsegmentation.
WhatIisIthatIadvantage?

Answer:
IItItargetsItheIrightIcustomers.



QUESTION
WhatIisItheIprocessIofInormalizationIofIaIdatabase?

Answer:
IRemovingIredundan-IciesIwithinItheIdatabase

,QUESTION
WhichIrestrictionIappliesItoItheIdataIinItheIprimaryIfieldIofIaIdatabase?-


Answer:
IEachIkeyImustIbeIunique.



QUESTION
FreedomIRockIBicyclesIhasIinstalledIaInewIdatabaseItoIkeepItrackIofIsalesIbyIregion,Isalesper
son,Iproduct,IandIsalesIprices,IamongIotherIitems,ItoIkeepIinformationIonIbusinessIprocesses.I
AfterIinstallation,IFreedomIRockIBicyclesIdiscoveredIadditionalIbenefitsIofItheIinformationIac
cumulatedIinItheIdatabaseIandIhowItheIinformationIcanIimproveItheIbusinessIprofitabilityIandI
futureIplans.
FreedomIRockIBicyclesIfoundIthatIdailyIreportsIcouldIbeIrunIusingISQLItoIindicateIproductIa
ndIpartsIinventoryIandIsalesIforItheIday.
I
WhichIapproachIcanIbeIusedItoIretrieveIthisIinformationIefficiently?

Answer:
IOnlineIanalyticalIprocessingI(OLAP)



QUESTION
FreedomIRockIBicyclesIfoundIthatIitIhasImultipleIrecordsIdueItoImultipleIsalesItoItheIsameIin
dividual.IThisIhasIcausedIaccessIproblemsIwhenIlookingIforIspecificIcustomers.
WhatIcanIFreedomIRockIBicyclesIdoItoIalleviateIthisIproblem?

Answer:
INormalizeItheIdatabase



QUESTION
WhichIvaluableIbusinessIintelligenceI(BI)IcanIFreedomIRockIBicyclesIac-
IquireIfromItheIdatabaseIthatIdirectlyIrelatesItoIoverallIrevenueIandIprofitabilityIbasedIonIthisI
scenario?

Answer:
IKnowingIwhichIproductsIsellItheIbestIinIeachIregion

, QUESTION
FreedomIRockIBicyclesIisIconsideringIadoptingIaIcloud-databaseIsys-Item.
WhatIisItheIprimaryIadvantageIofIaIcloudIdatabase?

Answer:
IItIcanIbeIaccessedIfromIanywhereIthereIisIanIinternetIconnection.



QUESTION
TheIdataIanalystIatIFreedomIRockIBicyclesIwantsItoIlinkItwoItablesIinItheIdatabase.
WhatIisItheInameIofItheIfieldIinIaIdatabaseItableIthatIisIusedItoIconnectIorIlinkItwoItablesItog
ether?

Answer:
IForeignIkey



QUESTION
MODULEI#6
WhatIisItheIcorrectIExcelIfunctionIexpressionItoIcalculateItheItotalIofIallIofItheIscoresI(colum
nIF)IinIcellIC2?

Answer:
IMODULEI#6
=SUM(F3:F17)



QUESTION
WhichIvalueIwillIbeIreturnedIinIcellIC4IifI"=MAX(F3:F17)"IisIinputIinItheIcell?

Answer:
I100



QUESTION
InItheIfollowingI"IF"Istatement,IwhatIisI"C2>B2"Icalled?I=IF(C2>B2,"Over
Budget","UnderIBudget")

Answer:
IArgument