DBS-C01 Updated Exam Dumps [2021] Practice Valid Exam Dumps Question
DBS-C01 Sample with Accurate & Updated Questions
Who Is Target Audience for AWS Database Specialty Certification?
The AWS Certified Database Specialty certification focuses on developing different capabilities in individuals to help them become key-performers in database-focused roles. This certification validates examinees' abilities to understand and differentiate the most important features used by AWS database services. Also, it helps them discover the best database solutions using AWS services to drive change in the organization. While the vendor doesn't have any express prerequisites to be eligible to pursue this certificate, it still has some recommendations. The candidates should have at least 5 years of practical experience using basic database technologies. Also, they should have a minimum of 2 years of hands-on experience working with AWS technologies. Finally, candidates should demonstrate that they have experience working with NoSQL databases and AWS Cloud-based infrastructure.
NEW QUESTION 13
A gaming company has implemented a leaderboard in AWS using a Sorted Set data structure within Amazon ElastiCache for Redis. The ElastiCache cluster has been deployed with cluster mode disabled and has a replication group deployed with two additional replicas. The company is planning for a worldwide gaming event and is anticipating a higher write load than what the current cluster can handle.
Which method should a Database Specialist use to scale the ElastiCache cluster ahead of the upcoming event?
- A. Enable cluster mode on the existing ElastiCache cluster and configure separate shards for the Sorted Setacross all nodes in the cluster.
- B. Create an additional ElastiCache cluster and load-balance traffic between the two clusters.
- C. Use the EXPIRE command and set a higher time to live (TTL) after each call to increment a given key.
- D. Increase the size of the ElastiCache cluster nodes to a larger instance size.
Answer: D
NEW QUESTION 14
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 fail because this storage capacity is too large.
- B. The request will fail as the most recent modification was too soon.
- C. The request will succeed only if CPU utilization is less than 10%.
- D. The request will succeed only if the primary instance is in active status.
Answer: D
NEW QUESTION 15
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 user_id as the partition key and game_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 game_id as the partition key and user_id as the sort key
Answer: B
NEW QUESTION 16
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup.
The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company.
Which solution will meet these requirements with minimal effort?
- A. Write RDS logs to Amazon Kinesis Data Firehose. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
- B. Create an Amazon Cloudwatch Events rule with the operations that need to be tracked on Amazon RDS. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
- C. Create an AWS Lambda function to trigger on AWS CloudTrail API calls. Filter on specific RDS API calls and write the output to the tracking systems.
- D. Create RDS event subscriptions. Have the tracking systems subscribe to specific RDS event system notifications.
Answer: D
NEW QUESTION 17
A company has migrated a single MySQL database to Amazon Auror
a. The production data is hosted in a DB cluster in VPC_PROD, and 12 testing environments are hosted in VPC_TEST using the same AWS account. Testing results in minimal changes to the test data. The Development team wants each environment refreshed nightly so each test database contains fresh production data every day.
Which migration approach will be the fastest and most cost-effective to implement?
- A. Run the master in Amazon Aurora MySQL. Create 12 Aurora Replicas in VPC_TEST, and script the replicas to be deleted and re-created nightly.
- B. Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
- C. Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.
- D. Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
Answer: B
NEW QUESTION 18
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 19
A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?
- A. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
- B. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
- C. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
- D. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.
Answer: B
NEW QUESTION 20
A company is looking to migrate a 1 TB Oracle database from on-premises to an Amazon Aurora PostgreSQL DB cluster. The company's Database Specialist discovered that the Oracle database is storing 100 GB of large binary objects (LOBs) across multiple tables. The Oracle database has a maximum LOB size of 500 MB with an average LOB size of 350 MB. The Database Specialist has chosen AWS DMS to migrate the data with the largest replication instances.
How should the Database Specialist optimize the database migration using AWS DMS?
- A. Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBstogether
- B. Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data andLOBs together
- C. Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB andtask 2 without LOBs
- D. Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2without LOBs
Answer: C
NEW QUESTION 21
A company is releasing a new mobile game featuring a team play mode. As a group of mobile device users play together, an item containing their statuses is updated in an Amazon DynamoDB table. Periodically, the other users' devices read the latest statuses of their teammates from the table using the BatchGetltemn operation.
Prior to launch, some testers submitted bug reports claiming that the status data they were seeing in the game was not up-to-date. The developers are unable to replicate this issue and have asked a database specialist for a recommendation.
Which recommendation would resolve this issue?
- A. Ensure the DynamoDB table is configured to be always consistent.
- B. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to false.
- C. Enable a stream on the DynamoDB table and subscribe each device to the stream to ensure all devices receive up-to-date status information.
- D. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to true.
Answer: C
NEW QUESTION 22
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. There were no active Aurora Replicas in the Aurora DB cluster
- B. After a database crash, Aurora needed to replay the redo log from the last database checkpoint
- C. After failover, the Aurora DB cluster needs time to warm up before accepting client connections
- D. The client-side application is caching the DNS data and its TTL is set too high
Answer: C
NEW QUESTION 23
A company runs a customer relationship management (CRM) system that is hosted on-premises with a MySQL database as the backend. A custom stored procedure is used to send email notifications to another system when data is inserted into a table. The company has noticed that the performance of the CRM system has decreased due to database reporting applications used by various teams. The company requires an AWS solution that would reduce maintenance, improve performance, and accommodate the email notification feature.
Which AWS solution meets these requirements?
- A. Use MySQL running on an Amazon EC2 instance with a read replica to accommodate the reporting applications. Configure Amazon SES integration to send email notifications to the other system.
- B. Use MySQL running on an Amazon EC2 instance with Auto Scaling to accommodate the reporting applications. Configure a stored procedure and an AWS Lambda function that uses Amazon SES to send email notifications to the other system.
- C. Use Amazon Aurora MySQL with a read replica for the reporting applications. Configure a stored procedure and an AWS Lambda function to publish a message to an Amazon SNS topic. Subscribe the other system's email address to the topic.
- D. Use Amazon Aurora MySQL in a multi-master cluster to accommodate the reporting applications. Configure Amazon RDS event subscriptions to publish a message to an Amazon SNS topic and subscribe the other system's email address to the topic.
Answer: C
NEW QUESTION 24
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 DynamoDB to provision throughput capacity using the stack outputs.
- B. 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.
- C. 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.
- D. 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.
Answer: B
NEW QUESTION 25
A database specialist is building a system that uses a static vendor dataset of postal codes and related territory information that is less than 1 GB in size. The dataset is loaded into the application's cache at start up. The company needs to store this data in a way that provides the lowest cost with a low application startup time.
Which approach will meet these requirements?
- A. Use an Amazon RDS DB instance. Shut down the instance once the data has been read.
- B. Use Amazon S3 and load the data from flat files.
- C. Use Amazon Aurora Serverless. Allow the service to spin resources up and down, as needed.
- D. Use Amazon DynamoDB in on-demand capacity mode.
Answer: A
NEW QUESTION 26
A company is building a software as a service application. As part of the new user sign-on workflow, a Python script invokes the CreateTable operation using the Amazon DynamoDB API. After the call returns, the script attempts to call PutItem.
Occasionally, the PutItem request fails with a ResourceNotFoundException error, which causes the workflow to fail. The development team has confirmed that the same table name is used in the two API calls.
How should a database specialist fix this issue?
- A. Add a ConditionExpression parameter in the PutItem request.
- B. Set the StreamEnabled property of the StreamSpecification parameter to true, then call PutItem.
- C. Add an allow statement for the dynamodb:PutItem action in a policy attached to the role used by the application creating the table.
- D. Change the application to call DescribeTable periodically until the TableStatus is ACTIVE, then call PutItem.
Answer: A
NEW QUESTION 27
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_DCL
- C. QUERY
- D. QUERY_DDL
- E. TABLE
- F. CONNECT
Answer: D,E,F
NEW QUESTION 28
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. Define IAM policies for access to the new table
- B. Set the provisioned read and write capacity
- C. Define the TTL settings
- D. Encrypt the table from the AWS Management Console or use the update-table command
- E. Re-create global secondary indexes in the new table
Answer: B,E
NEW QUESTION 29
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. Create an Aurora Global Database.
- C. Enable asynchronous binlog replication.
- D. Enable synchronous replication.
Answer: D
NEW QUESTION 30
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 AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
- B. Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance
- C. Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift
- D. Use DynamoDB Accelerator to offload the reads
Answer: C
NEW QUESTION 31
A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The solution should also automate configuration changes across all Regions.
Which solution would meet these requirements and deploy the DynamoDB tables?
- A. Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-bystep guide for future deployments.
- B. Create an AWS CloudFormation template and deploy the template to all the Regions.
- C. Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.
- D. Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.
Answer: B
NEW QUESTION 32
A software development company is using Amazon Aurora MySQL DB clusters for several use cases, including development and reporting. These use cases place unpredictable and varying demands on the Aurora DB clusters, and can cause momentary spikes in latency. System users run ad-hoc queries sporadically throughout the week. Cost is a primary concern for the company, and a solution that does not require significant rework is needed.
Which solution meets these requirements?
- A. Create new Aurora Serverless DB clusters for development and reporting, then migrate to these new DB clusters.
- B. Change the DB clusters to the burstable instance family.
- C. Upgrade one of the DB clusters to a larger size, and consolidate development and reporting activities on this larger DB cluster.
- D. Use existing DB clusters and stop/start the databases on a routine basis using scheduling tools.
Answer: B
NEW QUESTION 33
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 SQL Server Standard Edition on Amazon RDS.
- B. Run SQL Server Enterprise Edition on Amazon EC2.
- C. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.
- D. Run SQL Server Enterprise Edition on Amazon RDS.
Answer: C
NEW QUESTION 34
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 35
......
Pass Amazon DBS-C01 Premium Files Test Engine pdf - Free Dumps Collection: https://www.dumpsfree.com/DBS-C01-valid-exam.html
DBS-C01 Exam Info and Free Practice Test | DumpsFree: https://drive.google.com/open?id=1YvDbZKUw0rGOUDphch7kLWjlS0FNa7Q6