Free AWS DAS-C01 Practice Questions & Answers 2026 Part1

Question #1

An energy company collects voltage data in real time from sensors that are attached to buildings. The company wants to receive noti cations when a sequence of two voltage drops is detected within 10 minutes of a sudden voltage increase at the same building. All noti cations must be delivered as quickly as possible. The system must be highly available. The company needs a solution that will automatically scale when this monitoring feature is implemented in other cities. The noti cation system is subscribed to an Amazon Simple Noti cation Service (Amazon SNS) topic for remediation.Which solution will meet these requirements?

A. Create an Amazon Managed Streaming for Apache Kafka cluster to ingest the data

B. Create a REST-based web service by using Amazon API Gateway in front of an AWS Lambda function

C. Create an Amazon Kinesis Data Firehose delivery stream to capture the incoming sensor data

D. Create an Amazon Kinesis data stream to capture the incoming sensor data

View answer

Correct Answer: A

Question #2

A team of data scientists plans to analyze market trend data for their company's new investment strategy. The trend data comes from ve different data sources in large volumes. The team wants to utilize Amazon Kinesis to support their use case. The team uses SQL-like queries to analyze trends and wants to send noti cations based on certain signi cant patterns in the trends. Additionally, the data scientists want to save the data to Amazon S3 for archival and historical re- processing, and use AWS managed services wherever possible. The team wants to implement the lowest-cost solution.Which solution meets these requirements?

A. Publish data to one Kinesis data stream

B. Publish data to one Kinesis data stream

C. Publish data to two Kinesis data streams

D. Publish data to two Kinesis data streams

View answer

Correct Answer: B

Question #3

A data analyst is using AWS Glue to organize, cleanse, validate, and format a 200 GB dataset. The data analyst triggered the job to run with the Standard workertype. After 3 hours, the AWS Glue job status is still RUNNING. Logs from the job run show no error codes. The data analyst wants to improve the job executiontime without overprovisioning.Which actions should the data analyst take?

A. Enable job bookmarks in AWS Glue to estimate the number of data processing units (DPUs)

B. Enable job metrics in AWS Glue to estimate the number of data processing units (DPUs)

C. Enable job metrics in AWS Glue to estimate the number of data processing units (DPUs)

D. Enable job bookmarks in AWS Glue to estimate the number of data processing units (DPUs)

View answer

Correct Answer: B

Question #4

A team of data scientists plans to analyze market trend data for their company's new investment strategy. The trend data comes from ve different data sources in large volumes. The team wants to utilize Amazon Kinesis to support their use case. The team uses SQL-like queries to analyze trends and wants to send noti cations based on certain signi cant patterns in the trends. Additionally, the data scientists want to save the data to Amazon S3 for archival and historical re- processing, and use AWS managed services wherever possible. The team wants to implement the lowest-cost solution.Which solution meets these requirements?

A. Publish data to one Kinesis data stream

B. Publish data to one Kinesis data stream

C. Publish data to two Kinesis data streams

D. Publish data to two Kinesis data streams

View answer

Correct Answer: B

Question #5

A company wants to optimize the cost of its data and analytics platform. The company is ingesting a number of .csv and JSON les in Amazon S3 from various data sources. Incoming data is expected to be 50 GB each day. The company is using Amazon Athena to query the raw data in Amazon S3 directly. Most queries aggregate data from the past 12 months, and data that is older than 5 years is infrequently queried. The typical query scans about 500 MB of data and is expected to return results in less than 1 minute. The raw data must be retained inde nitely for compliance requirements.Which solution meets the company's requirements?

A. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data format

B. Use an AWS Glue ETL job to partition and convert the data into a row-based data format

C. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data format

D. Use an AWS Glue ETL job to partition and convert the data into a row-based data format

View answer

Correct Answer: A

Question #6

A company currently uses Amazon Athena to query its global datasets. The regional data is stored in Amazon S3 in the us-east-1 and us-west-2 Regions. The data is not encrypted. To simplify the query process and manage it centrally, the company wants to use Athena in us-west-2 to query data from Amazon S3 in bothRegions. The solution should be as low-cost as possible.What should the company do to achieve this goal?

A. Use AWS DMS to migrate the AWS Glue Data Catalog from us-east-1 to us-west-2

B. Run the AWS Glue crawler in us-west-2 to catalog datasets in all Regions

C. Enable cross-Region replication for the S3 buckets in us-east-1 to replicate data in us-west-2

D. Update AWS Glue resource policies to provide us-east-1 AWS Glue Data Catalog access to us-west-2

View answer

Correct Answer: B

Question #7

A company is building a service to monitor fleets of vehicles. The company collects IoT data from a device in each vehicle and loads the data into Amazon Redshift in near-real time. Fleet owners upload .csv files containing vehicle reference data into Amazon S3 at different times throughout the day. A nightly process loads the vehicle reference data from Amazon S3 into Amazon Redshift. The company joins the IoT data from the device and the vehicle reference data to power reporting and dashboards. Fleet owners are frustrated by waiting a day for the dashboards to update.

