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 Part3

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 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

View The Updated DAS-C01 Exam Questions

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

Contact Us Get DAS-C01 Practice Test
Question #2
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 #3
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 #4
A company stores its sales and marketing data that includes personally identifiable information (PII) in Amazon S3. The company allows its analysts to launch their own Amazon EMR cluster and run analytics reports with the data. To meet compliance requirements, the company must ensure the data is not publicly accessible throughout this process. A data engineer has secured Amazon S3 but must ensure the individual EMR clusters created by the analysts are not exposed to the public internet.Which solution should the data engineer to meet this compliance requirement with LEAST amount of effort?
A. reate an EMR security configuration and ensure the security configuration is associated with the EMR clusters when they are created
B. heck the security group of the EMR clusters regularly to ensure it does not allow inbound traffic from IPv4 0
C. nable the block public access setting for Amazon EMR at the account level before any EMR cluster is created
D. se AWS WAF to block public internet access to the EMR clusters across the board
View answer
Correct Answer: B
Question #5
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 #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
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 #8
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 #9
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 #10
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 #11
A company analyzes its data in an Amazon Redshift data warehouse, which currently has a cluster of three dense storage nodes. Due to a recent business acquisition, the company needs to load an additional 4 TB of user data into Amazon Redshift. The engineering team will combine all the user data and apply complex calculations that require I/O intensive resources. The company needs to adjust the cluster's capacity to support the change in analytical and storage requirements.Which solution meets these requirements?
A. esize the cluster using elastic resize with dense storage nodes
B. esize the cluster using classic resize with dense compute nodes
C. esize the cluster using elastic resize with dense compute nodes
D. esize the cluster using classic resize with dense storage nodes
View answer
Correct Answer: A
Question #12
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 #13
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 #14
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 #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 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 #17
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 #18
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 #19
A financial 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 modified 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 #20
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 #21
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 #22
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 #23
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 #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 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 #27
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 #28
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 #29
An ecommerce company stores customer purchase data in Amazon RDS. The company wants a solution to store and analyze historical dat a. The most recent 6 months of data will be queried frequently for analytics workloads. This data is several terabytes large. Once a month, historical data for the last 5 years must be accessible and will be joined with the more recent data. The company wants to optimize performance and cost.Which storage solution will meet these requirements?
A. ncrementally copy data from Amazon RDS to Amazon S3
B. se an ETL tool to incrementally load the most recent 6 months of data into an Amazon Redshift cluster
C. ncrementally copy data from Amazon RDS to Amazon S3
D. reate a read replica of the RDS database to store the most recent 6 months of data
View answer
Correct Answer: A
Question #30
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 inAmazon 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. Unload the call center data from Amazon Redshift to Amazon S3 using an AWS Lambda function
B. Export the call center data from Amazon Redshift using a Python shell in AWS Glue
C. Create an external table using Amazon Redshift Spectrum for the call center data and perform the join with Amazon Redshift
D. Export the call center data from Amazon Redshift to Amazon EMR using Apache Sqoop
View answer
Correct Answer: C
Question #31
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 #32
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 #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
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 #36
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 #37
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 #38
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 #39
A company is building a data lake and needs to ingest data from a relational database that has time-series data. The company wants to use managed services to accomplish this. The process needs to be scheduled daily and bring incremental data only from the source into Amazon S3.What is the MOST cost-effective approach to meet these requirements?
A. se AWS Glue to connect to the data source using JDBC Drivers
B. se AWS Glue to connect to the data source using JDBC Drivers
C. se AWS Glue to connect to the data source using JDBC Drivers and ingest the entire dataset
D. se AWS Glue to connect to the data source using JDBC Drivers and ingest the full data
View answer
Correct Answer: B
Question #40
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 #41
A company has a business unit uploading .csv files 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 handlescolumn mapping and creating the Amazon Redshift table appropriately. When the AWS Glue job is rerun for any reason in a day, duplicate records are introducedinto 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: B
Question #42
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 #43
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.
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 #44
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 #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
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 #47
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 #48
An insurance company has raw data in JSON format that is sent without a predefined schedule through an Amazon Kinesis Data Firehose delivery stream to anAmazon S3 bucket. An AWS Glue crawler is scheduled to run every 8 hours to update the schema in the data catalog of the tables stored in the S3 bucket. Dataanalysts analyze the data using Apache Spark SQL on Amazon EMR set up with AWS Glue Data Catalog as the metastore. Data analysts say that, occasionally,the data they receive is stale. A data engineer needs to provide access to the most up-to-date data.Which solution meets these requirements?
A. Create an external schema based on the AWS Glue Data Catalog on the existing Amazon Redshift cluster to query new data in Amazon S3 with Amazon Redshift Spectrum
B. Use Amazon CloudWatch Events with the rate (1 hour) expression to execute the AWS Glue crawler every hour
C. Using the AWS CLI, modify the execution schedule of the AWS Glue crawler from 8 hours to 1 minute
D. Run the AWS Glue crawler from an AWS Lambda function triggered by an S3:ObjectCreated:* event notification on the S3 bucket
View answer
Correct Answer: A
Question #49
An insurance company has raw data in JSON format that is sent without a prede ned schedule through an Amazon Kinesis Data Firehose delivery stream to anAmazon S3 bucket. An AWS Glue crawler is scheduled to run every 8 hours to update the schema in the data catalog of the tables stored in the S3 bucket. Data analysts analyze the data using Apache Spark SQL on Amazon EMR set up with AWS Glue Data Catalog as the metastore. Data analysts say that, occasionally, the data they receive is stale. A data engineer needs to provide access to the most up-to-date data.Which solution meets these requirements?
A. Create an external schema based on the AWS Glue Data Catalog on the existing Amazon Redshift cluster to query new data in Amazon S3 with Amazon Redshift Spectrum
B. Use Amazon CloudWatch Events with the rate (1 hour) expression to execute the AWS Glue crawler every hour
C. Using the AWS CLI, modify the execution schedule of the AWS Glue crawler from 8 hours to 1 minute
D. Run the AWS Glue crawler from an AWS Lambda function triggered by an S3:ObjectCreated:* event noti cation on the S3 bucket
View answer
Correct Answer: D
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

View The Updated AWS Exam Questions

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

Get AWS Practice Test

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


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.