FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
An organization needs a data store to handle the following data types and access patterns:1.Key value access pattern2.Complex SQL queries and transactions3.Consistent reads4.Fixed schemaWhich data store should the organization choose?
A
Amazon S3
B
Amazon Kinesis
C
Amazon DynamoDB
D
Amazon RDS
Explanation: 

Detailed explanation-1: -In general, you will find RDS, DynamoDB, and DocumentDB to be good initial choices with wide support for tooling, languages, and flexible data usage patterns. In this article, we discuss a variety of databases: relational, document, key-value, graph, in-memory, and search.

Detailed explanation-2: -Amazon Aurora is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases.

Detailed explanation-3: -Amazon RDS makes it easy to set up, operate, and scale MySQL deployments in the cloud. With Amazon RDS, you can deploy internet-scale MySQL deployments in minutes, with cost-efficient and resizable hardware capacity.

Detailed explanation-4: -Athena supports ANSI SQL queries. Athena uses Trino, an open-source, in-memory, distributed SQL engine, and can handle complex analysis, including large joins, window functions, and arrays.

There is 1 question to complete.