DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

Free AWS DAS-C01 Practice Questions & Answers 2026 Part2

Are you preparing for the AWS DAS-C01 certification exam? SPOTO offers the AWS DAS-C01 Premium File; all questions are aligned with the latest exam content and come with expert-provided answers. Our question banks cover the latest question types, core concepts, and detailed explanations, helping you familiarize yourself with the exam format and difficulty level. Whether you are reviewing core concepts or simulating a real exam environment, these resources will rapidly boost your confidence and readiness.
For over two decades, SPOTO has successfully helped numerous IT professionals secure their ideal positions at Fortune 500 companies. Download now to start practicing efficiently and ensure a high score on the actual exam. Don't miss this opportunity to pass your certification exam with ease!
Take other online exams

Question #1
A software company hosts an application on AWS, and new features are released weekly. As part of the application testing process, a solution must be developed that analyzes logs from each Amazon EC2 instance to ensure that the application is working as expected after each deployment. The collection and analysis solution should be highly available with the ability to display new information with minimal delays. Which method should the company use to collect and analyze the logs?
A. Enable detailed monitoring on Amazon EC2, use Amazon CloudWatch agent to store logs in Amazon S3, and use Amazon Athena for fast, interactive log analytics
B. Use the Amazon Kinesis Producer Library (KPL) agent on Amazon EC2 to collect and send data to Kinesis Data Streams to further push the data to Amazon Elasticsearch Service and visualize using Amazon QuickSight
C. Use the Amazon Kinesis Producer Library (KPL) agent on Amazon EC2 to collect and send data to Kinesis Data Firehose to further push the data to Amazon Elasticsearch Service and Kibana
D. Use Amazon CloudWatch subscriptions to get access to a real - time feed of logs and have the logs delivered to Amazon Kinesis Data Streams to further push the data to Amazon Elasticsearch Service and Kibana
View answer
Correct Answer: D

View The Updated DAS-C01 Exam Questions

