Updated Mar-2024 100% Cover Real DBS-C01 Exam Questions Make Sure You 100% Pass
DBS-C01 dumps Accurate Questions and Answers with Free and Fast Updates
Becoming AWS Certified in Database - Specialty (DBS-C01) can open up numerous career opportunities for individuals. As more businesses move towards cloud computing, the demand for AWS certified professionals continues to grow. AWS Certified Database - Specialty (DBS-C01) Exam certification can help individuals stand out in a competitive job market and showcase their expertise in AWS database services.
NEW QUESTION # 32
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 Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift
- B. Use DynamoDB Accelerator to offload the reads
- 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
Explanation:
https://docs.amazonaws.cn/en_us/amazondynamodb/latest/developerguide/DAX.html
"Applications that are read-intensive, but are also cost-sensitive. With DynamoDB, you provision the number of reads per second that your application requires. If read activity increases, you can increase your tables' provisioned read throughput (at an additional cost). Or, you can offload the activity from your application to a DAX cluster, and reduce the number of read capacity units that you need to purchase otherwise."
NEW QUESTION # 33
An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
* Update scores in real time whenever a player is playing the game.
* Retrieve a player's score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?
- A. Create a composite primary key with game_id as the partition key and user_id as the sort key
- B. Create a global secondary index with user_id as the partition key
- C. Create a global secondary index with game_id as the partition key
- D. Create a composite primary key with user_id as the partition key and game_id as the sort key
Answer: B
NEW QUESTION # 34
A social media company is using Amazon DynamoDB to store user profile data and user activity dat a. Developers are reading and writing the data, causing the size of the tables to grow significantly. Developers have started to face performance bottlenecks with the tables.
Which solution should a database specialist recommend to read items the FASTEST without consuming all the provisioned throughput for the tables?
- A. Use the Scan API operation in parallel with many workers to read all the items. Use the Query API operation to read multiple items that have a specific partition key and sort key. Use the GetItem API operation to read a single item.
- B. Use the Scan API operation with a filter expression that allows multiple items to be read. Use the Query API operation to read multiple items that have a specific partition key and sort key. Use the GetItem API operation to read a single item.
- C. Use the Scan API operation with a filter expression that allows multiple items to be read. Use the Query API operation to read a single item that has a specific primary key. Use the BatchGetItem API operation to read multiple items.
- D. Use the Scan API operation in parallel with many workers to read all the items. Use the Query API operation to read a single item that has a specific primary key Use the BatchGetItem API operation to read multiple items.
Answer: B
Explanation:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SQLtoNoSQL.ReadData.html
NEW QUESTION # 35
A business uses Amazon EC2 instances in VPC A to serve an internal file-sharing application. This application is supported by an Amazon ElastiCache cluster in VPC B that is peering with VPC A.
The corporation migrates the instances of its applications from VPC A to VPC B.
The file-sharing application is no longer able to connect to the ElastiCache cluster, as shown by the logs.
What is the best course of action for a database professional to take in order to remedy this issue?
- A. Create a second security group on the EC2 instances. Add an outbound rule to allow traffic from the ElastiCache cluster security group.
- B. Modify the ElastiCache security group by adding an inbound rule that allows traffic from the EC2 instances security group to the ElastiCache cluster.
- C. Modify the ElastiCache security group by adding outbound rules that allow traffic to VPC CIDR blocks from the ElastiCache cluster.
- D. Delete the ElastiCache security group. Add an interface VPC endpoint to enable the EC2 instances to connect to the ElastiCache cluster.
Answer: B
Explanation:
Explanation
https://docs.aws.amazon.com/vpc/latest/peering/vpc-peering-security-groups.html
NEW QUESTION # 36
A company wants to migrate its on-premises MySQL databases to Amazon RDS for MySQL. To comply with the company's security policy, all databases must be encrypted at rest. RDS DB instance snapshots must also be shared across various accounts to provision testing and staging environments.
Which solution meets these requirements?
- A. Create an RDS for MySQL DB instance with an AWS owned CMK. Create a new key policy to include the administrator user name of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
- B. Create an RDS for MySQL DB instance with an AWS managed CMK. Create a new key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
- C. Create an RDS for MySQL DB instance with an AWS Key Management Service (AWS KMS) customer managed CMK. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
- D. Create an RDS for MySQL DB instance with an AWS CloudHSM key. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
Answer: C
NEW QUESTION # 37
A database specialist needs to move an Amazon RDS DB instance from one AWS account to another AWS account.
Which solution will meet this requirement with the LEAST operational effort?
- A. Use AWS Database Migration Service (AWS DMS) to migrate the DB instance from the source AWS account to the destination AWS account.
- B. Create a DB snapshot of the DB instance. Share the snapshot with the destination AWS account. Create a new DB instance by restoring the snapshot in the destination AWS account.
- C. Create a Multi-AZ deployment for the DB instance. Create a read replica for the DB instance in the source AWS account. Use the read replica to replicate the data into the DB instance in the destination AWS account.
- D. Use AWS DataSync to back up the DB instance in the source AWS account. Use AWS Resource Access Manager (AWS RAM) to restore the backup in the destination AWS account.
Answer: B
Explanation:
Explanation
The solution that will meet the requirement with the least operational effort is to create a DB snapshot of the DB instance, share the snapshot with the destination AWS account, and create a new DB instance by restoring the snapshot in the destination AWS account. This solution is simple, secure, and does not require any additional services or tools. It also preserves the configuration and data of the original DB instance. The other solutions are either more complex, require additional services or tools, or do not guarantee data consistency or security. For example, using AWS DMS to migrate the DB instance requires setting up replication endpoints, tasks, and network connectivity between the source and destination accounts. Creating a Multi-AZ deployment and a read replica for the DB instance involves additional costs and complexity, and does not ensure data consistency between the source and destination DB instances. Using AWS DataSync and AWS RAM to back up and restore the DB instance requires additional storage and permissions, and does not support encryption or compression for the backup data
NEW QUESTION # 38
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. Copy Aurora incremental snapshots to the us-east-1 Region.
- B. Enable synchronous replication.
- C. Create an Aurora Global Database.
- D. Enable asynchronous binlog replication.
Answer: C
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-disaster-recovery.htm
NEW QUESTION # 39
A company is developing an application that performs intensive in-memory operations on advanced data structures such as sorted sets. The application requires sub-millisecond latency for reads and writes. The application occasionally must run a group of commands as an ACID-compliant operation. A database specialist is setting up the database for this application. The database specialist needs the ability to create a new database cluster from the latest backup of the production cluster.
Which type of cluster should the database specialist create to meet these requirements?
- A. Amazon Neptune
- B. Amazon ElastiCache for Memcached
- C. Amazon DynamoDB Accelerator (DAX)
- D. Amazon ElastiCache for Redis
Answer: D
Explanation:
https://aws.amazon.com/elasticache/redis-vs-memcached/
https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/elasticache-use-cases.html#elasticache-for-redis-use-cases-gaming
NEW QUESTION # 40
A company has an AWS CloudFormation template written in JSON that is used to launch new Amazon RDS for MySQL DB instances. The security team has asked a database specialist to ensure that the master password is automatically rotated every 30 days for all new DB instances that are launched using the template.
What is the MOST operationally efficient solution to meet these requirements?
- A. Integrate the Amazon RDS for MySQL DB instances with AWS IAM and centrally manage the master database user password.
- B. Create an AWS Lambda function to rotate the secret. Modify the CloudFormation template to add an AWS::SecretsManager::RotationSchedule resource. Configure the RotationLambdaARN value and, for the RotationRules property, set the AutomaticallyAfterDays parameter to 30.
- C. Modify the CloudFormation template to use the AWS KMS key as the database password. Configure an Amazon EventBridge rule to invoke the KMS API to rotate the key every 30 days by setting the ScheduleExpression parameter to ***/30***.
- D. Save the password in an Amazon S3 object. Encrypt the S3 object with an AWS KMS key. Set the KMS key to be rotated every 30 days by setting the EnableKeyRotation property to true. Use a CloudFormation custom resource to read the S3 object to extract the password.
Answer: B
Explanation:
Explanation
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-secretsmanager-rotationsche
NEW QUESTION # 41
A company has a database fleet that includes an Amazon RDS for MySQL DB instance. During an audit, the company discovered that the data that is stored on the DB instance is unencrypted.
A database specialist must enable encryption for the DB instance. The database specialist also must encrypt all connections to the DB instance.
Which combination of actions should the database specialist take to meet these requirements? (Choose three.)
- A. Create a snapshot of the unencrypted DB instance. Encrypt the snapshot by using an AWS Key Management Service (AWS KMS) key. Restore the DB instance from the encrypted snapshot. Delete the original DB instance.
- B. Enable SSH encryption on the DB instance.
- C. Require SSL connections for applicable database user accounts.
- D. In the RDS console, choose "Enable encryption" to encrypt the DB instance by using an AWS Key Management Service (AWS KMS) key.
- E. Use SSL/TLS from the application to encrypt a connection to the DB instance.
- F. Encrypt the read replica of the unencrypted DB instance by using an AWS Key Management Service (AWS KMS) key. Fail over the read replica to the primary DB instance.
Answer: A,D,E
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html#Overview.Encryption.E
NEW QUESTION # 42
An online gaming company is using an Amazon DynamoDB table in on-demand mode to store game scores.
After an intensive advertisement campaign in South
America, the average number of concurrent users rapidly increases from 100,000 to 500,000 in less than 10 minutes every day around 5 PM.
The on-call software reliability engineer has observed that the application logs contain a high number of DynamoDB throttling exceptions caused by game score insertions around 5 PM. Customer service has also reported that several users are complaining about their scores not being registered.
How should the database administrator remediate this issue at the lowest cost?
- A. Switch the table to provisioned mode and set the throughput to the peak value.
- B. Enable auto scaling and set the target usage rate to 90%.
- C. Switch the table to provisioned mode and enable auto scaling.
- D. Create a DynamoDB Accelerator cluster and use it to access the DynamoDB table.
Answer: C
NEW QUESTION # 43
An online advertising website uses an Amazon DynamoDB table with on-demand capacity mode as its data store. The website also has a DynamoDB Accelerator (DAX) cluster in the same VPC as its web application server. The application needs to perform infrequent writes and many strongly consistent reads from the data store by querying the DAX cluster.
During a performance audit, a systems administrator notices that the application can look up items by using the DAX cluster. However, the QueryCacheHits metric for the DAX cluster consistently shows 0 while the QueryCacheMisses metric continuously keeps growing in Amazon CloudWatch.
What is the MOST likely reason for this occurrence?
- A. A VPC endpoint was not added to access DynamoDB.
- B. Strongly consistent reads are always passed through DAX to DynamoDB.
- C. DynamoDB is scaling due to a burst in traffic, resulting in degraded performance.
- D. A VPC endpoint was not added to access CloudWatch.
Answer: B
Explanation:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DAX.concepts.html
"If the request specifies strongly consistent reads, DAX passes the request through to DynamoDB. The results from DynamoDB are not cached in DAX. Instead, they are simply returned to the application."
NEW QUESTION # 44
A company stores critical data for a department in Amazon RDS for MySQL DB instances. The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time. To meet this requirement, the database specialist stopped all the DB instances used by the department but did not select the option to create a snapshot. Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully.
What could be the reason for this?
- A. When stopping the DB instance, the option to create a snapshot should have been selected.
- B. Stopped DB instances will automatically restart if the instance is not manually started after 7 days.
- C. When stopping the DB instance, the duration for stopping the DB instance should have been selected.
- D. Stopped DB instances will automatically restart if the number of attempted connections exceeds the threshold set.
Answer: B
Explanation:
Explanation
https://aws.amazon.com/premiumsupport/knowledge-center/rds-stop-seven-days/
NEW QUESTION # 45
An IT consulting company wants to reduce costs when operating its development environment databases. The company's workflow creates multiple Amazon Aurora MySQL DB clusters for each development group. The Aurora DB clusters are only used for 8 hours a day. The DB clusters can then be deleted at the end of the development cycle, which lasts 2 weeks.
Which of the following provides the MOST cost-effective solution?
- A. Use Aurora Replicas. From the master automatic pause compute capacity option, create replicas for eachdevelopment group, and promote each replica to master. Delete the replicas at the end of the developmentcycle.
- B. Use AWS CloudFormation templates. Deploy a stack with the DB cluster for each development group.Delete the stack at the end of the development cycle.
- C. Use Aurora Serverless. Restore current Aurora snapshot and deploy to a serverless cluster for eachdevelopment group. Enable the option to pause the compute capacity on the cluster and set an appropriatetimeout.
- D. Use the Aurora DB cloning feature. Deploy a single development and test Aurora DB instance, and createclone instances for the development groups. Delete the clones at the end of the development cycle.
Answer: C
NEW QUESTION # 46
A business's production database is hosted on a single-node Amazon RDS for MySQL DB instance. The database instance is hosted in a United States AWS Region.
A week before a significant sales event, a fresh database maintenance update is released. The maintenance update has been designated as necessary. The firm want to minimize the database instance's downtime and requests that a database expert make the database instance highly accessible until the sales event concludes.
Which solution will satisfy these criteria?
- A. Create a read replica with the latest update. Transfer all read-only traffic to the read replica during the sales event.
- B. Convert the DB instance into a Multi-AZ deployment. Apply the maintenance update.
- C. Defer the maintenance update until the sales event is over.
- D. Create a read replica with the latest update. Initiate a failover before the sales event.
Answer: B
Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/
NEW QUESTION # 47
A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.
Where should the AWS DMS replication instance be placed for the MOST optimal performance?
- A. In the same VPC and Availability Zone as the source DB instance
- B. In the same Region and VPC of the source DB instance
- C. In the same VPC and Availability Zone as the target DB instance
- D. In the same Region and VPC as the target DB instance
Answer: A
NEW QUESTION # 48
A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users.
How should the Database Specialist apply the parameter group change for the DB instance?
- A. Reboot the secondary Multi-AZ DB instance
- B. Select the option to apply the change immediately
- C. Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
- D. Apply the change manually by rebooting the DB instance during the approved maintenance window
Answer: D
Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html#USER_WorkingWithParamGroups.Modifying
NEW QUESTION # 49
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 mediumsized 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?
- A. Aurora will promote an Aurora Replica that is of the same size as the primary instance
- B. Aurora will not promote an Aurora Replica
- C. Aurora will promote the largest-sized Aurora Replica
- D. Aurora will promote an arbitrary Aurora Replica
Answer: A
NEW QUESTION # 50
A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days.
Which solution will meet these requirements in the MOST operationally efficient way?
- A. Export the contents of the snapshot to an Amazon S3 bucket.
- B. Create a native SQL Server backup. Save the backup to an Amazon S3 bucket.
- C. Create a manual copy of the snapshot.
- D. Change the retention period of the snapshot to 45 days.
Answer: C
Explanation:
Explanation from Amazon documents:
Amazon RDS for Microsoft SQL Server supports two types of database snapshots: automated and manual.
Automated snapshots are taken daily and are retained for a period of time that you specify, from 1 to 35 days.
Manual snapshots are taken by you and are retained until you delete them.
To save a particular automated database snapshot for longer than the maximum number of days, the database administrator can create a manual copy of the snapshot. This can be done using the AWS Management Console, the AWS CLI, or the RDS API. The manual copy of the snapshot will be retained until it is deleted, regardless of the retention period of the automated snapshot. This solution is the most operationally efficient way to meet the requirements, because it does not require any additional steps or resources.
Therefore, option A is the correct solution to meet the requirements. Option B is not operationally efficient because it requires exporting the contents of the snapshot to an Amazon S3 bucket, which can be time-consuming and costly. Option C is not possible because the maximum retention period for automated snapshots is 35 days, not 45 days. Option D is not operationally efficient because it requires creating a native SQL Server backup and saving it to an Amazon S3 bucket, which can also be time-consuming and costly.
NEW QUESTION # 51
Amazon Neptune is being used by a corporation as the graph database for one of its products. During an ETL procedure, the company's data science team produced enormous volumes of temporary data by unintentionally. The Neptune DB cluster extended its storage capacity automatically to handle the added data, but the data science team erased the superfluous data.
What should a database professional do to prevent incurring extra expenditures for cluster volume space that is not being used?
- A. Add a Neptune read replica to the cluster. Promote this replica as a new primary DB instance. Reset the storage space of the cluster.
- B. Take a snapshot of the cluster volume. Restore the snapshot in another cluster with a smaller volume size.
- C. Use the AWS CLI to turn on automatic resizing of the cluster volume.
- D. Export the cluster data into a new Neptune DB cluster.
Answer: D
Explanation:
The only way to shrink the storage space used by your DB cluster when you have a large amount of unused allocated space is to export all the data in your graph and then reload it into a new DB cluster. Creating and restoring a snapshot does not reduce the amount of storage allocated for your DB cluster, because a snapshot retains the original image of the cluster's underlying storage.
NEW QUESTION # 52
A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available. Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.
What might account for this? (Choose two.)
- A. Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.
- B. The new minor version has not yet been designated as preferred and requires a manual upgrade.
- C. Configuring automatic upgrades using the AWS CLI is not supported. This must be enabled expressly using the AWS Management Console.
- D. The AWS CLI command did not include an apply-immediately parameter.
- E. Applying minor version upgrades requires sufficient free space.
Answer: B,D
Explanation:
Explanation
"When Amazon RDS designates a minor engine version as the preferred minor engine version, each database that meets both of the following conditions is upgraded to the minor engine version automatically"
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Upgrading.html
NEW QUESTION # 53
A vehicle insurance company needs to choose a highly available database to track vehicle owners and their insurance details. The persisted data should be immutable in the database, including the complete and sequenced history of changes over time with all the owners and insurance transfer details for a vehicle.
The data should be easily verifiable for the data lineage of an insurance claim.
Which approach meets these requirements with MINIMAL effort?
- A. Create an Amazon QLDB ledger to store the insurance details. Validate the data by choosing the ledger name in the digest request to verify the data lineage of an insurance claim.
- B. Create an Amazon DynamoDB table to store the insurance details. Validate the data using AWS DMS validation by moving the data to Amazon S3 to verify the data lineage of an insurance claim.
- C. Create an Amazon Aurora database to store the insurance details. Validate the data using AWS DMS validation by moving the data to Amazon S3 to verify the data lineage of an insurance claim.
- D. Create a blockchain to store the insurance details. Validate the data using a hash function to verify the data lineage of an insurance claim.
Answer: A
NEW QUESTION # 54
......
AWS Certified Database - Specialty (DBS-C01) is a certification exam offered by Amazon Web Services (AWS) for professionals who want to validate their expertise in designing, deploying, and managing databases on the AWS platform. DBS-C01 exam is designed for individuals who have experience in database technologies and want to demonstrate their skills in working with AWS technologies.
Real DBS-C01 Quesions Pass Certification Exams Easily: https://www.test4cram.com/DBS-C01_real-exam-dumps.html
Practice with these DBS-C01 dumps Certification Sample Questions: https://drive.google.com/open?id=1GLxNM0bSXOudqtRg4qzcDtxaM_UVlPmo