A. Use S3 event notifications to trigger an AWS Lambda function to copy the vehicle reference data into Amazon Redshift immediately when the reference data is uploaded to Amazon S3

B. Create and schedule an AWS Glue Spark job to run every 5 minutes

C. Send reference data to Amazon Kinesis Data Streams

D. Send the reference data to an Amazon Kinesis Data Firehose delivery stream

View answer

Correct Answer: A

Question #8

A large company receives les from external parties in Amazon EC2 throughout the day. At the end of the day, the les are combined into a single le, compressed into a gzip le, and uploaded to Amazon S3. The total size of all the les is close to 100 GB daily. Once the les are uploaded to Amazon S3, anAWS Batch program executes a COPY command to load the les into an Amazon Redshift cluster.Which program modi cation will accelerate the COPY process?

A. Upload the individual les to Amazon S3 and run the COPY command as soon as the les become available

B. Split the number of les so they are equal to a multiple of the number of slices in the Amazon Redshift cluster

C. Split the number of les so they are equal to a multiple of the number of compute nodes in the Amazon Redshift cluster

D. Apply sharding by breaking up the les so the distkey columns with the same values go to the same le

View answer

Correct Answer: B

Question #9

A company uses Amazon OpenSearch Service (Amazon Elasticsearch Service) to store and analyze its website clickstream data. The company ingests 1 TB of data daily using Amazon Kinesis Data Firehose and stores one day's worth of data in an Amazon ES cluster. The company has very slow query performance on the Amazon ES index and occasionally sees errors from Kinesis Data Firehose when attempting to write to the index. The Amazon ES cluster has 10 nodes running a single index and 3 dedicated master nodes. Each data node has 1.5 TB of Amazon EBS storage attached and the cluster is con gured with 1,000 shards. Occasionally, JVMMemoryPressure errors are found in the cluster logs.Which solution will improve the performance of Amazon ES?

A. Increase the memory of the Amazon ES master nodes

B. Decrease the number of Amazon ES data nodes

C. Decrease the number of Amazon ES shards for the index

D. Increase the number of Amazon ES shards for the index

View answer

Correct Answer: C

Question #10

A company wants to optimize the cost of its data and analytics platform. The company is ingesting a number of .csv and JSON les in Amazon S3 from various data sources. Incoming data is expected to be 50 GB each day. The company is using Amazon Athena to query the raw data in Amazon S3 directly. Most queries aggregate data from the past 12 months, and data that is older than 5 years is infrequently queried. The typical query scans about 500 MB of data and is expected to return results in less than 1 minute. The raw data must be retained inde nitely for compliance requirements.Which solution meets the company's requirements?

A. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data format

B. Use an AWS Glue ETL job to partition and convert the data into a row-based data format

C. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data format

D. Use an AWS Glue ETL job to partition and convert the data into a row-based data format

View answer

Correct Answer: A

Question #11

A manufacturing company has been collecting IoT sensor data from devices on its factory floor for a year and is storing the data in Amazon Redshift for dailyanalysis. A data analyst has determined that, at an expected ingestion rate of about 2 TB per day, the cluster will be undersized in less than 4 months. A long-termsolution is needed. The data analyst has indicated that most queries only reference the most recent 13 months of data, yet there are also quarterly reports thatneed to query all the data generated from the past 7 years. The chief technology officer (CTO) is concerned about the costs, administrative effort, andperformance of a long-term solution.Which solution should the data analyst use to meet these requirements?

A. Create a daily job in AWS Glue to UNLOAD records older than 13 months to Amazon S3 and delete those records from Amazon Redshift

B. Take a snapshot of the Amazon Redshift cluster

C. Execute a CREATE TABLE AS SELECT (CTAS) statement to move records that are older than 13 months to quarterly partitioned data in Amazon Redshift Spectrum backed by Amazon S3

D. Unload all the tables in Amazon Redshift to an Amazon S3 bucket using S3 Intelligent-Tiering

View answer

Correct Answer: B

Question #12

A media company has been performing analytics on log data generated by its applications. There has been a recent increase in the number of concurrent analytics jobs running, and the overall performance of existing jobs is decreasing as the number of new jobs is increasing. The partitioned data is stored inAmazon S3 One Zone-Infrequent Access (S3 One Zone-IA) and the analytic processing is performed on Amazon EMR clusters using the EMR File System(EMRFS) with consistent view enabled. A data analyst has determined that it is taking longer for the EMR task nodes to list objects in Amazon S3.Which action would MOST likely increase the performance of accessing log data in Amazon S3?

A. se a hash function to create a random string and add that to the beginning of the object prefixes when storing the log data in Amazon S3

B. se a lifecycle policy to change the S3 storage class to S3 Standard for the log data

C. ncrease the read capacity units (RCUs) for the shared Amazon DynamoDB table

