A data analytics company stores its data on Amazon Simple Storage Service (Amazon S3) and wants to do SQL based analysis on this data with minimum effort. As a Cloud Practitioner, which of the following AWS services will you suggest for this use case?Question 15Answera.Amazon Redshiftb.Amazon DynamoDBc.Amazon Aurorad.Amazon AthenaClear my choice
Question
A data analytics company stores its data on Amazon Simple Storage Service (Amazon S3) and wants to do SQL based analysis on this data with minimum effort. As a Cloud Practitioner, which of the following AWS services will you suggest for this use case?Question 15Answera.Amazon Redshiftb.Amazon DynamoDBc.Amazon Aurorad.Amazon AthenaClear my choice
Solution
The best AWS service for this use case would be Amazon Athena. Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. It doesn't require any servers to manage or data loading. You can start analyzing your data immediately. It's designed for quick, ad-hoc querying but you can also run complex analyses, including large joins, window functions, and arrays.
Similar Questions
A company wants to analyze terabytes of data to derive business insights. The data is currently stored in Amazon S3. The company wants to query this data without having to move it to a separate analytics system. Which service would you recommend for this use case?Question 16Answera.Amazon Neptuneb.Amazon Redshiftc.Amazon QuickSightd.Amazon Athena
Which AWS service would you choose for a data processing project that needs a schemaless database?Question 2Answera.Amazon DynamoDBb.Amazon Aurorac.Amazon RedShiftd.Amazon Relational Database Service (Amazon RDS)
A company wants to operate a data warehouse to analyze data without managing the data warehouse infrastructure. Which AWS service will meet this requirement?a.Amazon RDSb.Amazon Aurorac.Amazon Redshift Serverlessd.AWS Lambda
A data analytics company is running a proprietary batch analytics application on AWS and wants to use a storage service which would be accessed by hundreds of EC2 instances simultaneously to append data to existing files. As a Cloud Practitioner, which AWS service would you suggest for this use-case?
Which AWS serverless service allows you to prepare data for analytics?Question 24Answera.Amazon Athenab.AWS Gluec.Amazon Redshiftd.Amazon EMR
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.