AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ20

Data Ingestion and Transformation

An ecommerce company runs a complex order-fulfilment process across several operational systems hosted in AWS. Each operational system has a Java Database Connectivity (JDBC)-compliant relational database that captures the latest processing state.

The company must enable an operations team to track orders hourly throughout the entire fulfillment process.

Which solution meets these requirements with the LEAST development overhead?

  • A Use AWS Glue to build ingestion pipelines from the operational systems into Amazon Redshift Build dashboards in Amazon QuickSight that track the orders.
  • B Use AWS Glue to build ingestion pipelines from the operational systems into Amazon DynamoDBuild dashboards in Amazon QuickSight that track the orders.
  • C Use AWS Database Migration Service (AWS DMS) to capture changed records in the operational systems. Publish the changes to an Amazon DynamoDB table in a different AWS region from the source database. Build Grafana dashboards that track the orders.
  • D Use AWS Database Migration Service (AWS DMS) to capture changed records in the operational systems. Publish the changes to an Amazon DynamoDB table in a different AWS region from the source database. Build Amazon QuickSight dashboards that track the orders.
Explanation

AWS Glue provides JDBC connectivity for relational data integration and can load a consolidated Amazon Redshift analytics store. Amazon QuickSight natively supports Amazon Redshift as a data source, enabling dashboards over the consolidated order-state data. AWS DMS supports specific source database engines rather than arbitrary JDBC-compliant databases, while DynamoDB is not listed as a native Amazon QuickSight relational data source.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!