Analyze data by using AWS services.
18 practice questions under this official exam objective (DEA-C01), each with the answer key, an option-by-option explanation and instant feedback.
Questions under this objective
18 total · page 1 of 1How Do You Combine Live, Current, and Archived Redshift Data?
Amazon Redshift Federated Query lets Redshift read live Aurora PostgreSQL tables without copying them, while a monthly UNLOAD job moves data older tha
How to Query S3, RDS, DynamoDB, and Redshift with SQL?
AWS Glue Data Catalog plus Amazon Athena lets data scientists query JSON/CSV in S3, RDS SQL Server, DynamoDB, and Redshift with SQL-like syntax while
How to Make Amazon Athena Queries on CSV Files Run Faster?
This question asks which change will MOST speed up Amazon Athena queries whose source files are uncompressed .csv and whose users filter on a single c
Why Does QuickSight Report Insufficient Permissions for Athena S3 Data?
Amazon QuickSight dashboards backed by Athena over S3 fail with insufficient-permissions errors when the QuickSight service role cannot read the S3 bu
Which Redshift SQL Regex Matches city_name Starting With San or El?
This DEA-C01 question tests how to write an Amazon Redshift SQL filter that matches city_name values starting with San or El. It establishes that opti
How to Separate Athena Query Access and Query History?
Athena workgroups isolate query execution and query history across users, teams, and applications in a single AWS account. The correct solution (B) cr
How to Run 30-Minute Windowed Streaming Analytics with Least Overhead?
This DEA-C01 question asks which AWS service should power fault-tolerant real-time analytics with time-based aggregations over a 30-minute window whil
How Do You Make Redshift Spectrum Queries on S3 the Fastest?
Redshift Spectrum query speed on an S3 data lake is driven overwhelmingly by how the files are laid out, not by compression tricks. This page confirms
How to Join DynamoDB, RDS, Redshift, and S3 Cost-Effectively?
Amazon Athena Federated Query lets a single SQL query join data across DynamoDB, RDS, Redshift, and S3 without moving or duplicating it, making it the
How to Optimize Athena Queries on Partitioned S3 CSV Data?
This DEA-C01 question tests how to optimize Athena queries over date-partitioned CSV flight metrics in Amazon S3. The correct combination is same-Regi
Most Cost-Effective VPC Flow Log Analytics Solution?
This DEA-C01 question asks for the most cost-effective way to collect VPC flow logs and analyze network traffic. Publishing flow logs to Amazon S3 in
Least-Effort Way to Count Distinct Customers from an .xls File in S3?
For a 2 GB .xls customer file in Amazon S3, AWS Glue DataBrew provides the least operational effort to concatenate first and last names and count dist
Which Athena Query Returns 10 Recent CloudTrail Errors Since 2024?
This DEA-C01 question tests an Amazon Athena query over CloudTrail logs for 2024 error events, requiring errorcode filtering, eventtime filtering, gro
How to Prevent Amazon Athena Queries From Queueing?
Athena holds queries in a queue when a workgroup lacks dedicated query-processing capacity. Configuring provisioned capacity for the existing workgrou
Most Cost-Effective Athena and QuickSight SPICE for S3 Clickstream?
For clickstream data already in Amazon S3, Amazon Athena and Amazon QuickSight SPICE with a daily refresh deliver scalable dashboards for hundreds of
How Does Athena Show a Query Execution Plan With Computational Cost?
Amazon Athena's EXPLAIN ANALYZE statement returns both the distributed execution plan and the actual computational cost of every operator in a query.
Which AWS data warehouse handles spiky QuickSight direct queries with least overhead?
Amazon Redshift Serverless consolidates data into Redshift managed storage and automatically scales for unpredictable QuickSight direct-query workload
Athena Query Performance with AWS Glue Crawler Exclusions
This page explains how to resolve discrepancies between AWS Glue crawler exclusions and Amazon Athena query scans to achieve the shortest query times