PRE-ASSESSMENT: Discovering Data - D468
QUESTIONS & ANSWERS(RATED A)
Which example is a pattern that can be observed during data analysis? - ANSWER A student gets up at
6:00 a.m. daily throughout the semester.
Which data analysis life cycle phase focuses on data generation, collection, storage, and management? -
ANSWER Prepare
Why is it important to draw conclusions based on clean data versus raw data? - ANSWER Clean data are
structured, but raw data lack structure for understanding.
A client is worried about long wait lines at their retail store. Which question would be effective for a
better understanding of the problem? - ANSWER Which hours have the most customer visits?
Why are visuals helpful when trying to understand or solve a problem? - ANSWER Visuals present data in
an understandable form.
How does data design help ensure data strength? - ANSWER It sets parameters and determines how data
are stored, accessed, and understood.
What does an analyst typically use first to solve a customer's problem, which was discovered during the
Ask phase? - ANSWER Data set
Which activity takes place during the data preparation phase? - ANSWER Data is collected and the
information is stored.
Which phase of the data analysis life cycle addresses the communication and interpretation of the data?
- ANSWER Share
, How does the visualization process help to understand the data output? - ANSWER It presents data sets
to identify trends and results.
Which activity is involved in the Share phase of the data analysis process? - ANSWER Using data for
storytelling
A business wants to see which locations sold a particular product. Which conditional SQL (Structured
Query Language) query should an analyst apply to conduct this search? - ANSWER Where, Narrows the
search
During skill-set testing, an analyst is asked to write a query that will be graded on how well it executes.
Which guideline should be used to format a successful SQL (Structured Query Language) query? -
ANSWER SQL queries can contain capitalization and indentation for easier reading.
Why do businesses leverage data to make decisions? - ANSWER To ensure they make the most accurate
decisions
How does a tool such as Microsoft Excel quickly expose data problems? - ANSWER It helps to organize
data and allows for anomalies to be detected more efficiently than unorganized data.
Which type of question should be asked to best facilitate a problem-solving conversation with the
stakeholders? - ANSWER Open-ended questions
Data sets are combined in the Analyze phase of the data-analysis life cycle. Why is it important to inform
solutions to specific problems? - ANSWER It provides a unified data set to address the questions.
Which phase of data analysis defines the problem? - ANSWER Ask
The analyst is pulling data together to start telling a story to address a problem the client has discussed.
Which phase of the data-analysis life cycle is the analyst exercising? - ANSWER Analyze
QUESTIONS & ANSWERS(RATED A)
Which example is a pattern that can be observed during data analysis? - ANSWER A student gets up at
6:00 a.m. daily throughout the semester.
Which data analysis life cycle phase focuses on data generation, collection, storage, and management? -
ANSWER Prepare
Why is it important to draw conclusions based on clean data versus raw data? - ANSWER Clean data are
structured, but raw data lack structure for understanding.
A client is worried about long wait lines at their retail store. Which question would be effective for a
better understanding of the problem? - ANSWER Which hours have the most customer visits?
Why are visuals helpful when trying to understand or solve a problem? - ANSWER Visuals present data in
an understandable form.
How does data design help ensure data strength? - ANSWER It sets parameters and determines how data
are stored, accessed, and understood.
What does an analyst typically use first to solve a customer's problem, which was discovered during the
Ask phase? - ANSWER Data set
Which activity takes place during the data preparation phase? - ANSWER Data is collected and the
information is stored.
Which phase of the data analysis life cycle addresses the communication and interpretation of the data?
- ANSWER Share
, How does the visualization process help to understand the data output? - ANSWER It presents data sets
to identify trends and results.
Which activity is involved in the Share phase of the data analysis process? - ANSWER Using data for
storytelling
A business wants to see which locations sold a particular product. Which conditional SQL (Structured
Query Language) query should an analyst apply to conduct this search? - ANSWER Where, Narrows the
search
During skill-set testing, an analyst is asked to write a query that will be graded on how well it executes.
Which guideline should be used to format a successful SQL (Structured Query Language) query? -
ANSWER SQL queries can contain capitalization and indentation for easier reading.
Why do businesses leverage data to make decisions? - ANSWER To ensure they make the most accurate
decisions
How does a tool such as Microsoft Excel quickly expose data problems? - ANSWER It helps to organize
data and allows for anomalies to be detected more efficiently than unorganized data.
Which type of question should be asked to best facilitate a problem-solving conversation with the
stakeholders? - ANSWER Open-ended questions
Data sets are combined in the Analyze phase of the data-analysis life cycle. Why is it important to inform
solutions to specific problems? - ANSWER It provides a unified data set to address the questions.
Which phase of data analysis defines the problem? - ANSWER Ask
The analyst is pulling data together to start telling a story to address a problem the client has discussed.
Which phase of the data-analysis life cycle is the analyst exercising? - ANSWER Analyze