SPOTO Provides 100% Real DAS-C01 Exam Questions for You to Pass Your DAS-C01 Exam!

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 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 #4
A software company hosts an application on AWS, and new features are released weekly. As part of the application testing process, a solution must be developed that analyzes logs from each Amazon EC2 instance to ensure that the application is working as expected after each deployment. The collection and analysis solution should be highly available with the ability to display new information with minimal delays.Which method should the company use to collect and analyze the logs?
A. Enable detailed monitoring on Amazon EC2, use Amazon CloudWatch agent to store logs in Amazon S3, and use Amazon Athena for fast, interactive log analytics
B. Use the Amazon Kinesis Producer Library (KPL) agent on Amazon EC2 to collect and send data to Kinesis Data Streams to further push the data to Amazon OpenSearch Service (Amazon Elasticsearch Service) and visualize using Amazon QuickSight
C. Use the Amazon Kinesis Producer Library (KPL) agent on Amazon EC2 to collect and send data to Kinesis Data Firehose to further push the data to Amazon OpenSearch Service (Amazon Elasticsearch Service) and OpenSearch Dashboards (Kibana)
D. Use Amazon CloudWatch subscriptions to get access to a real-time feed of logs and have the logs delivered to Amazon Kinesis Data Streams to further push the data to Amazon OpenSearch Service (Amazon Elasticsearch Service) and OpenSearch Dashboards (Kibana)
View answer
Correct Answer: C
Question #5
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 #6
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 #7
A company has an application that ingests streaming data. The company needs to analyze this stream over a 5-minute timeframe to evaluate the stream for anomalies with Random Cut Forest (RCF) and summarize the current count of status codes. The source and summarized data should be persisted for future use.Which approach would enable the desired outcome while keeping data persistence costs low?
A. ngest the data stream with Amazon Kinesis Data Streams
B. ngest the data stream with Amazon Kinesis Data Firehose with a delivery frequency of 5 minutes or 1 MB into Amazon S3
C. ngest the data stream with Amazon Kinesis Data Streams
D. ngest the data stream with Amazon Kinesis Data Firehose with a delivery frequency of 1 minute or 1 MB in Amazon S3
View answer
Correct Answer: C
Question #8
A nancial services company needs to aggregate daily stock trade data from the exchanges into a data store. The company requires that data be streamed directly into the data store, but also occasionally allows data to be modi ed using SQL. The solution should integrate complex, analytic queries running with minimal latency. The solution must provide a business intelligence dashboard that enables viewing of the top contributors to anomalies in stock prices.Which solution meets the company's requirements?
A. Use Amazon Kinesis Data Firehose to stream data to Amazon S3
B. Use Amazon Kinesis Data Streams to stream data to Amazon Redshift
C. Use Amazon Kinesis Data Firehose to stream data to Amazon Redshift
D. Use Amazon Kinesis Data Streams to stream data to Amazon S3
View answer
Correct Answer: C
Question #9
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 #10
A company has a business unit uploading .csv les to an Amazon S3 bucket. The company's data platform team has set up an AWS Glue crawler to do discovery, and create tables and schemas. An AWS Glue job writes processed data from the created tables to an Amazon Redshift database. The AWS Glue job handles column mapping and creating the Amazon Redshift table appropriately. When the AWS Glue job is rerun for any reason in a day, duplicate records are introduced into the Amazon Redshift table.Which solution will update the Redshift table without duplicates when jobs are rerun?
A. Modify the AWS Glue job to copy the rows into a staging table
B. Load the previously inserted data into a MySQL database in the AWS Glue job
C. Use Apache Spark's DataFrame dropDuplicates() API to eliminate duplicates and then write the data to Amazon Redshift
D. Use the AWS Glue ResolveChoice built-in transform to select the most recent value of the column
View answer
Correct Answer: A
Question #11
A company needs to implement a solution to restrict the launch of new Amazon EMR clusters in public subnets. With the exception of SSH and HTTPS connections, no employee should be able to launch a new EMR cluster in a public subnet unless inbound traffic from the internet is blocked.
A. Turn on EMR block public access for an IAM user group
B. Turn on EMR block public access for the account
C. Add port 443 as an exception in the block public access configuration
D. Add port 22 as an exception in the block public access configuration
E. Create a private internal subnet
View answer
Correct Answer: DE
Question #12
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 #13
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 #14
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 #15
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 #16
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. 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 #17
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 #18
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 #19
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 #20
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 #21
A software company hosts an application on AWS, and new features are released weekly. As part of the application testing process, a solution must be developedthat analyzes logs from each Amazon EC2 instance to ensure that the application is working as expected after each deployment. The collection and analysissolution should be highly available with the ability to display new information with minimal delays.Which method should the company use to collect and analyze the logs?
A. Enable detailed monitoring on Amazon EC2, use Amazon CloudWatch agent to store logs in Amazon S3, and use Amazon Athena for fast, interactive log analytics
B. Use the Amazon Kinesis Producer Library (KPL) agent on Amazon EC2 to collect and send data to Kinesis Data Streams to further push the data to Amazon OpenSearch Service (Amazon Elasticsearch Service) and visualize using Amazon QuickSight
C. Use the Amazon Kinesis Producer Library (KPL) agent on Amazon EC2 to collect and send data to Kinesis Data Firehose to further push the data to Amazon OpenSearch Service (Amazon Elasticsearch Service) and OpenSearch Dashboards (Kibana)
D. Use Amazon CloudWatch subscriptions to get access to a real-time feed of logs and have the logs delivered to Amazon Kinesis Data Streams to further push the data to Amazon OpenSearch Service (Amazon Elasticsearch Service) and OpenSearch Dashboards (Kibana)
View answer
Correct Answer: D
Question #22
A streaming application is reading data from Amazon Kinesis Data Streams and immediately writing the data to an Amazon S3 bucket every 10 seconds. The application 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 les in Amazon S3 to form larger les
B. Increase the number of shards in Kinesis Data Streams
C. Add more memory and CPU capacity to the streaming application
D. Write the les to multiple S3 buckets
View answer
Correct Answer: A
Question #23
A company that produces network devices has millions of users. Data is collected from the devices on an hourly basis and stored in an Amazon S3 data lake.The company runs analyses on the last 24 hours of data ow logs for abnormality detection and to troubleshoot and resolve user issues. The company also analyzes historical logs dating back 2 years to discover patterns and look for improvement opportunities. The data ow logs contain many metrics, such as date, timestamp, source IP, and target IP. There are about 10 billion events every day.How should this data be stored for optimal performance?
A. In Apache ORC partitioned by date and sorted by source IP
B. In compressed
C. In Apache Parquet partitioned by source IP and sorted by date
D. In compressed nested JSON partitioned by source IP and sorted by date
View answer
Correct Answer: A
Question #24
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 #25
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 #26
A retail company has 15 stores across 6 cities in the United States. Once a month, the sales team requests a visualization in Amazon QuickSight that provides the ability to easily identify revenue trends across cities and stores. The visualization also helps identify outliers that need to be examined with further analysis.Which visual type in QuickSight meets the sales team's requirements?
A. eospatial chart
B. eat map
C. ree map
D. ine chart
View answer
Correct Answer: A
Question #27
A real estate company maintains data about all properties listed in a market. The company receives data about new property listings from vendors who upload the data daily as compressed files into Amazon S3. The company's leadership team wants to see the most up-to-date listings as soon as the data is uploaded to Amazon S3. The data analytics team must automate and orchestrate the data processing workflow of the listings to feed a dashboard. The team also must provide the ability to perform one-time queries and analytical reporting in a scalable manner.
A. Use Amazon EMR for processing incoming data
B. Use Amazon EMR for processing incoming data
C. Use AWS Glue for processing incoming data
D. Use AWS Glue for processing incoming data
View answer
Correct Answer: B
Question #28
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 #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 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 #31
A company's marketing team has asked for help in identifying a high performing long-term storage service for their data based on the following requirements:✑ The data size is approximately 32 TB uncompressed.✑ There is a low volume of single-row inserts each day.✑ There is a high volume of aggregation queries each day.✑ Multiple complex joins are performed.✑ The queries typically involve a small subset of the columns in a table.Which storage service will provide the MOST performant solution?
A. mazon Aurora MySQL
B. mazon Redshift
C. mazon Neptune
D. mazon Elasticsearch
View answer
Correct Answer: B
Question #32
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 #33
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 #34
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 #35
A technology company is creating a dashboard that will visualize and analyze time-sensitive data. The data will come in through Amazon Kinesis Data Firehose with the butter interval set to 60 seconds. The dashboard must support near-real-time data.Which visualization solution will meet these requirements?
A. elect Amazon OpenSearch Service (Amazon Elasticsearch Service) as the endpoint for Kinesis Data Firehose
B. elect Amazon S3 as the endpoint for Kinesis Data Firehose
C. elect Amazon Redshift as the endpoint for Kinesis Data Firehose
D. elect Amazon S3 as the endpoint for Kinesis Data Firehose
View answer
Correct Answer: A
Question #36
A company wants to improve the data load time of a sales data dashboard. Data has been collected as .csv files and stored within an Amazon S3 bucket that is partitioned by date. The data is then loaded to an Amazon Redshift data warehouse for frequent analysis. The data volume is up to 500 GB per day.Which solution will improve the data loading performance?
A. ompress
B. plit large
C. se Amazon Kinesis Data Firehose to ingest data into Amazon Redshift
D. oad the
View answer
Correct Answer: C
Question #37
A company uses Amazon Redshift for its data warehouse. The company is running an ET L process that receives data in data parts from five third-party providers. The data parts contain independent records that are related to one specific job. The company receives the data parts at various times throughout each day.A data analytics specialist must implement a solution that loads the data into Amazon Redshift only after the company receives all five data parts.Which solution will meet these requirements?
A. reate an Amazon S3 bucket to receive the data
B. reate an Amazon S3 bucket to receive the data
C. se an AWS Lambda function that is scheduled by cron to load the data into a temporary table in Amazon Redshift
D. reate an Amazon Kinesis Data Firehose delivery stream
View answer
Correct Answer: D
Question #38
A US-based sneaker retail company launched its global website. All the transaction data is stored in Amazon RDS and curated historic transaction data is stored in Amazon Redshift in the us-east-1 Region. The business intelligence (BI) team wants to enhance the user experience by providing a dashboard for sneaker trends.The BI team decides to use Amazon QuickSight to render the website dashboards. During development, a team in Japan provisioned Amazon QuickSight in ap- northeast-1. The team is having di culty connecting Amazon QuickSight from ap-northeast-1 to Amazon Redshift in us-east-1.Which solution will solve this issue and meet the requirements?
A. In the Amazon Redshift console, choose to con gure cross-Region snapshots and set the destination Region as ap-northeast-1
B. Create a VPC endpoint from the Amazon QuickSight VPC to the Amazon Redshift VPC so Amazon QuickSight can access data from Amazon Redshift
C. Create an Amazon Redshift endpoint connection string with Region information in the string and use this connection string in Amazon QuickSight to connect to Amazon Redshift
D. Create a new security group for Amazon Redshift in us-east-1 with an inbound rule authorizing access from the appropriate IP address range for the Amazon QuickSight servers in ap-northeast-1
View answer
Correct Answer: D
Question #39
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 #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 banking company is currently using an Amazon Redshift cluster with dense storage (DS) nodes to store sensitive data. An audit found that the cluster is unencrypted. Compliance requirements state that a database with sensitive data must be encrypted through a hardware security module (HSM) with automated key rotation.Which combination of steps is required to achieve compliance? (Choose two.)
A. Set up a trusted connection with HSM using a client and server certi cate with automatic key rotation
B. Modify the cluster with an HSM encryption option and automatic key rotation
C. Create a new HSM-encrypted Amazon Redshift cluster and migrate the data to the new cluster
D. Enable HSM with key rotation through the AWS CLI
E. Enable Elliptic Curve Di e-Hellman Ephemeral (ECDHE) encryption in the HSM
View answer
Correct Answer: AC
Question #42
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 #43
A real estate company has a mission-critical application using Apache HBase in Amazon EMR. Amazon EMR is con gured with a single master node. The company has over 5 TB of data stored on an Hadoop Distributed File System (HDFS). The company wants a cost-effective solution to make its HBase data highly available.Which architectural pattern meets company's requirements?
A. Use Spot Instances for core and task nodes and a Reserved Instance for the EMR master node
B. Store the data on an EMR File System (EMRFS) instead of HDFS
C. Store the data on an EMR File System (EMRFS) instead of HDFS and enable EMRFS consistent view
D. Store the data on an EMR File System (EMRFS) instead of HDFS and enable EMRFS consistent view
View answer
Correct Answer: D
Question #44
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 #45
A data analyst is using Amazon QuickSight for data visualization across multiple datasets generated by applications. Each application stores les within a separate Amazon S3 bucket. AWS Glue Data Catalog is used as a central catalog across all application data in Amazon S3. A new application stores its data within a separate S3 bucket. After updating the catalog to include the new application data source, the data analyst created a new Amazon QuickSight data source from an Amazon Athena table, but the import into SPICE failed.How should the data analyst resolve the issue?
A. Edit the permissions for the AWS Glue Data Catalog from within the Amazon QuickSight console
B. Edit the permissions for the new S3 bucket from within the Amazon QuickSight console
C. Edit the permissions for the AWS Glue Data Catalog from within the AWS Glue console
D. Edit the permissions for the new S3 bucket from within the S3 console
View answer
Correct Answer: B
Question #46
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 #47
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 #48
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 #49
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 #50
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.
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

View The Updated AWS Exam Questions

SPOTO Provides 100% Real AWS Exam Questions for You to Pass Your AWS Exam!

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:
Contact Us