D491 for Post Assessment Exam Questions With Correct
Answers
1) Which job position is primarily responsible for designing and constructing data pipelines
| | | | | | | | | | |
| within the field of data analytics?: Dataengineer
| | | | | | |
2) Which role is responsible for project initiation and providing the require-
| | | | | | | | | |
ments for a project?: Projectsponsor
| | | | |
3) Which role in a data analytics project helps data scientists shape data for
| | | | | | | | | | | |
| analysis?: Data engineer | |
4) Which role in a data analytics project provides expertise for analytical tech-niques?:
| | | | | | | | | | |
|Data scientist
|
5) Which skills are required by data scientists for converting unstructured data tostructured
| | | | | | | | | | | |
|dataindataanalyticsprojects?:Datawranglingskills
| | | | | | |
6) Which skill must a business intelligence analyst possess to collect and orga-nize data?:
| | | | | | | | | | | |
|Data preparation
|
7) Which project-related activity typically takes up the majority of a data ana-lyst's time?:
| | | | | | | | | | | |
|Data preparation
|
8) Which software do business intelligence analysts use to perform their re-
| | | | | | | | | |
sponsibilities?: Microsoft Excel | |
9) Whatisaskillrequiredofadataengineer?:Maintainingdatabases
| | | | | | | | | |
10) Which group of stakeholders comprises the professionals, such as line | | | | | | | | |
| managers?: Business users | |
11) Which stakeholder is primarily responsible for ensuring the desired quality of
| | | | | | | | | |
|the project?: Projectmanagers
| | |
12) Which stakeholder has access to essential tables or storage systems and | | | | | | | | | |
| guarantees the highest levels of security in the data repository?: Databaseadmin-istrator
| | | | | | | | | | |
13) Why is it significant to establish failure criteria for a data analytics project in
| | | | | | | | | | | | |
|the discovery phase?: Ithelpstheteamdeterminewhenitisbesttoaccepttheconclusions.
| | | | | | | | | | | | | | |
14) Which stakeholder extracts and transforms data during the discovery | | | | | | | |
| phase?: Data engineer | |
15) A person has been assigned to manage a project to implement a compa-ny-wide
| | | | | | | | | | | |
|customer relationship management (CRM) system. The CRM system aims to centralize
| | | | | | | | | |
| customer details, automate sales processes, and improve | | | | | |
1 |/ |27
,16)
17) customer service. What skills are crucial for the project team members work- | | | | | | | | | | |
ing on the CRM system implementation?: Data analysis, system integration, and training
| | | | | | | | | | |
18) Why is formulating an initial hypothesis an integral part of the discovery
| | | | | | | | | | |
|phase of the data analytics lifecycle?: Itguidesthesubsequent(following)datacollection, processing, and
| | | | | | | | | | | | | |
analysis activities.
| |
19) Who should be included as stakeholders in an analytics project?: Anyonewho will benefit
| | | | | | | | | | | | |
from the project
| | |
20) Who offers suggestions on ideas to test as the team formulates hypotheses during the
| | | | | | | | | | | | |
discovery phase of a data analytics project?: Datascientists
| | | | | | | | |
21) Which activity occurs during the data preparation phase of the data analyt-ics
| | | | | | | | | | |
lifecycle?: Understandingofdata
| | | |
22) Which data visualization is most suitable for understanding the trend and
| | | | | | | | | |
|progressionofa variable over time in the data preparation phase?: Linecharts
| | | | | | | | | | | |
23) Which task is commonly performed to identify and address data quality
| | | | | | | | | |
|issues during the data preparation phase?: Conductingdataprofiling
| | | | | | | |
24) Which common data cleaning task is used to address the missing data in a data set?:
| | | | | | | | | | | | | | |
Imputation
|
25) Which task is typically performed to handle outliers during the data prepa-
| | | | | | | | | | |
ration phase?: Truncatingextremevalues
| | | |
26) A data analyst at a retail company is provided with a large dataset contain-ing
| | | | | | | | | | | | |
|sales transactions, customer information, and product details. The analyst is tasked
| | | | | | | | | |
with preparing the data for analysis and modeling.
| | | | | | | |
27) Which activity would the analyst perform during the data preparation phase?-
| | | | | | | | | |
28) : Exploring available data to understand its characteristics and suitability
| | | | | | | | |
29) Which activity is performed during the model planning phase of a data
| | | | | | | | | | |
|analysis project?: Selecting relevant features for modeling
| | | | | |
30) Which is primarily used for statistical analysis and data manipulation in the model
| | | | | | | | | | | |
|planning phase?: R | |
31) Which classification model is based on the concept of probability and assigns
| | | | | | | | | | |
|class labels to instances based on the possibility of belonging to a particular class?:
| | | | | | | | | | | | |
NaiveBayes
| |
2 |/ |27
, 32)
33) Which tool is used to connect users to relational databases and data ware-house
| | | | | | | | | | | |
appliances in the model planning phase?: SAS/ACCESS
| | | | | | |
34) Which regression model is commonly used for predicting a continuous
| | | | | | | | |
numerical outcome based on a set of input features?: Linearregression
| | | | | | | | | | |
35) Which phase of the data analytics life cycle involves running analytical
| | | | | | | | | |
software packages on small datasets to test and refine models?: Modelexecution phase
| | | | | | | | | | | | |
36) Which step is typically performed after executing the model in the model
| | | | | | | | | | |
execution phase?: Result analysis
| | | |
37) What is the role of the SPSS modeler in the model execution phase of the data
| | | | | | | | | | | | | | |
analytics life cycle?: Itisusedforapplyingthetrained modeltonewdataforpredictions.
| | | | | | | | | | | | | | | |
38) Which testing procedure is used for evaluating the performance of a model in the
| | | | | | | | | | | | |
data analytics lifecycle?:Cross-validation
| | | | |
39) How does the communication of results tie to the operationalize phase of data
| | | | | | | | | | | |
analytics?: It implements data-driven insights into business functions.
| | | | | | | |
40) Which data visualization tool in the communicate results phase is used to create
| | | | | | | | | | | |
web-based visualization?: D3.js
| | |
41) Which measure assesses the validity of a correlation between two variables
| | | | | | | | | |
during the communicate results phase?: P-value
| | | | | |
42) Which statement is an example of a common pitfall in the communication of
| | | | | | | | | | | |
model results?: Focusing only on the accuracy of the model
| | | | | | | | | |
43) What is the purpose of communicating data analytics results to stakehold-
| | | | | | | | | |
ers?: To demonstrate the value and impact of data analytics on business outcomes
| | | | | | | | | | | |
44) A data analyst working for a retail company has a team that analyzes cus-tomer
| | | | | | | | | | | | |
purchasing behavior and identifies a segment of high-value customers who have a high
| | | | | | | | | | | | |
propensity to churn. Now the analyst needs to communicate the results to the customer
| | | | | | | | | | | | | |
service department to operationalize the insights and reduce customer churn. How does
| | | | | | | | | | | |
the communication of results tie to the operationalize phase of data analytics?: By implementing
| | | | | | | | | | | | | |
personalized outreach to customers
| | | |
45) Which phase is the immediate predecessor to the operationalize phase of the
| | | | | | | | | | |
data analytics life cycle?: Communicate results
| | | | | |
3 |/ |27
Answers
1) Which job position is primarily responsible for designing and constructing data pipelines
| | | | | | | | | | |
| within the field of data analytics?: Dataengineer
| | | | | | |
2) Which role is responsible for project initiation and providing the require-
| | | | | | | | | |
ments for a project?: Projectsponsor
| | | | |
3) Which role in a data analytics project helps data scientists shape data for
| | | | | | | | | | | |
| analysis?: Data engineer | |
4) Which role in a data analytics project provides expertise for analytical tech-niques?:
| | | | | | | | | | |
|Data scientist
|
5) Which skills are required by data scientists for converting unstructured data tostructured
| | | | | | | | | | | |
|dataindataanalyticsprojects?:Datawranglingskills
| | | | | | |
6) Which skill must a business intelligence analyst possess to collect and orga-nize data?:
| | | | | | | | | | | |
|Data preparation
|
7) Which project-related activity typically takes up the majority of a data ana-lyst's time?:
| | | | | | | | | | | |
|Data preparation
|
8) Which software do business intelligence analysts use to perform their re-
| | | | | | | | | |
sponsibilities?: Microsoft Excel | |
9) Whatisaskillrequiredofadataengineer?:Maintainingdatabases
| | | | | | | | | |
10) Which group of stakeholders comprises the professionals, such as line | | | | | | | | |
| managers?: Business users | |
11) Which stakeholder is primarily responsible for ensuring the desired quality of
| | | | | | | | | |
|the project?: Projectmanagers
| | |
12) Which stakeholder has access to essential tables or storage systems and | | | | | | | | | |
| guarantees the highest levels of security in the data repository?: Databaseadmin-istrator
| | | | | | | | | | |
13) Why is it significant to establish failure criteria for a data analytics project in
| | | | | | | | | | | | |
|the discovery phase?: Ithelpstheteamdeterminewhenitisbesttoaccepttheconclusions.
| | | | | | | | | | | | | | |
14) Which stakeholder extracts and transforms data during the discovery | | | | | | | |
| phase?: Data engineer | |
15) A person has been assigned to manage a project to implement a compa-ny-wide
| | | | | | | | | | | |
|customer relationship management (CRM) system. The CRM system aims to centralize
| | | | | | | | | |
| customer details, automate sales processes, and improve | | | | | |
1 |/ |27
,16)
17) customer service. What skills are crucial for the project team members work- | | | | | | | | | | |
ing on the CRM system implementation?: Data analysis, system integration, and training
| | | | | | | | | | |
18) Why is formulating an initial hypothesis an integral part of the discovery
| | | | | | | | | | |
|phase of the data analytics lifecycle?: Itguidesthesubsequent(following)datacollection, processing, and
| | | | | | | | | | | | | |
analysis activities.
| |
19) Who should be included as stakeholders in an analytics project?: Anyonewho will benefit
| | | | | | | | | | | | |
from the project
| | |
20) Who offers suggestions on ideas to test as the team formulates hypotheses during the
| | | | | | | | | | | | |
discovery phase of a data analytics project?: Datascientists
| | | | | | | | |
21) Which activity occurs during the data preparation phase of the data analyt-ics
| | | | | | | | | | |
lifecycle?: Understandingofdata
| | | |
22) Which data visualization is most suitable for understanding the trend and
| | | | | | | | | |
|progressionofa variable over time in the data preparation phase?: Linecharts
| | | | | | | | | | | |
23) Which task is commonly performed to identify and address data quality
| | | | | | | | | |
|issues during the data preparation phase?: Conductingdataprofiling
| | | | | | | |
24) Which common data cleaning task is used to address the missing data in a data set?:
| | | | | | | | | | | | | | |
Imputation
|
25) Which task is typically performed to handle outliers during the data prepa-
| | | | | | | | | | |
ration phase?: Truncatingextremevalues
| | | |
26) A data analyst at a retail company is provided with a large dataset contain-ing
| | | | | | | | | | | | |
|sales transactions, customer information, and product details. The analyst is tasked
| | | | | | | | | |
with preparing the data for analysis and modeling.
| | | | | | | |
27) Which activity would the analyst perform during the data preparation phase?-
| | | | | | | | | |
28) : Exploring available data to understand its characteristics and suitability
| | | | | | | | |
29) Which activity is performed during the model planning phase of a data
| | | | | | | | | | |
|analysis project?: Selecting relevant features for modeling
| | | | | |
30) Which is primarily used for statistical analysis and data manipulation in the model
| | | | | | | | | | | |
|planning phase?: R | |
31) Which classification model is based on the concept of probability and assigns
| | | | | | | | | | |
|class labels to instances based on the possibility of belonging to a particular class?:
| | | | | | | | | | | | |
NaiveBayes
| |
2 |/ |27
, 32)
33) Which tool is used to connect users to relational databases and data ware-house
| | | | | | | | | | | |
appliances in the model planning phase?: SAS/ACCESS
| | | | | | |
34) Which regression model is commonly used for predicting a continuous
| | | | | | | | |
numerical outcome based on a set of input features?: Linearregression
| | | | | | | | | | |
35) Which phase of the data analytics life cycle involves running analytical
| | | | | | | | | |
software packages on small datasets to test and refine models?: Modelexecution phase
| | | | | | | | | | | | |
36) Which step is typically performed after executing the model in the model
| | | | | | | | | | |
execution phase?: Result analysis
| | | |
37) What is the role of the SPSS modeler in the model execution phase of the data
| | | | | | | | | | | | | | |
analytics life cycle?: Itisusedforapplyingthetrained modeltonewdataforpredictions.
| | | | | | | | | | | | | | | |
38) Which testing procedure is used for evaluating the performance of a model in the
| | | | | | | | | | | | |
data analytics lifecycle?:Cross-validation
| | | | |
39) How does the communication of results tie to the operationalize phase of data
| | | | | | | | | | | |
analytics?: It implements data-driven insights into business functions.
| | | | | | | |
40) Which data visualization tool in the communicate results phase is used to create
| | | | | | | | | | | |
web-based visualization?: D3.js
| | |
41) Which measure assesses the validity of a correlation between two variables
| | | | | | | | | |
during the communicate results phase?: P-value
| | | | | |
42) Which statement is an example of a common pitfall in the communication of
| | | | | | | | | | | |
model results?: Focusing only on the accuracy of the model
| | | | | | | | | |
43) What is the purpose of communicating data analytics results to stakehold-
| | | | | | | | | |
ers?: To demonstrate the value and impact of data analytics on business outcomes
| | | | | | | | | | | |
44) A data analyst working for a retail company has a team that analyzes cus-tomer
| | | | | | | | | | | | |
purchasing behavior and identifies a segment of high-value customers who have a high
| | | | | | | | | | | | |
propensity to churn. Now the analyst needs to communicate the results to the customer
| | | | | | | | | | | | | |
service department to operationalize the insights and reduce customer churn. How does
| | | | | | | | | | | |
the communication of results tie to the operationalize phase of data analytics?: By implementing
| | | | | | | | | | | | | |
personalized outreach to customers
| | | |
45) Which phase is the immediate predecessor to the operationalize phase of the
| | | | | | | | | | |
data analytics life cycle?: Communicate results
| | | | | |
3 |/ |27
