[Data Analysis]
A marketing firm wants to find the average age of its consumers to better promote its products. Given the following dataset:
Name
Date of birth
Age
Jane
March 24
34
John
July 17
11
Joe
November 29
29
Ann
December 13
14
Robert
December 14
63
Which of the following is the mean of the consumer ages?
Answer : B
[Data Acquisition and Preparation]
Which of the following is the most efficient to use when programming repeatable tasks?
Answer : D
[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
4
00124
West
30000
Home
6
00125
South
40000
Garden
7
00126
North
50000
Furniture
8
00127
East
60000
Baby
10
Which of the following techniques should the team use for this task?
Answer : C
[Data Concepts and Environments]
Which of the following best describes the reason an analyst would reference a data dictionary versus a source's metadata?
Answer : B
[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?
Answer : C
[Data Concepts and Environments]
Which of the following best represents a type of infrastructure that requires a company to purchase and maintain all of its own servers?
Answer : A
[Visualization and Reporting]
An analyst must use the same data to create reports for police patrol supervisors, the city council, and a public website. Which of the following is the best way to differentiate the reports?
Answer : A