AWS (Amazon Web Services) Certification
61 practice questions with correct answers and detailed explanations. Use this guide to review concepts before taking the practice exam.
The AWS (Amazon Web Services) AWS Certified Data Analytics – Specialty (DAS-C01) certification validates professional expertise in AWS (Amazon Web Services) technologies. This study guide covers all 61 practice questions from our DAS-C01 practice test, complete with correct answers and explanations to help you understand each concept thoroughly.
Review each question and explanation below, then test yourself with the full interactive practice exam to measure your readiness.
You are designing a data pipeline that needs to process 500 GB of data daily with variable workloads. Which AWS service would be most cost-effective for running these batch ETL jobs?
AWS Glue with on-demand capacity automatically scales for variable workloads without requiring you to manage infrastructure, making it cost-effective for batch ETL jobs. EMR running 24/7 would waste resources during low-demand periods.
A data analyst needs to create dashboards showing real-time metrics from IoT devices publishing data to Kinesis Data Streams. Which combination of services would provide the lowest latency visualization?
Kinesis Data Analytics provides real-time SQL processing directly on streaming data with minimal latency, and can output directly to QuickSight for immediate visualization without intermediate storage layers.
You need to ensure that sensitive financial data in Amazon Redshift is encrypted both at rest and in transit. Which encryption approach is most comprehensive?
KMS encryption at rest combined with enforced SSL/TLS for connections provides comprehensive protection for sensitive data. While S3 encryption is helpful, it doesn't encrypt data in the Redshift cluster itself.
A company uses AWS Glue to catalog 10,000 tables across multiple data sources. They experience slow metadata queries. What optimization would most improve Glue Catalog performance?
The Glue Data Catalog Partitions feature enables hierarchical organization of metadata, significantly improving query performance for large catalogs. Partitioning the database logically would fragment the catalog further.
You are implementing a data lake on S3 with multiple teams accessing different datasets. What is the recommended approach for fine-grained access control?
AWS Lake Formation provides centralized permission management with database and table-level access control, which is more granular and manageable than bucket-level policies or ACLs for multi-team data lake scenarios.
A streaming analytics application needs to handle late-arriving data and out-of-order events. Which Kinesis Data Analytics feature addresses this requirement?
Kinesis Data Analytics allows you to configure allowed lateness on event time windows, ensuring late-arriving data is still processed correctly rather than being discarded.
What is the primary limitation of using Amazon Athena for querying data in S3?
Athena charges are based on the data scanned by queries, not the amount of data returned. This makes partitioning and columnar formats (Parquet) critical for cost optimization.
You need to perform complex machine learning transformations on data in a Glue job. Which approach is most efficient?
Writing custom PySpark code directly in Glue jobs allows you to use Python ML libraries efficiently without data movement. This avoids the latency and complexity of exporting to SageMaker.
An organization wants to implement near-real-time reporting on customer transactions. The data arrives at 1 million events per second. Which architecture minimizes latency?
Kinesis Data Analytics processes streaming SQL in real-time on Kinesis streams, and Elasticsearch/Kibana provide near-instant visualization capabilities suitable for high-volume event streams.
What is the key difference between AWS Glue DPU-based pricing and provisioned capacity?
Provisioned capacity commits to a minimum hourly cost for guaranteed capacity, while DPU-based pricing charges for every 0.25 DPU-hours of actual job execution, making it better for variable workloads.
You are building a federated query solution across Redshift, RDS, and S3 using Redshift Spectrum. What is a critical consideration?
Redshift Spectrum queries external data by defining external tables through the Glue Catalog, which enables federated queries without moving data into Redshift.
A data pipeline processes customer events with personally identifiable information (PII). Which AWS service should be used for automatic PII detection and masking?
AWS Glue DataBrew provides visual recipes specifically designed for PII detection and masking as part of data preparation workflows, with no coding required.
You need to optimize query performance on a 50 TB Redshift cluster. Which strategy would have the most significant impact?
Sort keys and distribution keys directly impact query execution by minimizing data shuffling and enabling efficient joins and scans, which is more impactful than node type upgrades for most scenarios.
An organization collects sensor data from 100,000 IoT devices every 5 seconds. What is the recommended approach for ingesting this data into AWS?
AWS IoT Core integrates directly with Kinesis Data Streams for high-throughput, low-latency ingestion of device data at scale, supporting the millions of concurrent connections typical of IoT workloads.
You are designing data retention policies for a compliance-heavy industry. How should you implement time-based data deletion in S3 using Redshift Spectrum?
Partitioned external tables allow you to efficiently drop entire partitions based on date ranges, which is the most efficient approach for time-based retention in Spectrum without modifying underlying S3 data.
What is the primary advantage of using Amazon QuickSight's SPICE engine?
SPICE (Super-fast, Parallel, In-memory Calculation Engine) caches data in-memory with optimized indexing, enabling extremely fast interactive dashboards and exploration without hitting the source database.
An analytics team needs to share a complex dataset with external partners while maintaining data security. Which approach is most appropriate?
Lake Formation provides fine-grained access control across accounts with row and column-level filtering, enabling secure data sharing with external partners while maintaining data governance.
You are implementing a data warehouse that requires strict isolation of workloads to prevent analytical queries from impacting operational systems. Which Redshift feature addresses this?
Redshift WLM allows you to define query queues with resource limits, CPU allocation, and query priorities, ensuring heavy analytical queries don't starve operational workloads of resources.
A company processes clickstream data with high cardinality dimensions (e.g., user IDs, session IDs). Which data storage format in S3 would minimize query costs in Athena?
Parquet format supports columnar storage and compression, allowing Athena to skip entire columns and partitions, significantly reducing scanned data and query costs compared to row-based formats like CSV.
What is the correct approach to handle slowly changing dimensions (Type 2) in an AWS data warehouse using Glue?
Type 2 SCD requires maintaining historical records with surrogate keys and effective date ranges, enabling point-in-time analysis while preserving dimension change history in the data warehouse.
An organization needs to monitor data quality for thousands of tables daily. Which service provides automated data quality checks?
AWS Glue Data Quality automatically generates and applies data quality rules, monitoring completeness, uniqueness, and accuracy across large numbers of datasets without manual rule creation.
You need to implement a data catalog that supports multi-region disaster recovery. Which approach minimizes failover time?
AWS Glue Catalog supports cross-region replication of metadata, enabling rapid failover to a standby region with minimal data loss and manual intervention.
What configuration is essential when using Amazon Kinesis Data Firehose for data transformation?
Firehose can invoke Lambda functions for data transformation; these functions must complete successfully and return properly formatted records for delivery to the destination.
A financial services company requires immutable audit logs for compliance. Which S3 configuration ensures data cannot be modified or deleted?
S3 Object Lock in COMPLIANCE mode provides WORM (Write-Once-Read-Many) protection with a retention period, preventing any deletion or modification even by administrators, meeting immutable audit log requirements.
You are designing an ETL process that must handle schema evolution in source data. Which Glue feature best supports this?
Glue Crawlers automatically detect schema changes by scanning source data and updating the catalog accordingly, eliminating the need for manual schema management as source data evolves.
A startup wants to build a serverless analytics solution with minimal operational overhead. Which technology stack would be most appropriate?
This stack is fully serverless and managed: Firehose ingests data automatically, S3 stores it, Glue transforms it on-demand, and QuickSight provides visualization without managing infrastructure.
You need to ingest real-time streaming data from IoT devices into AWS. Which service would best handle high-throughput, low-latency ingestion with automatic scaling?
Kinesis Data Streams is purpose-built for real-time data ingestion with automatic scaling, high throughput, and low latency, making it ideal for IoT device data.
A data analyst needs to perform interactive SQL queries on data stored in S3 without provisioning servers. Which service should be used?
Amazon Athena provides serverless SQL query capability for S3 data without requiring infrastructure setup, making it the most straightforward solution.
You are designing a data lake and need to ensure fine-grained access control across multiple AWS accounts. Which AWS service provides centralized governance and permission management?
AWS Lake Formation provides centralized data governance with fine-grained access control, cross-account access management, and simplified permission administration.
What is the primary advantage of using Amazon Redshift over traditional on-premises data warehouses for analytics workloads?
Redshift's MPP architecture enables horizontal scaling, cost-effective pay-per-use pricing, and eliminates upfront capital investment compared to on-premises systems.
A company uses AWS Glue to catalog and transform data. Which component automatically discovers and catalogues data schema changes?
AWS Glue Crawlers automatically scan data sources, infer schemas, and populate the Glue Data Catalog, detecting schema changes over time.
You need to stream data from Kinesis Data Streams to multiple destinations including S3, Redshift, and Elasticsearch. What is the most efficient approach?
Kinesis Data Firehose can deliver data to multiple AWS destinations (S3, Redshift, Elasticsearch) with built-in transformations and fault tolerance, though separate streams may be needed for different batching requirements.
Your organization needs to perform machine learning predictions on streaming data. Which combination of services provides the most integrated solution?
Kinesis Data Analytics integrates directly with Apache Flink for streaming analytics and can invoke SageMaker endpoints for real-time ML predictions within the streaming pipeline.
When configuring Amazon Redshift, which parameter directly affects query performance and storage capacity?
Node type (dense compute vs. dense storage) and cluster size determine both the computational resources and total storage capacity available for query processing.
A data pipeline ingests data from multiple heterogeneous sources. Which AWS Glue feature best handles complex ETL transformations with minimal code?
AWS Glue Studio provides a visual, drag-and-drop interface for building complex ETL pipelines without writing extensive code, supporting various source and target combinations.
You want to analyze data using QuickSight and need to establish real-time connectivity to a database. Which connection type provides the lowest latency?
Direct database connections via JDBC/ODBC provide real-time query execution with lowest latency, though SPICE offers better performance for repeated queries on cached data.
Which Amazon DMS feature enables continuous data replication from source to target with minimal downtime?
DMS performs an initial full load and then captures ongoing changes (CDC), enabling continuous replication that minimizes application downtime during database migration.
In Amazon Kinesis Data Analytics, what is the primary purpose of a source group?
Source groups in Kinesis Data Analytics allow you to logically combine and join data from multiple input streams for integrated processing within SQL or Flink applications.
You need to compress data before loading it into Redshift to reduce storage costs. Which compression algorithm provides the best ratio for columnar data?
AZ64 is a modern compression algorithm optimized for columnar data in Redshift, providing better compression ratios than older methods like LZO or Snappy.
A company wants to detect anomalies in real-time sensor data. Which AWS service is purpose-built for anomaly detection in streaming time-series data?
Amazon Lookout for Metrics is specifically designed for automated anomaly detection in time-series metrics and can integrate with various data sources for real-time detection.
What is the maximum retention period for data stored in Kinesis Data Streams without using enhanced fan-out?
Kinesis Data Streams retains data for 24 hours by default, and you can increase this to up to 365 days using the extended retention feature for an additional cost.
You are designing a cost-effective analytics solution for ad-hoc queries on large historical datasets. Which approach minimizes costs while maintaining query performance?
Storing data in S3 with Athena queries combined with proper partitioning and projection strategies provides cost-effective ad-hoc analysis without maintaining expensive data warehouse infrastructure.
In AWS Lake Formation, what does the 'LF-tag-based access control' feature enable?
LF-tag-based access control allows administrators to define permissions using metadata tags that are automatically enforced across Athena, Redshift, Glue, and other integrated services.
A data analyst needs to create visualizations with drill-down capability and complex calculations. Which QuickSight feature best supports this requirement?
QuickSight analyses with hierarchical dimensions enable drill-down capability, and calculated fields support complex business logic and transformations at visualization time.
What is the primary difference between Kinesis Data Streams and Kinesis Data Firehose in terms of data delivery guarantee?
Kinesis Data Firehose guarantees at-least-once delivery to destinations, while Kinesis Data Streams provides at-least-once delivery to consumers with ordered records per shard.
You need to join streaming data from two Kinesis streams with different arrival rates. What is the best approach in Kinesis Data Analytics?
Kinesis Data Analytics supports windowed joins (tumbling, sliding, session windows) that handle streams with different arrival rates by buffering events within the window duration.
Which AWS Glue feature allows scheduling of ETL jobs based on triggers, including event-based execution?
AWS Glue Workflows enable orchestration of multiple jobs with triggers (time-based, on-demand, or event-based), providing complex job dependency and sequencing management.
A company processes petabytes of data daily using EMR. To optimize costs, they should implement which cost management strategy?
Combining spot instances (for cost), reserved instances (for baseline capacity), on-demand (for peaks), and auto-scaling provides optimal cost efficiency for variable EMR workloads.
When using Amazon Redshift, what is the impact of row-level security (RLS) on query performance?
RLS performance impact depends on policy complexity, the number of policies, and how they interact with query predicates and data distribution, requiring careful design and testing.
You need to implement data quality checks in an AWS Glue ETL pipeline. Which feature is purpose-built for this?
AWS Glue Data Quality Rules provide a framework to define, validate, and monitor data quality checks directly within ETL jobs, with automatic recommendations and remediation.
In QuickSight, what is the primary advantage of using SPICE (Super-fast, Parallel, In-memory Calculation Engine)?
SPICE imports and caches data in memory, enabling fast interactive dashboard performance and drill-downs without repeatedly querying the source database or data warehouse.
You are designing a data lake on Amazon S3 for a healthcare organization. Which data format would be most efficient for analytical queries while maintaining ACID transactions and schema enforcement?
Apache Iceberg and Delta Lake provide ACID transactions, schema enforcement, and time-travel capabilities essential for healthcare data lakes, while Parquet alone lacks transaction support and CSV/JSON are less optimal for analytical queries.
Your company uses Amazon Redshift and needs to perform real-time analytics on streaming data. Which approach best combines streaming ingestion with Redshift analytical capabilities?
Kinesis Data Firehose is purpose-built for streaming data delivery to Redshift, handling batching, compression, and automatic retry logic without requiring custom code.
You need to optimize costs for infrequent analytical queries on historical data in Amazon Redshift. Which strategy would be most cost-effective?
Archiving historical data to S3 and using Athena for infrequent queries eliminates Redshift cluster costs for cold data, while Spectrum still requires an active cluster, making option B more cost-effective for this scenario.
An organization wants to implement a data quality framework in AWS Glue. Which combination of services would provide comprehensive data validation, cleansing, and quality metrics?
AWS Glue DataBrew and AWS Glue Data Quality are purpose-built for data profiling, cleansing, validation, and quality metric generation, providing a more comprehensive and maintainable solution than custom code or QuickSight alone.
You are implementing a machine learning pipeline where Amazon SageMaker needs access to training data stored in S3. What is the most secure way to grant this access without exposing AWS credentials?
Attaching an IAM role with S3 permissions to the SageMaker execution role follows AWS security best practices by using temporary credentials automatically managed by AWS, eliminating the need to handle credentials explicitly.
Your organization needs to perform complex SQL transformations on data that spans multiple data sources including RDS, S3, and DynamoDB. Which service would best enable unified querying across these heterogeneous sources?
Amazon Athena's federated query feature allows querying data across multiple sources without replicating them, providing SQL access to RDS, S3, and DynamoDB in a cost-effective manner without data movement.
You have implemented Amazon QuickSight dashboards that must comply with data masking requirements where certain users cannot see PII columns. What is the recommended approach?
QuickSight's field-level security combined with row-level security rules provides granular control over which columns users can access, enabling compliance with PII masking requirements while maintaining a single dataset.
An organization is building a real-time fraud detection system using Amazon Kinesis. Which configuration best supports low-latency processing with automatic scaling and exactly-once semantics?
Kinesis Data Streams with KCL provides automatic horizontal scaling through shard-based processing, managed checkpointing for exactly-once semantics, and lower latency compared to Firehose which is optimized for batch delivery.
You need to analyze unstructured log data from AWS services and application logs stored in S3. Which combination of services provides the most efficient solution for log analysis and visualization?
Using Glue for cataloging, Athena for SQL queries, and QuickSight for visualization provides a serverless, cost-effective solution that scales automatically and requires minimal infrastructure management for S3-based log analysis.
Your organization maintains multiple data marts built on Redshift clusters across different AWS regions. To ensure consistency and reduce data duplication, what approach should be implemented?
Centralizing ETL in Glue and using S3 as a single source of truth with Redshift Spectrum eliminates data duplication, ensures consistency across regions, and is more cost-effective than maintaining multiple cluster replicas or continuous replication.
You've reviewed all 61 questions. Take the interactive practice exam to simulate the real test environment.
▶ Start Practice Exam — Free