Which solution meets these requirements?

2025-10-02
By:
In: MLS-C01
With: 1 Comment

A data engineer needs to provide a team of data scientists with the appropriate dataset to run machine learning training jobs.The data will be stored in Amazon S3.The data engineer is obtaining the data from an Amazon Redshift database and is using join queries to extract a single tabular dataset.A portion of the schema is as follows:TransactionTimestamp (Timestamp)CardName (Varchar)CardNo (Varchar)The data engineer must provide the data so that any row with a CardNo value of NULL is removed.Also, the TransactionTimestamp column must be separated into a TransactionDate column and a TransactionTime column.Finally, the CardName column must be renamed to NameOnCard.The data will be extracted on a monthly basis and will be loaded into an S3 bucket.The solution must minimize the effort that is needed to set up infrastructure for the ingestion and transformation.The solution also must be automated and must minimize the load on the Amazon Redshift cluster.Which solution meets these requirements?Read More →

Which configuration on AWS will meet these requirements?

2025-10-02
By:
In: DVA-C01
With: 1 Comment

A company is running a software-as-a-service (SaaS) application in its on-premises data center.The application architecture uses a frontend Apache web server to support many customer-specific websites.The Apache web server routes traffic to a different set of servers based on the domain name that is specified in the host header of the initial request.The company decides to move its architecture to AWS.A developer is moving the customer-specific backend servers onto Amazon EC2 instances.The developer must configure the EC2 instances in Auto Scaling groups for each customer and must register the instances in different target groups.The developer needs to replace the frontend Apache web server with an Elastic Load Balancing (ELB) load balancer.The developer also must forward queries for specific domain names to the appropriate target groups.Which configuration on AWS will meet these requirements?Read More →

Which solution will meet these requirements?

2025-10-02
By:
In: SCS-C01
With: 1 Comment

A security engineer is evaluating a company’s use of AWS Key Management Service (AWS KMS).The security engineer must implement a hybrid solution with two sets of keys to meet the following requirements:• Set 1: The company needs granular control over the keys so that the company can maintain a copy of the keys in the key management infrastructure and reimport the keys at any time.The company needs the ability to set the expiration period to 3 days for the keys.• Set 2: No restrictions exist regarding immediate key deletion.A waiting period of 14 days is acceptable for keys to be marked deleted.Which solution will meet these requirements?Read More →

Which of the following approaches meets the schedule with LEAST downtime?

2025-10-02
By:
In: SAP-C01
With: 1 Comment

A company has a 24 TB MySQL database in its on-premises data center that grows at the rate of 10 GB per day.The data center is connected to the company’sAWS infrastructure with a 50 Mbps VPN connection.The company is migrating the application and workload to AWS.The application code is already installed and tested on Amazon EC2.The company now needs to migrate the database and wants to go live on AWS within 3 weeks.Which of the following approaches meets the schedule with LEAST downtime?Read More →

Which deployment solution will meet these requirements?

2025-10-02
By:
In: DOP-C01
With: 1 Comment

A company has deployed an application on AWS Elastic Beanstalk by using an all-at-once deployment method.The deployment failed recently because of an application misconfiguration and resulted in significant downtime.To prevent such downtime in the future, a DevOps engineer needs to revise the deployment method while maintaining the application performance.The DevOps engineer must ensure that application versions are consistently configured across all instances without creating new environments.Which deployment solution will meet these requirements?Read More →

Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?

2025-10-02
By:
In: DBS-C01
With: 1 Comment

A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database.After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower.The company has narrowed down the cause of this issue to the database and not the application.Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?Read More →

Which storage option meets these requirements?

2025-10-02
By:
In: SAA-C02
With: 1 Comment

A solutions architect is using Amazon S3 to design the storage architecture of a new digital media application.The media files must be resilient to the loss of anAvailability Zone.Some files are accessed frequently while other files are rarely accessed in an unpredictable pattern.The solutions architect must minimize the costs of storing and retrieving the media files.Which storage option meets these requirements?Read More →