Non-relational databases, like Amazon DynamoDB, are more suited for applications that require large amounts of data with simple lookup queries and have high throughput requirements, typical of user profile management in media streaming platforms.