WGU D465 Data Applications Exam
Practice Guide with Questions and
Expert Graded A+ Answers | Latest
Version
1. A/B testing - ANSWER The process of testing two variations of the same
web page to determine which page is more successful at attracting user
traffic and generating revenue
2. Absolute reference - ANSWER A reference within a function that is locked
so that rows and columns won't change if the function is copied
3. Access control - ANSWER Features such as password protection, user
permissions, and encryption that are used to protect a spreadsheet
4. Accuracy - ANSWER The degree to which data conforms to the actual
entity being measured or described
5. Bar graph - ANSWER A data visualization that uses size to contrast and
compare two or more values
6. Bias - ANSWER A conscious or subconscious preference in favor of or
against a person, group of people, or thing
7. Big data - ANSWER Large, complex datasets typically involving long
periods of time, which enable data analysts to address far-reaching business
problems
,8. Boolean data - ANSWER A data type with only two possible values,
usually true or false
9. Borders - ANSWER Lines that can be added around two or more cells on a
spreadsheet
10.Box plot - ANSWER A data visualization that displays the distribution of
values along an x-axis
11.Bubble chart - ANSWER A data visualization that displays individual data
points as bubbles, comparing numeric values by their relative size
12.Bullet graph - ANSWER A data visualization that displays data as a
horizontal bar chart moving toward a desired value
13.Business metric - ANSWER A standard of measurement used to solve a
business task
14.Business task - ANSWER The question or problem data analysis resolves
for a business
15.Calculated field - ANSWER A new field within a pivot table that carries out
certain calculations based on the values of other fields
16.Calculus - ANSWER A branch of mathematics that involves the study of
rates of change and the changes between values that are related by a function
,17.CASE - ANSWER A SQL statement that returns records that meet
conditions by including an if/then statement in a query
18.CAST - ANSWER A SQL function that converts data from one datatype to
another
19.Causation - ANSWER When an action directly leads to an outcome, such as
a cause-effect relationship
20.Cell reference - ANSWER A cell or a range of cells in a worksheet typically
used in formulas and functions
21.Ruby - ANSWER An object-oriented programming language for web
application development
22.Sample - ANSWER In data analytics, a segment of a population that is
representative of the entire population
23.Action-oriented question - ANSWER A question whose answers lead to
change
24.Administrative metadata - ANSWER Metadata that indicates the technical
source of a digital asset
25.Agenda - ANSWER A list of scheduled appointments
26.Aggregation - ANSWER The process of collecting or gathering many
separate pieces into a whole
27.Algorithm - ANSWER A process or set of rules followed for a specific task
, 28.Aliasing - ANSWER Temporarily naming a table or column in a query to
make it easier to read and write
29.Alternative text - ANSWER Text that provides an alternative to non-text
content, such as images and videos
30.Analytical skills - ANSWER Qualities and characteristics associated with
using facts to solve problems
31.Analytical thinking - ANSWER The process of identifying and defining a
problem, then solving it by using data in an organized, step-by-step manner
32.Annotation - ANSWER Text that briefly explains data or helps focus the
audience on a particular aspect of the data in a visualization
33.Area chart - ANSWER A data visualization that uses individual data points
for a changing variable connected by a continuous line with a filled in area
underneath
34.Array - ANSWER A collection of values in spreadsheet cells
35.Attribute - ANSWER A characteristic or quality of data used to label a
column in a table
36.Audio file - ANSWER Digitized audio storage usually in an MP3, AAC, or
other compressed format
37.AVERAGE - ANSWER A spreadsheet function that returns an average of
the values from a selected range
Practice Guide with Questions and
Expert Graded A+ Answers | Latest
Version
1. A/B testing - ANSWER The process of testing two variations of the same
web page to determine which page is more successful at attracting user
traffic and generating revenue
2. Absolute reference - ANSWER A reference within a function that is locked
so that rows and columns won't change if the function is copied
3. Access control - ANSWER Features such as password protection, user
permissions, and encryption that are used to protect a spreadsheet
4. Accuracy - ANSWER The degree to which data conforms to the actual
entity being measured or described
5. Bar graph - ANSWER A data visualization that uses size to contrast and
compare two or more values
6. Bias - ANSWER A conscious or subconscious preference in favor of or
against a person, group of people, or thing
7. Big data - ANSWER Large, complex datasets typically involving long
periods of time, which enable data analysts to address far-reaching business
problems
,8. Boolean data - ANSWER A data type with only two possible values,
usually true or false
9. Borders - ANSWER Lines that can be added around two or more cells on a
spreadsheet
10.Box plot - ANSWER A data visualization that displays the distribution of
values along an x-axis
11.Bubble chart - ANSWER A data visualization that displays individual data
points as bubbles, comparing numeric values by their relative size
12.Bullet graph - ANSWER A data visualization that displays data as a
horizontal bar chart moving toward a desired value
13.Business metric - ANSWER A standard of measurement used to solve a
business task
14.Business task - ANSWER The question or problem data analysis resolves
for a business
15.Calculated field - ANSWER A new field within a pivot table that carries out
certain calculations based on the values of other fields
16.Calculus - ANSWER A branch of mathematics that involves the study of
rates of change and the changes between values that are related by a function
,17.CASE - ANSWER A SQL statement that returns records that meet
conditions by including an if/then statement in a query
18.CAST - ANSWER A SQL function that converts data from one datatype to
another
19.Causation - ANSWER When an action directly leads to an outcome, such as
a cause-effect relationship
20.Cell reference - ANSWER A cell or a range of cells in a worksheet typically
used in formulas and functions
21.Ruby - ANSWER An object-oriented programming language for web
application development
22.Sample - ANSWER In data analytics, a segment of a population that is
representative of the entire population
23.Action-oriented question - ANSWER A question whose answers lead to
change
24.Administrative metadata - ANSWER Metadata that indicates the technical
source of a digital asset
25.Agenda - ANSWER A list of scheduled appointments
26.Aggregation - ANSWER The process of collecting or gathering many
separate pieces into a whole
27.Algorithm - ANSWER A process or set of rules followed for a specific task
, 28.Aliasing - ANSWER Temporarily naming a table or column in a query to
make it easier to read and write
29.Alternative text - ANSWER Text that provides an alternative to non-text
content, such as images and videos
30.Analytical skills - ANSWER Qualities and characteristics associated with
using facts to solve problems
31.Analytical thinking - ANSWER The process of identifying and defining a
problem, then solving it by using data in an organized, step-by-step manner
32.Annotation - ANSWER Text that briefly explains data or helps focus the
audience on a particular aspect of the data in a visualization
33.Area chart - ANSWER A data visualization that uses individual data points
for a changing variable connected by a continuous line with a filled in area
underneath
34.Array - ANSWER A collection of values in spreadsheet cells
35.Attribute - ANSWER A characteristic or quality of data used to label a
column in a table
36.Audio file - ANSWER Digitized audio storage usually in an MP3, AAC, or
other compressed format
37.AVERAGE - ANSWER A spreadsheet function that returns an average of
the values from a selected range
