Pass Your Amazon Exam with AWS-Certified-Database-Specialty Exam Dumps (Updated 147 Questions)
AWS-Certified-Database-Specialty Exam Dumps - Amazon Practice Test Questions
How much AWS Certified Database - Specialty Cost
The cost of the AWS Certified Database - Specialty is $150. For more information related to exam price, please visit the official website AWS as the cost of exams may be subjected to vary county-wise.
NEW QUESTION 77
A database specialist is managing an application in the us-west-1 Region and wants to set up disaster recovery in the us-east-1 Region. The Amazon Aurora MySQL DB cluster needs an RPO of 1 minute and an RTO of 2 minutes.
Which approach meets these requirements with no negative performance impact?
- A. Create an Aurora Global Database.
- B. Enable asynchronous binlog replication.
- C. Copy Aurora incremental snapshots to the us-east-1 Region.
- D. Enable synchronous replication.
Answer: D
NEW QUESTION 78
A large ecommerce company uses Amazon DynamoDB to handle the transactions on its web portal. Traffic patterns throughout the year are usually stable; however, a large event is planned. The company knows that traffic will increase by up to 10 times the normal load over the 3-day event. When sale prices are published during the event, traffic will spike rapidly.
How should a Database Specialist ensure DynamoDB can handle the increased traffic?
- A. Allow burst capacity to handle the additional load
- B. Preprovision additional capacity for the known peaks and then reduce the capacity after the event
- C. Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic
- D. Ensure the table is always provisioned to meet peak needs
Answer: A
NEW QUESTION 79
A company is due for renewing its database license. The company wants to migrate its 80 TB transactional database system from on-premises to the AWS Cloud. The migration should incur the least possible downtime on the downstream database applications. The company's network infrastructure has limited network bandwidth that is shared with other applications.
Which solution should a database specialist use for a timely migration?
- A. Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Periodically perform incremental backups of the source database to be shipped in another Snowball Edge appliance to handle syncing change data capture (CDC) data from the source to the target database.
- B. Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Use AWS DMS to migrate change data capture (CDC) data from the source database to Amazon S3. Use a second AWS DMS task to migrate all the S3 data to the target database.
- C. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS SCT to handle syncing change data capture (CDC) data from the source to the target database.
- D. Use AWS DMS to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS DMS to handle syncing change data capture (CDC) data from the source to the target database.
Answer: C
NEW QUESTION 80
A company's Security department established new requirements that state internal users must connect to an existing Amazon RDS for SQL Server DB instance using their corporate Active Directory (AD) credentials. A Database Specialist must make the modifications needed to fulfill this requirement.
Which combination of actions should the Database Specialist take? (Choose three.)
- A. Modify the RDS SQL Server DB instance to use the directory for Windows authentication. Create appropriate new logins.
- B. Use the AWS Management Console to create an AWS Managed Microsoft AD. Create a trust relationship with the corporate AD.
- C. Use the AWS Management Console to create an AD Connector. Create a trust relationship with the corporate AD.
- D. Configure the AWS Managed Microsoft AD domain controller Security Group.
- E. Disable Transparent Data Encryption (TDE) on the RDS SQL Server DB instance.
- F. Stop the RDS SQL Server DB instance, modify it to use the directory for Windows authentication, and start it again. Create appropriate new logins.
Answer: A,B,D
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerWinAuth.html
NEW QUESTION 81
A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system. New compliance requirements specify that the database must be encrypted at rest.
Which action will meet these requirements?
- A. Create an encrypted read replica of the DB instance. Promote the read replica to a standalone instance.
- B. Create an encrypted copy of manual snapshot of the DB instance. Restore a new DB instance from the encrypted snapshot.
- C. Restore a DB instance from the most recent automated snapshot and enable encryption.
- D. Modify the DB instance and enable encryption.
Answer: C
NEW QUESTION 82
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 CloudFormation template and use a stack set to deploy the template to all the Regions.
- B. Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-bystep guide for future deployments.
- C. Create an AWS CloudFormation template and deploy the template to all the Regions.
- D. Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
Answer: C
NEW QUESTION 83
A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.
What is the MOST cost-effective action that should be taken to avoid downtime?
- A. Enable a read replicas and direct read traffic to it when Amazon RDS is down
- B. Enable an Amazon RDS for MySQL Multi-AZ configuration
- C. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
- D. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
Answer: A
NEW QUESTION 84
Developers have requested a new Amazon Redshift cluster so they can load new third-party marketing dat a. The new cluster is ready and the user credentials are given to the developers. The developers indicate that their copy jobs fail with the following error message:
"Amazon Invalid operation: S3ServiceException:Access Denied,Status 403,Error AccessDenied." The developers need to load this data soon, so a database specialist must act quickly to solve this issue.
What is the MOST secure solution?
- A. Create a new IAM user with access keys and a new role with read-only access to the Amazon S3 bucket. Add this role to the Amazon Redshift cluster. Change the copy job to use the access keys created.
- B. Create a new IAM role with read-only access to the Amazon S3 bucket and include the assume role action. Modify the Amazon Redshift cluster to add the IAM role.
- C. Create a new IAM role with read-only access to the Amazon S3 bucket with the assume role action. Add this role to the developer IAM user ID used for the copy job that ended with an error message.
- D. Create a new IAM role with the same user name as the Amazon Redshift developer user ID. Provide the IAM role with read-only access to Amazon S3 with the assume role action.
Answer: A
NEW QUESTION 85
A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB instance goes live.
What change should the Database Specialist make to enable the migration?
- A. Configure the on-premises application database to act as a source for an AWS DMS full load with ongoing change data capture (CDC)
- B. Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)
- C. Configure the AWS DMS replication instance to allow both full load and ongoing change data capture(CDC)
- D. Configure the AWS DMS connections to allow two-way communication to allow for ongoing change datacapture (CDC)
Answer: A
NEW QUESTION 86
A company developed an AWS CloudFormation template used to create all new Amazon DynamoDB tables in its AWS account. The template configures provisioned throughput capacity using hard-coded values. The company wants to change the template so that the tables it creates in the future have independently configurable read and write capacity units assigned.
Which solution will enable this change?
- A. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template.
ConfigureDynamoDB to provision throughput capacity using the stack's mappings. - B. Add values for two Number parameters, rcuCount and wcuCount, to the template. Replace the hard-codedvalues with calls to the Ref intrinsic function, referencing the new parameters.
- C. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template.
Replacethe hard-coded values with calls to the Ref intrinsic function, referencing the new parameters. - D. Add values for the rcuCount and wcuCount parameters as outputs of the template. Configure DynamoDBto provision throughput capacity using the stack outputs.
Answer: B
NEW QUESTION 87
A company uses Amazon DynamoDB as the data store for its ecommerce website. The website receives little to no traffic at night, and the majority of the traffic occurs during the day. The traffic growth during peak hours is gradual and predictable on a daily basis, but it can be orders of magnitude higher than during off-peak hours.
The company initially provisioned capacity based on its average volume during the day without accounting for the variability in traffic patterns. However, the website is experiencing a significant amount of throttling during peak hours. The company wants to reduce the amount of throttling while minimizing costs.
What should a database specialist do to meet these requirements?
- A. Use on-demand capacity.
- B. Use provisioned capacity. Set it to the capacity levels required for peak daytime throughput.
- C. Use provisioned capacity. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
- D. Use reserved capacity. Set it to the capacity levels required for peak daytime throughput.
Answer: A
NEW QUESTION 88
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.)
- A. Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
- B. Disable the publicly accessible setting.
- C. Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
- D. Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
- E. Connect to the DB instance using private IPs and a VPN.
- F. Move the DB instance to a private subnet using AWS DMS.
Answer: A,B,E
NEW QUESTION 89
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?
- A. Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature
- B. Enable the Amazon RDS for MySQL Backtrack feature
- C. Deploy multiple read replicas and have the team members make changes to separate replica instances
- D. Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot
Answer: C
NEW QUESTION 90
A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has restored the latest backup to a new table.
To prepare the new table with identical settings, which steps should be performed? (Choose two.)
- A. Re-create global secondary indexes in the new table
- B. Set the provisioned read and write capacity
- C. Define the TTL settings
- D. Encrypt the table from the AWS Management Console or use the update-table command
- E. Define IAM policies for access to the new table
Answer: A,B
NEW QUESTION 91
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 an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance
- B. Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into AmazonRedshift
- C. Use DynamoDB Accelerator to offload the reads
- D. Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
Answer: B
NEW QUESTION 92
A database specialist at a large multi-national financial company is in charge of designing the disaster recovery strategy for a highly available application that is in development. The application uses an Amazon DynamoDB table as its data store. The application requires a recovery time objective (RTO) of 1 minute and a recovery point objective (RPO) of 2 minutes.
Which operationally efficient disaster recovery strategy should the database specialist recommend for the DynamoDB table?
- A. Use a DynamoDB global table replica in another Region. Enable point-in-time recovery for both tables.
- B. Use a DynamoDB Accelerator table in another Region. Enable point-in-time recovery for the table.
- C. Create a DynamoDB stream that is processed by an AWS Lambda function that copies the data to a DynamoDB table in another Region.
- D. Create an AWS Backup plan and assign the DynamoDB table as a resource.
Answer: B
NEW QUESTION 93
A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?
- A. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
- B. Configure RDS Storage Auto Scaling.
- C. Configure RDS instance Auto Scaling.
- D. Modify the DB instance allocated storage to meet the forecasted requirements.
Answer: C
NEW QUESTION 94
A database specialist was alerted that a production Amazon RDS MariaDB instance with 100 GB of storage was out of space. In response, the database specialist modified the DB instance and added 50 GB of storage capacity. Three hours later, a new alert is generated due to a lack of free space on the same DB instance. The database specialist decides to modify the instance immediately to increase its storage capacity by 20 GB.
What will happen when the modification is submitted?
- A. The request will succeed only if the primary instance is in active status.
- B. The request will fail because this storage capacity is too large.
- C. The request will fail as the most recent modification was too soon.
- D. The request will succeed only if CPU utilization is less than 10%.
Answer: A
NEW QUESTION 95
......
It is advisable that the learners have to know the syllabus for the Amazon AWS Certified Database – Specialty certification exam to effectively prepare for it with ease. This test consists of 5 topics that are listed below:
- Management & Operations (18%)
The questions of this topic evaluate the test takers’ skills in determining maintenance processes and tasks as well as restore and backup strategies and managing the operational environment of the database solution.
- Workload-Specific Database Design (26%)
The first domain validates the students’ expertise in selecting correct database services for specific types of workloads & data, comparing the costs of database solutions, as well as designing a database solution for compliance, scalability & performance, and determining strategies for high availability & disaster recovery.
- Database Security (18%)
This part requires that the individuals know how to demonstrate their knowledge of evaluating auditing solutions, encrypting data in transit & at rest, determining access control as well as authentication mechanisms, and recognizing potential security vulnerability within the database solutions.
- Monitoring and Troubleshooting (18%)
This objective revolves around the applicants’ proficiency in determining and monitoring strategies, optimizing database performance, as well as troubleshooting & resolving common database issues.
- Deployment and Migration (20%)
Within the framework of this subject area, the candidates have to demonstrate their competence in deploying automate database solutions, executing & validating data migration, as well as determining data migration and data preparation strategies, among others.
New Real AWS-Certified-Database-Specialty Exam Dumps Questions: https://drive.google.com/open?id=17RksaTU6pSMFsn1jNcWO70W6OqABfkwH
Pass Your AWS-Certified-Database-Specialty Exam Easily with Accurate PDF Questions: https://www.examcollectionpass.com/Amazon/AWS-Certified-Database-Specialty-practice-exam-dumps.html