[Mar-2022] AWS-Certified-Database-Specialty Dumps With 100% Verified Q&As - Pass Guarantee or Full Refund
Pass Amazon AWS-Certified-Database-Specialty Exam With Practice Test Questions Dumps Bundle
AWS Database Specialty Exam Syllabus Topics:
| Section | Objectives |
|---|---|
Workload-Specific Database Design - 26% | |
| Select appropriate database services for specific types of data and workloads. | - Differentiate between ACID vs. BASE workloads - Explain appropriate uses of types of databases (e.g., relational, key-value, document, in-memory, graph, time series, ledger) - Identify use cases for persisted data vs. ephemeral data |
| Determine strategies for disaster recovery and high availability. | - Select Region and Availability Zone placement to optimize database performance - Determine implications of Regions and Availability Zones on disaster recovery/high availability strategies - Differentiate use cases for read replicas and Multi-AZ deployments |
| Design database solutions for performance, compliance, and scalability. | - Recommend serverless vs. instance-based database architecture - Evaluate requirements for scaling read replicas - Define database caching solutions - Evaluate the implications of partitioning, sharding, and indexing - Determine appropriate instance types and storage options - Determine auto-scaling capabilities for relational and NoSQL databases - Determine the implications of Amazon DynamoDB adaptive capacity - Determine data locality based on compliance requirements |
| Compare the costs of database solutions. | - Determine cost implications of Amazon DynamoDB capacity units, including on-demand vs. provisioned capacity - Determine costs associated with instance types and automatic scaling - Design for costs including high availability, backups, multi-Region, Multi-AZ, and storage type options - Compare data access costs |
Deployment and Migration - 20% | |
| Automate database solution deployments. | - Evaluate application requirements to determine components to deploy - Choose appropriate deployment tools and services (e.g., AWS CloudFormation, AWS CLI) |
| Determine data preparation and migration strategies. | - Determine the data migration method (e.g., snapshots, replication, restore) - Evaluate database migration tools and services (e.g., AWS DMS, native database tools) - Prepare data sources and targets - Determine schema conversion methods (e.g., AWS Schema Conversion Tool) - Determine heterogeneous vs. homogeneous migration strategies |
| Execute and validate data migration. | - Design and script data migration - Run data extraction and migration scripts - Verify the successful load of data |
Management and Operations - 18% | |
Pattern of DBS-C01 Exam
Amazon exams consist of two types of questions: multiple choice and multiple response. According to the vendor, the multiple choice items have one correct variant while multiple response questions have more than one right answer out of 5 or more options. Be careful while choosing the accurate one because there will be many distractors.
To complete the tasks appearing in DBS-C01, the candidates will have 180 minutes. To register for the test, they should pay $300 (practice exam: $40). The AWS Certified Database Specialty exam is scored from 100-1000 marks, and to pass it, one should get at least 750. This score indicates your overall performance in the test, and there will be a detailed report that gives general feedback and highlights your strengths and weaknesses so you can improve them later.
Note that some unscored questions are also presented in the exam and these questions don't affect your results. They just serve the purpose of collecting statistical information.
NEW QUESTION 10
A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues. A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created. The database specialist must effectively apply this new partition key to all existing and new data.
How can this solution be implemented?
- A. Use AWS DMS to copy the data from the current DynamoDB table to Amazon S3. Then import the DynamoDB table to create a new DynamoDB table with the new partition key.
- B. Use the AWS CLI to update the DynamoDB table and modify the partition key.
- C. Use the AWS CLI to back up the DynamoDB table. Then use the restore-table-from-backup command and modify the partition key.
- D. Use Amazon EMR to export the data from the current DynamoDB table to Amazon S3. Then use Amazon EMR again to import the data from Amazon S3 into a new DynamoDB table with the new partition key.
Answer: C
NEW QUESTION 11
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 DynamoDB Accelerator to offload the reads
- 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 AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
Answer: B
NEW QUESTION 12
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?
- A. 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.
- B. 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.
- C. Create an RDS read replica in the ap-southeast-1 Region from the primary RDS DB instance in the uswest- 2 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
- D. 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.
Answer: D
NEW QUESTION 13
An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora.
Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?
- A. Provision a clone of the existing DB cluster for the new Application team.
- B. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoingreplication using AWS DMS change data capture (CDC).
- C. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPUconsumption.
- D. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
Answer: D
NEW QUESTION 14
A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To meet the company's disaster recovery policies, the database backup needs to be copied into another Region. The company requires the solution to be cost-effective and operationally efficient.
What should a Database Specialist do to copy the database backup into a different Region?
- A. Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region
- B. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication to copy the snapshot into another Region
- C. Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region
- D. Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot of the read replica
Answer: D
NEW QUESTION 15
An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Auror a. Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?
- A. Provision a clone of the existing DB cluster for the new Application team.
- B. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
- C. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
- D. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.
Answer: B
NEW QUESTION 16
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. Restore a DB instance from the most recent automated snapshot and enable encryption.
- B. Create an encrypted read replica of the DB instance. Promote the read replica to a standalone instance.
- C. Create an encrypted copy of manual snapshot of the DB instance. Restore a new DB instance from the encrypted snapshot.
- D. Modify the DB instance and enable encryption.
Answer: A
NEW QUESTION 17
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. Set an AWS Application Auto Scaling policy for the table to handle the increase in traffic
- B. Preprovision additional capacity for the known peaks and then reduce the capacity after the event
- C. Ensure the table is always provisioned to meet peak needs
- D. Allow burst capacity to handle the additional load
Answer: D
NEW QUESTION 18
A small startup company is looking to migrate a 4 TB on-premises MySQL database to AWS using an Amazon RDS for MySQL DB instance.
Which strategy would allow for a successful migration with the LEAST amount of downtime?
- A. Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data center. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance utilizing the MySQL utilities running on an Amazon EC2 instance. Immediately point the application to the DB instance.
- B. Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data center. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance using the MySQL utilities running on an Amazon EC2 instance. Establish replication into the new DB instance using MySQL replication. Stop application access to the on-premises MySQL server and let the remaining transactions replicate over. Point the application to the DB instance.
- C. Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into the EC2 instance and restore it into the EC2 MySQL instance. Use AWS DMS to migrate data into a new RDS for MySQL DB instance. Point the application to the DB instance.
- D. Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into an Amazon S3 bucket and import the snapshot into a new RDS for MySQL DB instance using the MySQL utilities running on an EC2 instance. Point the application to the DB instance.
Answer: C
NEW QUESTION 19
A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts. Post-migration, the company purged unwanted data from the instance. The company now want to downsize storage to save money. The solution must have the least impact on production and near-zero downtime.
Which solution would meet these requirements?
- A. Create a snapshot of the old databases and restore the snapshot with the required storage
- B. Create a new database using native backup and restore
- C. Create a new read replica and make it the primary by terminating the existing primary
- D. Create a new RDS DB instance with the required storage and move the databases from the old instances to the new instance using AWS DMS
Answer: D
Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/rds-db-storage-size/ Use AWS Database Migration Service (AWS DMS) for minimal downtime.
NEW QUESTION 20
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 local storage used to store temporary tables is full. The Database Specialist needs to scale up theinstance.
- B. The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs toenable Aurora storage scaling.
- C. The local storage used to store temporary tables is full. The Database Specialist needs to enable localstorage scaling.
- D. The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs tomodify the workload to load the data slowly.
Answer: A
NEW QUESTION 21
A database specialist deployed an Amazon RDS DB instance in Dev-VPC1 used by their development team. Dev-VPC1 has a peering connection with Dev-VPC2 that belongs to a different development team in the same department. The networking team confirmed that the routing between VPCs is correct; however, the database engineers in Dev-VPC2 are getting a timeout connections error when trying to connect to the database in Dev- VPC1.
What is likely causing the timeouts?
- A. The database is deployed in a VPC that is in a different Region.
- B. The database is deployed in a VPC that is in a different Availability Zone.
- C. The database is deployed with the wrong client connect timeout configuration.
- D. The database is deployed with misconfigured security groups.
Answer: D
NEW QUESTION 22
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. Set the provisioned read and write capacity
- B. Re-create global secondary indexes in the new table
- 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 23
A company developed a new application that is deployed on Amazon EC2 instances behind an Application Load Balancer. The EC2 instances use the security group named sg-application-servers. The company needs a database to store the data from the application and decides to use an Amazon RDS for MySQL DB instance. The DB instance is deployed in private DB subnet.
What is the MOST restrictive configuration for the DB instance security group?
- A. Only allow incoming traffic from the subnet of the application servers on port 443.
- B. Only allow incoming traffic from the subnet of the application servers on port 3306.
- C. Only allow incoming traffic from the sg-application-servers security group on port 3306.
- D. Only allow incoming traffic from the sg-application-servers security group on port 443.
Answer: D
NEW QUESTION 24
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?
- A. 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.
- B. 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.
- C. 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.
- D. 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.
Answer: B
NEW QUESTION 25
......
Preparation Sources and Resources
Following the official study guide related to the Amazon DBS-C01 exam is an excellent way to diversify your entire preparation strategy and pass the test. These are the preparation steps that are vital in order to complete the Amazon AWS Certified Database – Specialty exam.
- Official Website
The official website offers a lot of reliable resources and information that is extremely useful in preparing for the test. These available materials include study guides, documentations, whitepapers, FAQs, sample papers, and more.
- Practice Tests
The potential candidates can also take practice tests. With the help of the AWS Database Specialty Practice Exam, you will be sure of your preparation. By using this tool, you will be able to find out your weak areas so that you can work on them and fulfill the knowledge gaps. Besides the vendor’s website, you can observe other platforms that provide you with practice tests.
- Training Course
The candidates can also go for the AWS training programs. So, it is great to know that Amazon offers the opportunity to opt for this preparation variant. Joining this training program will help the applicants gain the skills and knowledge of the exam content.
- Books and Guides
The books and study guides should be your next step in your preparation guide. You need to find the material that is enriched with updated information.
2022 Valid AWS-Certified-Database-Specialty test answers & Amazon Exam PDF: https://www.prepawayete.com/Amazon/AWS-Certified-Database-Specialty-practice-exam-dumps.html
Free Amazon AWS-Certified-Database-Specialty Exam Questions and Answer from Training Expert PrepAwayETE: https://drive.google.com/open?id=1k9-LIloqvXthKZ2tPPR25fYh7I1zHH0B