Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors
  1. Home
  2. Amazon
  3. AWS Certified Database - Specialty

Amazon AWS Certified Database - Specialty AWS Certified Database - Specialty Exam Questions in PDF

Free Amazon AWS Certified Database - Specialty Dumps Questions (page: 4)

AWS Certified Database - Specialty PDF — 359 Questions

A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple times a day when Developers make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to complete.
Multiple team members are working on the project, making it difficult to find the correct restore point for each mistake.
Which approach should the Database Specialist take to reduce downtime?

  1. Deploy multiple read replicas and have the team members make changes to separate replica instances
  2. Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot
  3. Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature
  4. Enable the Amazon RDS for MySQL Backtrack feature

Answer(s): C



A media company is using Amazon RDS for PostgreSQL to store user data. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Following a recent AWS Well- Architected Framework review, a Database Specialist was given new security requirements:

-Only certain on-premises corporate network IPs should connect to the DB instance.
-Connectivity is allowed from the corporate network only.

Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)

  1. Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
  2. Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
  3. Move the DB instance to a private subnet using AWS DMS.
  4. Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
  5. Disable the publicly accessible setting.
  6. Connect to the DB instance using private IPs and a VPN.

Answer(s): B,E,F



A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.

What should the Database Specialist do to meet these requirements?

  1. Restore a snapshot from the production cluster into test clusters
  2. Create logical dumps of the production cluster and restore them into new test clusters
  3. Use database cloning to create clones of the production cluster
  4. Add an additional read replica to the production cluster and use that node for testing

Answer(s): C



A company with branch offices in Portland, New York, and Singapore has a three-tier web application that leverages a shared database. The database runs on Amazon RDS for MySQL and is hosted in the us-west-2 Region. The application has a distributed front end deployed in the us-west-2, ap-southheast-1, and us-east-2 Regions.

This front end is used as a dashboard for Sales Managers in each branch office to see current sales statistics. There are complaints that the dashboard performs more slowly in the Singapore location than it does in Portland or New York. A solution is needed to provide consistent performance for all users in each location.

Which set of actions will meet these requirements?

  1. Take a snapshot of the instance in the us-west-2 Region. Create a new instance from the snapshot in the ap-southeast-1 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
  2. Create an RDS read replica in the ap-southeast-1 Region from the primary RDS DB instance in the us- west-2 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
  3. Create a new RDS instance in the ap-southeast-1 Region. Use AWS DMS and change data capture (CDC) to update the new instance in the ap-southeast-1 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
  4. Create an RDS read replica in the us-west-2 Region where the primary instance resides. Create a read replica in the ap-southeast-1 Region from the read replica located on the us-west-2 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.

Answer(s): B



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?

  1. Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluster. Verify the datatype of the columns.
  2. 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.
  3. Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigration checklist to make sure there are no issues with the conversion.
  4. Enable AWS DMS data validation on the task so the AWS DMS task compares the source and target records, and reports any mismatches.

Answer(s): D

Explanation:


Reference:

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating.html



A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL.

The Database Specialist wrote and executed a script to stop all the DB instances.
When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.

How should the Database Specialist edit the script to fix this issue?

  1. Stop the source instances before stopping their read replicas
  2. Delete each read replica before stopping its corresponding source instance
  3. Stop the read replicas before stopping their source instances
  4. Use the AWS CLI to stop each read replica and source instance at the same time

Answer(s): B



A global digital advertising company captures browsing metadata to contextually display relevant images, pages, and links to targeted users. A single page load can generate multiple events that need to be stored individually. The maximum size of an event is 200 KB and the average size is 10 KB. Each page load must query the user’s browsing history to provide targeting recommendations. The advertising company expects over 1 billion page visits per day from users in the United States, Europe, Hong Kong, and India. The structure of the metadata varies depending on the event. Additionally, the browsing metadata must be written and read with very low latency to ensure a good viewing experience for the users.

Which database solution meets these requirements?

  1. Amazon DocumentDB
  2. Amazon RDS Multi-AZ deployment
  3. Amazon DynamoDB global table
  4. Amazon Aurora Global Database

Answer(s): C

Explanation:


Reference:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GlobalTables.html



A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users.

How should the Database Specialist apply the parameter group change for the DB instance?

  1. Select the option to apply the change immediately
  2. Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
  3. Apply the change manually by rebooting the DB instance during the approved maintenance window
  4. Reboot the secondary Multi-AZ DB instance

