AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A research company uses on-premises devices to generate data for analysis. The company wants to use the AWS Cloud to analyze the data. The devices generate .csv files and support writing the data to an SMB file share. Company analysts must be able to use SQL commands to query the data. The analysts will run queries periodically throughout the day.
Which combination of steps will meet these requirements MOST cost-effectively? (Choose three.)
Other
Community
UAnonymous
A
Deploy an AWS Storage Gateway on premises in Amazon S3 File Gateway mode.
B
Deploy an AWS Storage Gateway on premises in Amazon FSx File Gateway mode.
C
Set up an AWS Glue crawler to create a table based on the data that is in Amazon S3.
D
Set up an Amazon EMR cluster with EMR File System (EMRFS) to query the data that is in Amazon S3. Provide access to analysts.
E
Set up an Amazon Redshift cluster to query the data that is in Amazon S3. Provide access to analysts.
F
Setup Amazon Athena to query the data that is in Amazon S3. Provide access to analysts.
Explanation:
Explanation
The most cost-effective solution for this scenario involves:
1. A - Deploy an AWS Storage Gateway on premises in Amazon S3 File Gateway mode:
- The devices support SMB file shares, and Storage Gateway in S3 File Gateway mode provides an SMB interface that on-premises devices can write to
- Data is automatically transferred to Amazon S3, eliminating the need for manual data transfer
- This is cost-effective as Storage Gateway provides a seamless bridge between on-premises SMB shares and Amazon S3
2. C - Set up an AWS Glue crawler to create a table based on the data that is in Amazon S3:
- AWS Glue crawler automatically discovers the schema of CSV files in S3 and creates metadata tables in the AWS Glue Data Catalog
- This is serverless and cost-effective - you only pay for the crawler runtime
- The Data Catalog provides the metadata needed for SQL queries
3. F - Setup Amazon Athena to query the data that is in Amazon S3. Provide access to analysts:
- Amazon Athena is a serverless query service that allows analysts to run SQL queries directly on data in S3
- It's pay-per-query (cost-effective for periodic queries throughout the day)
- Integrates with AWS Glue Data Catalog for schema/metadata
- Analysts can use standard SQL commands as required
Why other options are not optimal:
- B (FSx File Gateway): More expensive and complex than S3 File Gateway for this use case
- D (Amazon EMR): Overkill for periodic SQL queries - EMR is designed for big data processing and would be more expensive
- E (Amazon Redshift): More expensive than Athena for periodic queries - Redshift is better for data warehousing with frequent, complex queries
Cost-effectiveness rationale:
- Storage Gateway S3 File Gateway: Low-cost gateway service
- AWS Glue crawler: Serverless, pay-per-use
- Amazon Athena: Serverless, pay-per-query (perfect for periodic queries throughout the day)
- All components are serverless or low-cost, with no need to maintain infrastructure 24/7
Comments
Loading comments...