[Jan 11, 2022] DBS-C01 Exam Dumps PDF Updated Dump from TestValid Guaranteed Success
Pass Your Amazon Exam with DBS-C01 Exam Dumps
Understanding functional and technical aspects of AWS Certified Database - Specialty - Deployment and Migration
The following will be discussed in AMAZON DBS-C01 dumps:
- Determine data preparation and migration strategies
- Execute and validate data migration
- Automate database solution deployments
Below is a salary of AWS Certified Database Specialty Certified Professional
- India: 7,63,709 INR
- United States: 108,849 USD
- England: 83,255 Pound
- Europe: 98,725 Euro
NEW QUESTION 73
A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy.
Which backup methodology should the database specialist use to MINIMIZE management overhead?
- A. Create a backup plan using AWS Backup, specify a backup frequency of every 24 hours, and give the plan a nightly backup window.
- B. Create an AWS Lambda function that creates a backup of the DynamoDB table. Create an Amazon CloudWatch Events rule that executes the Lambda function on a nightly basis.
- C. Install the AWS CLI on an Amazon EC2 instance. Write a CLI command that creates a backup of the DynamoDB table. Create a scheduled job or task that executes the command on a nightly basis.
- D. Configure DynamoDB backup and restore for an on-demand backup frequency of every 24 hours.
Answer: D
Explanation:
On-demand backup allows you to create full backups of your Amazon DynamoDB table for data archiving, helping you meet your corporate and governmental regulatory requirements. You can back up tables from a few megabytes to hundreds of terabytes of data, with no impact on performance and availability to your production applications. Backups process in seconds regardless of the size of your tables, so you do not have to worry about backup schedules or long-running processes. In addition, all backups are automatically encrypted, cataloged, easily discoverable, and retained until explicitly deleted.
NEW QUESTION 74
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 75
A company has an application that uses an Amazon DynamoDB table to store user dat a. 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. Enable auto scaling for the DynamoDB table.
- D. Double the table's provisioned RCUs.
Answer: B
NEW QUESTION 76
A company's database specialist disabled TLS on an Amazon DocumentDB cluster to perform benchmarking tests. A few days after this change was implemented, a database specialist trainee accidentally deleted multiple tables. The database specialist restored the database from available snapshots. An hour after restoring the cluster, the database specialist is still unable to connect to the new cluster endpoint.
What should the database specialist do to connect to the new, restored Amazon DocumentDB cluster?
- A. Change the restored cluster's parameter group to the Amazon DocumentDB default parameter group.
- B. Change the restored cluster's parameter group to the original cluster's custom parameter group.
- C. Run the syncInstances command in AWS DataSync.
- D. Configure the interface VPC endpoint and associate the new Amazon DocumentDB cluster.
Answer: A
NEW QUESTION 77
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 78
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. 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.
- C. 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.
- D. 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.
Answer: C
NEW QUESTION 79
A ride-hailing application uses an Amazon RDS for MySQL DB instance as persistent storage for bookings. This application is very popular and the company expects a tenfold increase in the user base in next few months. The application experiences more traffic during the morning and evening hours.
This application has two parts:
An in-house booking component that accepts online bookings that directly correspond to simultaneous requests from users.
A third-party customer relationship management (CRM) component used by customer care representatives. The CRM uses queries to access booking data.
A database specialist needs to design a cost-effective database solution to handle this workload. Which solution meets these requirements?
- A. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
- B. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
- C. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.
- D. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
Answer: C
NEW QUESTION 80
A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?
- A. Configure RDS Storage Auto Scaling.
- B. Modify the DB instance allocated storage to meet the forecasted requirements.
- C. Configure RDS instance Auto Scaling.
- D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
Answer: C
NEW QUESTION 81
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 82
A startup company is building a new application to allow users to visualize their on-premises and cloud networking components. The company expects billions of components to be stored and requires responses in milliseconds. The application should be able to identify:
The networks and routes affected if a particular component fails.
The networks that have redundant routes between them.
The networks that do not have redundant routes between them.
The fastest path between two networks.
Which database engine meets these requirements?
- A. Amazon ElastiCache for Redis
- B. Amazon Aurora MySQL
- C. Amazon DynamoDB
- D. Amazon Neptune
Answer: D
NEW QUESTION 83
A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.
What should the company do to achieve this in the shortest amount of time?
- A. Use RDS fault injection queries to simulate the primary node failure
- B. Use the RDS console to reboot the DB instance by choosing the option to reboot with failover
- C. Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone
- D. Use a blue-green deployment with a complete application-level failover test
Answer: A
NEW QUESTION 84
A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier. The database is used primarily during business hours with random activity peaks throughout the day. A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company's migration to AWS.
Which MySQL database option would meet these requirements?
- A. Amazon RDS for MySQL with read replica
- B. Amazon Aurora MySQL cluster
- C. Amazon Aurora Serverless MySQL cluster
- D. Amazon RDS for MySQL with Multi-AZ
Answer: B
NEW QUESTION 85
A company needs to migrate Oracle Database Standard Edition running on an Amazon EC2 instance to an Amazon RDS for Oracle DB instance with Multi-AZ. The database supports an ecommerce website that runs continuously. The company can only provide a maintenance window of up to 5 minutes.
Which solution will meet these requirements?
- A. Export the Oracle database from the EC2 instance using Oracle Data Pump and perform an import into Amazon RDS. Stop the application for the entire process. When the import is complete, change the database connection string and then restart the application.
- B. Configure AWS DataSync with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.
- C. Configure AWS DMS with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.
- D. Configure Oracle Real Application Clusters (RAC) on the EC2 instance and the RDS DB instance. Update the connection string to point to the RAC cluster. Once the EC2 instance and RDS DB instance are in sync, fail over from Amazon EC2 to Amazon RDS.
Answer: A
NEW QUESTION 86
The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real-time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.
Which approach will meet these requirements?
- A. Use pg_audit to generate audit logs and send the logs to the Security team.
- B. Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
- C. Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.
- D. Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.
Answer: B
NEW QUESTION 87
A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists.
Which step should be taken to troubleshoot this issue?
- A. Ensure that the RDS DB instance has not reached its maximum connections limit
- B. Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listeningfor encrypted connections
- C. Ensure that the database option group for the RDS DB instance allows ingress from the Developermachine's IP address
- D. Ensure that the RDS DB instance's subnet group includes a public subnet to allow the Developer toconnect
Answer: D
NEW QUESTION 88
A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster. The company requires a very low RTO and needs to improve the application recovery time after database failovers.
Which approach meets these requirements?
- A. Enable the query cache at the instance level.
- B. Set the max_connections parameter to 16,000 in the instance-level parameter group.
- C. Create an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.
- D. Modify the client connection timeout to 300 seconds.
Answer: A
NEW QUESTION 89
A company has migrated a single MySQL database to Amazon Aurora. 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 thereplicas to be deleted and re-created nightly.
- B. Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases inVPC_TEST using Aurora Serverless.
- C. Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, andscript the clones to be deleted and re-created nightly.
- D. Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to bedeleted and re-created nightly.
Answer: D
NEW QUESTION 90
A company is due for renewing its database license. The company wants to migrate its 80 TB transactional database system from on-premises to the AWS Cloud. The migration should incur the least possible downtime on the downstream database applications. The company's network infrastructure has limited network bandwidth that is shared with other applications.
Which solution should a database specialist use for a timely migration?
- A. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS SCT to handle syncing change data capture (CDC) data from the source to the target database.
- B. Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Periodically perform incremental backups of the source database to be shipped in another Snowball Edge appliance to handle syncing change data capture (CDC) data from the source to the target database.
- C. Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Use AWS DMS to migrate change data capture (CDC) data from the source database to Amazon S3. Use a second AWS DMS task to migrate all the S3 data to the target database.
- D. Use AWS DMS to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS DMS to handle syncing change data capture (CDC) data from the source to the target database.
Answer: A
NEW QUESTION 91
......
New Real DBS-C01 Exam Dumps Questions: https://www.testvalid.com/DBS-C01-exam-collection.html
DBS-C01 Exam Dumps - Amazon Practice Test Questions: https://drive.google.com/open?id=1cVA2D036mw35BF_I9nFkgWyLb4vT-_Yb