The human resources department wants to understand the relationship between the ages and incomes of all employees. Which of the following graphics is the most appropriate to present the analysis?
A data analyst receives the following sales data for a convenience store:
Item
Quantity
Price
Chocolate Bars
7
$1.99
Vanilla Ice Bars
2
$4.99
Chocolate Wafers
6
$0.99
Peanut Butter
2
$2.99
Cups
3
$4.99
Strawberry Jam
3
$4.99
Chocolate Cake
9
$6.99
Milk Chocolate
2
$2.99
Almonds
5
$2.99
The analyst needs to provide information on the products that contain chocolate. Which of the following RegEx should the analyst use to filter the chocolate products?
Before distributing a report, a marketing analyst notices that the total distinct promotional email messages is less than the combined total of emails sent. Which of the following is the most likely reason for this difference?
A data analyst is creating a report about cars sold within the last twelve months. The current data set only contains information from the last ten months. Which of the following is the most appropriate way to accomplish this task?
Which of the following best describes the semi-structured data that is gathered when web scraping?
A data analyst receives four files that need to be unified into a single spreadsheet for further analysis. All of the files have the same structure, number of columns, and field names, but each file contains different values. Which of the following methods will help the analyst convert the files into a single spreadsheet?
A data analyst is working on an initial analysis of the dataset in the following table:
DateTime
Count
2024-01-01
12
2024-01-02
245
2024-01-02
13
2024-01-03
13
2024-01-03
12
00:00:00
12
Which of the following issues should the analyst flag in the data report?
The sales department wants to include the composition of total sales amounts across all three sales channels in a report. Given the following sample sales table:
Sales channel
Month
Sales (million $)
Digital
January
135
Store
February
145
Online
March
165
Store
April
200
Store
May
125
Online
June
155
Digital
July
120
Online
August
145
Digital
September
160
Which of the following visualizations is the most appropriate?
A data engineer needs to create a reporting solution that has predefined filters and the ability to download .csv files. Which of the following is the best solution?
A product goes viral on social media, creating high demand. Distribution channels are facing supply chain issues because the testing and training models that are used for sales forecasting have not encountered similar demand. Which of the following best describes this situation?
An administrator needs to design a table that will include foreign words. Which of the following is the best option for storing non-native language characters?
A data analyst troubleshoots a dashboard every day for a week. Which of the following techniques best addresses how to validate the data moving forward?
A data analyst is creating a pivot table for a large dataset for an upcoming board meeting. Which of the following is the purpose of the pivot table?
A data analyst needs to create and deliver a dashboard that displays the company's financial transactions as they are updated. Which of the following delivery methods should the analyst consider? (Select two).
A sales manager wants to understand how sales are trending year over year. Which of the following chart types is the most appropriate to display the information?
A data analyst is generating a custom report for a Chief Executive Officer's executive meeting. Later, the analyst learns that other custom reports will be required for future executive meetings. Which of the following delivery methods should the analyst use?
An analyst needs to produce a final dataset using the following tables:
CourseID
SectionNumber
StudentID
MATH1000
1
10009
MATH1000
2
10007
PSYC1500
1
10009
PSYC1500
1
10015
StudentID
FirstName
LastName
10009
Jane
Smith
10007
John
Doe
10015
Robert
Roe
The expected output should be formatted as follows:
| CourseID | SectionNumber | StudentID | FirstName | LastName |
Which of the following actions is the best way to produce the requested output?
A company's entire server environment is located at the company’s headquarters. Which of the following describes this type of environment?
A table contains several rows of cellular numbers with call timestamps, call durations, called numbers, and carriers of the called number. Which of the following allows a data analyst to sort the cellular numbers based on the carriers of the called numbers and include the total call durations?
The following SQL code returns an error in the program console:
SELECT firstName, lastName, SUM(income)
FROM companyRoster
SORT BY lastName, income
Which of the following changes allows this SQL code to run?
A company's analytics manager wants all reports to be delivered once every seven days. Which of the following is the best delivery method?
A data breach occurs at a company. Which of the following actions should be taken?
Which of the following best enables the retrieval and manipulation of data that is stored in a relational database?
A data analyst is analyzing the following dataset:
Transaction Date
Quantity
Item
Item Price
12/12/12
11
USB Cords
9.99
11/11/11
3
Charging Block
8.89
10/10/10
5
Headphones
50.15
Which of the following methods should the analyst use to determine the total cost for each transaction?
A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?
A data analyst must combine service calls into low-, medium-, and high-priority levels in order to analyze organizational responses. Which of the following techniques should the analyst use for this task?
A data analyst is gathering data from multiple tables in a database. The analyst needs certain columns from each table. Which of the following is the best method to accomplish this task?
A manager wants to use the information in a recurring report on incomplete timesheets for the prior month to guide employee outreach. Which of the following report types is the best for this task?