Amazon Web Services Updated DBS-C01 Exam Questions and Answers by avery

The fastest way to replicate all the data from the original table is to use AWS Database Migration Service (AWS DMS) with ongoing replication in inline LOB mode. This option allows AWS DMS to transfer LOBs smaller than the specified size inline, which means that they are fetched from the database in bulk as VARCHAR data types. This is significantly faster than other methods that require piece-by-piece migration of LOBs. LOBs larger than the specified size are replicated using full LOB mode, which means that they are migrated one at a time. This option is suitable for the scenario where most of the LOB data is smaller than 32 KB, and only a few records are large in size. Using inline LOB mode can also avoid data truncation that might occur in limited LOB mode, where LOBs that exceed the maximum LOB size are cut off and a warning is issued to the log file. Full LOB mode can be quite slow, as it migrates all LOBs regardless of size, and it does not pre-allocate memory or load the LOB data in bulk. Taking a snapshot of the database and creating a new DB instance by using the snapshot is not a valid option, as it does not meet the requirement of updating the new table with any changes to the original table that happen while the migration is in progress

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.LOBSupport.html

Amazon Neptune is a fast, reliable, fully managed graph database service that makes it easy to build and run applications that work with highly connected data sets1. Graph databases are designed to store and query data that has complex relationships and interconnections, such as social networks, recommendation engines, fraud detection, and knowledge graphs2. Amazon Neptune supports two popular graph models: Property Graph and Resource Description Framework (RDF), and their respective query languages: Apache TinkerPop Gremlin and SPARQL2.

Amazon Neptune also supports IAM policies to control access to the database resources and operations. You can use IAM database authentication to authenticate users and applications that connect to a Neptune DB cluster. IAM database authentication works with MySQL and PostgreSQL database clients. You can also use IAM roles to manage access to Neptune from other AWS services, such as Amazon EC2, AWS Lambda, and Amazon SageMaker2.

Therefore, Amazon Neptune DB cluster is a suitable solution for the marketing company’s requirements, as it can provide a graph database storage solution that is optimized for highly connected data and can limit connections and programmatic access by using IAM policies.

https://aws.amazon.com/dynamodb/dax/#:~:text=Amazon%20DynamoDB%20Accelerator%20(DAX)%20is,millions%20of%20requests%20per%20second. "Amazon DynamoDB Accelerator (DAX) is a fully managed, highly available, in-memory cache for DynamoDB that delivers up to a 10x performance improvement – from milliseconds to microseconds – even at millions of requests per second. "