SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 25

A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions.

The data pipeline needs to run continuously ang efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal.

Which design will meet these requirements?

Ingest the data using COPY INTO and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Create an external function to do model inference with Amazon Comprehend and write the final records to a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

Ingest the data into Snowflake using Amazon EMR and PySpark using the Snowflake Spark connector. Apply transformations using another Spark job. Develop a python program to do model inference by leveraging the Amazon Comprehend text analysis API. Then write the results to a Snowflake table and create a listing in the Snowflake Marketplace to make the data available to other companies.

Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.

Correct Answer: B

The most suitable design for the given requirements involves using Snowpipe to ingest the data, as this allows for efficient and continuous data ingestion with minimal operational overhead. Using streams and tasks in Snowflake helps with orchestrating transformations in a structured and automated manner. Creating an external function to perform sentiment analysis with Amazon Comprehend allows for seamless integration and processing without the need for exporting and re-ingesting data. Finally, creating a listing in the Snowflake Marketplace makes it easy to share the data with other companies. This approach ensures low operational complexity, ease of maintenance, and minimal development effort while meeting all the specified requirements.

Discussion

hillcat111Option: B

Answer is B and is validated

HighBMIOption: B

https://aws.amazon.com/blogs/apn/using-amazon-comprehend-medical-with-the-snowflake-data-cloud/