Which of the following is the first step an analyst should perform upon receiving a business request for analysis?

• A.Determine the data needs and sources for analysis.
• B.Initiate the analysis for exploratory data analysis.
• C.Review the business questions to understand the scope.
• D.Finalize the methodology to solve the problem.

Comment: *

Name: *

Email: *

Verification: *

An analyst needs to join two tables of data together for analysis. All the names and cities in the first table should be joined with the corresponding ages in the second table, if applicable.

Which of the following is the correct join the analyst should complete. and how many total rows will be in one table?

• A.INNER JOIN, two rows
• B.LEFT JOIN. four rows
• C.RIGHT JOIN. five rows
• D.OUTER JOIN, seven rows

Comment: *

Name: *

Email: *

Verification: *

Each month an analyst needs to execute a data pull for the two prior months. Which of the following is the most efficient function for the analyst to use?

• A.Logical
• B.Date
• C.Aggregate
• D.System

Comment: *

Name: *

Email: *

Verification: *

Given the customer table below:

Which of the following chart types is the most appropriate to represent the average spending of active customers vs. inactive customers?

• A.Pie chart
• B.Heat graph
• C.Scatter plot
• D.Line chart

Comment: *

Name: *

Email: *

Verification: *

A customer survey reveals 90% positive feedback. Which of the following statistical methods would be best to utilize to determine the reliability of a data set and predict how a larger sample of customers over the same time period might respond?

• A.Calculate a high variance on survey responses.
• B.Calculate the maximum range of the survey responses.
• C.Calculate a low standard deviation on survey responses.
• D.Remove any data more than 4 standard deviation from the mean.

Comment: *

Name: *

Email: *

Verification: *