AWS AWS Database and Analytics Services 4

Question 1

A company needs to run complex SQL analytics on petabytes of structured data with minimal administration. Which AWS service is BEST suited?

Accepted Answer

Amazon Redshift

Answer

Amazon Redshift is a fully managed petabyte-scale data warehouse optimized for complex analytical queries using SQL.

Question 2

Which Amazon DynamoDB feature automatically distributes data and traffic across multiple partitions to handle increased load?

Accepted Answer

Adaptive Capacity

Answer

DynamoDB Adaptive Capacity automatically redistributes capacity to partitions that receive more traffic, preventing throttling.

Question 3

A team wants to query data stored in S3 using standard SQL without loading it into a database. Which service enables this?

Accepted Answer

Amazon Athena

Answer

Amazon Athena is a serverless interactive query service that allows you to analyze data directly in S3 using standard SQL.

Question 4

What is the purpose of Amazon ElastiCache write-through strategy?

Accepted Answer

Data is written to both cache and the database simultaneously

Answer

Write-through ensures cache and database stay synchronized by writing to both on every update, preventing stale reads.

Question 5

Which AWS Glue component serves as a central metadata repository for all your data assets?

Accepted Answer

Glue Data Catalog

Answer

The AWS Glue Data Catalog is a persistent metadata store that holds table definitions, schemas, and connection information.

AWS Practice Test