Practice Test 1 | AWS Certified Solutions Architect Associate | SAA-C03 | Dumps | Mock Test
A company is generating large datasets with millions of rows to be summarized column-wise. To build daily reports from these data sets, Business Intelligence tools would be used.
Which storage service would meet these requirements?
A. Amazon Redshift
B. Amazon RDS
C. ElastiCache
D. DynamoDB
Explanation:
Correct Answer – A
AWS Documentation mentions the following:
Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. You can start with just a few hundred gigabytes of data and scale to a petabyte or more. This enables you to use your data to acquire new insights for your business and customers.
For more information on AWS Redshift, please visit the following URL:
Columnar storage for database tables is an important factor in optimizing analytic query performance because it drastically reduces the overall disk I/O requirements and the amount of data you need to load from disk.
Amazon Redshift uses a block size of 1 MB, which is more efficient and further reduces the number of I/O requests needed to perform any database loading or other operations that are part of query execution.
For more information on how redshift manages the columnar storage, please visit the following URL:
Comments are closed, but trackbacks and pingbacks are open.