DEA-C01 Practice Question 84: Graph Database Fraud Rings
AWS Certified Data Engineer – Associate (DEA-C01) · Test 9 · question 4 of 10
A payments company wants to detect fraud rings by finding accounts that are linked through shared devices, addresses and phone numbers, up to several hops away. The queries must return in milliseconds, and the relational joins that the team tried became slow and hard to maintain as the number of relationships grew into the billions. Which data store fits this workload best?
Show answer and explanation
Answer:
Amazon Neptune is *"a fast, reliable, fully managed graph database service that makes it easy to build and run applications that work with highly connected datasets."* Its engine is *"optimized for storing billions of relationships and querying the graph with milliseconds latency,"* and it *"powers graph use cases such as recommendation engines, fraud detection, knowledge graphs"*. AWS also notes that *"SQL queries for highly connected data are complex and hard to tune for performance"* (option C).
- A is wrong because Redshift is a columnar data warehouse for large analytic scans and aggregations. Multi-hop relationship traversal there still means many-way joins. - B is wrong because DynamoDB is a key-value and document store for key-based access patterns. Traversing relationships means many sequential lookups. - D is wrong because DocumentDB stores JSON documents and is not designed for traversing relationships across many hops.
Reference: What Is Amazon Neptune?