Free Amazon AWS-DEA-C01 Exam Questions
Try our Free Demo Practice Tests for Comprehensive AWS-DEA-C01 Exam Preparation
-
Amazon AWS-DEA-C01 Exam Questions
-
Provided By: Amazon
- Exam: AWS Certified Data Engineer - Associate
- Certification: AWS Certified Data Engineer
-
Total Questions: 485
-
Updated On: Nov 12, 2024
-
Rated: 4.9 |
-
Online Users: 970
-
Question 1
-
As a Data Engineer, you've been given the task of enhancing the performance of a business analytics application. This application predominantly performs complex, read-intensive queries against large, historical datasets.
The data is currently housed in a MySQL database on Amazon RDS. However, due to the increasing dataset size and query complexity, query performance has significantly degraded. To address this issue, you are considering implementing Amazon ElastiCache.
Which caching strategy would be most effective in this scenario to improve query performance?
Answer: B
-
As a Data Engineer, you've been given the task of enhancing the performance of a business analytics application. This application predominantly performs complex, read-intensive queries against large, historical datasets.
-
Question 2
-
A data engineer needs to build an enterprise data catalog based on the company's Amazon S3 buckets andAmazon RDS databases. The data catalog must include storage format metadata for the data in the catalog.Which solution will meet these requirements with the LEAST effort?
Answer: B
-
A data engineer needs to build an enterprise data catalog based on the company's Amazon S3 buckets andAmazon RDS databases. The data catalog must include storage format metadata for the data in the catalog.Which solution will meet these requirements with the LEAST effort?
-
Question 3
-
A company uses Amazon S3 as a data lake. The company sets up a data warehouse by using a multi-nodeAmazon Redshift cluster. The company organizes the data files in the data lake based on the data source ofeach data file.The company loads all the data files into one table in the Redshift cluster by using a separate COPY commandfor each data file location. This approach takes a long time to load all the data files into the table. Thecompany must increase the speed of the data ingestion. The company does not want to increase the cost of theprocess.Which solution will meet these requirements?
Answer: D
-
A company uses Amazon S3 as a data lake. The company sets up a data warehouse by using a multi-nodeAmazon Redshift cluster. The company organizes the data files in the data lake based on the data source ofeach data file.The company loads all the data files into one table in the Redshift cluster by using a separate COPY commandfor each data file location. This approach takes a long time to load all the data files into the table. Thecompany must increase the speed of the data ingestion. The company does not want to increase the cost of theprocess.Which solution will meet these requirements?
-
Question 4
-
A mobile app tracks user activity data, which is continuously streamed to Amazon Kinesis Data Streams. The app requires a solution to process this data in real-time and update user profiles stored in Amazon DynamoDB based on the activity data.
What combination of AWS services should be used for real-time processing of the stream and updating the user profiles in DynamoDB?
Answer: A
-
A mobile app tracks user activity data, which is continuously streamed to Amazon Kinesis Data Streams. The app requires a solution to process this data in real-time and update user profiles stored in Amazon DynamoDB based on the activity data.
-
Question 5
-
A company stores its processed data in an S3 bucket. The company has a strict data access policy. Thecompany uses IAM roles to grant teams within the company different levels of access to the S3 bucket.The company wants to receive notifications when a user violates the data access policy. Each notificationmust include the username of the user who violated the policy.Which solution will meet these requirements?
Answer: C
-
A company stores its processed data in an S3 bucket. The company has a strict data access policy. Thecompany uses IAM roles to grant teams within the company different levels of access to the S3 bucket.The company wants to receive notifications when a user violates the data access policy. Each notificationmust include the username of the user who violated the policy.Which solution will meet these requirements?