COMPTIA FINAL ASSESSMENT QUESTIONS AND CORRECT ANSWERS

COMPTIA FINAL ASSESSMENT
QUESTIONS AND CORRECT
ANSWERS
AA2softwareA2consultantA2isA2reviewingA2datasetsA2andA2measuringA2centralA2tendencies.A
2WhatA2isA2determinedA2byA2establishingA2theA2midpointA2valueA2forA2theA2dataA2byA2showi
ngA2howA2manyA2valuesA2areA2aboveA2orA2belowA2it?A2-A2Ans--
TheA2medianA2(middleA2valueA2withinA2anA2orderedA2setA2ofA2numbers)A2allowsA2theA2esta
blishmentA2ofA2aA2midpointA2value.

AA2cyberA2analystA2isA2preparingA2toA2researchA2aA2topicA2ofA2interest.A2WhatA2isA2theA2firs
tA2thingA2theA2analystA2shouldA2consider?A2-A2Ans--
OneA2ofA2theA2firstA2stepsA2toA2takeA2isA2toA2determineA2theA2researchA2questionsA2thatA2w
illA2beA2usedA2inA2theA2desiredA2study.

InA2anA2attemptA2toA2gainA2detailsA2surroundingA2aA2newA2platformA2feature,A2theA2cyberA2t
eamA2developsA2aA2surveyA2toA2collectA2dataA2basedA2onA2theA2opinionsA2ofA2theA2employ
ees.A2WhatA2typeA2ofA2responseA2isA2elicitedA2fromA2aA2fill-in-the-blankA2question?A2-
A2Ans--Text-basedA2answersA2allowA2forA2moreA2detailed,A2writtenA2feedback


AA2dataA2analystA2isA2searchingA2forA2dataA2thatA2hasA2alreadyA2beenA2compiledA2andA2su
mmarizedA2forA2analysisA2andA2reporting.A2WhatA2isA2theA2termA2forA2thisA2typeA2ofA2data?
A2-A2Ans--
AggregatedA2dataA2isA2dataA2thatA2hasA2alreadyA2beenA2compiledA2andA2summarized.

AA2cyberA2consultantA2isA2lookingA2toA2appendA2aA2dataA2setA2ofA2companyA2records.A2Wh
atA2isA2theA2benefitA2ofA2usingA2anA2intermediateA2append?A2-A2Ans--
AnA2intermediateA2appendA2willA2retainA2theA2separateA2dataA2setsA2andA2alsoA2createA2aA
2newA2dataA2setA2withA2allA2theA2combinedA2data.


AA2cyberA2technicianA2isA2reviewingA2theA2variousA2codeA2languagesA2usedA2forA2data.A2
WhatA2languageA2isA2consideredA2theA2mostA2comprehensiveA2andA2providesA2syntaxA2th
atA2isA2dedicatedA2toA2workingA2withA2data?A2-A2Ans--
TheA2mostA2comprehensiveA2languageA2isA2StructuredA2QueryA2LanguageA2(SQL).

AA2softwareA2engineerA2isA2curiousA2aboutA2missingA2valuesA2locatedA2withinA2theA2team's
A2spreadsheetA2afterA2reviewingA2severalA2NULLA2definedA2fields.A2WhatA2canA2causeA2th
eseA2NULLA2values?A2-A2Ans--
ValueA2isA2notA2applicableA2toA2theA2field,A2DataA2setA2hasA2noA2match,A2SurveyA2dataA2isA
2incomplete.


AA2businessA2analystA2isA2modifyingA2aA2dataA2setA2toA2provideA2forecastedA2totalsA2base
dA2onA2estimatedA2assetsA2andA2liabilitiesA2forA2theA2nextA2quarter.A2WhatA2isA2theA2analys

, tA2doingA2byA2modifyingA2theA2dataA2setA2fieldsA2withA2estimatedA2values?A2-A2Ans--
ImputingA2valuesA2meansA2replacingA2dataA2withA2anA2estimatedA2value.

