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 DEA-C01 Practice Questions & Answers 2026 Part2

Are you preparing for the AWS DEA-C01 certification exam? SPOTO offers the AWS DEA-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 needs to build an extract, transform, and load (ETL) pipeline that has separate stages for batch data ingestion, transformation, and storage. The pipeline must store the transformed data in an Amazon S3 bucket. Each stage must automatically retry failures. The pipeline must provide visibility into the success or failure of individual stages.Which solution will meet these requirements with the LEAST operational overhead?
A. eploy AWS Step Functions workflows to orchestrate AWS Lambda functions that ingest data
B. uild an Amazon EventBridge-based pipeline that invokes AWS Lambda functions to perform each stage
C. chedule Apache Airflow directed acyclic graphs (DAGs) on Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to orchestrate pipeline steps
D. hain AWS Glue jobs that perform each stage together by using job triggers
View answer
Correct Answer: A
Question #2
A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)
A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB
B. Use a columnar storage file format
C. Partition the data based on the most common query predicates
D. Split the data into files that are less than 10 KB
E. Use file formats that are not splittable
View answer
Correct Answer: BC
Question #3
A company created an extract, transform, and load (ETL) data pipeline in AWS Glue. A data engineer must crawl a table that is in Microsoft SQL Server. The data engineer needs to extract, transform, and load the output of the crawl to an Amazon S3 bucket. The data engineer also must orchestrate the data pipeline.Which AWS service or feature will meet these requirements MOST cost-effectively?
A. AWS Step Functions
B. AWS Glue workflows
C. AWS Glue Studio
D. Amazon Managed Workflows for Apache Airflow (Amazon MWAA)
View answer
Correct Answer: B
Question #4
A data engineer is configuring an AWS Glue job to read data from an Amazon S3 bucket. The data engineer has set up the necessary AWS Glue connection details and an associated IAM role. However, when the data engineer attempts to run the AWS Glue job, the data engineer receives an error message that indicates that there are problems with the Amazon S3 VPC gateway endpoint.The data engineer must resolve the error and connect the AWS Glue job to the S3 bucket.Which solution will meet this requirement?
A. Update the AWS Glue security group to allow inbound traffic from the Amazon S3 VPC gateway endpoint
B. Configure an S3 bucket policy to explicitly grant the AWS Glue job permissions to access the S3 bucket
C. Review the AWS Glue job code to ensure that the AWS Glue connection details include a fully qualified domain name
D. Verify that the VPC's route table includes inbound and outbound routes for the Amazon S3 VPC gateway endpoint
View answer
Correct Answer: D
Question #5
A company stores datasets in JSON format and .csv format in an Amazon S3 bucket. The company has Amazon RDS for Microsoft SQL Server databases, Amazon DynamoDB tables that are in provisioned capacity mode, and an Amazon Redshift cluster. A data engineering team must develop a solution that will give data scientists the ability to query all data sources by using syntax similar to SQL.Which solution will meet these requirements with the LEAST operational overhead?
A. Use AWS Glue to crawl the data sources
B. Use AWS Glue to crawl the data sources
C. Use AWS Glue to crawl the data sources
D. Use AWS Lake Formation to create a data lake
View answer
Correct Answer: A
Question #6
A data engineer maintains custom Python scripts that perform a data formatting process that many AWS Lambda functions use. When the data engineer needs to modify the Python scripts, the data engineer must manually update all the Lambda functions. The data engineer requires a less manual way to update the Lambda functions. Which solution will meet this requirement?
A. Store a pointer to the custom Python scripts in the execution context object in a shared Amazon S3 bucket
B. Package the custom Python scripts into Lambda layers
C. Store a pointer to the custom Python scripts in environment variables in a shared Amazon S3 bucket
D. Assign the same alias to each Lambda function
View answer
Correct Answer: B
Question #7
A company stores customer transactions, product images, clickstream logs, and social media posts in a centralized repository. Which big data characteristic is primarily demonstrated?
A. Variety
B. Volume
C. Velocity
D. Value
View answer
Correct Answer: a
Question #8
A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)
A. Partition the data that is in the S3 bucket
B. Increase the AWS Glue instance size by scaling up the worker type
C. Convert the AWS Glue schema to the DynamicFrame schema class
D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day
E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features
View answer
Correct Answer: AB
Question #9
A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?
A. Use Kinesis Data Streams to stage data in Amazon S3
B. Access the data from Kinesis Data Streams by using SQL queries
C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object
D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose
View answer
Correct Answer: C
Question #10
A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)
A. Partition the data that is in the S3 bucket
B. Increase the AWS Glue instance size by scaling up the worker type
C. Convert the AWS Glue schema to the DynamicFrame schema class
D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day
E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features
View answer
Correct Answer: AB
Question #11
A telecommunications company collects network usage data throughout each day at a rate of several thousand data points each second. The company runs an application to process the usage data in real time. The company aggregates and stores the data in an Amazon Aurora DB instance.Sudden drops in network usage usually indicate a network outage. The company must be able to identify sudden drops in network usage so the company can take immediate remedial actions.Which solution will meet this requirement with the LEAST latency?
A. reate an AWS Lambda function within the Database Activity Streams feature of Aurora to detect drops in network usage
B. odify the processing application to publish the data to an Amazon Kinesis data stream
C. eplace the Aurora database with an Amazon DynamoDB table
D. reate an AWS Lambda function to query Aurora for drops in network usage
View answer
Correct Answer: B
Question #12
A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?
A. Use Kinesis Data Streams to stage data in Amazon S3
B. Access the data from Kinesis Data Streams by using SQL queries
C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object
D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose
View answer
Correct Answer: C
Question #13
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?
A. Use an Amazon EMR provisioned cluster to read from all sources
B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3
C. Use Amazon Athena Federated Query to join the data from all data sources
D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift
View answer
Correct Answer: C
Question #14
A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?
A. Write a custom extract, transform, and load (ETL) job in Python
B. Write an AWS Glue extract, transform, and load (ETL) job
C. Write a custom extract, transform, and load (ETL) job in Python
D. Write an AWS Glue extract, transform, and load (ETL) job
View answer
Correct Answer: B
Question #15
A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)
A. Partition the data that is in the S3 bucket
B. Increase the AWS Glue instance size by scaling up the worker type
C. Convert the AWS Glue schema to the DynamicFrame schema class
D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day
E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features
View answer
Correct Answer: AB
Question #16
A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)
A. Turn on the public access setting for the DB instance
B. Update the security group of the DB instance to allow only Lambda function invocations on the database port
C. Configure the Lambda function to run in the same subnet that the DB instance uses
D. Attach the same security group to the Lambda function and the DB instance
E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port
View answer
Correct Answer: CD
Question #17
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #18
A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)
A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB
B. Use a columnar storage file format
C. Partition the data based on the most common query predicates
D. Split the data into files that are less than 10 KB
E. Use file formats that are not splittable
View answer
Correct Answer: BC
Question #19
A company has five offices in different AWS Regions. Each office has its own human resources (HR) department that uses a unique IAM role. The company stores employee records in a data lake that is based on Amazon S3 storage.A data engineering team needs to limit access to the records. Each HR department should be able to access records for only employees who are within the HR department's Region.Which combination of steps should the data engineering team take to meet this requirement with the LEAST operational overhead? (Choose two.)
A. se data filters for each Region to register the S3 paths as data locations
B. egister the S3 path as an AWS Lake Formation location
C. odify the IAM roles of the HR departments to add a data filter for each department's Region
D. nable fine-grained access control in AWS Lake Formation
E. reate a separate S3 bucket for each Region
View answer
Correct Answer: BD
Question #20
A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?
A. Write a custom extract, transform, and load (ETL) job in Python
B. Write an AWS Glue extract, transform, and load (ETL) job
C. Write a custom extract, transform, and load (ETL) job in Python
D. Write an AWS Glue extract, transform, and load (ETL) job
View answer
Correct Answer: B
Question #21
A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)
A. Partition the data that is in the S3 bucket
B. Increase the AWS Glue instance size by scaling up the worker type
C. Convert the AWS Glue schema to the DynamicFrame schema class
D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day
E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features
View answer
Correct Answer: AB
Question #22
A data engineer must use AWS services to ingest a dataset into an Amazon S3 data lake. The data engineer profiles the dataset and discovers that the dataset contains personally identifiable information (PII). The data engineer must implement a solution to profile the dataset and obfuscate the PII.Which solution will meet this requirement with the LEAST operational effort?
A. Use an Amazon Kinesis Data Firehose delivery stream to process the dataset
B. Use the Detect PII transform in AWS Glue Studio to identify the PII
C. Use the Detect PII transform in AWS Glue Studio to identify the PII
D. Ingest the dataset into Amazon DynamoDB
View answer
Correct Answer: B
Question #23
Which use case would be BEST suited for the search optimization service?
A. nalysts who need to perform aggregates over high cardinality columns
B. usiness users who need fast response times using highly selective filters
C. ata Scientists who seek specific JOIN statements with large volumes of data
D. ata Engineers who create clustered tables with frequent reads against clustering keys
View answer
Correct Answer: B
Question #24
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?
A. Use an Amazon EMR provisioned cluster to read from all sources
B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3
C. Use Amazon Athena Federated Query to join the data from all data sources
D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift
View answer
Correct Answer: C
Question #25
A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)
A. Partition the data that is in the S3 bucket
B. Increase the AWS Glue instance size by scaling up the worker type
C. Convert the AWS Glue schema to the DynamicFrame schema class
D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day
E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features
View answer
Correct Answer: AB
Question #26
When processing large datasets using distributed computing frameworks, uneven distribution of data can lead to processing delays. What is this phenomenon commonly known as?
A. Data skew
B. Data partitioning
C. Data shuffling
D. Data fragmentation
View answer
Correct Answer: a
Question #27
A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?
A. Write a custom extract, transform, and load (ETL) job in Python
B. Write an AWS Glue extract, transform, and load (ETL) job
C. Write a custom extract, transform, and load (ETL) job in Python
D. Write an AWS Glue extract, transform, and load (ETL) job
View answer
Correct Answer: B
Question #28
A manufacturing company collects sensor data from its factory floor to monitor and enhance operational efficiency. The company uses Amazon Kinesis Data Streams to publish the data that the sensors collect to a data stream. Then Amazon Kinesis Data Firehose writes the data to an Amazon S3 bucket.The company needs to display a real-time view of operational efficiency on a large screen in the manufacturing facility.Which solution will meet these requirements with the LOWEST latency?
A. Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to process the sensor data
B. Configure the S3 bucket to send a notification to an AWS Lambda function when any new object is created
C. Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to process the sensor data
D. Use AWS Glue bookmarks to read sensor data from the S3 bucket in real time
View answer
Correct Answer: A
Question #29
A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)
A. Turn on the public access setting for the DB instance
B. Update the security group of the DB instance to allow only Lambda function invocations on the database port
C. Configure the Lambda function to run in the same subnet that the DB instance uses
D. Attach the same security group to the Lambda function and the DB instance
E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port
View answer
Correct Answer: CD
Question #30
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #31
A data engineer maintains custom Python scripts that perform a data formatting process that many AWS Lambda functions use. When the data engineer needs to modify the Python scripts, the data engineer must manually update all the Lambda functions.The data engineer requires a less manual way to update the Lambda functions.Which solution will meet this requirement?
A. Store a pointer to the custom Python scripts in the execution context object in a shared Amazon S3 bucket
B. Package the custom Python scripts into Lambda layers
C. Store a pointer to the custom Python scripts in environment variables in a shared Amazon S3 bucket
D. Assign the same alias to each Lambda function
View answer
Correct Answer: B
Question #32
A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?
A. Parallel state
B. Choice state
C. Map state
D. Wait state
View answer
Correct Answer: C
Question #33
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?
A. Use an Amazon EMR provisioned cluster to read from all sources
B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3
C. Use Amazon Athena Federated Query to join the data from all data sources
D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift
View answer
Correct Answer: C
Question #34
A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application.Which solution will meet these requirements with the LEAST operational overhead?
A. Establish WebSocket connections to Amazon Redshift
B. Use the Amazon Redshift Data API
C. Set up Java Database Connectivity (JDBC) connections to Amazon Redshift
D. Store frequently accessed data in Amazon S3
View answer
Correct Answer: B
Question #35
A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application.Which solution will meet these requirements with the LEAST operational overhead?
A. Establish WebSocket connections to Amazon Redshift
B. Use the Amazon Redshift Data API
C. Set up Java Database Connectivity (JDBC) connections to Amazon Redshift
D. Store frequently accessed data in Amazon S3
View answer
Correct Answer: B
Question #36
A company stores daily records of the financial performance of investment portfolios in .csv format in an Amazon S3 bucket. A data engineer uses AWS Glue crawlers to crawl the S3 data.The data engineer must make the S3 data accessible daily in the AWS Glue Data Catalog.Which solution will meet these requirements?
A. Create an IAM role that includes the AmazonS3FullAccess policy
B. Create an IAM role that includes the AWSGlueServiceRole policy
C. Create an IAM role that includes the AmazonS3FullAccess policy
D. Create an IAM role that includes the AWSGlueServiceRole policy
View answer
Correct Answer: B
Question #37
A data engineer runs Amazon Athena queries on data that is in an Amazon S3 bucket. The Athena queries use AWS Glue Data Catalog as a metadata table.The data engineer notices that the Athena query plans are experiencing a performance bottleneck. The data engineer determines that the cause of the performance bottleneck is the large number of partitions that are in the S3 bucket. The data engineer must resolve the performance bottleneck and reduce Athena query planning time.Which solutions will meet these requirements? (Choose two.)
A. reate an AWS Glue partition index
B. ucket the data based on a column that the data have in common in a WHERE clause of the user query
C. se Athena partition projection based on the S3 bucket prefix
D. ransform the data that is in the S3 bucket to Apache Parquet format
E. se the Amazon EMR S3DistCP utility to combine smaller objects in the S3 bucket into larger objects
View answer
Correct Answer: AC
Question #38
A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?
A. Parallel state
B. Choice state
C. Map state
D. Wait state
View answer
Correct Answer: C
Question #39
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #40
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #41
A company uses Amazon Athena for one-time queries against data that is in Amazon S3. The company has several use cases. The company must implement permission controls to separate query processes and access to query history among users, teams, and applications that are in the same AWS account.Which solution will meet these requirements?
A. Create an S3 bucket for each use case
B. Create an Athena workgroup for each use case
C. Create an IAM role for each use case
D. Create an AWS Glue Data Catalog resource policy that grants permissions to appropriate individual IAM users for each use case
View answer
Correct Answer: B
Question #42
A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)
A. Partition the data that is in the S3 bucket
B. Increase the AWS Glue instance size by scaling up the worker type
C. Convert the AWS Glue schema to the DynamicFrame schema class
D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day
E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features
View answer
Correct Answer: AB
Question #43
In data modeling, an entity-relationship diagram (ERD) is primarily used to:
A. Transform raw data into structured data
B. Illustrate relationships between entities
C. Store data in a physical location
D. Cleanse dirty data
View answer
Correct Answer: b
Question #44
A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)
A. Turn on the public access setting for the DB instance
B. Update the security group of the DB instance to allow only Lambda function invocations on the database port
C. Configure the Lambda function to run in the same subnet that the DB instance uses
D. Attach the same security group to the Lambda function and the DB instance
E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port
View answer
Correct Answer: CD
Question #45
A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)
A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB
B. Use a columnar storage file format
C. Partition the data based on the most common query predicates
D. Split the data into files that are less than 10 KB
E. Use file formats that are not splittable
View answer
Correct Answer: BC
Question #46
A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)
A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB
B. Use a columnar storage file format
C. Partition the data based on the most common query predicates
D. Split the data into files that are less than 10 KB
E. Use file formats that are not splittable
View answer
Correct Answer: BC
Question #47
A company uses AWS Glue Data Catalog to index data that is uploaded to an Amazon S3 bucket every day. The company uses a daily batch processes in an extract, transform, and load (ETL) pipeline to upload data from external sources into the S3 bucket.The company runs a daily report on the S3 data. Some days, the company runs the report before all the daily data has been uploaded to the S3 bucket. A data engineer must be able to send a message that identifies any incomplete data to an existing Amazon Simple Notification Service (Amazon SNS) topic.Which solution will meet this requirement with the LEAST operational overhead?
A. reate data quality checks for the source datasets that the daily reports use
B. reate AWS Lambda functions that run data quality queries on the columns data type and the presence of null values
C. reate data quality checks on the source datasets that the daily reports use
D. reate data quality checks on the source datasets that the daily reports use
View answer
Correct Answer: C
Question #48
A company maintains multiple extract, transform, and load (ETL) workflows that ingest data from the company's operational databases into an Amazon S3 based data lake. The ETL workflows use AWS Glue and Amazon EMR to process data.The company wants to improve the existing architecture to provide automated orchestration and to require minimal manual effort.Which solution will meet these requirements with the LEAST operational overhead?
A. AWS Glue workflows
B. AWS Step Functions tasks
C. AWS Lambda functions
D. Amazon Managed Workflows for Apache Airflow (Amazon MWAA) workflows
View answer
Correct Answer: B
Question #49
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #50
A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?
A. Write a custom extract, transform, and load (ETL) job in Python
B. Write an AWS Glue extract, transform, and load (ETL) job
C. Write a custom extract, transform, and load (ETL) job in Python
D. Write an AWS Glue extract, transform, and load (ETL) job
View answer
Correct Answer: B
Question #51
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?
A. Use an Amazon EMR provisioned cluster to read from all sources
B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3
C. Use Amazon Athena Federated Query to join the data from all data sources
D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift
View answer
Correct Answer: C
Question #52
A company currently stores all of its data in Amazon S3 by using the S3 Standard storage class.A data engineer examined data access patterns to identify trends. During the first 6 months, most data files are accessed several times each day. Between 6 months and 2 years, most data files are accessed once or twice each month. After 2 years, data files are accessed only once or twice each year.The data engineer needs to use an S3 Lifecycle policy to develop new data storage rules. The new storage solution must continue to provide high availability.Which solution will meet these requirements in the MOST cost-effective way?
A. Transition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months
B. Transition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months
C. Transition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months
D. Transition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months
View answer
Correct Answer: B
Question #53
A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?
A. Write a custom extract, transform, and load (ETL) job in Python
B. Write an AWS Glue extract, transform, and load (ETL) job
C. Write a custom extract, transform, and load (ETL) job in Python
D. Write an AWS Glue extract, transform, and load (ETL) job
View answer
Correct Answer: B
Question #54
A company uses an Amazon Redshift cluster that runs on RA3 nodes. The company wants to scale read and write capacity to meet demand. A data engineer needs to identify a solution that will turn on concurrency scaling.Which solution will meet this requirement?
A. Turn on concurrency scaling in workload management (WLM) for Redshift Serverless workgroups
B. Turn on concurrency scaling at the workload management (WLM) queue level in the Redshift cluster
C. Turn on concurrency scaling in the settings during the creation of any new Redshift cluster
D. Turn on concurrency scaling for the daily usage quota for the Redshift cluster
View answer
Correct Answer: B
Question #55
A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)
A. Turn on the public access setting for the DB instance
B. Update the security group of the DB instance to allow only Lambda function invocations on the database port
C. Configure the Lambda function to run in the same subnet that the DB instance uses
D. Attach the same security group to the Lambda function and the DB instance
E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port
View answer
Correct Answer: CD
Question #56
A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?
A. Parallel state
B. Choice state
C. Map state
D. Wait state
View answer
Correct Answer: C
Question #57
A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?
A. Use Kinesis Data Streams to stage data in Amazon S3
B. Access the data from Kinesis Data Streams by using SQL queries
C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object
D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose
View answer
Correct Answer: C
Question #58
What are characteristics of Snowpark Python packages? (Select THREE).Third-party packages can be registered as a dependency to the Snowpark session using the session,import () method.
A. ython packages can access any external endpoints
B. ython packages can only be loaded in a local environment
C. hird-party supported Python packages are locked down to prevent hitting
D. he SQL command DESCRIBE FUNCTION will list the imported Python packages of the Python User-Defined Function (UDF)
E. uerying information__schema
View answer
Correct Answer: ADE
Question #59
A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)
A. Turn on the public access setting for the DB instance
B. Update the security group of the DB instance to allow only Lambda function invocations on the database port
C. Configure the Lambda function to run in the same subnet that the DB instance uses
D. Attach the same security group to the Lambda function and the DB instance
E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port
View answer
Correct Answer: CD
Question #60
A company currently stores all of its data in Amazon S3 by using the S3 Standard storage class.A data engineer examined data access patterns to identify trends. During the first 6 months, most data files are accessed several times each day. Between 6 months and 2 years, most data files are accessed once or twice each month. After 2 years, data files are accessed only once or twice each year.The data engineer needs to use an S3 Lifecycle policy to develop new data storage rules. The new storage solution must continue to provide high availability.Which solution will meet these requirements in the MOST cost-effective way?
A. Transition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months
B. Transition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months
C. Transition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months
D. Transition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months
View answer
Correct Answer: B
Question #61
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #62
A Data Engineer is implementing a near real-time ingestion pipeline to toad data into Snowflakeusing the Snowflake Kafka connector. There will be three Kafka topics created.……snowflake objects are created automatically when the Kafka connector starts? (Select THREE)
A. ables
B. asks
C. ipes
D. nternal stages
E. xternal stages
F. aterialized views
View answer
Correct Answer: ACD
Question #63
A company currently stores all of its data in Amazon S3 by using the S3 Standard storage class.A data engineer examined data access patterns to identify trends. During the first 6 months, most data files are accessed several times each day. Between 6 months and 2 years, most data files are accessed once or twice each month. After 2 years, data files are accessed only once or twice each year.The data engineer needs to use an S3 Lifecycle policy to develop new data storage rules. The new storage solution must continue to provide high availability.Which solution will meet these requirements in the MOST cost-effective way?
A. Transition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months
B. Transition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months
C. Transition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months
D. Transition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months
View answer
Correct Answer: B
Question #64
A data engineer is configuring an AWS Glue job to read data from an Amazon S3 bucket. The data engineer has set up the necessary AWS Glue connection details and an associated IAM role. However, when the data engineer attempts to run the AWS Glue job, the data engineer receives an error message that indicates that there are problems with the Amazon S3 VPC gateway endpoint.The data engineer must resolve the error and connect the AWS Glue job to the S3 bucket.Which solution will meet this requirement?
A. Update the AWS Glue security group to allow inbound traffic from the Amazon S3 VPC gateway endpoint
B. Configure an S3 bucket policy to explicitly grant the AWS Glue job permissions to access the S3 bucket
C. Review the AWS Glue job code to ensure that the AWS Glue connection details include a fully qualified domain name
D. Verify that the VPC's route table includes inbound and outbound routes for the Amazon S3 VPC gateway endpoint
View answer
Correct Answer: D
Question #65
A company uses an Amazon QuickSight dashboard to monitor usage of one of the company's applications. The company uses AWS Glue jobs to process data for the dashboard. The company stores the data in a single Amazon S3 bucket. The company adds new data every day.A data engineer discovers that dashboard queries are becoming slower over time. The data engineer determines that the root cause of the slowing queries is long-running AWS Glue jobs.Which actions should the data engineer take to improve the performance of the AWS Glue jobs? (Choose two.)
A. Partition the data that is in the S3 bucket
B. Increase the AWS Glue instance size by scaling up the worker type
C. Convert the AWS Glue schema to the DynamicFrame schema class
D. Adjust AWS Glue job scheduling frequency so the jobs run half as many times each day
E. Modify the IAM role that grants access to AWS glue to grant access to all S3 features
View answer
Correct Answer: AB
Question #66
A data engineering team is using an Amazon Redshift data warehouse for operational reporting. The team wants to prevent performance issues that might result from long- running queries. A data engineer must choose a system table in Amazon Redshift to record anomalies when a query optimizer identifies conditions that might indicate performance issues.Which table views should the data engineer use to meet this requirement?
A. TL_USAGE_CONTROL
B. TL_ALERT_EVENT_LOG
C. TL_QUERY_METRICS
D. TL_PLAN_INFO
View answer
Correct Answer: B
Question #67
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?
A. Use an Amazon EMR provisioned cluster to read from all sources
B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3
C. Use Amazon Athena Federated Query to join the data from all data sources
D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift
View answer
Correct Answer: C
Question #68
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #69
A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?
A. Parallel state
B. Choice state
C. Map state
D. Wait state
View answer
Correct Answer: C
Question #70
A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)
A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB
B. Use a columnar storage file format
C. Partition the data based on the most common query predicates
D. Split the data into files that are less than 10 KB
E. Use file formats that are not splittable
View answer
Correct Answer: BC
Question #71
A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?
A. Use Kinesis Data Streams to stage data in Amazon S3
B. Access the data from Kinesis Data Streams by using SQL queries
C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object
D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose
View answer
Correct Answer: C
Question #72
A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?
A. Use Kinesis Data Streams to stage data in Amazon S3
B. Access the data from Kinesis Data Streams by using SQL queries
C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object
D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose
View answer
Correct Answer: C
Question #73
A financial company wants to implement a data mesh. The data mesh must support centralized data governance, data analysis, and data access control. The company has decided to use AWS Glue for data catalogs and extract, transform, and load (ETL) operations.Which combination of AWS services will implement a data mesh? (Choose two.)
A. Use Amazon Aurora for data storage
B. Use Amazon S3 for data storage
C. Use AWS Glue DataBrew for centralized data governance and access control
D. Use Amazon RDS for data storage
E. Use AWS Lake Formation for centralized data governance and access control
View answer
Correct Answer: BE
Question #74
Company DEF has a strict security policy that mandates that all data at rest in Amazon S3 must be encrypted. They want to ensure that the encryption keys are managed by AWS, but they also want the flexibility to change the encryption keys when required.Which of the following encryption methods best meets Company DEF's requirements?
A. Server-Side Encryption with Customer-Provided Keys (SSE-C)
B. Server-Side Encryption with Amazon S3 Managed Keys (SSE-S3)
C. Server-Side Encryption with AWS Key Management Service (SSE-KMS)
D. Client-Side Encryption with a client-side master key
View answer
Correct Answer: c
Question #75
A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)
A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB
B. Use a columnar storage file format
C. Partition the data based on the most common query predicates
D. Split the data into files that are less than 10 KB
E. Use file formats that are not splittable
View answer
Correct Answer: BC
Question #76
A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?
A. Write a custom extract, transform, and load (ETL) job in Python
B. Write an AWS Glue extract, transform, and load (ETL) job
C. Write a custom extract, transform, and load (ETL) job in Python
D. Write an AWS Glue extract, transform, and load (ETL) job
View answer
Correct Answer: B
Question #77
A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)
A. Turn on the public access setting for the DB instance
B. Update the security group of the DB instance to allow only Lambda function invocations on the database port
C. Configure the Lambda function to run in the same subnet that the DB instance uses
D. Attach the same security group to the Lambda function and the DB instance
E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port
View answer
Correct Answer: CD
Question #78
A data engineer needs Amazon Athena queries to finish faster. The data engineer notices that all the files the Athena queries use are currently stored in uncompressed .csv format. The data engineer also notices that users perform most queries by selecting a specific column.Which solution will MOST speed up the Athena query performance?
A. Change the data format from
B. Compress the
C. Change the data format from
D. Compress the
View answer
Correct Answer: C
Question #79
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #80
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #81
A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?
A. Use Kinesis Data Streams to stage data in Amazon S3
B. Access the data from Kinesis Data Streams by using SQL queries
C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object
D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose
View answer
Correct Answer: C
Question #82
A data engineer maintains custom Python scripts that perform a data formatting process that many AWS Lambda functions use. When the data engineer needs to modify the Python scripts, the data engineer must manually update all the Lambda functions.The data engineer requires a less manual way to update the Lambda functions.Which solution will meet this requirement?
A. Store a pointer to the custom Python scripts in the execution context object in a shared Amazon S3 bucket
B. Package the custom Python scripts into Lambda layers
C. Store a pointer to the custom Python scripts in environment variables in a shared Amazon S3 bucket
D. Assign the same alias to each Lambda function
View answer
Correct Answer: B
Question #83
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?
A. Use an Amazon EMR provisioned cluster to read from all sources
B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3
C. Use Amazon Athena Federated Query to join the data from all data sources
D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift
View answer
Correct Answer: C
Question #84
A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.Which actions will provide the FASTEST queries? (Choose two.)
A. Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB
B. Use a columnar storage file format
C. Partition the data based on the most common query predicates
D. Split the data into files that are less than 10 KB
E. Use file formats that are not splittable
View answer
Correct Answer: BC
Question #85
A company is planning to use a provisioned Amazon EMR cluster that runs Apache Spark jobs to perform big data analysis. The company requires high reliability. A big data team must follow best practices for running cost-optimized and long-running workloads on Amazon EMR. The team must find a solution that will maintain the company's current level of performance.Which combination of resources will meet these requirements MOST cost-effectively? (Choose two.)
A. Use Hadoop Distributed File System (HDFS) as a persistent data store
B. Use Amazon S3 as a persistent data store
C. Use x86-based instances for core nodes and task nodes
D. Use Graviton instances for core nodes and task nodes
E. Use Spot Instances for all primary nodes
View answer
Correct Answer: BD
Question #86
A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)
A. Turn on the public access setting for the DB instance
B. Update the security group of the DB instance to allow only Lambda function invocations on the database port
C. Configure the Lambda function to run in the same subnet that the DB instance uses
D. Attach the same security group to the Lambda function and the DB instance
E. Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port
View answer
Correct Answer: CD
Question #87
A data engineer is launching an Amazon EMR cluster. The data that the data engineer needs to load into the new cluster is currently in an Amazon S3 bucket. The data engineer needs to ensure that data is encrypted both at rest and in transit.The data that is in the S3 bucket is encrypted by an AWS Key Management Service (AWS KMS) key. The data engineer has an Amazon S3 path that has a Privacy Enhanced Mail (PEM) file.Which solution will meet these requirements?
A. Create an Amazon EMR security configuration
B. Create an Amazon EMR security configuration
C. Create an Amazon EMR security configuration
D. Create an Amazon EMR security configuration
View answer
Correct Answer: C
Question #88
A company is migrating its database servers from Amazon EC2 instances that run Microsoft SQL Server to Amazon RDS for Microsoft SQL Server DB instances. The company's analytics team must export large data elements every day until the migration is complete. The data elements are the result of SQL joins across multiple tables. The data must be in Apache Parquet format. The analytics team must store the data in Amazon S3.Which solution will meet these requirements in the MOST operationally efficient way?
A. reate a view in the EC2 instance-based SQL Server databases that contains the required data elements
B. chedule SQL Server Agent to run a daily SQL query that selects the desired data elements from the EC2 instance-based SQL Server databases
C. se a SQL query to create a view in the EC2 instance-based SQL Server databases that contains the required data elements
D. reate an AWS Lambda function that queries the EC2 instance-based databases by using Java Database Connectivity (JDBC)
View answer
Correct Answer: A
Question #89
A data engineer is configuring an AWS Glue job to read data from an Amazon S3 bucket. The data engineer has set up the necessary AWS Glue connection details and an associated IAM role. However, when the data engineer attempts to run the AWS Glue job, the data engineer receives an error message that indicates that there are problems with the Amazon S3 VPC gateway endpoint. The data engineer must resolve the error and connect the AWS Glue job to the S3 bucket. Which solution will meet this requirement?
A. Update the AWS Glue security group to allow inbound traffic from the Amazon S3 VPC gateway endpoint
B. Configure an S3 bucket policy to explicitly grant the AWS Glue job permissions to access the S3 bucket
C. Review the AWS Glue job code to ensure that the AWS Glue connection details include a fully qualified domain name
D. Verify that the VPC's route table includes inbound and outbound routes for the Amazon S3 VPC gateway endpoint
View answer
Correct Answer: D
Question #90
A data engineer needs to securely transfer 5 TB of data from an on-premises data center to an Amazon S3 bucket. Approximately 5% of the data changes every day. Updates to the data need to be regularly proliferated to the S3 bucket. The data includes files that are in multiple formats. The data engineer needs to automate the transfer process and must schedule the process to run periodically.Which AWS service should the data engineer use to transfer the data in the MOST operationally efficient way?
A. AWS DataSync
B. AWS Glue
C. AWS Direct Connect
D. Amazon S3 Transfer Acceleration
View answer
Correct Answer: A
Question #91
A company is migrating a legacy application to an Amazon S3 based data lake. A data engineer reviewed data that is associated with the legacy application. The data engineer found that the legacy data contained some duplicate information.The data engineer must identify and remove duplicate information from the legacy application data.Which solution will meet these requirements with the LEAST operational overhead?
A. Write a custom extract, transform, and load (ETL) job in Python
B. Write an AWS Glue extract, transform, and load (ETL) job
C. Write a custom extract, transform, and load (ETL) job in Python
D. Write an AWS Glue extract, transform, and load (ETL) job
View answer
Correct Answer: B
Question #92
A company uses an on-premises Microsoft SQL Server database to store financial transaction data. The company migrates the transaction data from the on-premises database to AWS at the end of each month. The company has noticed that the cost to migrate data from the on-premises database to an Amazon RDS for SQL Server database has increased recently.The company requires a cost-effective solution to migrate the data to AWS. The solution must cause minimal downtown for the applications that access the database.Which AWS service should the company use to meet these requirements?
A. AWS Lambda
B. AWS Database Migration Service (AWS DMS)
C. AWS Direct Connect
D. AWS DataSync
View answer
Correct Answer: B
Question #93
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?
A. Use an Amazon EMR provisioned cluster to read from all sources
B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3
C. Use Amazon Athena Federated Query to join the data from all data sources
D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift
View answer
Correct Answer: C
Question #94
A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?
A. Parallel state
B. Choice state
C. Map state
D. Wait state
View answer
Correct Answer: C
Question #95
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.Which solution will meet this requirement MOST cost-effectively?
A. Use an Amazon EMR provisioned cluster to read from all sources
B. Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3
C. Use Amazon Athena Federated Query to join the data from all data sources
D. Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift
View answer
Correct Answer: C
Question #96
The following chart represents the performance of a virtual warehouse over time:A Data Engineer notices that the warehouse is queueing queries The warehouse is size X-Small theminimum and maximum cluster counts are set to 1 the scaling policy is set to i and auto-suspend isset to 10 minutes.How can the performance be improved?
A. hange the cluster settings
B. ncrease the size of the warehouse
C. hange the scaling policy to economy
D. hange auto-suspend to a longer time frame
View answer
Correct Answer: B
Question #97
A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file.Which Step Functions state should the data engineer use to meet these requirements?
A. Parallel state
B. Choice state
C. Map state
D. Wait state
View answer
Correct Answer: C
Question #98
A company wants to implement real-time analytics capabilities. The company wants to use Amazon Kinesis Data Streams and Amazon Redshift to ingest and process streaming data at the rate of several gigabytes per second. The company wants to derive near real-time insights by using existing business intelligence (BI) and analytics tools.Which solution will meet these requirements with the LEAST operational overhead?
A. Use Kinesis Data Streams to stage data in Amazon S3
B. Access the data from Kinesis Data Streams by using SQL queries
C. Create an external schema in Amazon Redshift to map the data from Kinesis Data Streams to an Amazon Redshift object
D. Connect Kinesis Data Streams to Amazon Kinesis Data Firehose
View answer
Correct Answer: C
Question #99
What is the main purpose of separating development, testing, and production environments for batch jobs?
A. To remove the need for job scheduling
B. To make production data unavailable to all authorized users
C. To reduce the risk of untested changes affecting production data
D. To prevent batch jobs from using source data
View answer
Correct Answer: c
Question #100
A company is planning to upgrade its Amazon Elastic Block Store (Amazon EBS) General Purpose SSD storage from gp2 to gp3. The company wants to prevent any interruptions in its Amazon EC2 instances that will cause data loss during the migration to the upgraded storage. Which solution will meet these requirements with the LEAST operational overhead? Changing the volume type of the existing gp2 volumes to gp3 is the easiest and fastest way to migrate to the new storage type without any downtime or data loss. You can use the AWS Management Console, the AWS CLI, or the Amazon EC2 API to modify the volume type, size, IOPS, and throughput of your gp2 volumes. The modification takes effect immediately, and you can monitor the progress of the modification using CloudWatch. The other options are either more complex or require additional steps, such as creating snapshots, transferring data, or attaching new volumes, which can increase the operational overhead and the risk of errors.Reference: Migrating Amazon EBS volumes from gp2 to gp3 and save up to 20% on costs(Section: How to migrate from gp2 to gp3) Switching from gp2 Volumes to gp3 Volumes to Lower AWS EBS Costs(Section: How to Switch from GP2 Volumes to GP3 Volumes) Modifying the volume type, IOPS, or size of an EBS volume - Amazon Elastic Compute Cloud(Section: Modifying the volume type)
A. Create snapshots of the gp2 volumes
B. Create new gp3 volumes
C. Change the volume type of the existing gp2 volumes to gp3
D. Use AWS DataSync to create new gp3 volumes
View answer
Correct Answer: C

View The Updated AWS Exam Questions

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

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.