Choose a data store.
13 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
13 total · page 1 of 1Which S3 Lifecycle Policy Meets High Availability and Lowest Cost?
This DEA-C01 question tests an S3 Lifecycle policy that moves aging data from S3 Standard to the cheapest storage class while preserving high availabi
Which AWS Services Implement a Data Mesh with Centralized Governance?
A data mesh on AWS is built with Amazon S3 as the scalable storage layer, Athena for serverless analysis, and Lake Formation for centralized governanc
Amazon Redshift Compound Sort Key Query Optimization
A compound sort key in Amazon Redshift improves query performance when filters are applied on the leading columns of the key. This page establishes th
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
Which EMR Storage and Instance Choices Meet Cost and Reliability Needs?
This DEA-C01 question tests cost-optimized, reliable Amazon EMR design for long-running Apache Spark workloads. The page establishes that Amazon S3 fo
AWS Service for Cost-Effective SQL Server Migration
This question evaluates the selection of AWS Database Migration Service (DMS) for migrating on-premises Microsoft SQL Server data to Amazon RDS with m
Low-Latency IoT Data Ingestion with Kinesis and DynamoDB
This question evaluates the selection of AWS services for real-time sensor data ingestion and low-latency querying. The correct solution leverages Ama
Which AWS NoSQL Database Meets Global OLTP with Least Overhead?
This DEA-C01 question tests which fully managed AWS NoSQL service delivers single-digit millisecond OLTP performance and global high availability with
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
How to migrate EBS gp2 volumes to gp3 without downtime?
Amazon EBS Elastic Volumes lets you change an existing gp2 volume to gp3 in place, so no snapshot/restore cycle or data-copy tooling is required. This
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
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
Amazon Redshift AUTO Distribution Style for Growing Tables
This question addresses how to handle a de-normalized table in Amazon Redshift that lacks a suitable distribution key and is growing in size. The corr