Data Analytics Practice Exam
You are provided with this table of past, present, and future sales data. You need to
create a chart that allows you to visualize and compare the relative sales of the three
products for each year.
Which chart should you create? - answer Bar Chart
You are provided this table of aggregated employment data about data analysts from
different regions of the world. You need to determine when you should disaggregate this
data. For each statement, select Yes if you should disaggregate the data or No if you
should not.
You want to know if the employment rate is proportional to students who went to
colleges in high-income areas.
You want to know if military training has a positive correlation with employment.
You want to know whether there are more employed people in the Western USA than in
the Eastern USA. - answerYes
No
No
Which US law protects healthcare patients' private information by imposing limitations
on how healthcare providers can share and access data? - answerHIPPA
To reduce bias, a teacher needs to grade student assignments without knowing who
submitted each assignment. She asks her colleague to replace the name on each
assignment with a number and to maintain a private list of the names and their
corresponding numbers. After the teacher finishes grading, the colleague replaces each
number with the original name.
Which process are they using? - answerPseudonymization, this is a deidentification
procedure
For each statement, select Yes if it represents quantitative data or No if it does not.
The percentage of teachers in each school district teaching more than one subject
A survey of 100 teachers asking for their favorite subject, favorite classroom size, and
favorite time of day to teach
The average number of students at each grade level at a school - answerYes
No
Yes
Which statement is true about p-values?
, A p-value describes how much one variable impacts another.
A p-value close to 1 reflects a greater relationship between two values.
Large p-values reflect a significant difference between two groups.
Smaller p-values provide greater evidence that the null hypothesis should be rejected. -
answerSmaller p-values provide greater evidence that the null hypothesis should be
rejected.
You have been asked to organize this data so that each product is displayed on a row,
with the columns being titled ProductID, Color, Cost, ListPrice, Size, and
ShippingWeight. They are currently rows and your asked to make them columns. Which
organization technique fulfills the request? - answerTranspose
You received a file from which you need to extract data. A small section of the file is
shown below.
{"breakfast":[{"Entree":"Belgian Waffles","Price":"$9.95","Description":"Two of our
famous Belgian Waffles with plenty of real maple syrup","Calories":"650"},
{"Entree":"French Toast","Price":"$8.95","Description":"Thick slices made from our
homemade sourdough bread","Calories":"600"}]}
Which type of file are you importing? - answerJSON File
You gather data from an automobile dealership regarding vehicles sold last month. You
need to determine which visualization to use to answer questions about the data.
Move each chart type from the list on the left to the correct question that it can answer
on the right.
How many more cars were sold than trucks?
Which vehicle make had the most sales?
Which day had the highest vehicle sales? - answerColumn (bar) Chart
Pie Chart
Line Graph
For each statement, select Yes if it is true or No if it is false.
In a typical data table, rows run horizontally and contain data related to a single entity
(such as a person or a company).
In a typical data table, columns run horizontally and contain data related to a single
entity (such as a person or a company).
In a typical data table, rows run horizontally and each row contains only one specified
data type (such as text or numbers).
In a typical data table, columns run vertically and contain data values of a specified type
(such as text or numbers). - answerYes
No
You are provided with this table of past, present, and future sales data. You need to
create a chart that allows you to visualize and compare the relative sales of the three
products for each year.
Which chart should you create? - answer Bar Chart
You are provided this table of aggregated employment data about data analysts from
different regions of the world. You need to determine when you should disaggregate this
data. For each statement, select Yes if you should disaggregate the data or No if you
should not.
You want to know if the employment rate is proportional to students who went to
colleges in high-income areas.
You want to know if military training has a positive correlation with employment.
You want to know whether there are more employed people in the Western USA than in
the Eastern USA. - answerYes
No
No
Which US law protects healthcare patients' private information by imposing limitations
on how healthcare providers can share and access data? - answerHIPPA
To reduce bias, a teacher needs to grade student assignments without knowing who
submitted each assignment. She asks her colleague to replace the name on each
assignment with a number and to maintain a private list of the names and their
corresponding numbers. After the teacher finishes grading, the colleague replaces each
number with the original name.
Which process are they using? - answerPseudonymization, this is a deidentification
procedure
For each statement, select Yes if it represents quantitative data or No if it does not.
The percentage of teachers in each school district teaching more than one subject
A survey of 100 teachers asking for their favorite subject, favorite classroom size, and
favorite time of day to teach
The average number of students at each grade level at a school - answerYes
No
Yes
Which statement is true about p-values?
, A p-value describes how much one variable impacts another.
A p-value close to 1 reflects a greater relationship between two values.
Large p-values reflect a significant difference between two groups.
Smaller p-values provide greater evidence that the null hypothesis should be rejected. -
answerSmaller p-values provide greater evidence that the null hypothesis should be
rejected.
You have been asked to organize this data so that each product is displayed on a row,
with the columns being titled ProductID, Color, Cost, ListPrice, Size, and
ShippingWeight. They are currently rows and your asked to make them columns. Which
organization technique fulfills the request? - answerTranspose
You received a file from which you need to extract data. A small section of the file is
shown below.
{"breakfast":[{"Entree":"Belgian Waffles","Price":"$9.95","Description":"Two of our
famous Belgian Waffles with plenty of real maple syrup","Calories":"650"},
{"Entree":"French Toast","Price":"$8.95","Description":"Thick slices made from our
homemade sourdough bread","Calories":"600"}]}
Which type of file are you importing? - answerJSON File
You gather data from an automobile dealership regarding vehicles sold last month. You
need to determine which visualization to use to answer questions about the data.
Move each chart type from the list on the left to the correct question that it can answer
on the right.
How many more cars were sold than trucks?
Which vehicle make had the most sales?
Which day had the highest vehicle sales? - answerColumn (bar) Chart
Pie Chart
Line Graph
For each statement, select Yes if it is true or No if it is false.
In a typical data table, rows run horizontally and contain data related to a single entity
(such as a person or a company).
In a typical data table, columns run horizontally and contain data related to a single
entity (such as a person or a company).
In a typical data table, rows run horizontally and each row contains only one specified
data type (such as text or numbers).
In a typical data table, columns run vertically and contain data values of a specified type
(such as text or numbers). - answerYes
No
