Scenario: A financial institution wants to analyze large volumes of transactional data, including customer accounts, transactions, and account balances. The analysis involves complex queries and aggregations. Which type of database would be the best fit for this scenario?
- Columnar Database
- In-Memory Database
- NoSQL Database
- Relational Database
A Relational Database would be the best fit for this scenario. Relational databases provide strong support for complex queries, transactions, and aggregations, making them suitable for handling the structured and transactional nature of financial data.
Loading...
Related Quiz
- Database _______ involves fine-tuning the physical design and configuration parameters to optimize performance.
- What are the advantages of using Data Marts over Data Warehouses in certain scenarios?
- _______ techniques reduce the size of data stored in a database by eliminating redundancy and using encoding schemes.
- What does a modality of "Optional" mean in a relationship?
- The second normal form (2NF) eliminates _______ dependencies.