Answer(s): C

Explanation:


Reference:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Troubleshooting.html



Viewing page 4 of 42

Share your comments for Amazon AWS Certified Database - Specialty exam with other users:

J
Jeya
9/13/2023 7:50:00 AM

its very useful

INDIA
T
Tracy
10/24/2023 6:28:00 AM

i mastered my skills and aced the comptia 220-1102 exam with a score of 920/1000. i give the credit to for my success.

Anonymous
J
James
8/17/2023 4:33:00 PM

real questions

UNITED STATES
A
Aderonke
10/23/2023 1:07:00 PM

very helpful assessments

UNITED KINGDOM
S
Simmi
8/24/2023 7:25:00 AM

hi there, i would like to get dumps for this exam

AUSTRALIA
J
johnson
10/24/2023 5:47:00 AM

i studied for the microsoft azure az-204 exam through it has 100% real questions available for practice along with various mock tests. i scored 900/1000.

GERMANY
M
Manas
9/9/2023 1:48:00 AM

please upload 1z0-1072-23 exam dups

UNITED STATES
S
SB
9/12/2023 5:15:00 AM

i was hoping if you could please share the pdf as i’m currently preparing to give the exam.

Anonymous
J
Jagjit
8/26/2023 5:01:00 PM

i am looking for oracle 1z0-116 exam

UNITED STATES
S
S Mallik
11/27/2023 12:32:00 AM

where we can get the answer to the questions

Anonymous
P
PiPi Li
12/12/2023 8:32:00 PM

nice questions

NETHERLANDS
D
Dan
8/10/2023 4:19:00 PM

question 129 is completely wrong.

UNITED STATES
G
gayathiri
7/6/2023 12:10:00 AM

i need dump

UNITED STATES
D
Deb
8/15/2023 8:28:00 PM

love the site.

UNITED STATES
M
Michelle
6/23/2023 4:08:00 AM

can you please upload it back?

Anonymous
A
Ajay
10/3/2023 12:17:00 PM

could you please re-upload this exam? thanks a lot!

Anonymous
H
him
9/30/2023 2:38:00 AM

great about shared quiz

Anonymous
S
San
11/14/2023 12:46:00 AM

goood helping

Anonymous
W
Wang
6/9/2022 10:05:00 PM

pay attention to questions. they are very tricky. i waould say about 80 to 85% of the questions are in this exam dump.

UNITED STATES
M
Mary
5/16/2023 4:50:00 AM

wish you would allow more free questions

Anonymous
T
thomas
9/12/2023 4:28:00 AM

great simulation

Anonymous
S
Sandhya
12/9/2023 12:57:00 AM

very g inood

Anonymous
A
Agathenta
12/16/2023 1:36:00 PM

q35 should be a

Anonymous
M
MD. SAIFUL ISLAM
6/22/2023 5:21:00 AM

sap c_ts450_2021

Anonymous
S
Satya
7/24/2023 3:18:00 AM

nice questions

UNITED STATES
S
sk
5/13/2023 2:10:00 AM

ecellent materil for unserstanding

INDIA
G
Gerard
6/29/2023 11:14:00 AM

good so far

Anonymous
L
Limbo
10/9/2023 3:08:00 AM

this is way too informative

BOTSWANA
T
Tejasree
8/26/2023 1:46:00 AM

very helpfull

UNITED STATES
Y
Yolostar Again
10/12/2023 3:02:00 PM

q.189 - answers are incorrect.

Anonymous
S
Shikha Bakra
9/10/2023 5:16:00 PM

awesome job in getting these questions

AUSTRALIA
K
Kevin
10/20/2023 2:01:00 AM

i cant find aws certified practitioner clf-c01 exam in aws website but i found aws certified practitioner clf-c02 exam. can everyone please verify the difference between the two clf-c01 and clf-c02? thank you

UNITED STATES
D
D Mario
6/19/2023 10:38:00 PM

grazie mille. i got a satisfactory mark in my exam test today because of this exam dumps. sorry for my english.

ITALY
B
Bharat Kumar Saraf
10/31/2023 4:36:00 AM

some of the answers are incorrect. need to be reviewed.

HONG KONG
AI Tutor 👋 I’m here to help!