Free AWS DAS-C01 Practice Questions & Answers 2026 Part4

Question #1

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

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

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

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

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

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

View answer

Correct Answer: A

Question #3

A financial company uses Amazon Athena to query data from an Amazon S3 data lake. Files are stored in the S3 data lake in Apache ORC format. Data analysts recently introduced nested fields in the data lake ORC files, and noticed that queries are taking longer to run in Athen a. A data analysts discovered that more data than what is required is being scanned for the queries.What is the MOST operationally efficient solution to improve query performance?

A. latten nested data and create separate files for each nested dataset

B. ecreate the data partition strategy and further narrow down the data filter criteria

C. se Apache Parquet format instead of ORC format

D. se the Athena query engine V2 and push the query filter to the source ORC file

View answer

Correct Answer: D

Question #4

A company uses Amazon EC2 instances to receive files from external vendors throughout each day. At the end of each day, the EC2 instances combine the files into a single file, perform gzip compression, and upload the single file to an Amazon S3 bucket. The total size of all the files is approximately 100 GB each day.When the files are uploaded to Amazon S3, an AWS Batch job runs a COPY command to load the files into an Amazon Redshift cluster.Which solution will MOST accelerate the COPY process?

A. ply sharding by breaking up the files so that the DISTKEY columns with the same values go to the same file

B. plit the files so that each file uses 50% of the free storage on each compute node in the Redshift cluster

C. plit the files so that the number of files is equal to a multiple of the number of slices in the Redshift cluster

D. pload the individual files to Amazon S3

View answer

Correct Answer: C

Question #5

A machinery company wants to collect data from sensors. A data analytics specialist needs to implement a solution that aggregates the data in near-real time and saves the data to a persistent data store. The data must be stored in nested JSON format and must be queried from the data store with a latency of single-digit milliseconds.Which solution will meet these requirements?

A. se Amazon Kinesis Data Firehose to receive the data from the sensors

B. se Amazon Kinesis Data Firehose to receive the data from the sensors

C. se Amazon Kinesis Data Streams to receive the data from the sensors

D. se Amazon Kinesis Data Firehose to receive the data from the sensors

View answer

Correct Answer: B

Question #6

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

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

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

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

A data analytics specialist is building an automated ETL ingestion pipeline using AWS Glue to ingest compressed files that have been uploaded to an Amazon S3 bucket. The ingestion pipeline should support incremental data processing.Which AWS Glue feature should the data analytics specialist use to meet this requirement?

A. riggers

B. orkflows

C. lassifiers

D. ob bookmarks

View answer

Correct Answer: D

Question #11

A bank is using Amazon Managed Streaming for Apache Kafka (Amazon MSK) to populate real-time data into a data lake The data lake is built on Amazon S3, and data must be accessible from the data lake within 24 hours Different microservices produce messages to different topics in the cluster The cluster is created with 8 TB of Amazon Elastic Block Store (Amazon EBS) storage and a retention period of 7 days The customer transaction volume has tripled recently and disk monitoring has provided an alert that the cluster is almost out of storage capacity What should a data analytics specialist do to prevent the cluster from running out of disk space1?

A. se the Amazon MSK console to triple the broker storage and restart the cluster

B. reate an Amazon CloudWatch alarm that monitors the KafkaDataLogsDiskUsed metric Automatically flush the oldest messages when the value of this metric exceeds 85%

C. riple the number of consumers to ensure that data is consumed as soon as it is added to a topic

D. reate a custom Amazon MSK configuration Set the log retention hours parameter to 48 Update the cluster with the new configuration file

View answer

Correct Answer: B

Question #12

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

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

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

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

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

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

B. esize the cluster using classic resize with dense compute nodes

C. esize the cluster using elastic resize with dense storage nodes

D. esize the cluster using classic resize with dense storage nodes

View answer

Correct Answer: C

Question #19

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

A company is providing analytics services to its sales and marketing departments. The departments can access the data only through their business intelligence (BI) tools, which run queries on Amazon Redshift using an Amazon Redshift internal user to connect. Each department is assigned a user in the Amazon Redshift database with the permissions needed for that department. The marketing data analysts must be granted direct access to the advertising table, which is stored in Apache Parquet format in the marketing S3 bucket of the company data lake. The company data lake is managed by AWS Lake Formation. Finally, access must be limited to the three promotion columns in the table.

A. Grant permissions in Amazon Redshift to allow the marketing Amazon Redshift user to access the three promotion columns of the advertising external table

B. Create an Amazon Redshift Spectrum IAM role with permissions for Lake Formation

C. Create an Amazon Redshift Spectrum IAM role with permissions for the marketing S3 bucket

D. Create an external schema in Amazon Redshift by using the Amazon Redshift Spectrum IAM role