D. edeploy the EMR clusters that are running slowly to a different Availability Zone

View answer

Correct Answer: D

Question #13

A company wants to optimize the cost of its data and analytics platform. The company is ingesting a number of .csv and JSON les in Amazon S3 from various data sources. Incoming data is expected to be 50 GB each day. The company is using Amazon Athena to query the raw data in Amazon S3 directly. Most queries aggregate data from the past 12 months, and data that is older than 5 years is infrequently queried. The typical query scans about 500 MB of data and is expected to return results in less than 1 minute. The raw data must be retained inde nitely for compliance requirements.Which solution meets the company's requirements?

A. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data format

B. Use an AWS Glue ETL job to partition and convert the data into a row-based data format

C. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data format

D. Use an AWS Glue ETL job to partition and convert the data into a row-based data format

View answer

Correct Answer: A

Question #14

A team of data scientists plans to analyze market trend data for their company's new investment strategy. The trend data comes from ve different data sources in large volumes. The team wants to utilize Amazon Kinesis to support their use case. The team uses SQL-like queries to analyze trends and wants to send noti cations based on certain signi cant patterns in the trends. Additionally, the data scientists want to save the data to Amazon S3 for archival and historical re- processing, and use AWS managed services wherever possible. The team wants to implement the lowest-cost solution.Which solution meets these requirements?

A. Publish data to one Kinesis data stream

B. Publish data to one Kinesis data stream

C. Publish data to two Kinesis data streams

D. Publish data to two Kinesis data streams

View answer

Correct Answer: B

Question #15

An energy company collects voltage data in real time from sensors that are attached to buildings. The company wants to receive noti cations when a sequence of two voltage drops is detected within 10 minutes of a sudden voltage increase at the same building. All noti cations must be delivered as quickly as possible. The system must be highly available. The company needs a solution that will automatically scale when this monitoring feature is implemented in other cities. The noti cation system is subscribed to an Amazon Simple Noti cation Service (Amazon SNS) topic for remediation.Which solution will meet these requirements?

A. Create an Amazon Managed Streaming for Apache Kafka cluster to ingest the data

B. Create a REST-based web service by using Amazon API Gateway in front of an AWS Lambda function

C. Create an Amazon Kinesis Data Firehose delivery stream to capture the incoming sensor data

D. Create an Amazon Kinesis data stream to capture the incoming sensor data

View answer

Correct Answer: A

Question #16

A company is reading data from various customer databases that run on Amazon RDS. The databases contain many inconsistent fields For example, a customer record field that is place_id in one database is location_id in another database. The company wants to link customer records across different databases, even when many customer record fields do not match exactly Which solution will meet these requirements with the LEAST operational overhead?

A. reate an Amazon EMR cluster to process and analyze data in the databases

B. reate an Amazon EMR cluster to process and analyze data in the databases Connect to the Apache Zeppelin notebook, and use the FindMatches transform to find duplicate records in the data

C. reate an AWS Glue crawler to crawl the databases

D. reate an AWS Glue crawler to crawl the data in the databases Use Amazon SageMaker to construct Apache Spark ML pipelines to find duplicate records in the data

View answer

Correct Answer: C

Question #17

A manufacturing company has been collecting IoT sensor data from devices on its factory oor for a year and is storing the data in Amazon Redshift for daily analysis. A data analyst has determined that, at an expected ingestion rate of about 2 TB per day, the cluster will be undersized in less than 4 months. A long-term solution is needed. The data analyst has indicated that most queries only reference the most recent 13 months of data, yet there are also quarterly reports that need to query all the data generated from the past 7 years. The chief technology o cer (CTO) is concerned about the costs, administrative effort, and performance of a long-term solution.Which solution should the data analyst use to meet these requirements?

A. Create a daily job in AWS Glue to UNLOAD records older than 13 months to Amazon S3 and delete those records from Amazon Redshift

B. Take a snapshot of the Amazon Redshift cluster

C. Execute a CREATE TABLE AS SELECT (CTAS) statement to move records that are older than 13 months to quarterly partitioned data in Amazon Redshift Spectrum backed by Amazon S3

D. Unload all the tables in Amazon Redshift to an Amazon S3 bucket using S3 Intelligent-Tiering

View answer

Correct Answer: A

Question #18

An energy company collects voltage data in real time from sensors that are attached to buildings. The company wants to receive noti cations when a sequence of two voltage drops is detected within 10 minutes of a sudden voltage increase at the same building. All noti cations must be delivered as quickly as possible. The system must be highly available. The company needs a solution that will automatically scale when this monitoring feature is implemented in other cities. The noti cation system is subscribed to an Amazon Simple Noti cation Service (Amazon SNS) topic for remediation.Which solution will meet these requirements?

A. Create an Amazon Managed Streaming for Apache Kafka cluster to ingest the data

B. Create a REST-based web service by using Amazon API Gateway in front of an AWS Lambda function

