1|Page
Comptia Data+ Questions with 100% Verified Answers
LATESTLY UPDATED!!!
CSV and TSV - ANSWER Commas & Tabs (whitespace)
HTML - ANSWER Formatting tags in <>
Ident & Auth - ANSWER Separate Steps: Claim & Prove
JSON - ANSWER Key Value Pairs
- { "name" : "MikeMcMac1" }
- between curly braces
Measures & Dimensions - ANSWER Measures - Data observed &
explored
Dimensions - Space & Time segment data
Non-Relational Databases - ANSWER Developed to handle large
sets of data that are not easily organized into tables, columns,
and rows
,2|Page
Efficient by reducing overhead via Key/Value Pairs
Record Subsets & Temp Table - ANSWER Record Subsets - few
records returned from larger dataset, for less waiting during
command creating/testing. Ex: First 100
Temp Table - table not kept outside of session, for running stats
on it during that session
Query Execution Plan - ANSWER declarative - what to do:
sequence of steps for how to run query, with speed varying
based on optimizing via human or DBMS
Correlation Coefficient - ANSWER a statistical index of the
relationship between two things (from -1 to +1), computed via
statistical apps
Sample - ANSWER random subset of population that is
representative of population
, 3|Page
Sample Standard Deviation - ANSWER sum of [ (sample value
minus sample average) squared] divided by numbers of samples
less one.
used as approximation of population standard deviation
T-Test - ANSWER Compares mean values of a continuous
variable between 2 categories/groups.
Chi-Square Test - ANSWER hypothesis testing method for
whether your data is as expected.
If you have a single measurement variable, you use a Chi-square
goodness of fit test. If you have two measurement variables,
you use a Chi-square test of independence.
XML - ANSWER Structured text all in <>
Online transactional processing (OLTP) - ANSWER live capture of
transaction and event info to:
1) process info according to defined business rules
2) store info
3) update existing info if changed
Comptia Data+ Questions with 100% Verified Answers
LATESTLY UPDATED!!!
CSV and TSV - ANSWER Commas & Tabs (whitespace)
HTML - ANSWER Formatting tags in <>
Ident & Auth - ANSWER Separate Steps: Claim & Prove
JSON - ANSWER Key Value Pairs
- { "name" : "MikeMcMac1" }
- between curly braces
Measures & Dimensions - ANSWER Measures - Data observed &
explored
Dimensions - Space & Time segment data
Non-Relational Databases - ANSWER Developed to handle large
sets of data that are not easily organized into tables, columns,
and rows
,2|Page
Efficient by reducing overhead via Key/Value Pairs
Record Subsets & Temp Table - ANSWER Record Subsets - few
records returned from larger dataset, for less waiting during
command creating/testing. Ex: First 100
Temp Table - table not kept outside of session, for running stats
on it during that session
Query Execution Plan - ANSWER declarative - what to do:
sequence of steps for how to run query, with speed varying
based on optimizing via human or DBMS
Correlation Coefficient - ANSWER a statistical index of the
relationship between two things (from -1 to +1), computed via
statistical apps
Sample - ANSWER random subset of population that is
representative of population
, 3|Page
Sample Standard Deviation - ANSWER sum of [ (sample value
minus sample average) squared] divided by numbers of samples
less one.
used as approximation of population standard deviation
T-Test - ANSWER Compares mean values of a continuous
variable between 2 categories/groups.
Chi-Square Test - ANSWER hypothesis testing method for
whether your data is as expected.
If you have a single measurement variable, you use a Chi-square
goodness of fit test. If you have two measurement variables,
you use a Chi-square test of independence.
XML - ANSWER Structured text all in <>
Online transactional processing (OLTP) - ANSWER live capture of
transaction and event info to:
1) process info according to defined business rules
2) store info
3) update existing info if changed
