[Visualization and Reporting]
Which of the following is the best tool for creating a dynamic dashboard?
A
[Data Acquisition and Preparation]
Which of the following best describes the semi-structured data that is gathered when web scraping?
A
[Data Concepts and Environments]
A report triggers an error that prevents information from being displayed. However, the report was
functional before a database upgrade. Which of the following should a data analyst do first to
troubleshoot the problem?
C
[Data Governance]
Which of the following explains the purpose of UAT?
D
[Visualization and Reporting]
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?
C
[Visualization and Reporting]
A grocery store wants to view the revenue from the previous year, highlighting individual
departments. Which of the following is the most appropriate chart to communicate this information?
B
[Data Acquisition and Preparation]
A data analyst receives the following sales data for a convenience store:
Item
Quantity
Price
Chocolate Bars
$1.99
Vanilla Ice Bars
$4.99
Chocolate Wafers
$0.99
Peanut Butter
$2.99
Cups
$4.99
Strawberry Jam
$4.99
Chocolate Cake
$6.99
Milk Chocolate
$2.99
Almonds
$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?
B
[Visualization and Reporting]
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?
A
[Data Concepts and Environments]
A company has a document that includes the names of key metrics and the standard for how those
metrics are calculated company-wide. Which of the following describes this documentation?
A
[Visualization and Reporting]
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,C
[Data Analysis]
A data analyst receives a request for the current employee head count and runs the following SQL
statement:
SELECT COUNT(EMPLOYEE_ID) FROM JOBS
The returned head count is higher than expected because employees can have multiple jobs. Which
of the following should return an accurate employee head count?
D
[Data Governance]
A data analyst created a dashboard to illustrate the traffic volume and mean response time for a call
center. The traffic data is current, but the mean response time has not updated for more than an
hour. Which of the following is the best way to verify the data's freshness?
C
[Data Governance]
Which of the following pieces of information, if made public, results in a data privacy violation?
B
[Data Acquisition and Preparation]
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?
B
[Data Analysis]
A data analyst team needs to segment customers based on customer spending behavior. Given one
million rows of data like the information in the following sales order table:
Customer_ID
Region
Amount_spent
Product_category
Quantity_of_items
00123
East
20000
Baby
00124
West
30000
Home
00125
South
40000
Garden
00126
North
50000
Furniture
00127
East
60000
Baby
Which of the following techniques should the team use for this task?
C