E. Grant permissions in Lake Formation to allow the Amazon Redshift Spectrum role to access the three promotion columns of the advertising table

F. Grant permissions in Lake Formation to allow the marketing IAM group to access the three promotion columns of the advertising table

View answer

Correct Answer: BDE

Question #21

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

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

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

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

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

View answer

Correct Answer: B

Question #22

A 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 #23

A manufacturing company has been collecting IoT sensor data from devices on its factory floor for a year and is storing the data in Amazon Redshift for 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 officer (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. xecute 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

B. nload all the tables in Amazon Redshift to an Amazon S3 bucket using S3 Intelligent-Tiering

C. ake a snapshot of the Amazon Redshift cluster

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

View answer

Correct Answer: D

Question #24

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

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

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

An online retail company is migrating its reporting system to AWS. The company's legacy system runs data processing on online transactions using a complex series of nested Apache Hive queries. Transactional data is exported from the online system to the reporting system several times a day. Schemas in the files are stable between updates.

A. Create an AWS Glue Data Catalog to manage the Hive metadata

B. Create an AWS Glue Data Catalog to manage the Hive metadata

C. Create an Amazon Athena table with CREATE TABLE AS SELECT (CTAS) to ensure data is refreshed from underlying queries against the raw dataset

D. Use an S3 Select query to ensure that the data is properly updated

View answer

Correct Answer: A

Question #28

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

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

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

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

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

View answer

Correct Answer: B

Question #29

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

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

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

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

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

View answer

Correct Answer: B

Question #30

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

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

A company that monitors weather conditions from remote construction sites is setting up a solution to collect temperature data from the following two weather stations.✑ Station A, which has 10 sensors✑ Station B, which has five sensorsThese weather stations were placed by onsite subject-matter experts.Each sensor has a unique ID. The data collected from each sensor will be collected using Amazon Kinesis Data Streams.Based on the total incoming and outgoing data throughput, a single Amazon Kinesis data stream with two shards is created. Two partition keys are created based on the station names. During testing, there is a bottleneck on data coming from Station A, but not from Station B. Upon review, it is confirmed that the total stream throughput is still less than the allocated Kinesis Data Streams throughput.How can this bottleneck be resolved without increasing the overall cost and complexity of the solution, while retaining the data collection quality requirements?

A. ncrease the number of shards in Kinesis Data Streams to increase the level of parallelism

B. reate a separate Kinesis data stream for Station A with two shards, and stream Station A sensor data to the new stream

C. odify the partition key to use the sensor ID instead of the station name

D. educe the number of sensors in Station A from 10 to 5 sensors

View answer

Correct Answer: A

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

A real estate company has a mission - critical application using Apache HBase in Amazon EMR. Amazon EMR is configured 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 #35

A company is planning to do a proof of concept for a machine learning (ML) project using Amazon SageMaker with a subset of existing on- premises data hosted in the company's 3 TB data warehouse. For part of the project, AWS Direct Connect is established and tested. To prepare the data for ML, data analysts are performing data curation. The data analysts want to perform multiple step, including mapping, dropping null elds, resolving choice, and splitting elds. The company needs the fastest solution to curate the data for this project.Which solution meets these requirements?

A. Ingest data into Amazon S3 using AWS DataSync and use Apache Spark scrips to curate the data in an Amazon EMR cluster

B. Create custom ETL jobs on-premises to curate the data

C. Ingest data into Amazon S3 using AWS DMS

D. Take a full backup of the data store and ship the backup les using AWS Snowball

View answer

Correct Answer: C

Question #36

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

A. Increase the memory of the Amazon ES master nodes

B. Decrease the number of Amazon ES data nodes

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

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

View answer

Correct Answer: C

Question #37

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

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

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

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

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

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

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

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

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

View answer

Correct Answer: A

Question #42

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

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

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

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

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

View answer

Correct Answer: B

Question #43

A financial company uses Amazon S3 as its data lake and has set up a data warehouse using a multi-node Amazon Redshift cluster. The data files in the data lake are organized in folders based on the data source of each data file. All the data files are loaded to one table in the Amazon Redshift cluster using a separateCOPY command for each data file location. With this approach, loading all the data files into Amazon Redshift takes a long time to complete. Users want a faster solution with little or no increase in cost while maintaining the segregation of the data files in the S3 data lake.Which solution meets these requirements?

A. se Amazon EMR to copy all the data files into one folder and issue a COPY command to load the data into Amazon Redshift

B. oad all the data files in parallel to Amazon Aurora, and run an AWS Glue job to load the data into Amazon Redshift

C. se an AWS Glue job to copy all the data files into one folder and issue a COPY command to load the data into Amazon Redshift

D. reate a manifest file that contains the data file locations and issue a COPY command to load the data into Amazon Redshift

View answer

Correct Answer: A

Question #44

A company wants to ingest clickstream data from its website into an Amazon S3 bucket. The streaming data is in JSON format. The data in the S3 bucket must be partitioned by product_id.Which solution will meet these requirements MOST cost-effectively?

A. reate an Amazon Kinesis Data Firehose delivery stream to ingest the streaming data into the S3 bucket

B. reate an Amazon Kinesis Data Firehose delivery stream to ingest the streaming data into the S3 bucket

C. reate an Amazon Kinesis Data Firehose delivery stream to ingest the streaming data into the S3 bucket

D. reate an AWS Glue streaming job to partition the data by productjd before delivering the data to the S3 bucket

View answer

Correct Answer: A

Question #45

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

A real estate company has a mission-critical application using Apache HBase in Amazon EMR. Amazon EMR is configured 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. se Spot Instances for core and task nodes and a Reserved Instance for the EMR master node

B. tore the data on an EMR File System (EMRFS) instead of HDFS

C. tore the data on an EMR File System (EMRFS) instead of HDFS and enable EMRFS consistent view

D. tore the data on an EMR File System (EMRFS) instead of HDFS and enable EMRFS consistent view

View answer

Correct Answer: D

Question #47

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

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

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

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

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

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

View answer

Correct Answer: B

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

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

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

A manufacturing company uses Amazon S3 to store its data. The company wants to use AWS Lake Formation to provide granular-level security on those data assets. The data is in Apache Parquet format. The company has set a deadline for a consultant to build a data lake.How should the consultant create the MOST cost-effective solution that meets these requirements?

A. un Lake Formation blueprints to move the data to Lake Formation

B. nstall Apache Ranger on an Amazon EC2 instance and integrate with Amazon EMR

C. reate multiple IAM roles for different users and groups

D. o create the data catalog, run an AWS Glue crawler on the existing Parquet data

View answer

Correct Answer: A

Question #53

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

A company has a data warehouse in Amazon Redshift that is approximately 500 TB in size. New data is imported every few hours and read-only queries are run throughout the day and evening. There is a particularly heavy load with no writes for several hours each morning on business days. During those hours, some queries are queued and take a long time to execute. The company needs to optimize query execution and avoid any downtime.What is the MOST cost-effective solution?

A. nable concurrency scaling in the workload management (WLM) queue

B. dd more nodes using the AWS Management Console during peak hours

C. se elastic resize to quickly add nodes during peak times

D. se a snapshot, restore, and resize operation

View answer

Correct Answer: A

Question #55

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

A financial services company needs to aggregate daily stock trade data from the exchanges into a data store. The company requires that data be streameddirectly into the data store, but also occasionally allows data to be modified using SQL. The solution should integrate complex, analytic queries running withminimal 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: D

Question #57

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

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

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

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

Once a month, a company receives a 100 MB .csv file compressed with gzip. The file contains 50,000 property listing records and is stored in Amazon S3 Glacier.The company needs its data analyst to query a subset of the data for a specific vendor.What is the most cost-effective solution?

A. oad the data into Amazon S3 and query it with Amazon S3 Select

B. uery the data from Amazon S3 Glacier directly with Amazon Glacier Select

C. oad the data to Amazon S3 and query it with Amazon Athena

D. oad the data to Amazon S3 and query it with Amazon Redshift Spectrum

View answer

Correct Answer: C

Question #62

A company is planning to do a proof of concept for a machine learning (ML) project using Amazon SageMaker with a subset of existing on- premises data hosted in the company's 3 TB data warehouse. For part of the project, AWS Direct Connect is established and tested. To prepare the data for ML, data analysts are performing data curation. The data analysts want to perform multiple step, including mapping, dropping null elds, resolving choice, and splitting elds. The company needs the fastest solution to curate the data for this project.Which solution meets these requirements?

A. Ingest data into Amazon S3 using AWS DataSync and use Apache Spark scrips to curate the data in an Amazon EMR cluster

B. Create custom ETL jobs on-premises to curate the data

C. Ingest data into Amazon S3 using AWS DMS

D. Take a full backup of the data store and ship the backup les using AWS Snowball

View answer

Correct Answer: C

Question #63

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

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

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

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

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

View answer

Correct Answer: A

Question #64

A real estate company has a mission-critical application using Apache HBase in Amazon EMR. Amazon EMR is configured with a single master node. Thecompany 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 highlyavailable.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: C

Question #65

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

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

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

DON'T WANT TO MISS A THING?

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

Free AWS DAS-C01 Practice Questions & Answers 2026 Part4

View The Updated DAS-C01 Exam Questions

View The Updated AWS Exam Questions

View Answers after Submission

DON'T WANT TO MISS A THING?

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

Free AWS DAS-C01 Practice Questions & Answers 2026 Part4

View The Updated DAS-C01 Exam Questions

View The Updated AWS Exam Questions

View Answers after Submission

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