Free DEA-C01 Exam Braindumps (page: 27)

Page 26 of 53

A data engineer finished testing an Amazon Redshift stored procedure that processes and inserts data into a table that is not mission critical. The engineer wants to automatically run the stored procedure on a daily basis.
Which solution will meet this requirement in the MOST cost-effective way?

  1. Create an AWS Lambda function to schedule a cron job to run the stored procedure.
  2. Schedule and run the stored procedure by using the Amazon Redshift Data API in an Amazon EC2 Spot Instance.
  3. Use query editor v2 to run the stored procedure on a schedule.
  4. Schedule an AWS Glue Python shell job to run the stored procedure.

Answer(s): C



A marketing company collects clickstream data. The company sends the clickstream data to Amazon Kinesis Data Firehose and stores the clickstream data in Amazon S3. The company wants to build a series of dashboards that hundreds of users from multiple departments will use.
The company will use Amazon QuickSight to develop the dashboards. The company wants a solution that can scale and provide daily updates about clickstream activity.
Which combination of steps will meet these requirements MOST cost-effectively? (Choose two.)

  1. Use Amazon Redshift to store and query the clickstream data.
  2. Use Amazon Athena to query the clickstream data
  3. Use Amazon S3 analytics to query the clickstream data.
  4. Access the query data through a QuickSight direct SQL query.
  5. Access the query data through QuickSight SPICE (Super-fast, Parallel, In-memory Calculation Engine). Configure a daily refresh for the dataset.

Answer(s): B,E



A data engineer is building a data orchestration workflow. The data engineer plans to use a hybrid model that includes some on-premises resources and some resources that are in the cloud. The data engineer wants to prioritize portability and open source resources.
Which service should the data engineer use in both the on-premises environment and the cloud-based environment?

  1. AWS Data Exchange
  2. Amazon Simple Workflow Service (Amazon SWF)
  3. Amazon Managed Workflows for Apache Airflow (Amazon MWAA)
  4. AWS Glue

Answer(s): C



A gaming company uses a NoSQL database to store customer information. The company is planning to migrate to AWS.
The company needs a fully managed AWS solution that will handle high online transaction processing (OLTP) workload, provide single-digit millisecond performance, and provide high availability around the world.
Which solution will meet these requirements with the LEAST operational overhead?

  1. Amazon Keyspaces (for Apache Cassandra)
  2. Amazon DocumentDB (with MongoDB compatibility)
  3. Amazon DynamoDB
  4. Amazon Timestream

Answer(s): C






Post your Comments and Discuss Amazon DEA-C01 exam with other Community members:

DEA-C01 Discussions & Posts