C. Create an Amazon Kinesis Data Firehose delivery stream to capture the incoming sensor data

D. Create an Amazon Kinesis data stream to capture the incoming sensor data

View answer

Correct Answer: A

Question #19

A financial company hosts a data lake in Amazon S3 and a data warehouse on an Amazon Redshift cluster. The company uses Amazon QuickSight to build dashboards and wants to secure access from its on - premises Active Directory to Amazon QuickSight. How should the data be secured?

A. Use an Active Directory connector and single sign - on (SSO) in a corporate network environment

B. Use a VPC endpoint to connect to Amazon S3 from Amazon QuickSight and an IAM role to authenticate Amazon Redshift

C. Establish a secure connection by creating an S3 endpoint to connect Amazon QuickSight and a VPC endpoint to connect to Amazon Redshift

D. Place Amazon QuickSight and Amazon Redshift in the security group and use an Amazon S3 endpoint to connect Amazon QuickSight to Amazon S3

View answer

Correct Answer: A

Question #20

An Amazon Redshift database contains sensitive user data. Logging is necessary to meet compliance requirements. The logs must contain database authentication attempts, connections, and disconnections. The logs must also contain each query run against the database and record which database user ran each query.Which steps will create the required logs?

A. nable Amazon Redshift Enhanced VPC Routing

B. llow access to the Amazon Redshift database using AWS IAM only

C. nable audit logging for Amazon Redshift using the AWS Management Console or the AWS CLI

D. nable and download audit reports from AWS Artifact

View answer

Correct Answer: C

Question #21

A company currently uses Amazon Athena to query its global datasets. The regional data is stored in Amazon S3 in the us-east-1 and us-west-2 Regions. The data is not encrypted. To simplify the query process and manage it centrally, the company wants to use Athena in us-west-2 to query data from Amazon S3 in bothRegions. The solution should be as low-cost as possible.What should the company do to achieve this goal?

A. Use AWS DMS to migrate the AWS Glue Data Catalog from us-east-1 to us-west-2

B. Run the AWS Glue crawler in us-west-2 to catalog datasets in all Regions

C. Enable cross-Region replication for the S3 buckets in us-east-1 to replicate data in us-west-2

D. Update AWS Glue resource policies to provide us-east-1 AWS Glue Data Catalog access to us-west-2

View answer

Correct Answer: B

Question #22

A financial services company is building a data lake solution on Amazon S3. The company plans to use analytics offerings from AWS to meet user needs for one-time querying and business intelligence reports. A portion of the columns will contain personally identifiable information (PII) Only authorized users should be able to see plaintext PII data.

A. Define a bucket policy for each S3 bucket of the data lake to allow access to users who have authorization to see PII data

B. Register the S3 locations with AWS Lake Formation

C. Register the S3 locations with AWS Lake Formation

D. Register the S3 locations with AWS Lake Formation

View answer

Correct Answer: B

Question #23

A large ride-sharing company has thousands of drivers globally serving millions of unique customers every day. The company has decided to migrate an existing data mart to Amazon Redshift. The existing schema includes the following tables.A trips fact table for information on completed rides.A drivers dimension table for driver pro les.A customers fact table holding customer pro le information.The company analyzes trip details by date and destination to examine pro tability by region. The drivers data rarely changes. The customers data frequently changes.What table design provides optimal query performance?

A. Use DISTSTYLE KEY (destination) for the trips table and sort by date

B. Use DISTSTYLE EVEN for the trips table and sort by date

C. Use DISTSTYLE KEY (destination) for the trips table and sort by date

D. Use DISTSTYLE EVEN for the drivers table and sort by date

View answer

Correct Answer: C

Question #24

An airline has .csv-formatted data stored in Amazon S3 with an AWS Glue Data Catalog. Data analysts want to join this data with call center data stored in Amazon Redshift as part of a dally batch process. The Amazon Redshift cluster is already under a heavy load. The solution must be managed, serverless, well-functioning, and minimize the load on the existing Amazon Redshift cluster. The solution should also require minimal effort and development activity.Which solution meets these requirements?

A. nload the call center data from Amazon Redshift to Amazon S3 using an AWS Lambda function

B. xport the call center data from Amazon Redshift using a Python shell in AWS Glue

C. xport the call center data from Amazon Redshift to Amazon EMR using Apache Sqoop

D. reate an external table using Amazon Redshift Spectrum for the call center data and perform the join with Amazon Redshift

View answer

Correct Answer: D

Question #25

A team of data scientists plans to analyze market trend data for their company's new investment strategy. The trend data comes from ve different data sources in large volumes. The team wants to utilize Amazon Kinesis to support their use case. The team uses SQL-like queries to analyze trends and wants to send noti cations based on certain signi cant patterns in the trends. Additionally, the data scientists want to save the data to Amazon S3 for archival and historical re- processing, and use AWS managed services wherever possible. The team wants to implement the lowest-cost solution.Which solution meets these requirements?

