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: 3)

AWS Certified Database - Specialty PDF — 359 Questions

A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The company requires fast responses for end-user queries when looking at data from the current year, and users must have access to the full 15-year dataset, when needed. This solution also needs to handle a fluctuating number incoming queries. Storage costs for the 100 TB of data must be kept low.

Which solution meets these requirements?

  1. Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storage. Provision enough instances to support high demand.
  2. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Provision enough instances to support high demand.
  3. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling.
  4. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Leverage Amazon Redshift elastic resize.

Answer(s): C



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?

  1. Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
  2. Create an AWS CloudFormation template and deploy the template to all the Regions.
  3. Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
  4. Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-by- step guide for future deployments.

Answer(s): C



A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation.

How can the Database Specialists accomplish this?

  1. Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
  2. Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
  3. Enable Amazon RDS Performance Insights and review the appropriate dashboard
  4. Enable Enhanced Monitoring will the appropriate settings

Answer(s): C



A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.

What should the company do to achieve this in the shortest amount of time?

  1. Use a blue-green deployment with a complete application-level failover test
  2. Use the RDS console to reboot the DB instance by choosing the option to reboot with failover
  3. Use RDS fault injection queries to simulate the primary node failure
  4. Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone

Answer(s): B

Explanation:


Reference:

https://wellarchitectedlabs.com/Reliability/300_Testing_for_Resiliency_of_EC2_RDS_and_S3/Lab_Guide.html



A company maintains several databases using Amazon RDS for MySQL and PostgreSQL. Each RDS database generates log files with retention periods set to their default values. The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and after- the-fact analyses.

What should a Database Specialist do to meet these requirements with minimal effort?

  1. Create an AWS Lambda function to pull logs from the RDS databases and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.
  2. Modify the RDS databases to publish log to Amazon CloudWatch Logs. Change the log retention policy for each log group to expire the events after 90 days.
  3. Write a stored procedure in each RDS database to download the logs and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.
  4. Create an AWS Lambda function to download the logs from the RDS databases and publish the logs to Amazon CloudWatch Logs. Change the log retention policy for the log group to expire the events after 90 days.

Answer(s): B



A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one medium- sized primary instance, one large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.

In the event of a primary failure, what will occur?

  1. Aurora will promote an Aurora Replica that is of the same size as the primary instance
  2. Aurora will promote an arbitrary Aurora Replica
  3. Aurora will promote the largest-sized Aurora Replica
  4. Aurora will not promote an Aurora Replica

Answer(s): C


Reference:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-ug.pdf



A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.

Which migration method should a Database Specialist use?

  1. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
  2. Make a backup of the RDS for MySQL DB instance using the my sql dump utility, create a new Aurora DB cluster, and restore the backup.
  3. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
  4. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

Answer(s): C


Reference:

https://d1.awsstatic.com/whitepapers/RDS/Migrating%20your%20databases%20to%20Amazon%20Aurora.pdf (10)



The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real- time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.
Which approach will meet these requirements?

  1. Use pg_audit to generate audit logs and send the logs to the Security team.
  2. Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
  3. Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.
  4. Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.

Answer(s): C


Reference:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-ug.pdf (525)



Viewing page 3 of 42

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

S
Smaranika
6/22/2023 8:42:00 AM

could you please upload the dumps of sap c_sac_2302

INDIA
B
Blessious Phiri
8/15/2023 1:56:00 PM

asm management configuration is about storage

Anonymous
L
Lewis
7/6/2023 8:49:00 PM

kool thumb up

UNITED STATES
M
Moreece
5/15/2023 8:44:00 AM

just passed the az-500 exam this last friday. most of the questions in this exam dumps are in the exam. i bought the full version and noticed some of the questions which were answered wrong in the free version are all corrected in the full version. this site is good but i wish the had it in an interactive version like a test engine simulator.

Anonymous
T
Terry
5/24/2023 4:41:00 PM

i can practice for exam

