INTRO INTO DATA ANALYTICS EXAM
QUESTIONS WITH COMPLETE
SOLUTIONS
Which activity occurs during the data preparation phase of the data analytics
lifecycle?
A. Discovery of data
B. Modeling of data
C. Collection of data
D. Understanding of data - ANSWER-D. Understanding of data
Which data visualization is most suitable for understanding the trend and
progression of a variable over time in the data preparation phase?
A. Histograms
B. Scatter plots
C. Box plots
D. Line charts - ANSWER-D. Line charts
Which task is commonly performed to identify and address data quality issues during
the data preparation phase?
A. Performing data deduplication
B. Developing data visualization
C. Conducting data profiling
D. Executing data integration - ANSWER-C. Conducting data profiling
Which common data cleaning task is used to address the missing data in a data set?
A. Normalization
B. Handling outliers
C. Data transformation
D. Imputation - ANSWER-D. Imputation
Which task is typically performed to handle outliers during the data preparation
phase?
A. Normalization
B. Truncating extreme values
C. Data transformation
D. Missing data imputation - ANSWER-B. Truncating extreme values
A data analyst at a retail company is provided with a large dataset containing sales
transactions, customer information, and product details. The analyst is tasked with
preparing the data for analysis and modeling.
, Which activity would the analyst perform during the data preparation phase?
A. Exploring available data to understand its characteristics and suitability
B. Identifying the business problem or research question that needs to be addressed
C. Developing initial hypotheses about the relationship between data variables
D. Allocating computing resources for the data analysis - ANSWER-A. Exploring
available data to understand its characteristics and suitability
Which activity is performed during the model planning phase of a data analysis
project?
A. Building the final predictive model
B. Selecting relevant features for modeling
C. Generating synthetic data for model training
D. Conducting hypothesis testing on the modeling data - ANSWER-B. Selecting
relevant features for modeling
Which stakeholder is primarily responsible for ensuring the desired quality of the
project?
A. Business intelligence analysts
B. Business users
C. Project managers
D. Project sponsors - ANSWER-C. Project managers
Which stakeholder has access to essential tables or storage systems and
guarantees the highest levels of security in the data repository?
A. Data analyst
B. Data engineer
C. Data scientist
D. Database administrator - ANSWER-D. Database administrator
Why is it significant to establish failure criteria for a data analytics project in the
discovery phase?
A. It ensures that the project team will reach its goals.
B. It helps the team determine when it is best to accept the conclusions.
C. It provides a best-case scenario approach.
D. It guides the team in identifying the main objectives of the project. - ANSWER-B.
It helps the team determine when it is best to accept the conclusions.
Which stakeholder extracts and transforms data during the discovery phase?
A. Data engineer
B. Data scientist
C. Database administrator
D. Business intelligence analyst - ANSWER-A. Data engineer
QUESTIONS WITH COMPLETE
SOLUTIONS
Which activity occurs during the data preparation phase of the data analytics
lifecycle?
A. Discovery of data
B. Modeling of data
C. Collection of data
D. Understanding of data - ANSWER-D. Understanding of data
Which data visualization is most suitable for understanding the trend and
progression of a variable over time in the data preparation phase?
A. Histograms
B. Scatter plots
C. Box plots
D. Line charts - ANSWER-D. Line charts
Which task is commonly performed to identify and address data quality issues during
the data preparation phase?
A. Performing data deduplication
B. Developing data visualization
C. Conducting data profiling
D. Executing data integration - ANSWER-C. Conducting data profiling
Which common data cleaning task is used to address the missing data in a data set?
A. Normalization
B. Handling outliers
C. Data transformation
D. Imputation - ANSWER-D. Imputation
Which task is typically performed to handle outliers during the data preparation
phase?
A. Normalization
B. Truncating extreme values
C. Data transformation
D. Missing data imputation - ANSWER-B. Truncating extreme values
A data analyst at a retail company is provided with a large dataset containing sales
transactions, customer information, and product details. The analyst is tasked with
preparing the data for analysis and modeling.
, Which activity would the analyst perform during the data preparation phase?
A. Exploring available data to understand its characteristics and suitability
B. Identifying the business problem or research question that needs to be addressed
C. Developing initial hypotheses about the relationship between data variables
D. Allocating computing resources for the data analysis - ANSWER-A. Exploring
available data to understand its characteristics and suitability
Which activity is performed during the model planning phase of a data analysis
project?
A. Building the final predictive model
B. Selecting relevant features for modeling
C. Generating synthetic data for model training
D. Conducting hypothesis testing on the modeling data - ANSWER-B. Selecting
relevant features for modeling
Which stakeholder is primarily responsible for ensuring the desired quality of the
project?
A. Business intelligence analysts
B. Business users
C. Project managers
D. Project sponsors - ANSWER-C. Project managers
Which stakeholder has access to essential tables or storage systems and
guarantees the highest levels of security in the data repository?
A. Data analyst
B. Data engineer
C. Data scientist
D. Database administrator - ANSWER-D. Database administrator
Why is it significant to establish failure criteria for a data analytics project in the
discovery phase?
A. It ensures that the project team will reach its goals.
B. It helps the team determine when it is best to accept the conclusions.
C. It provides a best-case scenario approach.
D. It guides the team in identifying the main objectives of the project. - ANSWER-B.
It helps the team determine when it is best to accept the conclusions.
Which stakeholder extracts and transforms data during the discovery phase?
A. Data engineer
B. Data scientist
C. Database administrator
D. Business intelligence analyst - ANSWER-A. Data engineer