A. Publish data to one Kinesis data stream

B. Publish data to one Kinesis data stream

C. Publish data to two Kinesis data streams

D. Publish data to two Kinesis data streams

View answer

Correct Answer: B

Question #26

A financial company uses Apache Hive on Amazon EMR for ad-hoc queries. Users are complaining of sluggish performance.A data analyst notes the following:✑ Approximately 90% of queries are submitted 1 hour after the market opens.Hadoop Distributed File System (HDFS) utilization never exceeds 10%.Which solution would help address the performance issues?

A. reate instance fleet configurations for core and task nodes

B. reate instance fleet configurations for core and task nodes

C. reate instance group configurations for core and task nodes

D. reate instance group configurations for core and task nodes

View answer

Correct Answer: C

Question #27

A streaming application is reading data from Amazon Kinesis Data Streams and immediately writing the data to an Amazon S3 bucket every 10 seconds. Theapplication is reading data from hundreds of shards. The batch interval cannot be changed due to a separate requirement. The data is being accessed by AmazonAthena. Users are seeing degradation in query performance as time progresses.Which action can help improve query performance?

A. Merge the files in Amazon S3 to form larger files

B. Increase the number of shards in Kinesis Data Streams

C. Add more memory and CPU capacity to the streaming application

D. Write the files to multiple S3 buckets

View answer

Correct Answer: C

Question #28

A company has developed several AWS Glue jobs to validate and transform its data from Amazon S3 and load it into Amazon RDS for MySQL in batches once every day. The ETL jobs read the S3 data using a DynamicFrame. Currently, the ETL developers are experiencing challenges in processing only the incremental data on every run, as the AWS Glue job processes all the S3 input data on each run.Which approach would allow the developers to solve the issue with minimal coding effort?

A. ave the ETL jobs read the data from Amazon S3 using a DataFrame

B. nable job bookmarks on the AWS Glue jobs

C. reate custom logic on the ETL jobs to track the processed S3 objects

D. ave the ETL jobs delete the processed objects or data from Amazon S3 after each run

View answer

Correct Answer: D

Question #29

A large company receives les from external parties in Amazon EC2 throughout the day. At the end of the day, the les are combined into a single le, compressed into a gzip le, and uploaded to Amazon S3. The total size of all the les is close to 100 GB daily. Once the les are uploaded to Amazon S3, anAWS Batch program executes a COPY command to load the les into an Amazon Redshift cluster.Which program modi cation will accelerate the COPY process?

A. Upload the individual les to Amazon S3 and run the COPY command as soon as the les become available

B. Split the number of les so they are equal to a multiple of the number of slices in the Amazon Redshift cluster

C. Split the number of les so they are equal to a multiple of the number of compute nodes in the Amazon Redshift cluster

D. Apply sharding by breaking up the les so the distkey columns with the same values go to the same le

View answer

Correct Answer: B

Question #30

A media analytics company consumes a stream of social media posts. The posts are sent to an Amazon Kinesis data stream partitioned on user_id. An AWS Lambda function retrieves the records and validates the content before loading the posts into an Amazon OpenSearch Service (Amazon Elasticsearch Service) cluster. The validation process needs to receive the posts for a given user in the order they were received by the Kinesis data stream.

A. Migrate the validation process from Lambda to AWS Glue

B. Migrate the Lambda consumers from standard data stream iterators to an HTTP/2 stream consumer

C. Increase the number of shards in the Kinesis data stream

D. Send the posts stream to Amazon Managed Streaming for Apache Kafka instead of the Kinesis data stream

View answer

Correct Answer: C

Question #31

A large ride-sharing company has thousands of drivers globally serving millions of unique customers every day. The company has decided to migrate an existing data mart to Amazon Redshift. The existing schema includes the following tables.A trips fact table for information on completed rides.A drivers dimension table for driver pro les.A customers fact table holding customer pro le information.The company analyzes trip details by date and destination to examine pro tability by region. The drivers data rarely changes. The customers data frequently changes.What table design provides optimal query performance?

A. Use DISTSTYLE KEY (destination) for the trips table and sort by date

B. Use DISTSTYLE EVEN for the trips table and sort by date

C. Use DISTSTYLE KEY (destination) for the trips table and sort by date

D. Use DISTSTYLE EVEN for the drivers table and sort by date

View answer

Correct Answer: C

Question #32

A company currently uses Amazon Athena to query its global datasets. The regional data is stored in Amazon S3 in the us-east-1 and us-west-2 Regions. The data is not encrypted. To simplify the query process and manage it centrally, the company wants to use Athena in us-west-2 to query data from Amazon S3 in bothRegions. The solution should be as low-cost as possible.What should the company do to achieve this goal?

A. Use AWS DMS to migrate the AWS Glue Data Catalog from us-east-1 to us-west-2

B. Run the AWS Glue crawler in us-west-2 to catalog datasets in all Regions

C. Enable cross-Region replication for the S3 buckets in us-east-1 to replicate data in us-west-2

