Questions With Complete Solutions
A data analyst is analyzing the employees' salaries
at a company to find a representative value that
summarizes the central tendency of the data.
Which metric should be used to summarize the
central tendency of the data?
Median
An organization is building a theme park where the
temperature can vary wildly. All rides should be
built to handle the extremes of the temperature
spectrum.
Which metric should be used in this scenario?
Range
A person has been assigned to manage a
project to implement a company-wide
customer relationship management (CRM)
system. The CRM system aims to centralize
customer details, automate sales processes,
and improve customer service.
,What skills are crucial for the project team
members working on the CRM system
implementation?
Data analysis, system integration, and training
Which role is responsible for project initiation and
providing the requirements for a project?
Project sponsor
Which job position is primarily responsible
for designing and constructing data pipelines
within the field of data analytics?
Data engineer
Which role in a data analytics project helps
data scientists shape data for analysis?
Data engineer
Which role in a data analytics project
provides expertise for analytical techniques?
Data scientist
,Which skills are required by data scientists
for converting unstructured data to
structured data in data analytics projects?
Data wrangling skills
Which skill must a business intelligence
analyst possess to collect and organize data?
Data preparation
Which project-related activity typically takes
up the majority of a data analyst's time?
Data preparation
Which software do business intelligence
analysts use to perform their
responsibilities?
Microsoft Excel
What is a skill required of a data engineer?
Maintaining databases
delete
, Which group of stakeholders comprises the
professionals, such as line managers?
Business users
Which stakeholder is primarily responsible
for ensuring the desired quality of the
project?
Project managers
Which stakeholder has access to essential
tables or storage systems and guarantees
the highest levels of security in the data
repository?
Database administrator
Why is it significant to establish failure
criteria for a data analytics project in the
discovery phase?
It helps the team determine when it is best to
accept the conclusions.
Which stakeholder extracts and transforms
data during the discovery phase?
Data engineer