Latest Amazon DBS-C01 PDF and Dumps (2022) Free Exam Questions Answers
Pass Your AWS Certified Database DBS-C01 Exam on Oct 31, 2022 with 200 Questions
How can you get ready for the AWS Certified Database Specialty Certification Exam
There is a study guide for the AWS Certified Database Specialty Certification Exam
Here is our instant guide if you don't have time to read all the page
AWS offers the beta version of a certification specially designed for manufacturers with extensive experience with AWS databases. These are the details that you must be among the first to obtain the specialty certification of the AWS certified database. AWS Certified Database Specialty certification validates a comprehensive understanding of the scope of AWS database services and how to accelerate the use of database technology to drive business transformation in your organization. The certification covers complete database concepts that include design, migration, implementation, access, maintenance, automation, monitoring, security, and troubleshooting. This is the first AWS certification that focuses specifically on experience with database technology. The variety of databases has increased for AWS customers, creating a demand for new skills to design and recommend AWS database solutions tailored to specific workloads. With this certification, there is now a recognized diploma in the sector to validate this differentiated experience.
Below is the AWS Certified Database Specialty Exam Format
Format: Multiple choices, multiple answers
- Language: English
- Passing score: 750
- Length of Examination: 170 minutes
Below are the requirements of AWS Certified Database Specialty Exam
There is no prerequisites for AWS Certified Database - Specialty exam.
NEW QUESTION 19
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 every 6 hours and use Amazon S3 cross-Region replication tocopy the snapshot into another Region
- B. 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
- 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 ofthe read replica
Answer: D
NEW QUESTION 20
A company is developing a new web application. An AWS CloudFormation template was created as a part of the build process.
Recently, a change was made to an AWS::RDS::DBInstance resource in the template. The CharacterSetName property was changed to allow the application to process international text. A change set was generated using the new template, which indicated that the existing DB instance should be replaced during an upgrade.
What should a database specialist do to prevent data loss during the stack upgrade?
- A. Deactivate any applications that are using the DB instance. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack and reactivate the applications.
- B. Create a snapshot of the DB instance. Update the stack. Restore the database to a new instance.
- C. Modify the stack policy using the aws cloudformation update-stack command and the set-stack-policy command, then make the DB resource protected.
- D. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack.
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 with misconfigured security groups.
- B. The database is deployed with the wrong client connect timeout configuration.
- C. The database is deployed in a VPC that is in a different Availability Zone.
- D. The database is deployed in a VPC that is in a different Region.
Answer: A
Explanation:
Explanation
"A VPC peering connection is a networking connection between two VPCs that enables you to route traffic between them using private IP addresses. Instances in either VPC can communicate with each other as if they are within the same network. You can create a VPC peering connection between your own VPCs, with a VPC in another AWS account, or with a VPC in a different AWS Region."
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html
NEW QUESTION 22
A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too time- consuming, so it is not an option.
How should the Database Specialist satisfy this new requirement?
- A. Modify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.
- B. Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
- C. Create an encrypted read replica of the RDS DB instance. Promote it the master.
- D. Create a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted snapshot. Restore the encrypted snapshot copy.
Answer: D
Explanation:
Explanation
"However, because you can encrypt a copy of an unencrypted DB snapshot, you can effectively add encryption to an unencrypted DB instance. That is, you can create a snapshot of your DB instance, and then create an encrypted copy of that snapshot. You can then restore a DB instance from the encrypted snapshot, and thus you have an encrypted copy of your original DB instance. For more information, see Copying a Snapshot." https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html
NEW QUESTION 23
A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when survey responses are being collected, a Database Specialist sees the ProvisionedThroughputExceededException error.
What can the Database Specialist do to resolve this error? (Choose two.)
- A. Change the table to use Amazon DynamoDB Streams
- B. Change the table capacity mode to on-demand
- C. Purchase DynamoDB reserved capacity in the affected Region
- D. Change the table type to throughput optimized
- E. Increase the write capacity units for the specific table
Answer: B,E
Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/switching.capacitymode.html
NEW QUESTION 24
A company has an application that uses an Amazon DynamoDB table to store user data. Every morning, a single-threaded process calls the DynamoDB API Scan operation to scan the entire table and generate a critical start-of-day report for management. A successful marketing campaign recently doubled the number of items in the table, and now the process takes too long to run and the report is not generated in time.
A database specialist needs to improve the performance of the process. The database specialist notes that, when the process is running, 15% of the table's provisioned read capacity units (RCUs) are being used.
What should the database specialist do?
- A. Set the Limit and Offset parameters before every call to the API.
- B. Use four threads and parallel DynamoDB API Scan operations.
- C. Double the table's provisioned RCUs.
- D. Enable auto scaling for the DynamoDB table.
Answer: B
Explanation:
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Scan.html#Scan.ParallelScan
NEW QUESTION 25
A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.
Which of the following will resolve this issue?
- A. Change the DB cluster to Multi-AZ
- B. Edit the my.cnf file for the DB cluster to increase max_connections
- C. Increase the instance size of the DB cluster
- D. Increase the number of Aurora Replicas
Answer: C
NEW QUESTION 26
AWS CloudFormation stack including an Amazon RDS database instance was mistakenly removed, resulting in the loss of recent data. A Database Specialist must apply RDS parameters to the CloudFormation template in order to minimize the possibility of future inadvertent instance data loss.
Which settings will satisfy this criterion? (Select three.)
- A. Set MultiAZ to True
- B. Set DeletionPolicy to Retain
- C. Set TerminationProtection to True
- D. Set DeleteAutomatedBackups to False
- E. Set DeletionProtection to True
- F. Set DeletionPolicy to Delete
Answer: B,D,E
Explanation:
Explanation
A -
https://aws.amazon.com/about-aws/whats-new/2018/09/amazon-rds-now-provides-database-deletion-protection/ D -
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html F - https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-attribute-deletionpolicy.html
NEW QUESTION 27
Recently, an ecommerce business transferred one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition database instance. The corporation anticipates an increase in read traffic as a result of an approaching sale. To accommodate the projected read load, a database professional must establish a read replica of the database instance.
Which procedures should the database professional do prior to establishing the read replica? (Select two.)
- A. Ensure that automatic backups are enabled for the source DB instance.
- B. Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).
- C. Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
- D. Modify the read replica parameter group setting and set the value to 1.
- E. Identify a potential downtime window and stop the application calls to the source DB instance.
Answer: A,C
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html
NEW QUESTION 28
A huge gaming firm is developing a centralized method for storing the status of various online games' user sessions. The workload requires low-latency key-value storage and will consist of an equal number of reads and writes. Across the games' geographically dispersed user base, data should be written to the AWS Region nearest to the user. The design should reduce the burden associated with managing data replication across Regions.
Which solution satisfies these criteria?
- A. Amazon DynamoDB global tables
- B. Amazon Aurora global database
- C. Amazon RDS for Oracle with GoldenGate
- D. Amazon RDS for MySQL with multi-Region read replicas
Answer: A
Explanation:
Explanation
https://aws.amazon.com/dynamodb/?nc1=h_ls
NEW QUESTION 29
A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ DB instance. When using the AWS Management Console to conduct this task, the Database Specialist discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read replica cannot be created.
What is the most likely reason for this?
- A. Enhanced Monitoring is not enabled on the source DB instance.
- B. The source DB instance has to be converted to Single-AZ first to create a read replica from it.
- C. The minor MySQL version in the source DB instance does not support read replicas.
- D. Automated backups are not enabled on the source DB instance.
Answer: D
NEW QUESTION 30
A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server.
Due to escalating support and maintenance costs, the company is exploring the option of moving the workload to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?
- A. Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate themigration compatibility.
- B. Perform a logical dump from the Db2 database and restore it to an Aurora DB cluster. Identify the gaps andcompatibility of the objects migrated by comparing row counts from source and target tables.
- C. Run AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and compatibility of theobjects migrated by comparing the row counts from source and target tables.
- D. Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster.Create a migration assessment report to evaluate the migration compatibility.
Answer: D
NEW QUESTION 31
A company has multiple applications serving data from a secure on-premises database. The company is migrating all applications and databases to the AWS Cloud. The IT Risk and Compliance department requires that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as the migration target, and leveraging the Advanced Auditing feature in Aurora.
Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements? (Choose three.)
- A. QUERY_DML
- B. QUERY_DDL
- C. QUERY
- D. CONNECT
- E. TABLE
- F. QUERY_DCL
Answer: B,D,E
NEW QUESTION 32
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?
- A. 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.
- B. 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.
- C. 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.
- D. 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: B
NEW QUESTION 33
A company is migrating its on-premises database workloads to the AWS Cloud. A database specialist performing the move has chosen AWS DMS to migrate an Oracle database with a large table to Amazon RDS.
The database specialist notices that AWS DMS is taking significant time to migrate the data.
Which actions would improve the data migration speed? (Choose three.)
- A. Configure the AWS DMS replication instance with Multi-AZ.
- B. Enable an Amazon RDS Multi-AZ configuration.
- C. Establish an AWS Direct Connect connection between the on-premises data center and AWS.
- D. Increase the capacity of the AWS DMS replication server.
- E. Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.
- F. Create multiple AWS DMS tasks to migrate the large table.
Answer: B,C,D
NEW QUESTION 34
Recently, a financial institution created a portfolio management service. The application's backend is powered by Amazon Aurora, which supports MySQL.
The firm demands a response time of five minutes and a response time of five minutes. A database professional must create a disaster recovery system that is both efficient and has a low replication latency.
How should the database professional tackle these requirements?
- A. Configure a binlog and create a replica in a different AWS Region.
- B. Configure an Amazon Aurora global database and add a different AWS Region.
- C. Configure AWS Database Migration Service (AWS DMS) and create a replica in a different AWS Region.
- D. Configure a cross-Region read replica.
Answer: B
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-disaster-recovery.htm
https://aws.amazon.com/blogs/database/how-to-choose-the-best-disaster-recovery-option-for-your-amazon-auror
https://aws.amazon.com/about-aws/whats-new/2019/11/aurora-supports-in-place-conversion-to-global-database/
NEW QUESTION 35
A company is using Amazon with Aurora Replicas for read-only workload scaling. A Database Specialist needs to split up two read-only applications so each application always connects to a dedicated replica. The Database Specialist wants to implement load balancing and high availability for the read-only applications.
Which solution meets these requirements?
- A. Use custom endpoints for the two read-only applications.
- B. Use a reader endpoint for one read-only application and use an instance endpoint for the other read-onlyapplication.
- C. Use a specific instance endpoint for each replica and add the instance endpoint to each read-onlyapplication connection string.
- D. Use reader endpoints for both the read-only workload applications.
Answer: D
NEW QUESTION 36
A company is using an Amazon Aurora PostgreSQL DB cluster with an xlarge primary instance master and two large Aurora Replicas for high availability and read-only workload scaling. A failover event occurs and application performance is poor for several minutes. During this time, application servers in all Availability Zones are healthy and responding normally.
What should the company do to eliminate this application performance issue?
- A. Deploy an AWS Lambda function that calls the DescribeDBInstances action to establish which instance has failed, and then use the PromoteReadReplica operation to promote one Aurora Replica to be the primary DB instance. Configure an Amazon RDS event subscription to send a notification to an Amazon SNS topic to which the Lambda function is subscribed.
- B. Configure both of the Aurora Replicas to the same instance class as the primary DB instance. Enable cache coherence on the DB cluster, set the primary DB instance failover priority to tier-0, and assign a failover priority of tier-1 to the replicas.
- C. Configure both Aurora Replicas to have the same instance class as the primary DB instance. Implement Aurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DB instance and to tier-1 for the replicas.
- D. Configure one Aurora Replica to have the same instance class as the primary DB instance. Implement Aurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DB instance and one replica with the same instance class. Set the failover priority to tier-1 for the other replicas.
Answer: C
NEW QUESTION 37
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 as outputs of the template. Configure DynamoDBto provision throughput capacity using the stack outputs.
- B. 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. - C. 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.
- D. 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.
Answer: C
NEW QUESTION 38
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 as the most recent modification was too soon.
- C. The request will fail because this storage capacity is too large.
- D. The request will succeed only if CPU utilization is less than 10%.
Answer: A
NEW QUESTION 39
A Database Specialist is designing a new database infrastructure for a ride hailing application. The application data includes a ride tracking system that stores GPS coordinates for all rides. Real-time statistics and metadata lookups must be performed with high throughput and microsecond latency. The database should be fault tolerant with minimal operational overhead and development effort.
Which solution meets these requirements in the MOST efficient way?
- A. Use Amazon DynamoDB as the database and use Amazon API Gateway
- B. Use Amazon DynamoDB as the database and use DynamoDB Accelerator
- C. Use Amazon RDS for MySQL as the database and use Amazon ElastiCache
- D. Use Amazon Aurora MySQL as the database and use Aurora's buffer cache
Answer: B
Explanation:
Explanation
https://aws.amazon.com/dynamodb/dax/#:~:text=Amazon%20DynamoDB%20Accelerator%20(DAX)%20is,mil
"Amazon DynamoDB Accelerator (DAX) is a fully managed, highly available, in-memory cache for DynamoDB that delivers up to a 10x performance improvement - from milliseconds to microseconds - even at millions of requests per second. "
NEW QUESTION 40
A financial organization must ensure that the most current 90 days of MySQL database backups are accessible.
Amazon RDS for MySQL DB instances are used to host all MySQL databases. A database expert must create a solution that satisfies the criteria for backup retention with the least amount of development work feasible.
Which strategy should the database administrator take?
- A. Modify the DB instances to enable the automated backup option. Select the required backup retention period.
- B. Use AWS Lambda to schedule a daily manual snapshot of the DB instances. Delete snapshots that exceed the retention requirement.
- C. Use AWS Backup to build a backup plan for the required retention period. Assign the DB instances to the backup plan.
- D. Automate a daily cron job on an Amazon EC2 instance to create MySQL dumps, transfer to Amazon S3, and implement an S3 Lifecycle policy to meet the retention requirement.
Answer: C
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html
NEW QUESTION 41
On AWS, a business is developing a web application. The application needs that the database supports concurrent read and write activities in several AWS Regions. Additionally, the database must communicate data changes across Regions as they occur. The application must be highly available and have a latency of less than a few hundred milliseconds.
Which solution satisfies these criteria?
- A. Amazon DynamoDB streams with AWS Lambda to replicate the data
- B. An Amazon ElastiCache for Redis cluster with cluster mode enabled and multiple shards
- C. Amazon DynamoDB global tables
- D. An Amazon Aurora global database
Answer: C
Explanation:
Explanation
Aurora Global Databases provides a writer and a reader endpoints in the primary region but only a reader endpoints in other region. Although strongly consistent, it does not fulfill the requirements that "there are plenty of read / write activities" in all regions.
NEW QUESTION 42
......
DBS-C01 Dumps for AWS Certified Database Certified Exam Questions and Answer: https://www.exams4sures.com/Amazon/DBS-C01-practice-exam-dumps.html
DBS-C01 Free Exam Study Guide! (Updated 200 Questions): https://drive.google.com/open?id=1vWwD-6sxpwKCA4r4nXz2mbdF3fy1Y2D9