D. Update AWS Glue resource policies to provide us-east-1 AWS Glue Data Catalog access to us-west-2

View answer

Correct Answer: B

Question #33

Three teams of data analysts use Apache Hive on an Amazon EMR cluster with the EMR File System (EMRFS) to query data stored within each teams AmazonS3 bucket. The EMR cluster has Kerberos enabled and is con gured to authenticate users from the corporate Active Directory. The data is highly sensitive, so access must be limited to the members of each team.Which steps will satisfy the security requirements?

A. For the EMR cluster Amazon EC2 instances, create a service role that grants no access to Amazon S3

B. For the EMR cluster Amazon EC2 instances, create a service role that grants no access to Amazon S3

C. For the EMR cluster Amazon EC2 instances, create a service role that grants full access to Amazon S3

D. For the EMR cluster Amazon EC2 instances, create a service role that grants full access to Amazon S3

View answer

Correct Answer: B

Question #34

A large ride-sharing company has thousands of drivers globally serving millions of unique customers every day. The company has decided to migrate an existing data mart to Amazon Redshift. The existing schema includes the following tables.A trips fact table for information on completed rides.A drivers dimension table for driver pro les.A customers fact table holding customer pro le information.The company analyzes trip details by date and destination to examine pro tability by region. The drivers data rarely changes. The customers data frequently changes.What table design provides optimal query performance?

A. Use DISTSTYLE KEY (destination) for the trips table and sort by date

B. Use DISTSTYLE EVEN for the trips table and sort by date

C. Use DISTSTYLE KEY (destination) for the trips table and sort by date

D. Use DISTSTYLE EVEN for the drivers table and sort by date

View answer

Correct Answer: C

Question #35

A manufacturing company wants to create an operational analytics dashboard to visualize metrics from equipment in near-real time. The company uses Amazon Kinesis Data Streams to stream the data to other applications. The dashboard must automatically refresh every 5 seconds. A data analytics specialist must design a solution that requires the least possible implementation effort.Which solution meets these requirements?

A. se Amazon Kinesis Data Firehose to push the data into an Amazon Elasticsearch Service (Amazon ES) cluster

B. se AWS Glue streaming ETL to store the data in Amazon S3

C. se Apache Spark Streaming on Amazon EMR to read the data in near-real time

D. se Amazon Kinesis Data Firehose to store the data in Amazon S3

View answer

Correct Answer: C

Question #36

A company is planning to create a data lake in Amazon S3. The company wants to create tiered storage based on access patterns and cost objectives. The solution must include support for JDBC connections from legacy clients, metadata management that allows federation for access control, and batch-based ETL using PySpark and Scala. Operational management should be limited. Which combination of components can meet these requirements? (Choose three.)

A. AWS Glue Data Catalog for metadata management

B. Amazon EMR with Apache Spark for ETL

C. AWS Glue for Scala-based ETL

D. Amazon EMR with Apache Hive for JDBC clients

E. Amazon Athena for querying data in Amazon S3 using JDBC drivers

F. Amazon EMR with Apache Hive, using an Amazon RDS with MySQL-compatible backed metastore

View answer

Correct Answer: ACE

Question #37

A company currently uses Amazon Athena to query its global datasets. The regional data is stored in Amazon S3 in the us-east-1 and us-west-2 Regions. The data is not encrypted. To simplify the query process and manage it centrally, the company wants to use Athena in us-west-2 to query data from Amazon S3 in bothRegions. The solution should be as low-cost as possible.What should the company do to achieve this goal?

A. Use AWS DMS to migrate the AWS Glue Data Catalog from us-east-1 to us-west-2

B. Run the AWS Glue crawler in us-west-2 to catalog datasets in all Regions

C. Enable cross-Region replication for the S3 buckets in us-east-1 to replicate data in us-west-2

D. Update AWS Glue resource policies to provide us-east-1 AWS Glue Data Catalog access to us-west-2

View answer

Correct Answer: B

Question #38

An energy company collects voltage data in real time from sensors that are attached to buildings. The company wants to receive noti cations when a sequence of two voltage drops is detected within 10 minutes of a sudden voltage increase at the same building. All noti cations must be delivered as quickly as possible. The system must be highly available. The company needs a solution that will automatically scale when this monitoring feature is implemented in other cities. The noti cation system is subscribed to an Amazon Simple Noti cation Service (Amazon SNS) topic for remediation.Which solution will meet these requirements?

A. Create an Amazon Managed Streaming for Apache Kafka cluster to ingest the data

B. Create a REST-based web service by using Amazon API Gateway in front of an AWS Lambda function

C. Create an Amazon Kinesis Data Firehose delivery stream to capture the incoming sensor data

D. Create an Amazon Kinesis data stream to capture the incoming sensor data

View answer

Correct Answer: A

Question #39

