A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

A. A real-time monitor that allows the manager to view performance the day the campaign was launched
B. A sell-service dashboard that allows the manager to look at the company's annual budget performance
C. A spreadsheet of the raw data from all marketing campaigns and channels
D. A summary with statistics, conclusions, and recommendations from the data analyst

Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general- purpose programming language?

A. SAS
B. Microsoft Power BI
C. IBM SPSS
D. Python

Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

A. Rephrase the business requirement.
B. Determine the data necessary for the analysis.
C. Build a mock dashboard/presentation layout.
D. Perform exploratory data analysis.

Which of the following is the correct data type for text?

A. Boolean
B. String
C. Integer
D. Float

Which of the following would be considered non-personally identifiable information?

A. Cell phone device name
B. Customer's name
C. Government ID number
D. Telephone number

A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business's performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. Which of the following report types should the data analyst create?

A. Static
B. Real-time
C. Self-service
D. Dynamic

The number of phone calls that call center receives in a day is an example of:

A. continuous data.
B. categorical data.
C. ordinal data.
D. discrete data.

A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

A. Display the version number next to each submission on the dashboard.
B. Present a data refresh date at the top of the dashboard.
C. Confirm the dashboard is adhering to the corporate style guide.
D. Use permissions to ensure users only see certain versions of the submissions.

A company's marketing department wants to do a promotional campaign next month. A data analyst on the team has been asked to perform customer segmentation, looking at how recently a customer bought product, at what frequency, and at what value. Which of the following types of analysis would this practice be considered?

A. Prescriptive
B. Trend
C. Gap
D. Custer

Given the diagram below:

Which of the following data schemas shown?

A. Key-value pairs
B. Online transactional processing
C. Data lake
D. Relational database