Anonymous
E
Emerys
7/29/2023 6:55:00 AM

please i need this exam.

Anonymous
G
Goni Mala
9/2/2023 12:27:00 PM

i need the dump

Anonymous
L
Lenny
9/29/2023 11:30:00 AM

i want it bad, even if cs6 maybe retired, i want to learn cs6

HONG KONG
M
MilfSlayer
12/28/2023 8:32:00 PM

i hate comptia with all my heart with their "choose the best" answer format as an argument could be made on every question. they say "the "comptia way", lmao no this right here boys is the comptia way 100%. take it from someone whos failed this exam twice but can configure an entire complex network that these are the questions that are on the test 100% no questions asked. the pbqs are dead on! nice work

Anonymous
S
Swati Raj
11/14/2023 6:28:00 AM

very good materials

UNITED STATES
K
Ko Htet
10/17/2023 1:28:00 AM

thanks for your support.

Anonymous
P
Philippe
1/22/2023 10:24:00 AM

iam impressed with the quality of these dumps. they questions and answers were easy to understand and the xengine app was very helpful to use.

CANADA
S
Sam
8/31/2023 10:32:00 AM

not bad but you question database from isaca

MALAYSIA
B
Brijesh kr
6/29/2023 4:07:00 AM

awesome contents

INDIA
J
JM
12/19/2023 1:22:00 PM

answer to 134 is casb. while data loss prevention is the goal, in order to implement dlp in cloud applications you need to deploy a casb.

UNITED STATES
N
Neo
7/26/2023 9:36:00 AM

are these brain dumps sufficient enough to go write exam after practicing them? or does one need more material this wont be enough?

SOUTH AFRICA
B
Bilal
8/22/2023 6:33:00 AM

i did attend the required cources and i need to be sure that i am ready to take the exam, i would ask you please to share the questions, to be sure that i am fit to proceed with taking the exam.

Anonymous
J
John
11/12/2023 8:48:00 PM

why only give explanations on some, and not all questions and their respective answers?

UNITED STATES
B
Biswa
11/20/2023 8:50:00 AM

refresh db knowledge

Anonymous
S
Shalini Sharma
10/17/2023 8:29:00 AM

interested for sap certification

JAPAN
E
ethan
9/24/2023 12:38:00 PM

could you please upload practice questions for scr exam ?

HONG KONG
V
vijay joshi
8/19/2023 3:15:00 AM

please upload free oracle cloud infrastructure 2023 foundations associate exam braindumps

Anonymous
A
Ayodele Talabi
8/25/2023 9:25:00 PM

sweating! they are tricky

CANADA
R
Romero
3/23/2022 4:20:00 PM

i never use these dumps sites but i had to do it for this exam as it is impossible to pass without using these question dumps.

UNITED STATES
J
John Kennedy
9/20/2023 3:33:00 AM

good practice and well sites.

Anonymous
N
Nenad
7/12/2022 11:05:00 PM

passed my first exam last week and pass the second exam this morning. thank you sir for all the help and these brian dumps.

INDIA
L
Lucky
10/31/2023 2:01:00 PM

does anyone who attended exam csa 8.8, can confirm these questions are really coming ? or these are just for practicing?

HONG KONG
P
Prateek
9/18/2023 11:13:00 AM

kindly share the dumps

UNITED STATES
I
Irfan
11/25/2023 1:26:00 AM

very nice content

Anonymous
P
php
6/16/2023 12:49:00 AM

passed today

Anonymous
D
Durga
6/23/2023 1:22:00 AM

hi can you please upload questions

Anonymous
J
JJ
5/28/2023 4:32:00 AM

please upload quetions

THAILAND
N
Norris
1/3/2023 8:06:00 PM

i passed my exam thanks to this braindumps questions. these questions are valid in us and i highly recommend it!

UNITED STATES
A
abuti
7/21/2023 6:10:00 PM

are they truely latest

Anonymous
AI Tutor 👋 I’m here to help!