An analyst needs to create an analytics dashboard for an employee intranet site to improve the search functionality, display relevant information, and maintain an updated FAQ page. Which of the following visualizations would best represent what employees are searching for?

A. A word cloud

B. A histogram

C. A pie chart

D. A scatter plot

A data analyst is performing a data merge within a spreadsheet using the tables below:

The analyst is attempting to pull the addresses from Table 2 into Table 1 using the last names and is receiving an error message. Which of the following steps can the analyst perform to fix the error?

A. Use concatenate to combine the tables.

B. Ensure the formula is pulling from right to left.

C. Sort the data by the last name field.

D. Review the spelling and data type.

An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

A. Histogram

B. Pie

C. Line

D. Scatter pot

E. Waterfall

An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

A. Scatter plot

B. Heat map

C. Pie chart

D. Infographic

An employer needs to maintain adequate office staffing during the winter and wants to track storm data. Which of the following data collection methods should the employer use?

A. Web scraping

B. Public databases

C. Observations

D. Weather surveys

Given the image below:

The data should be cleaned because of the presence of:

A. outlier

B. non-parametric data.

C. multicollinearity.

D. invalid data.

The duration of a phone call in milliseconds is an example of:

A. ordinal data.

B. nominal data.

C. boolean data.

D. continuous data.

Given the following report:

Which of the following components need to be added to ensure the report is point-in-time and static? (Select two).

A. A control group for the phrases

B. A summary of the KPIs

C. Filter buttons for the status

D. The date when the report was last accessed

E. The time period lhe report covers

F. The date on which the report was run

A data analyst is compiling a report that a Chief Executive Officer needs for an impromptu meeting. The report should include information on the previous day's performance. Which of the following reports should the analyst provide?

A. Tactical

B. Ad hoc

C. Dynamic

D. Recurring

What SQL command is used to delete an entire table from a database?

A. DROP.

B. MODIFY.

C. DELETE.

D. ALTER.

Which of the following is a domain-specific language used in programming that is designed for managing data that is held in a relational data stream management system?

A. SAS

B. SQL

C. Python

D. R

Given the following graph:

Which of the following summary statements upholds integrity in data reporting?

A. Sales are approximately equal for Product A and Product B across all strategies.

B. Strategy 4 provides the best sales in comparison to other strategies.

C. While Strategy 2 does not result in the highest sales of Product D, over all products it appears to be the most effective.

D. Product D should be promoted more than the other products in all strategies.