1
D204: The Data Analytics Journey Practice Questions with
Correct Verified Answers/ Rated A+
What does SQL stand for? - ANS - structured query language
What is the 68, 95, 99 rule - ANS - 68% of the data are within one standard deviation, above or below the
mean. 95% of the observations are within two standard deviations above or below the mean. And 99.7%
of the observations are within three standard deviations above or below the mean.
the output of research and business environment must not only drive value but be simple enough and
easy enough to __________________________. - ANS - consume by the end users
Who are the end users? - ANS - Business managers, executives and even customers who are using the
outputs of the research
This is where you actually create the statistical model and you do the linear regression. You do the
decision tree. You do the deep learning neural network. - ANS - Modeling
These are the developers, and the system architects, the people who focus on the hardware and the
software that make data science possible - ANS - Data engineers
This is the phase of collecting data. - ANS - Data acquisition
Which phase? - Working with stakeholders to help them ask better questions so that both they and you
understand the outcome. - ANS - Discovery
What are the 4 parts of data analytics cycle? - ANS - Planning, Wrangling, Modeling and Applying
, 2
This phase is also known as the discovery phase. During this phase, an analyst defines the major
questions of interest that need to be answered, understand the needs of the stakeholders, and assess
the resource constraints in the project. - ANS - Business understanding
Which activity does an analyst perform in the discovery phase of the data analytics life cycle?
A. Identifying business needs
B. Identifying outliers
C. Cleaning data
D. Collecting data - ANS - A
In which phase of the data analytics life cycle does an analyst build a histogram?
A. Data acquisition
B. Data exploration
C. Discovery
D. Predictive modeling - ANS - B
An analyst applies a statistical formula to obtain the average temperature for a city over the last 50
years. Which phase of the data analytics life cycle is represented by this activity? A.
A. Data acquisition
B. Exploratory data analysis
C. Predictive modeling
D. Data reporting - ANS - B.
An analyst has been tasked with defining data columns that could contain null values. Which activity of
the data acquisition phase is represented?
A. Collecting data
, 3
B. Disqualifying data sources
C. Detecting missing values
D. Transforming improperly formatted text - ANS - C.
Which activity in the data analytics life cycle occurs during the data acquisition phase and requires the
most time and effort from the data analyst?
A. Selecting the data sources
B. Importing data into a database
C. Cleaning data
D. Defining goals - ANS - C.
____________________ is the person who champions the vision of the project and has the authority to
allocate resources. - ANS - The project sponsor
__________________ is responsible for making sure things get done on time and within budget and
removes roadblocks. - ANS - Project manager
___________ is when new requirements are added to the project that increases the time/resources
needed to complete it. - ANS - Scope creep
What are the 3 types of analysis? - ANS - Descriptive, Predictive, Prescriptive
___________________________ describes the data that is present. Mean, Median, Mode, counting
things. How many of each size and color of shirt were sold in the last month? Do we sell more shirts in
the summer vs winter? - ANS - Descriptive analysis
____________________ makes predictions about future state of business. Forecasting volumes for
example. Based on last summer and winter, what will we sell next year? - ANS - Predictive analytics
_______________________ analysis with an end goal of making a recommendation. What colors and
sizes of shirts should we sell to maximize profits? - ANS - Prescriptive analytics
, 4
______________________ is just looking at any variable over time - ANS - Time series analysis
A data analytics project manager has been asked to complete a project on a very short timeline. Which
action is likely to yield positive results?
A. Outsource the skilled work to an unproven vendor
B. Expand the team with experienced staff
C. Require current team to work overtime
D. Accept lowered quality standards - ANS - B
Which type of project management problem occurs when a data mining task has started but a data
acquisition task has not been completed?
A. Scope
B. Schedule
C. Procedure
D. Cost - ANS - B.
_______________ is a multipurpose programing language that has libraries that extend its capabilities to
do statistical analysis. - ANS - Python
______________________ are platforms that specialize in visualization. This is where you can make
graphs and charts for presentations and data storytelling to executive leaders. - ANS - Tableau and Power
BI
_______________________ are instant messaging platforms that facilitate in a faster, but less formal,
way than email. - ANS - Teams, Slack
A European union law regulating their citizens must have informed consent and ability to request or
delete their own data that you collect. - ANS - GDPR
D204: The Data Analytics Journey Practice Questions with
Correct Verified Answers/ Rated A+
What does SQL stand for? - ANS - structured query language
What is the 68, 95, 99 rule - ANS - 68% of the data are within one standard deviation, above or below the
mean. 95% of the observations are within two standard deviations above or below the mean. And 99.7%
of the observations are within three standard deviations above or below the mean.
the output of research and business environment must not only drive value but be simple enough and
easy enough to __________________________. - ANS - consume by the end users
Who are the end users? - ANS - Business managers, executives and even customers who are using the
outputs of the research
This is where you actually create the statistical model and you do the linear regression. You do the
decision tree. You do the deep learning neural network. - ANS - Modeling
These are the developers, and the system architects, the people who focus on the hardware and the
software that make data science possible - ANS - Data engineers
This is the phase of collecting data. - ANS - Data acquisition
Which phase? - Working with stakeholders to help them ask better questions so that both they and you
understand the outcome. - ANS - Discovery
What are the 4 parts of data analytics cycle? - ANS - Planning, Wrangling, Modeling and Applying
, 2
This phase is also known as the discovery phase. During this phase, an analyst defines the major
questions of interest that need to be answered, understand the needs of the stakeholders, and assess
the resource constraints in the project. - ANS - Business understanding
Which activity does an analyst perform in the discovery phase of the data analytics life cycle?
A. Identifying business needs
B. Identifying outliers
C. Cleaning data
D. Collecting data - ANS - A
In which phase of the data analytics life cycle does an analyst build a histogram?
A. Data acquisition
B. Data exploration
C. Discovery
D. Predictive modeling - ANS - B
An analyst applies a statistical formula to obtain the average temperature for a city over the last 50
years. Which phase of the data analytics life cycle is represented by this activity? A.
A. Data acquisition
B. Exploratory data analysis
C. Predictive modeling
D. Data reporting - ANS - B.
An analyst has been tasked with defining data columns that could contain null values. Which activity of
the data acquisition phase is represented?
A. Collecting data
, 3
B. Disqualifying data sources
C. Detecting missing values
D. Transforming improperly formatted text - ANS - C.
Which activity in the data analytics life cycle occurs during the data acquisition phase and requires the
most time and effort from the data analyst?
A. Selecting the data sources
B. Importing data into a database
C. Cleaning data
D. Defining goals - ANS - C.
____________________ is the person who champions the vision of the project and has the authority to
allocate resources. - ANS - The project sponsor
__________________ is responsible for making sure things get done on time and within budget and
removes roadblocks. - ANS - Project manager
___________ is when new requirements are added to the project that increases the time/resources
needed to complete it. - ANS - Scope creep
What are the 3 types of analysis? - ANS - Descriptive, Predictive, Prescriptive
___________________________ describes the data that is present. Mean, Median, Mode, counting
things. How many of each size and color of shirt were sold in the last month? Do we sell more shirts in
the summer vs winter? - ANS - Descriptive analysis
____________________ makes predictions about future state of business. Forecasting volumes for
example. Based on last summer and winter, what will we sell next year? - ANS - Predictive analytics
_______________________ analysis with an end goal of making a recommendation. What colors and
sizes of shirts should we sell to maximize profits? - ANS - Prescriptive analytics
, 4
______________________ is just looking at any variable over time - ANS - Time series analysis
A data analytics project manager has been asked to complete a project on a very short timeline. Which
action is likely to yield positive results?
A. Outsource the skilled work to an unproven vendor
B. Expand the team with experienced staff
C. Require current team to work overtime
D. Accept lowered quality standards - ANS - B
Which type of project management problem occurs when a data mining task has started but a data
acquisition task has not been completed?
A. Scope
B. Schedule
C. Procedure
D. Cost - ANS - B.
_______________ is a multipurpose programing language that has libraries that extend its capabilities to
do statistical analysis. - ANS - Python
______________________ are platforms that specialize in visualization. This is where you can make
graphs and charts for presentations and data storytelling to executive leaders. - ANS - Tableau and Power
BI
_______________________ are instant messaging platforms that facilitate in a faster, but less formal,
way than email. - ANS - Teams, Slack
A European union law regulating their citizens must have informed consent and ability to request or
delete their own data that you collect. - ANS - GDPR