A large company receives les from external parties in Amazon EC2 throughout the day. At the end of the day, the les are combined into a single le, compressed into a gzip le, and uploaded to Amazon S3. The total size of all the les is close to 100 GB daily. Once the les are uploaded to Amazon S3, anAWS Batch program executes a COPY command to load the les into an Amazon Redshift cluster.Which program modi cation will accelerate the COPY process?

A. Upload the individual les to Amazon S3 and run the COPY command as soon as the les become available

B. Split the number of les so they are equal to a multiple of the number of slices in the Amazon Redshift cluster

C. Split the number of les so they are equal to a multiple of the number of compute nodes in the Amazon Redshift cluster

D. Apply sharding by breaking up the les so the distkey columns with the same values go to the same le

View answer

Correct Answer: B

Question #40

A large ride-sharing company has thousands of drivers globally serving millions of unique customers every day. The company has decided to migrate an existing data mart to Amazon Redshift. The existing schema includes the following tables.A trips fact table for information on completed rides.A drivers dimension table for driver pro les.A customers fact table holding customer pro le information.The company analyzes trip details by date and destination to examine pro tability by region. The drivers data rarely changes. The customers data frequently changes.What table design provides optimal query performance?

A. Use DISTSTYLE KEY (destination) for the trips table and sort by date

B. Use DISTSTYLE EVEN for the trips table and sort by date

C. Use DISTSTYLE KEY (destination) for the trips table and sort by date

D. Use DISTSTYLE EVEN for the drivers table and sort by date

View answer

Correct Answer: C

Question #41

A company wants to optimize the cost of its data and analytics platform. The company is ingesting a number of .csv and JSON les in Amazon S3 from various data sources. Incoming data is expected to be 50 GB each day. The company is using Amazon Athena to query the raw data in Amazon S3 directly. Most queries aggregate data from the past 12 months, and data that is older than 5 years is infrequently queried. The typical query scans about 500 MB of data and is expected to return results in less than 1 minute. The raw data must be retained inde nitely for compliance requirements.Which solution meets the company's requirements?

A. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data format

B. Use an AWS Glue ETL job to partition and convert the data into a row-based data format

C. Use an AWS Glue ETL job to compress, partition, and convert the data into a columnar data format

D. Use an AWS Glue ETL job to partition and convert the data into a row-based data format

View answer

Correct Answer: A

Question #42

A company currently uses Amazon Athena to query its global datasets. The regional data is stored in Amazon S3 in the us-east-1 and us-west-2 Regions. The data is not encrypted. To simplify the query process and manage it centrally, the company wants to use Athena in us-west-2 to query data from Amazon S3 in bothRegions. The solution should be as low-cost as possible.What should the company do to achieve this goal?

A. Use AWS DMS to migrate the AWS Glue Data Catalog from us-east-1 to us-west-2

B. Run the AWS Glue crawler in us-west-2 to catalog datasets in all Regions

C. Enable cross-Region replication for the S3 buckets in us-east-1 to replicate data in us-west-2

D. Update AWS Glue resource policies to provide us-east-1 AWS Glue Data Catalog access to us-west-2

View answer

Correct Answer: B

Question #43

A mortgage company has a microservice for accepting payments. This microservice uses the Amazon DynamoDB encryption client with AWS KMS managed keys to encrypt the sensitive data before writing the data to DynamoDB. The finance team should be able to load this data into Amazon Redshift and aggregate the values within the sensitive fields. The Amazon Redshift cluster is shared with other data analysts from different business units.Which steps should a data analyst take to accomplish this task efficiently and securely?

A. reate an AWS Lambda function to process the DynamoDB stream

B. reate an AWS Lambda function to process the DynamoDB stream

C. reate an Amazon EMR cluster with an EMR_EC2_DefaultRole role that has access to the KMS key

D. reate an Amazon EMR cluster

View answer

Correct Answer: B

Question #44

A data analyst is using AWS Glue to organize, cleanse, validate, and format a 200 GB dataset. The data analyst triggered the job to run with the Standard worker type. After 3 hours, the AWS Glue job status is still RUNNING. Logs from the job run show no error codes. The data analyst wants to improve the job execution time without overprovisioning.Which actions should the data analyst take?

A. Enable job bookmarks in AWS Glue to estimate the number of data processing units (DPUs)

B. Enable job metrics in AWS Glue to estimate the number of data processing units (DPUs)

C. Enable job metrics in AWS Glue to estimate the number of data processing units (DPUs)

D. Enable job bookmarks in AWS Glue to estimate the number of data processing units (DPUs)

View answer

Correct Answer: B

Question #45

A company currently uses Amazon Athena to query its global datasets. The regional data is stored in Amazon S3 in the us-east-1 and us-west-2 Regions. The data is not encrypted. To simplify the query process and manage it centrally, the company wants to use Athena in us-west-2 to query data from Amazon S3 in bothRegions. The solution should be as low-cost as possible.What should the company do to achieve this goal?

A. Use AWS DMS to migrate the AWS Glue Data Catalog from us-east-1 to us-west-2

