[2024] Use Real Amazon Dumps - 100% Free AWS-Certified-Database-Specialty Exam Dumps
Realistic AWS-Certified-Database-Specialty Dumps Latest Amazon Practice Tests Dumps
The AWS Certified Database - Specialty (DBS-C01) Exam is a valuable credential for professionals who want to advance their careers in database management. With the growing demand for cloud-based database solutions, this certification can help professionals stand out in the job market and demonstrate their expertise in managing databases on the AWS platform.
The AWS Certified Database - Specialty exam is an excellent way for professionals to validate their expertise in AWS databases and demonstrate their commitment to ongoing learning and professional development. By passing AWS-Certified-Database-Specialty exam, candidates can differentiate themselves from other professionals in the field and enhance their career opportunities.
NEW QUESTION # 90
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. Change the DB instance to an instance class with a higher maximum bandwidth
- B. Change the underlying EBS storage type to General Purpose SSD (gp2)
- C. Increase the size of the DB instance storage
- D. Disable EBS optimization on the DB instance
Answer: A
Explanation:
https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html
NEW QUESTION # 91
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. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.
- B. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template. Configure DynamoDB to provision throughput capacity using the stack's mappings.
- C. Add values for the rcuCount and wcuCount parameters as outputs of the template. Configure DynamoDB to provision throughput capacity using the stack outputs.
- D. Add values for two Number parameters, rcuCount and wcuCount, to the template. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.
Answer: D
Explanation:
Input parameter and FindInMap You can use an input parameter with the Fn::FindInMap function to refer to a specific value in a map. For example, suppose you have a list of regions and environment types that map to a specific AMI ID. You can select the AMI ID that your stack uses by using an input parameter (EnvironmentType). To determine the region, use the AWS::Region pseudo parameter, which gets the AWS Region in which you create the stack.
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/parameters-section-structure.html
NEW QUESTION # 92
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. Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region
- B. Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot ofthe read replica
- C. Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a secondLambda function to copy the snapshot into another Region
- D. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication tocopy the snapshot into another Region
Answer: B
NEW QUESTION # 93
In one AWS account, a business runs a two-tier ecommerce application. An Amazon RDS for MySQL Multi-AZ database instance serves as the application's backend. A developer removed the database instance in the production environment by accident. Although the organization recovers the database, the incident results in hours of outage and financial loss.
Which combination of adjustments would reduce the likelihood that this error will occur again in the future? (Select three.)
- A. Enable deletion protection on existing production DB instances.
- B. Enable AWS CloudTrail logging and Enhanced Monitoring.
- C. Allow all users to restore a database from a backup.
- D. Use an ACL policy to restrict users from DB instance deletion.
- E. Grant least privilege to groups, IAM users, and roles.
Answer: A,D,E
NEW QUESTION # 94
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. Modify the DB instance and enable encryption.
- B. Create an encrypted copy of manual snapshot of the DB instance. Restore a new DB instance from the encrypted snapshot.
- C. Create an encrypted read replica of the DB instance. Promote the read replica to a standalone instance.
- D. Restore a DB instance from the most recent automated snapshot and enable encryption.
Answer: D
NEW QUESTION # 95
A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.
Which AWS services should the Database Specialist consider? (Choose two.)
- A. Amazon Elasticsearch Service
- B. Amazon Neptune
- C. Amazon ElastiCache
- D. Amazon Redshift
- E. Amazon DynamoDB
Answer: C,E
Explanation:
https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html#Strategies.WriteThrough
https://aws.amazon.com/products/databases/real-time-apps-elasticache-for-redis/
NEW QUESTION # 96
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 Streams to replicate all DynamoDB transactions and sync them
- B. Use Amazon Aurora Global Database to synchronize all transactions
- C. Use Amazon EMR to copy the orders table data across Regions
- D. Use Amazon DynamoDB global tables to synchronize transactions
Answer: D
NEW QUESTION # 97
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 cross-Region read replicas and direct read traffic to then when Amazon RDS is down
- C. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
- D. Enable an Amazon RDS for MySQL Multi-AZ configuration
Answer: A
NEW QUESTION # 98
A significant automotive manufacturer is switching a mission-critical finance application's database to Amazon DynamoDB. According to the company's risk and compliance policy, any update to the database must be documented as a log entry for auditing purposes. Each minute, the system anticipates about 500,000 log entries. Log entries should be kept in Apache Parquet files in batches of at least 100,000 records per file.
How could a database professional approach these needs while using DynamoDB?
- A. Create a backup plan in AWS Backup to back up the DynamoDB table once a day. Create an AWS Lambda function that restores the backup in another table and compares both tables for changes.
Generate the log entries and write them to an Amazon S3 object. - B. Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon S3 object.
- C. Enable AWS CloudTrail logs on the table. Create an AWS Lambda function that reads the log files once an hour and filters DynamoDB API actions. Write the filtered log files to Amazon S3.
- D. Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon Kinesis Data Firehose delivery stream with buffering and Amazon S3 as the destination.
Answer: D
NEW QUESTION # 99
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 3306.
- B. Only allow incoming traffic from the subnet of the application servers on port 443.
- 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: C
Explanation:
most restrictive approach is to allow only incoming connections from SG of EC2 instance on port 3306
NEW QUESTION # 100
A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS. A deep review is performed and the AWS Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server Standard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL. The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.
What is the MOST cost-effective and operationally efficient solution?
- A. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.
- B. Run SQL Server Enterprise Edition on Amazon RDS.
- C. Run SQL Server Standard Edition on Amazon RDS.
- D. Run SQL Server Enterprise Edition on Amazon EC2.
Answer: C
NEW QUESTION # 101
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. Use policy conditions to restrict access to selective IP addresses
- B. Enable multi-factor authentication for sensitive operations to access sensitive resources and APIoperations
- C. Allow all users to restore a database from a backup that will reduce the overall downtime to restore thedatabase
- D. Grant least privilege to groups, users, and roles
- E. Enable AWS CloudTrail logging and Enhanced Monitoring
- F. Use AccessList Controls policy type to restrict users for database instance deletion
Answer: A,B,D
NEW QUESTION # 102
A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon RDS events and determined a failover event occurred at that time. The failover process took around 15 seconds to complete.
What is the MOST likely cause of the 5-minute connection outage?
- A. After failover, the Aurora DB cluster needs time to warm up before accepting client connections
- B. After a database crash, Aurora needed to replay the redo log from the last database checkpoint
- C. The client-side application is caching the DNS data and its TTL is set too high
- D. There were no active Aurora Replicas in the Aurora DB cluster
Answer: A
NEW QUESTION # 103
A financial services organization employs an Amazon Aurora PostgreSQL DB cluster to host an application on AWS. No log files detailing database administrator activity were discovered during a recent examination. A database professional must suggest a solution that enables access to the database and maintains activity logs.
The solution should be simple to implement and have a negligible effect on performance.
Which database specialist solution should be recommended?
- A. Allow connections to the DB cluster through a bastion host only. Restrict database access to the bastion host and application servers. Push the bastion host logs to Amazon CloudWatch Logs using the CloudWatch Logs agent.
- B. Create an AWS CloudTrail trail in the Region where the database runs. Associate the database activity logs with the trail.
- C. Enable Aurora Database Activity Streams on the database in synchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Kinesis Data Firehose destination to an Amazon S3 bucket.
- D. Enable Aurora Database Activity Streams on the database in asynchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Firehose destination to an Amazon S3 bucket.
Answer: D
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/DBActivityStreams.Overview.html
NEW QUESTION # 104
An online shopping company has a large inflow of shopping requests daily. As a result, there is a consistent load on the company's Amazon RDS database. A database specialist needs to ensure the database is up and running at all times. The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.
What should the database specialist do to achieve this? (Choose two.)
- A. Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
- B. Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
- C. Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
- D. Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
- E. Enable email notifications for AWS Trusted Advisor.
Answer: A,C
NEW QUESTION # 105
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. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.
- B. Add values for the rcuCount and wcuCount parameters as outputs of the template. Configure DynamoDB to provision throughput capacity using the stack outputs.
- C. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template.
Configure DynamoDB to provision throughput capacity using the stack's mappings. - D. Add values for two Number parameters, rcuCount and wcuCount, to the template. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.
Answer: D
Explanation:
Explanation
Input parameter and FindInMap You can use an input parameter with the Fn::FindInMap function to refer to a specific value in a map. For example, suppose you have a list of regions and environment types that map to a specific AMI ID. You can select the AMI ID that your stack uses by using an input parameter (EnvironmentType). To determine the region, use the AWS::Region pseudo parameter, which gets the AWS Region in which you create the stack.
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/parameters-section-structure.html
NEW QUESTION # 106
A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A database specialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Server backup file is approximately 120 GB in size. The application can be down for an extended period of time to complete the migration.
Connectivity between the on-premises environment and AWS can be initiated from on-premises only.
How can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?
- A. Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Download the backup files on an Amazon EC2 instance and restore them from the EC2 instance into the new production RDS instance.
- B. Provision and configure AWS DMS. Set up replication between the on-premises SQL Server environment to replicate the database to the new production RDS instance.
- C. Back up the SQL Server database using AWS Backup. Once the backup is complete, restore the completed backup to an Amazon EC2 instance and move it to the new production RDS instance.
- D. Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Restore the backup files from the S3 bucket into the new production RDS instance.
Answer: D
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html
NEW QUESTION # 107
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?
- A. Enable Amazon RDS Performance Insights and review the appropriate dashboard
- B. Enable Enhanced Monitoring will the appropriate settings
- C. Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
- D. Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
Answer: A
NEW QUESTION # 108
A business's production databases are housed on a 3 TB Amazon Aurora MySQL DB cluster. The database cluster is installed in the region us-east-1. For disaster recovery (DR) requirements, the company's database expert needs to fast deploy the DB cluster in another AWS Region to handle the production load with an RTO of less than two hours.
Which approach is the MOST OPERATIONALLY EFFECTIVE in meeting these requirements?
- A. Create an Aurora global database that spans two Regions. Use AWS Database Migration Service (AWS DMS) to migrate the existing database to the new global database.
- B. Add a cross-Region read replica in the DR Region with the same instance type as the current primary instance. If the read replica in the DR Region needs to be used for production, promote the read replica to become a standalone DB cluster.
- C. Implement an AWS Lambda function to take a snapshot of the production DB cluster every 2 hours, and copy that snapshot to an Amazon S3 bucket in the DR Region. Restore the snapshot to an appropriately sized DB cluster in the DR Region.
- D. Create a smaller DB cluster in the DR Region. Configure an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) enabled to replicate data from the current production DB cluster to the DB cluster in the DR Region.
Answer: B
Explanation:
Explanation
RTO is 2 hours. With 3 TB database, cross-region replica is a better option
NEW QUESTION # 109
A gaming company is evaluating Amazon ElastiCache as a solution to manage player leaderboards. Millions of players around the world will complete in annual tournaments. The company wants to implement an architecture that is highly available. The company also wants to ensure that maintenance activities have minimal impact on the availability of the gaming platform.
Which combination of steps should the company take to meet these requirements? (Choose two.)
- A. Deploy an ElastiCache for Redis cluster with read replicas and Multi-AZ enabled.
- B. Deploy a single-node ElastiCache for Redis cluster with automatic backups enabled. In the event of a failure, create a new cluster and restore data from the most recent backup.
- C. Use the default maintenance window to apply any required system changes and mandatory updates as soon as they are available.
- D. Choose a preferred maintenance window at the time of lowest usage to apply any required changes and mandatory updates.
- E. Deploy an ElastiCache for Memcached global datastore.
Answer: A,D
Explanation:
Explanation
https://aws.amazon.com/blogs/database/configuring-amazon-elasticache-for-redis-for-higher-availability/
NEW QUESTION # 110
......
What Are Career Opportunities That Certified AWS Database Specialty Specialists Can Get?
Once you pass the AWS DBS-C01 test and get the AWS Certified Database Specialty certification, you will become eligible for different career opportunities, such as:
- AWS Cloud Engineer;
- Senior Database Administrator;
- Technical Support & Solutions Analyst.
- Database Developer;
- Data Architect;
If you wonder what the responsibilities of an AWS Cloud Engineer are, you should know that he/she is in charge of handling the AWS cloud platform together with developing and ensuring its proper running. In addition, such a specialist is responsible for planning, implementing, and growing AWS cloud infrastructure. Also, an AWS Cloud Engineer will release and manage different production systems configuration. Finally, he/she is responsible for implementing the continuous integration and deployment of server-based technologies.
When it comes to salaries, Payscale.com offers verified information on the average annual payment that an AWS Database Specialty certified specialist might get. For example, a Data Architect can earn around $119k on average per year. However, this salary can grow depending on the candidate's expertise. Besides, a Cloud Engineer can get about $91k per annum. But in case the specialist manages to add the AWS Certified Database Specialty certification under his/her belt, the annual salary can become higher and will equal $126k per year.
Last but not least, Payscale.com mentions that the annual payment that a Senior Database Administrator can get is a little bit more than $108k. An experienced professional can win up to $138k per annum in this position. As this is a well-paid job role, you should know that the responsibilities list of such an employee includes providing database architecture to meet the required goals of specialized software. All in all, Senior Database Administrators will deal with the maintenance, configuration, and creation of databases. This, in its turn, involves backup, storage, and access to databases.
After getting the AWS Certified Database Specialty certification, you can expand your knowledge and skills by obtaining any other database related certification.
AWS-Certified-Database-Specialty Dumps PDF - AWS-Certified-Database-Specialty Real Exam Questions Answers: https://www.examsreviews.com/AWS-Certified-Database-Specialty-pass4sure-exam-review.html
AWS-Certified-Database-Specialty Exam [2024] Dumps Amazon PDF Questions: https://drive.google.com/open?id=15J5BY4PgE5vNQDr-rDbLb0KXJvnTtwbp