Which of the following are the first steps a company should take after discovering a data breach? (Select two).

A. Delete data.

B. Notify affected users.

C. Assess the breach.

D. Back up the system.

E. Issue a press release.

F. Delay reporting.

Which of the following is a characteristic of a relational database?

A. It utilizes key-value pairs.

B. It has undefined fields.

C. It is structured in nature.

D. It uses minimal memory.

The senior management team at a company receives a detailed sales report at the end of each quarter. The report is several pages long and includes data from dozens of offices across the country. The team wants a better way to get a quick snapshot of what is included in the report. Which of the following modifications would best meet this requirement?

A. Modifying documentation elements to include reference data sources

B. Modifying the font size and style so important data points are more visible

C. Modifying the report to include a summary section with observations and insights

D. Modifying the report layout so it is easier to follow and understand

Which of the following activities occurs during the ETL process?

A. Reviewing and addressing missing values

B. Creating a dashboard

C. Inserting a pivot table and pivot chart

D. Multiplying unique data

A Chief Executive Officer (CEO) is requesting more up-to-date sales data for improved visibility prior to month-end. An analyst must determine the frequency of a sales report that was previously distributed on an as-needed basis. Which of the following would be the most appropriate frequency for this report?

A. Monthly

B. Quarterly

C. Weekly

D. Every other month

A data analyst is setting up a data dashboard to monitor several ETL data streams to ensure that data is complete for later analysis. Which of the following audiences should the analyst target for this dashboard?

A. Executives

B. The management team

C. Technical experts

D. External vendors

Which one of the following programming languages is specifically designed for use in analytics applications?

A. Python.

B. R

C. C++

D. Java.

Which of the following types of analyses is best to use when tracking sales revenue against quarterly targets?

A. Trend

B. Performance

C. Link

D. Scope

Which of the following is a process that is used during data integration to collect, blend, and load data?

A. MDM

B. ETL

C. OLTP

D. BI

A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank. Considering this data is PHI, which of the following would be the best way for the commander to view the information?

A. An emailed report

B. A password-protected dashboard

C. A daily printout of a report

D. A cloud-hosted spreadsheet

A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

A. dependent data.

B. duplicate data.

C. invalid data

D. redundant data

An analyst wants to include a graph in a quarterly sales report that shows the comparison between two quantitative variables. Which of the following visual diagrams can the analyst use to most effectively represent this relationship?

A. Bar graph

B. Heat map

C. Pie chart

D. Scatter plot