ExamGecko
Home / Amazon / DBS-C01 / List of questions
Ask Question

Amazon DBS-C01 Practice Test - Questions Answers, Page 17

Add to Whishlist

List of questions

Question 161

Report Export Collapse

A company is running its customer feedback application on Amazon Aurora MySQL. The company runs a report every day to extract customer feedback, and a team reads the feedback to determine if the customer comments are positive or negative. It sometimes takes days before the company can contact unhappy customers and take corrective measures. The company wants to use machine learning to automate this workflow.

Which solution meets this requirement with the LEAST amount of effort?

Become a Premium Member for full access
  Unlock Premium Member

Question 162

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 163

Report Export Collapse

For the first time, a database professional is establishing a test graph database on Amazon Neptune. Thedatabase expert must input millions of rows of test observations from an Amazon S3.csv file. Thedatabase professional uploaded the data to the Neptune DB instance through a series of API calls.Which sequence of actions enables the database professional to upload the data most quickly? (Select three.)

Become a Premium Member for full access
  Unlock Premium Member

Question 164

Report Export Collapse

A financial services company has an application deployed on AWS that uses an Amazon Aurora PostgreSQL DB cluster. A recent audit showed that no log files contained database administrator activity. A database specialist needs to recommend a solution to provide database access and activity logs. The solution should use the least amount of effort and have a minimal impact on performance.

Which solution should the database specialist recommend?

Become a Premium Member for full access
  Unlock Premium Member

Question 165

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 166

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 167

Report Export Collapse

A financial institution uses AWS to host its online application. Amazon RDS for MySQL is used to host the application's database, which includes automatic backups.

The program has corrupted the database logically, resulting in the application being unresponsive.

The exact moment the corruption occurred has been determined, and it occurred within the backup retention period.

How should a database professional restore a database to its previous state prior to corruption?

Become a Premium Member for full access
  Unlock Premium Member

Question 168

Report Export Collapse

An worldwide gaming company's development team is experimenting with using Amazon DynamoDB to store in-game events for three mobile titles. Maximum concurrent users for the most popular game is 500,000, while the least popular game is 10,000. The typical event is 20 KB in size, while the average user session generates one event each second. Each event is assigned a millisecond time stamp and a globally unique identification.

The lead developer generated a single DynamoDB database with the following structure for the events:

Partition key: game name Sort key: event identifier Local secondary index: player identifier Event time In a small-scale development setting, the tests were successful. When the application was deployed to production, however, new events were not being added to the database, and the logs indicated DynamoDB failures with the ItemCollectionSizeLimitExceededException issue code.

Which design modification should a database professional offer to the development team?

Become a Premium Member for full access
  Unlock Premium Member

Question 169

Report Export Collapse

A business's mission-critical production workload is being operated on a 500 GB Amazon Aurora MySQL DB cluster. A database engineer must migrate the workload without causing data loss to a new Amazon Aurora Serverless MySQL DB cluster.

Which approach will result in the LEAST amount of downtime and the LEAST amount of application impact?

Become a Premium Member for full access
  Unlock Premium Member

Question 170

Report Export Collapse

A database professional is developing an application that will respond to single-instance requests.

The program will query large amounts of client data and offer end users with results.

These reports may include a variety of fields. The database specialist want to enable users to query the database using any of the fields offered.

During peak periods, the database's traffic volume will be significant yet changeable. However, the database will see little activity over the rest of the day.

Which approach will be the most cost-effective in meeting these requirements?

Become a Premium Member for full access
  Unlock Premium Member
Total 321 questions
Go to page: of 33
Search

Related questions