SAA-C03 Q586 · Database

Question

A company has 5 TB of datasets. The datasets consist of 1 million user profiles and 10 million connections. The user profiles have connections as many-to-many relationships. The company needs a performance efficient way to find mutual connections up to five levels. Which solution will meet these requirements?

Accepted Answer

**Amazon Neptune** is a fully managed graph database service purpose-built for exactly this type of problem. Here's why it satisfies every requirement:

1. **Many-to-many relationships**: Graph databases model relationships as first-class citizens using **edges** (connections) and **vertices** (nodes/user profiles). Unlike relational databases that require junction tables and expensive JOINs, Neptune stores relationships directly in the graph structure.

2. **Finding mutual connections up to 5 levels deep**: This is a classic **graph traversal** problem. In a graph database, traversing from one node through 5 levels of connections is done using simple traversal queries (e.g., Gremlin or SPARQL). The time complexity depends on the local neighborhood size, NOT the total dataset size. Neptune

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips