NEW QUESTION 1
A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a
database-1.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com endpoint listening on port 3306. The company’s Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logging a “could not connect to server: Connection times out” error message to Amazon CloudWatch Logs.
What is the cause of this error?

• A. The user name and password the application is using are incorrect.
• B. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.
• C. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
• D. The user name and password are correct, but the user is not authorized to use the DB instance.

Answer: C

NEW QUESTION 2
A gaming company has recently acquired a successful iOS game, which is particularly popular during theholiday season. The company has decided to add a leaderboard to the game that uses Amazon DynamoDB.The application load is expected to ramp up over the holiday season.
Which solution will meet these requirements at the lowest cost?

• A. DynamoDB Streams
• B. DynamoDB with DynamoDB Accelerator
• C. DynamoDB with on-demand capacity mode
• D. DynamoDB with provisioned capacity mode with Auto Scaling

Answer: C

NEW QUESTION 3
A Database Specialist is designing a new database infrastructure for a ride hailing application. The application data includes a ride tracking system that stores GPS coordinates for all rides. Real-time statistics and metadata lookups must be performed with high throughput and microsecond latency. The database should be fault tolerant with minimal operational overhead and development effort.
Which solution meets these requirements in the MOST efficient way?

• A. Use Amazon RDS for MySQL as the database and use Amazon ElastiCache
• B. Use Amazon DynamoDB as the database and use DynamoDB Accelerator
• C. Use Amazon Aurora MySQL as the database and use Aurora’s buffer cache
• D. Use Amazon DynamoDB as the database and use Amazon API Gateway

Answer: D

NEW QUESTION 4
A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.
Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

• A. Grant least privilege to groups, users, and roles
• B. Allow all users to restore a database from a backup that will reduce the overall downtime to restore thedatabase
• C. Enable multi-factor authentication for sensitive operations to access sensitive resources and APIoperations
• D. Use policy conditions to restrict access to selective IP addresses
• E. Use AccessList Controls policy type to restrict users for database instance deletion
• F. Enable AWS CloudTrail logging and Enhanced Monitoring

Answer: ACD

NEW QUESTION 5
An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application. The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts.
How should a Database Specialist address these requirements?

• A. Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
• B. Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into AmazonRedshift
• C. Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance
• D. Use DynamoDB Accelerator to offload the reads

Answer: B

NEW QUESTION 6
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL
Multi-AZ DB instance. Tests were run on the database after work hours, which generated additional database logs. The free storage of the RDS DB instance is low due to these additional logs.
What should the company do to address this space constraint issue?

• A. Log in to the host and run the rm $PGDATA/pg_logs/* command
• B. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to bedeleted
• C. Create a ticket with AWS Support to have the logs deleted
• D. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs

Answer: B

NEW QUESTION 7
A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The solution should also automate configuration changes across all Regions.
Which solution would meet these requirements and deploy the DynamoDB tables?

• A. Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
• B. Create an AWS CloudFormation template and deploy the template to all the Regions.
• C. Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
• D. Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-bystep guide for future deployments.

Answer: B

NEW QUESTION 8
An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
Update scores in real time whenever a player is playing the game.
Retrieve a player’s score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?

• A. Create a global secondary index with game_id as the partition key
• B. Create a global secondary index with user_id as the partition key
• C. Create a composite primary key with game_id as the partition key and user_id as the sort key
• D. Create a composite primary key with user_id as the partition key and game_id as the sort key

Answer: B

NEW QUESTION 9
A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load fata from Amazon S3 into the Neptune DB cluster using the Neptune bulk loader API. The Database Specialist receives the following error:
“Unable to connect to s3 endpoint. Provided source = s3://mybucket/graphdata/ and region = us-east-1. Please verify your S3 configuration.”
Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)

• A. Check that Amazon S3 has an IAM role granting read access to Neptune
• B. Check that an Amazon S3 VPC endpoint exists
• C. Check that a Neptune VPC endpoint exists
• D. Check that Amazon EC2 has an IAM role granting read access to Amazon S3
• E. Check that Neptune has an IAM role granting read access to Amazon S3

Answer: BD

NEW QUESTION 10
A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime using AWS DMS. A Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover. The migration must have minimal impact on the performance of the source database.
Which approach will MOST effectively meet these requirements?

• A. Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluste
• B. Verify the datatype of the columns.
• C. Use the table metrics of the AWS DMS task created for migrating the data to verify the statistics for the tables being migrated and to verify that the data definition language (DDL) statements are completed.
• D. Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigrationchecklist to make sure there are no issues with the conversion.
• E. Enable AWS DMS data validation on the task so the AWS DMS task compares the source and targetrecords, and reports any mismatches.

Answer: D

NEW QUESTION 11
A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost-effective and able to handle unpredictable application traffic.
What should a Database Specialist recommend for this user?

• A. Create an Amazon DynamoDB table with provisioned capacity mode
• B. Create an Amazon DocumentDB cluster
• C. Create an Amazon DynamoDB table with on-demand capacity mode
• D. Create an Amazon Aurora Serverless DB cluster

Answer: C

NEW QUESTION 12
A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective.
Which approach should the Database Specialist take?

• A. Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp).Rundata transformations in AWS Glu
• B. Load the data from the S3 bucket to the Aurora DB cluster.
• C. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball applianc
• D. Once theSnowball data is delivered to Amazon S3, create a new Aurora DB cluste
• E. Enable the S3 integration tomigrate the data directly from Amazon S3 to Amazon RDS.
• F. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during theschema migratio
• G. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
• H. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an AmazonEC2 instanc
• I. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to anAurora DB cluster.

Answer: D

NEW QUESTION 13
A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company’s main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.
Which solution meets these requirements?

• A. Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the apnortheast-1 Regio
• B. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cacheapplication data from the replica to generate the dashboards.
• C. Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1Regio
• D. Use Amazon QuickSight for displaying dashboard results.
• E. Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replicainstance in the ap-northeast-1 Regio
• F. Have the dashboard application read from the read replica.
• G. Use an Amazon Aurora global databas
• H. Deploy the writer instance in the us-east-1 Region and the replicain the ap-northeast-1 Regio
• I. Have the dashboard application read from the replica ap-northeast-1 Region.

Answer: D

NEW QUESTION 14
A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ DB instance. When using the AWS Management Console to conduct this task, the Database Specialist discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read replica cannot be created.
What is the most likely reason for this?

• A. The source DB instance has to be converted to Single-AZ first to create a read replica from it.
• B. Enhanced Monitoring is not enabled on the source DB instance.
• C. The minor MySQL version in the source DB instance does not support read replicas.
• D. Automated backups are not enabled on the source DB instance.

Answer: D

NEW QUESTION 15
A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will enable connections logging.
Which combination of steps should the Database Specialist take to meet the logging and retention requirements? (Choose two.)

• A. Update the log_connections parameter in the default parameter group
• B. Create a custom parameter group, update the log_connections parameter, and associate the parameterwith the DB instance
• C. Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to180 days
• D. Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180 days
• E. Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file

Answer: AE

NEW QUESTION 16
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup.
The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company.
Which solution will meet these requirements with minimal effort?

• A. Create an Amazon Cloudwatch Events rule with the operations that need to be tracked on Amazon RD
• B. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
• C. Create an AWS Lambda function to trigger on AWS CloudTrail API call
• D. Filter on specific RDS API calls and write the output to the tracking systems.
• E. Create RDS event subscription
• F. Have the tracking systems subscribe to specific RDS event system notifications.
• G. Write RDS logs to Amazon Kinesis Data Firehos
• H. Create an AWS Lambda function to act on theserules and write the output to the tracking systems.

Answer: C

NEW QUESTION 17
A retail company is about to migrate its online and mobile store to AWS. The company’s CEO has strategic plans to grow the brand globally. A Database Specialist has been challenged to provide predictable read and write database performance with minimal operational overhead.
What should the Database Specialist do to meet these requirements?

• A. Use Amazon DynamoDB global tables to synchronize transactions
• B. Use Amazon EMR to copy the orders table data across Regions
• C. Use Amazon Aurora Global Database to synchronize all transactions
• D. Use Amazon DynamoDB Streams to replicate all DynamoDB transactions and sync them

Answer: A

NEW QUESTION 18
A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:
ERROR: cloud not write block 7507718 of temporary file: No space left on device
What is the cause of this error and what should the Database Specialist do to resolve this issue?

• A. The scaling of Aurora storage cannot catch up with the data loadin
• B. The Database Specialist needs tomodify the workload to load the data slowly.
• C. The scaling of Aurora storage cannot catch up with the data loadin
• D. The Database Specialist needs toenable Aurora storage scaling.
• E. The local storage used to store temporary tables is ful
• F. The Database Specialist needs to scale up theinstance.
• G. The local storage used to store temporary tables is ful
• H. The Database Specialist needs to enable localstorage scaling.

Answer: C

NEW QUESTION 19
A gaming company is designing a mobile gaming app that will be accessed by many users across the globe. The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users.
Which solution meets these requirements?

• A. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling
• B. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
• C. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
• D. Use Amazon Neptune for storage

Answer: A

NEW QUESTION 20
An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to sub-second levels?

• A. Increase the size of the DB instance storage
• B. Change the underlying EBS storage type to General Purpose SSD (gp2)
• C. Disable EBS optimization on the DB instance
• D. Change the DB instance to an instance class with a higher maximum bandwidth

Answer: B

NEW QUESTION 21
......