B. Run the AWS Glue crawler in us-west-2 to catalog datasets in all Regions

C. Enable cross-Region replication for the S3 buckets in us-east-1 to replicate data in us-west-2

D. Update AWS Glue resource policies to provide us-east-1 AWS Glue Data Catalog access to us-west-2

View answer

Correct Answer: B

Question #46

An energy company collects voltage data in real time from sensors that are attached to buildings. The company wants to receive noti cations when a sequence of two voltage drops is detected within 10 minutes of a sudden voltage increase at the same building. All noti cations must be delivered as quickly as possible. The system must be highly available. The company needs a solution that will automatically scale when this monitoring feature is implemented in other cities. The noti cation system is subscribed to an Amazon Simple Noti cation Service (Amazon SNS) topic for remediation.Which solution will meet these requirements?

A. Create an Amazon Managed Streaming for Apache Kafka cluster to ingest the data

B. Create a REST-based web service by using Amazon API Gateway in front of an AWS Lambda function

C. Create an Amazon Kinesis Data Firehose delivery stream to capture the incoming sensor data

D. Create an Amazon Kinesis data stream to capture the incoming sensor data

View answer

Correct Answer: A

Question #47

A large ride-sharing company has thousands of drivers globally serving millions of unique customers every day. The company has decided to migrate an existing data mart to Amazon Redshift. The existing schema includes the following tables.A trips fact table for information on completed rides.A drivers dimension table for driver pro les.A customers fact table holding customer pro le information.The company analyzes trip details by date and destination to examine pro tability by region. The drivers data rarely changes. The customers data frequently changes.What table design provides optimal query performance?

A. Use DISTSTYLE KEY (destination) for the trips table and sort by date

B. Use DISTSTYLE EVEN for the trips table and sort by date

C. Use DISTSTYLE KEY (destination) for the trips table and sort by date

D. Use DISTSTYLE EVEN for the drivers table and sort by date

View answer

Correct Answer: C

Question #48

An energy company collects voltage data in real time from sensors that are attached to buildings. The company wants to receive noti cations when a sequence of two voltage drops is detected within 10 minutes of a sudden voltage increase at the same building. All noti cations must be delivered as quickly as possible. The system must be highly available. The company needs a solution that will automatically scale when this monitoring feature is implemented in other cities. The noti cation system is subscribed to an Amazon Simple Noti cation Service (Amazon SNS) topic for remediation.Which solution will meet these requirements?

A. Create an Amazon Managed Streaming for Apache Kafka cluster to ingest the data

B. Create a REST-based web service by using Amazon API Gateway in front of an AWS Lambda function

C. Create an Amazon Kinesis Data Firehose delivery stream to capture the incoming sensor data

D. Create an Amazon Kinesis data stream to capture the incoming sensor data

View answer

Correct Answer: A

Question #49

A company uses Amazon OpenSearch Service (Amazon Elasticsearch Service) to store and analyze its website clickstream data. The company ingests 1 TB ofdata daily using Amazon Kinesis Data Firehose and stores one day's worth of data in an Amazon ES cluster.The company has very slow query performance on the Amazon ES index and occasionally sees errors from Kinesis Data Firehose when attempting to write to theindex. The Amazon ES cluster has 10 nodes running a single index and 3 dedicated master nodes. Each data node has 1.5 TB of Amazon EBS storage attachedand the cluster is configured with 1,000 shards. Occasionally, JVMMemoryPressure errors are found in the cluster logs.Which solution will improve the performance of Amazon ES?

A. Increase the memory of the Amazon ES master nodes

B. Decrease the number of Amazon ES data nodes

C. Decrease the number of Amazon ES shards for the index

D. Increase the number of Amazon ES shards for the index

View answer

Correct Answer: C

Question #50

A company is planning to create a data lake in Amazon S3. The company wants to create tiered storage based on access patterns and cost objectives. The solution must include support for JDBC connections from legacy clients, metadata management that allows federation for access control, and batch-based ETL using PySpark and Scala. Operational management should be limited. Which combination of components can meet these requirements? (Choose three.)

A. AWS Glue Data Catalog for metadata management

B. Amazon EMR with Apache Spark for ETL

C. AWS Glue for Scala-based ETL

D. Amazon EMR with Apache Hive for JDBC clients

E. Amazon Athena for querying data in Amazon S3 using JDBC drivers

F. Amazon EMR with Apache Hive, using an Amazon RDS with MySQL-compatible backed metastore

View answer

Correct Answer: ACE

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now

Free AWS DAS-C01 Practice Questions & Answers 2026 Part1

View The Updated DAS-C01 Exam Questions

View The Updated AWS Exam Questions

View Answers after Submission

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE Get Now

Free AWS DAS-C01 Practice Questions & Answers 2026 Part1

View The Updated DAS-C01 Exam Questions

View The Updated AWS Exam Questions

View Answers after Submission

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now