AA2cyberA2consultantA2isA2conductingA2researchA2andA2testingA2hypothesesA2againstA2obt
ainedA2data.A2WhatA2occursA2whenA2researchA2questionsA2areA2convertedA2toA2aA2positive
A2statement?A2-A2Ans--
WhenA2researchA2questionsA2areA2convertedA2toA2aA2positiveA2statement,A2anA2alternative
A2hypothesisA2isA2created.


AA2cyberA2architectA2isA2reviewingA2aA2styleA2guideA2forA2appropriateA2colorA2schemesA2to
A2beA2associatedA2withA2theA2annualA2report.A2WhatA2shouldA2beA2consideredA2withA2theA2
selectionA2ofA2colorA2schemes?A2-A2Ans--
SelectA2schemesA2withA2theA2audienceA2experienceA2inA2mind,A2AvoidA2distractingA2sche
mes,A2UseA2aA2consistentA2scheme.

AA2cyberA2technicianA2isA2developingA2aA2lectureA2toA2discussA2structured,A2unstructured,A
2andA2semi-structuredA2data.A2WhatA2areA2examplesA2ofA2semi-structuredA2data?A2-
A2Ans--JSONA2files,A2XMLA2files,A2WebA2pagesA2(HTML)


AA2softwareA2consultantA2isA2preparingA2forA2anA2upcomingA2trainingA2symposiumA2andA2i
sA2reviewingA2commonA2techniquesA2forA2queryA2optimization.A2WhatA2isA2aA2queryA2thatA
2isA2nestedA2insideA2anotherA2queryA2statement?A2-A2Ans--
AA2subquery,A2alsoA2commonlyA2referredA2toA2asA2aA2nestedA2query,A2isA2aA2queryA2thatA2i
sA2nestedA2insideA2anotherA2queryA2statement.

AA2softwareA2engineerA2wantsA2toA2learnA2moreA2aboutA2theA2differencesA2associatedA2wit
hA2staticA2andA2dynamicA2reportA2writing.A2WhatA2typeA2ofA2reportA2reflectsA2onA2aA2specifi
cA2pointA2inA2time,A2whetherA2lookingA2atA2dataA2fromA2theA2mostA2recentA2monthA2orA2dat
aA2fromA2oneA2yearA2prior?A2-A2Ans--AA2point-in-
timeA2reportA2reflectsA2onA2aA2specificA2pointA2inA2time.

AA2softwareA2engineerA2isA2reviewingA2theA2variousA2typesA2ofA2dataA2thatA2areA2presentA2
inA2theA2company'sA2workingA2environment.A2WhatA2typeA2ofA2dataA2canA2beA2countedA2a
ndA2onlyA2takeA2onA2aA2certainA2numberA2ofA2values?A2-A2Ans--
DiscreteA2dataA2canA2beA2countedA2andA2canA2onlyA2takeA2onA2aA2certainA2numberA2ofA2va
lues.

AA2cyberA2technicianA2isA2reviewingA2theA2organization'sA2currentA2reportingA2techniques.
A2InA2creatingA2aA2report,A2whichA2reportA2isA2generatedA2inA2responseA2toA2aA2one-
timeA2request?A2-A2Ans--AA2reportA2generatedA2inA2responseA2toA2aA2one-
timeA2requestA2isA2knownA2asA2anA2ad-hocA2report.

AA2cyberA2technicianA2isA2reviewingA2theA2tenetsA2ofA2slowlyA2changingA2dimensions.A2Wh
atA2isA2anA2aspectA2ofA2SlowlyA2ChangingA2DimensionA2TypeA23?A2-A2Ans--
SlowlyA2ChangingA2DimensionA2TypeA23A2addsA2aA2newA2columnA2forA2theA2currentA2valu
e,A2butA2alsoA2retainsA2theA2originalA2columnA2withA2theA2originalA2value.