DS-200 · Question #30
You are building a system to perform outlier detection for a large online retailer. You need to build a system to detect if the total dollar value of sales are outside the norm for each U.S. state…
The correct answer is A. Database of employees that Includes only the employee ID, start date, and department D. Database of user sessions that includes only session ID, corresponding user ID, and the F. Database of items that includes only the item name, item ID, and warehouse location. See the full explanation below for the reasoning.
Question
You are building a system to perform outlier detection for a large online retailer. You need to build a system to detect if the total dollar value of sales are outside the norm for each U.S. state, as determined from the physical location of the buyer for each purchase. The retailer's data sources are scattered across multiple systems and databases and are unorganized with little coordination or shared data or keys between the various data sources. Below are the sources of data available to you. Determine which three will give you the smallest set of data sources but still allow you to implement the outlier detector by state.
Options
- ADatabase of employees that Includes only the employee ID, start date, and department
- BDatabase of users that contains only their user ID, name, and a list of every Item the user has
- CTransaction log that contains only basket ID, basket amount, time of sale completion, and a
- DDatabase of user sessions that includes only session ID, corresponding user ID, and the
- EExternal database mapping IP addresses to geographic locations
- FDatabase of items that includes only the item name, item ID, and warehouse location
- GDatabase of shipments that includes only the basket ID, shipment address, shipment date, and
How the community answered
(43 responses)- A84% (36)
- C2% (1)
- E9% (4)
- G5% (2)
Community Discussion
No community discussion yet for this question.