Learning Data
Analytics
Analysts engage in all of the following activities, except:
a. cleaning data to remove unnecessary data from the mix
b. looking for data to uncover issues in a process
c. building reports, as well as queries and spreadsheets
d. changing data values - ANSWERD
Data analysts work in a variety of different ways, depending on the
project. Data analysts, at a minimum, do what for their data science
team?
a. Deliver statistical talking points.
b. Provide historical perspective.
c. Take meeting minute notes.
d. Bring data to the team for additional analysis. - ANSWERD
Learning syntax is one of the first big hurdles for any analyst. Which of
the following are NOT recommended for learning syntax?
a. on-screen help in the palettes of the program you are using
b. The Help menu of the program you are using
c. trial and error
, d. credible online resources - ANSWERC
Getting data to a _____ format can help you do more with it.
a. raw
b. queried
c. customized
d. aggregated - ANSWERA
The result of a(n) _____ join for two tables/columns/etc. always
contains all records of the "left" table, even if the join-condition does not
find any matching record in the "right" table.
a. right outer
b. inner
c. left outer
d. outer - ANSWERC
What kind of join requires that there is a record in both of the joined
tables/columns?
a. left outer
b. inner
c. outer
d. right outer - ANSWERB
Analytics
Analysts engage in all of the following activities, except:
a. cleaning data to remove unnecessary data from the mix
b. looking for data to uncover issues in a process
c. building reports, as well as queries and spreadsheets
d. changing data values - ANSWERD
Data analysts work in a variety of different ways, depending on the
project. Data analysts, at a minimum, do what for their data science
team?
a. Deliver statistical talking points.
b. Provide historical perspective.
c. Take meeting minute notes.
d. Bring data to the team for additional analysis. - ANSWERD
Learning syntax is one of the first big hurdles for any analyst. Which of
the following are NOT recommended for learning syntax?
a. on-screen help in the palettes of the program you are using
b. The Help menu of the program you are using
c. trial and error
, d. credible online resources - ANSWERC
Getting data to a _____ format can help you do more with it.
a. raw
b. queried
c. customized
d. aggregated - ANSWERA
The result of a(n) _____ join for two tables/columns/etc. always
contains all records of the "left" table, even if the join-condition does not
find any matching record in the "right" table.
a. right outer
b. inner
c. left outer
d. outer - ANSWERC
What kind of join requires that there is a record in both of the joined
tables/columns?
a. left outer
b. inner
c. outer
d. right outer - ANSWERB
