DBS-C01 Dumps To Pass Amazon Exam in 24 Hours - PassReview
Buy Latest DBS-C01 Exam Q&A PDF - One Year Free Update
Below are advantages of Getting the AWS Certified Database Specialty Certification Exam
Amazon AWS Certified Database - Specialty has more useful and relevant networks that help them in setting career goals for themselves. Amazon AWS Certified Database - Specialty networks provide them with the right career direction than non certified usually are unable to get.
Amazon AWS Certified Database - Specialty Certification provides practical experience to candidates from all the aspects to be a proficient worker in the organization.
Amazon AWS Certified Database - Specialty has the knowledge to use the tools to complete the task efficiently and cost effectively than the other non-certified professionals lack in doing so.
Amazon AWS Certified Database - Specialty is distinguished among competitors. Amazon AWS Certified Database - Specialty certification can give them an edge at that time easily when candidates appear for a job interview employers seek to notify something which differentiates the individual to another.
Amazon AWS Certified Database - Specialty Certifications provide opportunities to get a job easily in which they are interested in instead of wasting years and ending without getting any experience.
NEW QUESTION 61
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 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
- B. 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.
- 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. Create 12 Aurora Replicas in VPC_TEST, and script the replicas to be deleted and re-created nightly.
Answer: A
NEW QUESTION 62
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. Amazon DynamoDB global tables
- C. An Amazon Aurora global database
- D. An Amazon ElastiCache for Redis cluster with cluster mode enabled and multiple shards
Answer: B
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 63
A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company's main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.
Which solution meets these requirements?
- A. Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replicain the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.
- B. Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the apnortheast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cacheapplication data from the replica to generate the dashboards.
- C. Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replicainstance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
- D. Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1Region. Use Amazon QuickSight for displaying dashboard results.
Answer: A
NEW QUESTION 64
A business is transferring a database from one AWS Region to another using an Amazon RDS for SQL Server DB instance. The organization wishes to keep database downtime to a minimum throughout the transfer.
Which migration strategy should the organization use for this cross-regional move?
- A. Back up the source database using native backup to an Amazon S3 bucket in the same Region. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Region. Then restore the backup in the target Region.
- B. Add an RDS for SQL Server cross-Region read replica in the target Region. Once the replication is in sync, promote the read replica to master.
- C. Back up the source database using native backup to an Amazon S3 bucket in the same Region. Then restore the backup in the target Region.
- D. Configure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target databases. Once the replication is in sync, terminate the DMS task.
Answer: D
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.XRgn.html With Amazon RDS, you can create a MariaDB, MySQL, Oracle, or PostgreSQL read replica in a different AWS Region from the source DB instance. Creating a cross-Region read replica isn't supported for SQL Server on Amazon RDS.
NEW QUESTION 65
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. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
- B. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
- C. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.
- D. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
Answer: B
Explanation:
Explanation
https://aws.amazon.com/blogs/database/best-practices-for-migrating-rds-for-mysql-databases-to-amazon-aurora/
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraP
NEW QUESTION 66
An online retail company is planning a multi-day flash sale that must support processing of up to 5,000 orders per second. The number of orders and exact schedule for the sale will vary each day. During the sale, approximately 10,000 concurrent users will look at the deals before buying items. Outside of the sale, the traffic volume is very low. The acceptable performance for read/write queries should be under 25 ms. Order items are about 2 KB in size and have a unique identifier. The company requires the most cost-effective solution that will automatically scale and is highly available.
Which solution meets these requirements?
- A. Amazon DynamoDB with on-demand capacity mode
- B. Amazon Aurora with one writer node and an Aurora Replica with the parallel query feature enabled
- C. Amazon DynamoDB with provisioned capacity mode with 5,000 write capacity units (WCUs) and 10,000 read capacity units (RCUs)
- D. Amazon Aurora with one writer node and two cross-Region Aurora Replicas
Answer: C
NEW QUESTION 67
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. Select the option to apply the change immediately
- B. Apply the change manually by rebooting the DB instance during the approved maintenance window
- C. Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
- D. Reboot the secondary Multi-AZ DB instance
Answer: D
NEW QUESTION 68
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. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
- B. Enable a read replicas and direct read traffic to it when Amazon RDS is down
- C. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
- D. Enable an Amazon RDS for MySQL Multi-AZ configuration
Answer: D
Explanation:
Explanation
https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/ To minimize downtime, modify the Amazon RDS DB instance to a Multi-AZ deployment. For Multi-AZ deployments, OS maintenance is applied to the secondary instance first, then the instance fails over, and then the primary instance is updated. The downtime is during failover. For more information, see Maintenance for Multi-AZ Deployments. https://aws.amazon.com/rds/faqs/ The availability benefits of Multi-AZ also extend to planned maintenance. For example, with automated backups, I/O activity is no longer suspended on your primary during your preferred backup window, since backups are taken from the standby. In the case of patching or DB instance class scaling, these operations occur first on the standby, prior to automatic fail over.
As a result, your availability impact is limited to the time required for automatic failover to complete.
NEW QUESTION 69
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 an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance
- C. Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
- D. Use DynamoDB Accelerator to offload the reads
Answer: D
Explanation:
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 70
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. Change the application to call DescribeTable periodically until the TableStatus is ACTIVE, then call PutItem.
- D. Add an allow statement for the dynamodb:PutItem action in a policy attached to the role used by the application creating the table.
Answer: A
NEW QUESTION 71
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. 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.
- 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. 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.
Answer: A
NEW QUESTION 72
A company has a production environment running on Amazon RDS for SQL Server with an in-house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries.
How should the company identify the source of the problem?
- A. Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
- B. Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.
- C. Use AWS X-Ray deployed with Amazon RDS to track query system traces.
- D. Create a support request and work with AWS Support to identify the source of the issue.
Answer: A
NEW QUESTION 73
A company is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs).
The site performs a high number of repetitive reads and writes each second on an Amazon RDS for MySQL Multi- AZ DB instance with General Purpose SSD (gp2) storage. After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance.
Which approach should the database specialist to take to resolve this issue without changing the application?
- A. Implementing sharding to distribute the load to multiple RDS for MySQL databases.
- B. Use the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.
- C. Add an RDS for MySQL read replica.
- D. Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS).
Answer: D
NEW QUESTION 74
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. Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
- B. Enable email notifications for AWS Trusted Advisor.
- C. Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
- D. Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
- E. Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
Answer: C,D
NEW QUESTION 75
To meet new data compliance requirements, a company needs to keep critical data durably stored and readily accessible for 7 years. Data that is more than 1 year old is considered archival data and must automatically be moved out of the Amazon Aurora MySQL DB cluster every week. On average, around 10 GB of new data is added to the database every month. A database specialist must choose the most operationally efficient solution to migrate the archival data to Amazon S3.
Which solution meets these requirements?
- A. Configure an AWS Lambda function that exports archival data from the DB cluster to Amazon S3 using a SELECT INTO OUTFILE S3 statement, then deletes the archival data from the DB cluster. Schedule the Lambda function to run weekly using Amazon EventBridge (Amazon CloudWatch Events).
- B. Configure two AWS Lambda functions: one that exports archival data from the DB cluster to Amazon S3 using the mysqldump utility, and another that deletes the archival data from the DB cluster. Schedule both Lambda functions to run weekly using Amazon EventBridge (Amazon CloudWatch Events).
- C. Use AWS Database Migration Service (AWS DMS) to continually export the archival data from the DB cluster to Amazon S3. Configure an AWS Data Pipeline process to run weekly that executes a custom SQL script to delete the archival data from the DB cluster.
- D. Create a custom script that exports archival data from the DB cluster to Amazon S3 using a SQL view, then deletes the archival data from the DB cluster. Launch an Amazon EC2 instance with a weekly cron job to execute the custom script.
Answer: B
NEW QUESTION 76
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 Neptune
- B. Amazon DynamoDB
- C. Amazon Aurora MySQL
- D. Amazon ElastiCache for Redis
Answer: A
NEW QUESTION 77
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. Encrypt the table from the AWS Management Console or use the update-table command
- B. Define IAM policies for access to the new table
- C. Set the provisioned read and write capacity
- D. Re-create global secondary indexes in the new table
- E. Define the TTL settings
Answer: C,D
NEW QUESTION 78
A corporation is transitioning from an IBM Informix database to an Amazon RDS for SQL Server Multi-AZ implementation with Always On Availability Groups (AGs). SQL Server Agent tasks are scheduled to execute at 5-minute intervals on the Always On AG listener to synchronize data between the Informix and SQL Server databases. After a successful failover to the backup node with minimum delay, users endure hours of stale data.
How can a database professional guarantee that consumers view the most current data after a failover?
- A. Break up large transactions into multiple smaller transactions that complete in less than 5 minutes.
- B. Set the databases on the secondary node to read-only mode.
- C. Set TTL to less than 30 seconds for cached DNS values on the Always On AG listener.
- D. Create the SQL Server Agent jobs on the secondary node from a script when the secondary node takes over after a failure.
Answer: D
Explanation:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html If you have SQL Server Agent jobs, recreate them on the secondary. You do so because these jobs are stored in the msdb database, and you can't replicate this database by using Database Mirroring (DBM) or Always On Availability Groups (AGs). Create the jobs first in the original primary, then fail over, and create the same jobs in the new primary.
NEW QUESTION 79
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 DynamoDB
- B. Amazon Elasticsearch Service
- C. Amazon Neptune
- D. Amazon ElastiCache
- E. Amazon Redshift
Answer: A,D
NEW QUESTION 80
A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS. The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity. A Database Specialist wants to ensure that the changes made by the Application team will not change the Amazon RDS database resources already deployed.
Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)
- A. Review the stack drift before modifying the template
- B. Export the database resources as stack outputs
- C. Create and review a change set before applying it
- D. Set a stack policy for the database resources
- E. Define the database resources in a nested stack
Answer: C,D
Explanation:
Explanation
https://docs.amazonaws.cn/en_us/AWSCloudFormation/latest/UserGuide/best-practices.html#cfn-best-practices-
NEW QUESTION 81
......
Download the Latest DBS-C01 Dump - 2022 DBS-C01 Exam Question Bank: https://www.passreview.com/DBS-C01_exam-braindumps.html
Latest Amazon DBS-C01 Certification Practice Test Questions: https://drive.google.com/open?id=1QYPIK7pnoTxE4jFiDoLoLb_Q6fwIoS3I