← Back to exam page

Free AWS-CERTIFIED-DATA-ENGINEER-ASSOCIATE-DEA-C01 – Amazon AWS-CERTIFIED-DATA-ENGINEER-ASSOCIATE-DEA-C01 Practice Test Question

Loading demo links...

Showing 28–30 of 32 questions

Question 28 (Topic 1)

A company needs to implement real-time analytics for a retail shopping platform. The company wants to capture clickstream data, process the data, and load the data into Amazon Redshift for analysis. The solution must handle hundreds of megabytes of data every second. Which solution will meet these requirements with the LEAST query latency for analytics?

Select an option, then click Submit answer.

  • ○ Use Amazon Data Firehose to capture the data. Store the data in an Amazon S3 bucket. Use the COPY command to load data into Amazon Redshift.
  • ○ Use Amazon Managed Streaming for Apache Kafka (Amazon MSK) to capture the data. Use Amazon EMR to process the data. Use federated queries to access data in Amazon Redshift.
  • ○ Use Amazon Kinesis Data Streams to capture the data. Use Amazon Redshift streaming ingestion to load data directly into materialized views.
  • ○ Use Amazon DynamoDB Streams to capture the data. Use AWS Glue to process the data. Use a zero-ETL integration to load the data into Amazon Redshift.
Question 29 (Topic 1)

A company’s application needs to search and analyze data in near real time. The application must handle up to 1,000 requests each second with low query latency. The company wants a solution that individual data teams can own and configure to meet each team's cost and performance optimization requirements. Which solution will meet these requirements?

Select an option, then click Submit answer.

  • ○ Use Amazon S3 buckets to store the data. Use Amazon Athena to query and analyze the data. Assign each data team a separate S3 bucket prefix to optimize queries.
  • ○ Use streams in Amazon Kinesis Data Streams and Amazon Managed Service for Apache Flink to query and analyze the data. Assign each data team a separate stream to manage and consume.
  • ○ Use Amazon OpenSearch Service clusters with indexing to query the data. Assign each data team a separate cluster to configure for storage and queries.
  • ○ Use Amazon Aurora clusters that run on Aurora I/O-Optimized instances. Assign each data team a separate Aurora cluster to configure for storage and queries.
Question 30 (Topic 1)

A company stores historical customer data in an Amazon Redshift table. A column named Email contains null entries and values that are not email addresses. The quality of the Email column is critical for multiple downstream processes. A data engineer must create an AWS Glue Data Quality rule that fails when the percentage of valid email addresses in the Email column is less than 90%. Which component of an AWS Glue Data Quality rule will meet these requirements?

Select an option, then click Submit answer.

  • ○ Uniqueness "Email" matches "[%@%.%]" with a threshold set to > 0.9
  • ○ ColumnValues "Email” matches "[%@%.%]" with a threshold set to > 0.1
  • ○ ColumnValues "Email" matches "[%@%.%]" with a threshold set to > 0.9
  • ○ UniqueValueRatio "Email" matches "[%@%.%]" with a threshold set to > 0.1