Questions Flashcards

1
Q

Which activity does an analyst perform in the discovery phase of the data analytics life cycle?

A

Identifying business needs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

In which phase of the data analytics life cycle does an analyst build a histogram?

A

Data exploration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

Exploratory data analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

An analyst has been tasked with defining data columns that could contain null values.

Which activity of the data acquisition phase is represented?

A

Detecting missing values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

Cleaning data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What might be developed by data analysts when acquiring data from a data warehouse?

A

The SQL queries of data within the tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What can be identified using a box plot?

A

Interquartile range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What will be a consequence of poor attention to detail during the data exploration phase?

A

The analyst will lack insight into the structure of the data set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which aspect of data exploration occurs when an analyst writes code to compile a bar graph of dog food sales per month?

A

Verification through visualization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

An oil company uses robots and sensors to detect how pipeline corrosion changes over time. The collected data is then used in a predictive model that estimates when a pipe should be replaced.

How does the predictive model serve this oil company?

A

To minimize interruptions from maintenance shutdowns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

During which phase in the data analytics life cycle would a churn analysis be performed?

A

Predictive analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which mistake is commonly made during the predictive analytics phase?

A

The model is developed before the research question is known.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Why might a data analyst resample a data set with replacement data in a data mining project?

A

Too little data for training and testing data sets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A data analyst has identified combinations of sales transactions that frequently occur together in data over the past 5 years.

Which phase of the data analytics life cycle is represented by this analysis?

A

Data mining

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

An analyst realizes that the data set has been reduced significantly, resulting in sample sizes that are too small.

In which phase of the data analytics life cycle did this likely occur?

A

Data mining

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What strategy will contribute to effective data representation and reporting?

A

Excluding unrelated data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What are two purposes of the reporting phase of the data analytics life cycle?

A

Provide the conclusions from the analysis in an engaging manner
Provide actionable insights that can inform decision-making

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

During which phase of the data analytics life cycle does an analyst create a story to report data?

A

Data reporting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is a common duty of a database administrator?

A

Maintain data on the IT infrastructure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which party has the primary vision for a data analytics project and brings resources to complete it?

A

Project sponsors

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is an example of an external stakeholder for a data analytics project?

A

Regulatory body

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What does the critical path represent in data analytics project management?

A

Maximum time to complete dependent tasks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

Expand the team with experienced staff

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Which type of project management problem occurs when a data mining task has started but a data acquisition task has not been completed?

A

Schedule

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

How can an organization improve interprofessional communication among team members?

A

By using tools that provide a team-based collaboration space

26
Q

A data analyst needs to contact a specific member of the database administration team.

Which method should be used to discover the person’s email address?

A

Send an email to the team member’s manager

27
Q

Which feature is commonly found in collaboration tools like Jira, Slack, Teams, and PivotalTracker?

A

Real-time messaging

28
Q

Which action can the project manager take to keep the team engaged in the analytics project?

A

Throughout the project, the project manager holds regular meetings so the entire data analytics team can showcase their work to different departments.

29
Q

What is an effective method for a data analyst to prepare for a one-on-one meeting with a manager?

A

Bring a set of questions to draw on to keep the conversation going

30
Q

What is a characteristic of active listening?

A

Seeking to understand the speaker’s emotions and intent

31
Q

Which circumstance could cause a data analyst to have difficulty developing a model to answer a business question?

A

Lack of relevant data sources

32
Q

A data analytics project team is preparing to develop a predictive model that will be included within a business intelligence tool for upper management.A data analytics project team is preparing to develop a predictive model that will be included within a business intelligence tool for upper management.

Which step should be considered for inclusion when creating the project schedule?

A

Business intelligence tool interface training

33
Q

Which task would an analyst consider first during the discovery phase of the data analytics lifecycle?

A

Identify project goals.

34
Q

Numerical measurements of the amount of a toxic chemical substance are recorded in a large database.

Which hypothesis can the data analyst answer through exploratory data analytic methods?

A

The best analytic approach for analyzing the data is linear regression.

35
Q

A restaurant owner wants to sponsor a data analytics project to provide insights regarding hamburger sales before developing a strategy for increasing sales.

Which question is framed appropriately for the data analytics project?

A

What does the supply and demand curve look like for hamburgers?

36
Q

Which organizational objective could be accomplished with a descriptive data analytics project using website request logs as a data source?

A

Explain why web data transfer has increased 25%

37
Q

A travel website tabulated the results of their latest marketing campaign to understand the relationship of clicks-to-sales conversions.

Which area of analytics does this activity represent?

A

Descriptive

38
Q

An analyst is looking at data that includes the customer’s address, date of purchase, and age.

Which question could be answered from this data?

A

Which state has the highest total customers?

39
Q

Which outcome should be expected when working with data aggregated from multiple sources?

Select two answers.

A

Inconsistently named fields
Data needs cleaning

40
Q

Which technique can a project manager use to foster the identification of quality data analytics questions?

A

Frequent collaboration with the team

41
Q

A data analyst notices that the data selected for an analytics project is slightly misaligned with the research question.

How can the data analyst resolve this situation?

A

Qualitative

42
Q

A U.S. company collects and sells information on consumers.

Which law prevents the company from collecting information on European Union consumers without their permission?

A

General Data Protection Regulation

43
Q

A consumer sues an entertainment streaming company for leaking personal information regarding her viewing habits.

Which ASA ethical standard did the streaming company violate?

A

Privacy

44
Q

A specific drug is manufactured for the treatment of depression. The company decides to ignore research results on an alternative, less expensive, drug treatment in order to make higher profits.

Which ASA ethical standard has the company violated?

A

Conflict of interest

45
Q

What do open-source software tools and widely available analysis tools, such as spreadsheets, help accomplish?

A

Data democratization

46
Q

What is a feature of SQL?

Choose 2 answers.

A

The basic language is the same across database servers.
It is used to interface with relational databases.

47
Q

What is an example of unstructured data?

A

Text messages that include video

48
Q

Which tool should a researcher use to conduct a univariate analysis on complex statistical data?

A

R

49
Q

Which language allows for charts and is geared towards statistical analysis?

A

R

50
Q

What is an example of random sampling of college students?

A

Surveying students chosen arbitrarily from around the entire college campus

51
Q

Which type of analysis would be used to predict a binary outcome based on a set of independent variables?

A

Regression

52
Q

Which type of data analysis is appropriate if the goal is to minimize the cost of a diet, using a data set consisting of the following variables: protein content, fat content, and cost per unit?

A

Optimization

53
Q

Which technique can be used to determine the likelihood that a positive diagnostic test result indicates whether the disease is actually present?

A

Bayes’ theorem

54
Q

Which concept should be considered when choosing variables for inclusion in a linear regression model?

A

Feasibility of controlling the variables

55
Q

A neural network algorithm in machine learning endeavors to recognize underlying relationships in a set of data.

What does this process mimic?

A

The way the human brain operates

56
Q

Which characteristics are used to group data together in a cluster analysis?

Choose 2 answers.

A

Distance
Similarity

57
Q

Which tool has libraries that expand its visualization capabilities?

A

Python

58
Q

Which tools can be used for performing statistics and creating interactive data visualization for large datasets from various sources?

A

Tableau
R

59
Q

Which type of data representation should a data analyst use to display expense categories as a percentage of total business expenses?

A

Pie chart

60
Q

A data analyst notices that the data selected for an analytics project is slightly misaligned with the research question.

How can the data analyst resolve this situation?

A

Adjust the research question to reframe the analysis