Skip to content

3.4

Question 1

A company is deploying a traditional SQL-based customer relationship management application. The company wants AWS to handle database provisioning, patching, backups, and routine maintenance while the application continues to use a relational database. Which AWS service best meets these requirements?

A. Amazon RDS
B. Amazon DynamoDB
C. Amazon ElastiCache
D. Amazon Neptune

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon RDS is a managed relational database service. It simplifies database administration tasks such as provisioning, patching, backups, and recovery for supported relational database engines. * **Why B is incorrect:** Amazon DynamoDB is a managed NoSQL key-value and document database, not a traditional relational database. * **Why C is incorrect:** Amazon ElastiCache provides in-memory caching and is not intended to be the primary relational database for an application. * **Why D is incorrect:** Amazon Neptune is a managed graph database designed for highly connected data and graph relationships.

Question 2

A financial application uses a relational database and requires high performance, high availability, and compatibility with common MySQL or PostgreSQL workloads. The development team wants a cloud-optimized relational database rather than managing database servers. Which AWS service should the company choose?

A. Amazon Aurora
B. Amazon DocumentDB
C. Amazon DynamoDB
D. Amazon Neptune

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon Aurora is a fully managed relational database engine compatible with MySQL and PostgreSQL. It is designed for high performance and availability in AWS. * **Why B is incorrect:** Amazon DocumentDB is a managed document database with MongoDB compatibility, not a relational database. * **Why C is incorrect:** Amazon DynamoDB is a NoSQL key-value and document database and does not provide a traditional relational SQL database model. * **Why D is incorrect:** Amazon Neptune is a graph database for data involving relationships, such as social networks and knowledge graphs.

Question 3

An online gaming company needs a database for player profiles and game-state data. The workload has unpredictable traffic, requires single-digit millisecond performance, and the company does not want to manage database servers. Which AWS service is the best fit?

A. Amazon DynamoDB
B. Amazon RDS
C. Amazon Neptune
D. Amazon ElastiCache

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon DynamoDB is a fully managed NoSQL key-value and document database that provides low-latency performance and can scale to handle changing workloads without server management. * **Why B is incorrect:** Amazon RDS is a managed relational database service and is generally selected when an application requires relational tables and SQL capabilities. * **Why C is incorrect:** Amazon Neptune is designed for graph data and complex relationships, not typical player profile and game-state storage. * **Why D is incorrect:** Amazon ElastiCache is an in-memory caching service. It is commonly used to accelerate access to frequently requested data, but it is not typically the system of record for durable player data.

Question 4

An e-commerce application repeatedly reads product catalog information from its primary database. The company wants to reduce database load and improve response times by storing frequently accessed data in memory. Which AWS service should the company use?

A. Amazon ElastiCache
B. Amazon RDS
C. Amazon DynamoDB
D. AWS Database Migration Service (AWS DMS)

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon ElastiCache provides managed in-memory data stores that can be used to cache frequently accessed information and reduce latency and load on a primary database. * **Why B is incorrect:** Amazon RDS provides managed relational databases, but it is not primarily an in-memory caching service. * **Why C is incorrect:** Amazon DynamoDB is a NoSQL database that can store application data, but the requirement specifically describes an in-memory cache for frequently accessed data. * **Why D is incorrect:** AWS DMS migrates and replicates databases. It does not provide an application caching layer.

Question 5

A company is building a content management application that stores flexible JSON-like documents. The application requires a managed database with compatibility for MongoDB workloads. Which AWS service is most appropriate?

A. Amazon DocumentDB
B. Amazon Aurora
C. Amazon Neptune
D. Amazon ElastiCache

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon DocumentDB is a fully managed document database service designed for applications that use MongoDB compatibility and document-oriented data models. * **Why B is incorrect:** Amazon Aurora is a relational database compatible with MySQL and PostgreSQL workloads, not a document database for MongoDB-compatible applications. * **Why C is incorrect:** Amazon Neptune is a graph database designed for highly connected data and graph queries. * **Why D is incorrect:** Amazon ElastiCache is used for in-memory caching and does not provide the document database capabilities required by the application.

Question 6

A social networking company needs to model relationships among users, such as friendships, followers, and connections. The company wants a managed database designed for highly connected data. Which AWS service should it use?

A. Amazon Neptune
B. Amazon DynamoDB
C. Amazon RDS
D. Amazon DocumentDB

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon Neptune is a managed graph database service designed to store and query highly connected data, such as social relationships and network connections. * **Why B is incorrect:** Amazon DynamoDB is a NoSQL key-value and document database. Although relationships can be represented in DynamoDB, it is not specifically designed as a graph database. * **Why C is incorrect:** Amazon RDS is a relational database service and is not optimized for graph traversal workloads. * **Why D is incorrect:** Amazon DocumentDB is a document database for JSON-like documents and MongoDB-compatible workloads, not a graph database.

Question 7

A company is migrating an on-premises relational database to AWS. The company wants to keep the source database available during the migration and continuously replicate changes to the target database to minimize application downtime. Which AWS service should the company use?

A. AWS Database Migration Service (AWS DMS)
B. AWS Schema Conversion Tool (AWS SCT)
C. Amazon RDS
D. Amazon ElastiCache

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** AWS DMS supports database migration and ongoing replication. It can perform an initial load and replicate ongoing changes so that downtime during cutover can be minimized. * **Why B is incorrect:** AWS SCT helps convert database schemas and code between different database engines. It does not perform the primary data migration and ongoing replication function. * **Why C is incorrect:** Amazon RDS can host the target relational database, but it is not the migration service responsible for replicating data from the source. * **Why D is incorrect:** Amazon ElastiCache is an in-memory caching service and is not used to migrate relational databases.

Question 8

A company wants to migrate a database from one database engine to another. The source and target engines use different schemas and SQL code. The company needs help assessing and converting schema objects and application code before moving the data. Which AWS service should it use?

A. AWS Schema Conversion Tool (AWS SCT)
B. AWS Database Migration Service (AWS DMS)
C. Amazon Aurora
D. Amazon DynamoDB

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** AWS SCT helps convert database schemas, stored procedures, and application code between different database engines when the source and target engines are not fully compatible. * **Why B is incorrect:** AWS DMS is used to migrate and replicate data. For heterogeneous migrations, AWS SCT may be used first to convert the schema and code. * **Why C is incorrect:** Amazon Aurora is a managed relational database target that could be used in a migration, but it does not perform schema conversion. * **Why D is incorrect:** Amazon DynamoDB is a NoSQL database and does not provide schema conversion functionality for relational database engines.

Question 9

A company is selecting a managed AWS database for an application that requires tables, relationships between records, and SQL queries. Which TWO services meet the requirement? (Select TWO)

A. Amazon RDS
B. Amazon Aurora
C. Amazon DynamoDB
D. Amazon Neptune

Click to view Answer & Explanation **Correct Answers:** A and B **Explanation:** * **Why A is correct:** Amazon RDS is a managed service for supported relational database engines and provides relational tables and SQL capabilities. * **Why B is correct:** Amazon Aurora is a managed relational database engine compatible with MySQL and PostgreSQL workloads. * **Why C is incorrect:** Amazon DynamoDB is a NoSQL key-value and document database rather than a relational SQL database. * **Why D is incorrect:** Amazon Neptune is a graph database designed for relationships represented as graph data, not for general-purpose relational table workloads.

Question 10

A company is choosing between hosting a database on an Amazon EC2 instance and using a managed AWS database service. Which TWO situations favor hosting the database on EC2? (Select TWO)

A. The database engine is not supported by Amazon RDS or Amazon Aurora.
B. The company requires full control over the database server operating system and database software installation.
C. The company wants AWS to handle database patching and routine maintenance.
D. The company wants a serverless NoSQL database that automatically scales without managing database instances.

Click to view Answer & Explanation **Correct Answers:** A and B **Explanation:** * **Why A is correct:** Hosting a database on EC2 can be appropriate when the required database engine is not available through a managed service such as Amazon RDS or Amazon Aurora. * **Why B is correct:** EC2 provides greater control over the operating system, database software, configuration, and installation process than a managed database service. * **Why C is incorrect:** Wanting AWS to handle patching and routine maintenance favors a managed service such as Amazon RDS or Amazon Aurora rather than hosting the database on EC2. * **Why D is incorrect:** A serverless NoSQL database with automatic scaling is a use case for Amazon DynamoDB, not for hosting a database on EC2.

Question 11

A company is deploying a business application that requires a managed relational database with automated backups, patching, and support for multiple database engines. Which AWS service best meets these requirements?

A. Amazon RDS
B. Amazon DynamoDB
C. Amazon ElastiCache
D. Amazon Neptune

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon RDS is a managed relational database service that supports database engines such as MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server. AWS manages common administrative tasks such as backups, patching, and infrastructure provisioning. * **Why B is incorrect:** Amazon DynamoDB is a managed NoSQL key-value and document database. * **Why C is incorrect:** Amazon ElastiCache is an in-memory caching service, not a general-purpose relational database. * **Why D is incorrect:** Amazon Neptune is a managed graph database designed for highly connected data.

Question 12

A financial application requires complex SQL queries, transactions, and relationships between customers, accounts, and transactions. The company wants AWS to manage database infrastructure and backups. Which service should the company use?

A. Amazon DynamoDB
B. Amazon RDS
C. Amazon Neptune
D. Amazon ElastiCache

Click to view Answer & Explanation **Correct Answer:** B **Explanation:** * **Why B is correct:** Amazon RDS is appropriate for relational workloads that require SQL, transactions, and relationships between tables. It also reduces administrative overhead through managed backups, patching, and infrastructure management. * **Why A is incorrect:** Amazon DynamoDB is a NoSQL database and is not designed for traditional relational joins and SQL-based relational modeling. * **Why C is incorrect:** Amazon Neptune is designed for graph relationships, such as social networks and recommendation graphs. * **Why D is incorrect:** Amazon ElastiCache provides low-latency, in-memory data access and is commonly used as a cache rather than as the primary relational database.

Question 13

A social media application stores user profiles and session data. The data structure changes frequently, and the application needs single-digit millisecond performance at any scale without managing database servers. Which service is the best choice?

A. Amazon DynamoDB
B. Amazon RDS
C. Amazon Aurora
D. Amazon Neptune

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon DynamoDB is a serverless NoSQL database that supports key-value and document data models, flexible schemas, and low-latency performance at scale. * **Why B is incorrect:** Amazon RDS is a managed relational database service and is better suited for structured relational data and SQL workloads. * **Why C is incorrect:** Amazon Aurora is a relational database engine compatible with MySQL and PostgreSQL. * **Why D is incorrect:** Amazon Neptune is optimized for graph data and relationship-based queries, not general-purpose user profiles and sessions.

Question 14

An online shopping application frequently reads product information that changes infrequently. The database is receiving a large number of repeated requests, and the company wants to reduce database load and improve response times. Which service should the company use?

A. Amazon ElastiCache
B. AWS Database Migration Service (AWS DMS)
C. Amazon Neptune
D. AWS Schema Conversion Tool (AWS SCT)

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon ElastiCache provides in-memory caching using engines such as Redis or Memcached. It can store frequently accessed data close to the application, reducing database load and improving latency. * **Why B is incorrect:** AWS DMS migrates data between databases; it is not a caching service. * **Why C is incorrect:** Amazon Neptune is a managed graph database. * **Why D is incorrect:** AWS SCT converts database schemas and code between database engines; it does not provide application caching.

Question 15

A company is designing an application that analyzes relationships among people, organizations, and their connections. The application must efficiently traverse complex relationships. Which AWS database service should the company choose?

A. Amazon Neptune
B. Amazon RDS
C. Amazon DynamoDB
D. Amazon ElastiCache

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon Neptune is a managed graph database service designed for highly connected datasets and graph use cases such as social networks, knowledge graphs, and fraud detection. * **Why B is incorrect:** Amazon RDS is intended for relational workloads using tables, rows, columns, and SQL. * **Why C is incorrect:** Amazon DynamoDB is a key-value and document database and is not specifically optimized for graph traversals. * **Why D is incorrect:** Amazon ElastiCache is an in-memory caching service, not a graph database.

Question 16

A development team needs a managed relational database that is compatible with MySQL or PostgreSQL and provides improved availability and performance compared with standard open-source database deployments. Which service should the team evaluate?

A. Amazon Aurora
B. Amazon DocumentDB
C. Amazon DynamoDB
D. Amazon ElastiCache

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon Aurora is a managed relational database engine compatible with MySQL and PostgreSQL. It is designed for high performance, availability, and durability while reducing database administration tasks. * **Why B is incorrect:** Amazon DocumentDB is a managed document database with MongoDB compatibility, not a MySQL- or PostgreSQL-compatible relational database. * **Why C is incorrect:** Amazon DynamoDB is a NoSQL key-value and document database. * **Why D is incorrect:** Amazon ElastiCache is used for in-memory caching and data access, not as a relational database engine.

Question 17

A company wants to store product catalog data as JSON documents. The development team uses applications designed for MongoDB compatibility and does not want to manage database servers. Which AWS service is most appropriate?

A. Amazon DocumentDB
B. Amazon Neptune
C. Amazon RDS
D. Amazon Aurora

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon DocumentDB is a managed document database service with compatibility for MongoDB workloads. It is suitable for applications that store and query JSON-like documents. * **Why B is incorrect:** Amazon Neptune is designed for graph databases and relationship-based data. * **Why C is incorrect:** Amazon RDS is a managed relational database service. * **Why D is incorrect:** Amazon Aurora is a managed relational database compatible with MySQL and PostgreSQL, not a document database.

Question 18

A company has an existing database running on an Amazon EC2 instance. The database requires an operating system configuration that is not supported by Amazon RDS, and the database administrators need full control of the operating system and database software. Which approach should the company use?

A. Continue hosting the database on Amazon EC2
B. Migrate the database to Amazon DynamoDB
C. Migrate the database to Amazon ElastiCache
D. Migrate the database to Amazon Neptune

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Hosting a database on Amazon EC2 provides control over the operating system, database software, and configuration. This approach is appropriate when a required database engine or operating system configuration is not supported by a managed service. * **Why B is incorrect:** Amazon DynamoDB is a NoSQL database and would require redesigning the application and data model. * **Why C is incorrect:** Amazon ElastiCache is an in-memory caching service and is not a replacement for a persistent general-purpose database. * **Why D is incorrect:** Amazon Neptune is a graph database and would not provide the same database engine or data model.

Question 19

A company wants to reduce the administrative work associated with database backups, software patching, and infrastructure provisioning. The application uses a supported relational database engine. Which solution provides the most managed approach?

A. Run the database on Amazon EC2
B. Use Amazon RDS
C. Use Amazon ElastiCache on Amazon EC2
D. Use Amazon Neptune on Amazon EC2

Click to view Answer & Explanation **Correct Answer:** B **Explanation:** * **Why B is correct:** Amazon RDS is a managed relational database service. AWS handles much of the underlying infrastructure administration, including supported backup, patching, and provisioning activities. * **Why A is incorrect:** A database hosted on Amazon EC2 requires the customer to manage the operating system, database software, backups, and many maintenance tasks. * **Why C is incorrect:** Amazon ElastiCache is an in-memory caching service and does not provide a managed relational database. * **Why D is incorrect:** Amazon Neptune is a managed graph database, not a general-purpose relational database service.

Question 20

A company needs to migrate data from an on-premises PostgreSQL database to an Amazon RDS for PostgreSQL database. The company wants to minimize downtime and continuously replicate changes during the migration. Which service should it use?

A. AWS Database Migration Service (AWS DMS)
B. AWS Schema Conversion Tool (AWS SCT)
C. Amazon ElastiCache
D. Amazon Neptune

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** AWS DMS supports database migrations and can perform ongoing replication, helping keep the target database synchronized with changes made to the source during a migration. * **Why B is incorrect:** AWS SCT is primarily used to convert database schemas and application code between different database engines. It is not the primary service for ongoing data replication. * **Why C is incorrect:** Amazon ElastiCache is an in-memory caching service. * **Why D is incorrect:** Amazon Neptune is a graph database and is not a database migration service.

Question 21

A company is migrating from an Oracle database to an Amazon Aurora PostgreSQL-Compatible database. The company needs to convert tables, indexes, and other schema objects between the database engines. Which tool should it use?

A. AWS Schema Conversion Tool (AWS SCT)
B. AWS Database Migration Service (AWS DMS)
C. Amazon DynamoDB
D. Amazon ElastiCache

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** AWS SCT helps convert database schemas and application code from one database engine to another, such as from Oracle to PostgreSQL-compatible databases. * **Why B is incorrect:** AWS DMS is used to migrate and replicate data. It does not primarily convert incompatible schemas and database code. * **Why C is incorrect:** Amazon DynamoDB is a NoSQL database and is not a schema conversion tool. * **Why D is incorrect:** Amazon ElastiCache provides in-memory caching and does not convert database schemas.

Question 22

A company is migrating a database between two different database engines. The source and target engines use different data types and SQL syntax. Which two AWS capabilities can help complete the migration? (Select TWO)

A. AWS Schema Conversion Tool (AWS SCT)
B. AWS Database Migration Service (AWS DMS)
C. Amazon ElastiCache
D. Amazon Neptune

Click to view Answer & Explanation **Correct Answers:** A and B **Explanation:** * **Why A is correct:** AWS SCT can convert schemas, database objects, and some application code between different database engines. * **Why B is correct:** AWS DMS can migrate data from the source database to the target database and can support ongoing replication during a migration. * **Why C is incorrect:** Amazon ElastiCache is used for in-memory caching, not database engine conversion or migration. * **Why D is incorrect:** Amazon Neptune is a graph database and does not provide general-purpose schema conversion or database migration capabilities.

Question 23

A company is building a gaming application that requires extremely fast access to temporary player session data. The data can be regenerated if lost, and the company wants to avoid repeatedly querying the primary database. Which service is most appropriate?

A. Amazon ElastiCache
B. Amazon RDS
C. AWS DMS
D. Amazon DocumentDB

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon ElastiCache provides low-latency, in-memory storage that is well suited for temporary session data, frequently accessed values, and reducing load on a primary database. * **Why B is incorrect:** Amazon RDS is a managed relational database service and is not optimized as an in-memory session cache. * **Why C is incorrect:** AWS DMS migrates and replicates database data; it does not store application session data for fast access. * **Why D is incorrect:** Amazon DocumentDB is a persistent document database, not an in-memory cache.

Question 24

A logistics company stores shipment records with a fixed structure and requires SQL queries, transactions, and referential relationships between shipments, customers, and invoices. Which database category best matches this workload?

A. Relational database
B. Key-value database
C. Graph database
D. In-memory cache

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Relational databases organize structured data into tables and support SQL, transactions, and relationships between entities. Amazon RDS and Amazon Aurora are examples of AWS relational database services. * **Why B is incorrect:** Key-value databases, such as Amazon DynamoDB, are optimized for access by keys and flexible NoSQL data models. * **Why C is incorrect:** Graph databases, such as Amazon Neptune, are optimized for traversing relationships between entities. * **Why D is incorrect:** An in-memory cache, such as Amazon ElastiCache, is primarily used for very fast temporary or frequently accessed data.

Question 25

A mobile application must support millions of users and requires a serverless database that automatically scales without the operations team managing database servers. The application primarily retrieves records using a unique key. Which service should the company select?

A. Amazon DynamoDB
B. Amazon RDS
C. Amazon Neptune
D. Amazon DocumentDB

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon DynamoDB is a managed NoSQL database that supports key-value access, automatic scaling options, and serverless operation without requiring customers to manage database servers. * **Why B is incorrect:** Amazon RDS is managed, but it is a relational database service that generally requires selecting and managing database capacity and is not primarily designed for key-value access at massive scale. * **Why C is incorrect:** Amazon Neptune is designed for graph workloads. * **Why D is incorrect:** Amazon DocumentDB is designed for document database workloads and MongoDB compatibility rather than simple key-value access.

Question 26

A company is moving an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The company wants to migrate the existing data with minimal interruption to the application. Which service is designed for this task?

A. AWS Database Migration Service (AWS DMS)
B. AWS Schema Conversion Tool (AWS SCT)
C. Amazon Aurora
D. Amazon ElastiCache

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** AWS DMS is designed to migrate data between supported database sources and targets, including on-premises databases and Amazon RDS. It can also replicate ongoing changes to reduce downtime. * **Why B is incorrect:** AWS SCT is mainly used when schema or code conversion is required between different database engines. Both the source and target in this scenario use SQL Server, so data migration is the primary requirement. * **Why C is incorrect:** Amazon Aurora is a database engine, not a database migration service. * **Why D is incorrect:** Amazon ElastiCache is a caching service and does not migrate relational databases.

Question 27

A healthcare company needs to build a knowledge graph connecting patients, treatments, providers, and medical research. The application must identify indirect relationships and traverse connections efficiently. Which service is the best fit?

A. Amazon Neptune
B. Amazon DynamoDB
C. Amazon RDS
D. Amazon DocumentDB

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** Amazon Neptune is designed for graph workloads where the relationships between entities are as important as the entities themselves. It is appropriate for knowledge graphs and connected data. * **Why B is incorrect:** Amazon DynamoDB is a key-value and document database and does not provide a graph-optimized data model. * **Why C is incorrect:** Amazon RDS is optimized for relational tables and SQL queries rather than graph traversals. * **Why D is incorrect:** Amazon DocumentDB is a document database and is not designed specifically for graph relationships.

Question 28

A company is evaluating whether to use a database hosted on Amazon EC2 or a managed AWS database service. The team wants AWS to handle routine database maintenance while the application uses a standard relational database engine. Which two benefits support choosing Amazon RDS? (Select TWO)

A. AWS manages supported database infrastructure maintenance tasks
B. The service supports relational database engines
C. The customer must install and patch the operating system manually
D. The service is an in-memory cache rather than a persistent database

Click to view Answer & Explanation **Correct Answers:** A and B **Explanation:** * **Why A is correct:** Amazon RDS reduces administrative effort by managing much of the underlying infrastructure and supporting tasks such as backups and patching. * **Why B is correct:** Amazon RDS supports relational database engines and is appropriate for applications that require SQL and relational data models. * **Why C is incorrect:** Manually installing and patching the operating system is more characteristic of hosting a database directly on Amazon EC2, not using Amazon RDS. * **Why D is incorrect:** Amazon RDS is a persistent managed relational database service. An in-memory cache is provided by Amazon ElastiCache.

Question 29

An application stores flexible JSON documents representing product listings. Different listings can have different attributes, and the company wants a managed NoSQL database. Which two AWS services could be considered for this type of workload? (Select TWO)

A. Amazon DynamoDB
B. Amazon DocumentDB
C. Amazon Neptune
D. Amazon ElastiCache

Click to view Answer & Explanation **Correct Answers:** A and B **Explanation:** * **Why A is correct:** Amazon DynamoDB supports a flexible NoSQL document data model and is suitable for applications that store and retrieve document-style records. * **Why B is correct:** Amazon DocumentDB is a managed document database service that is appropriate for JSON-like document workloads, particularly applications using MongoDB-compatible interfaces. * **Why C is incorrect:** Amazon Neptune is designed for graph data and relationship traversal, not general-purpose document storage. * **Why D is incorrect:** Amazon ElastiCache is an in-memory caching service and is not typically used as the durable primary store for product listings.

Question 30

A company needs to migrate data from an on-premises database to an AWS database. The source and target databases use different engines, and the source schema includes database objects that are not directly compatible with the target. Which sequence best addresses the migration?

A. Use AWS SCT to convert the schema, then use AWS DMS to migrate the data
B. Use Amazon ElastiCache to convert the schema, then use Amazon Neptune to migrate the data
C. Use Amazon RDS to convert the schema, then use Amazon DynamoDB to replicate the data
D. Use Amazon Neptune to convert the schema, then use AWS SCT to provide ongoing replication

Click to view Answer & Explanation **Correct Answer:** A **Explanation:** * **Why A is correct:** AWS SCT helps convert schemas and database code between different database engines. AWS DMS then migrates the data and can replicate ongoing changes during the migration. * **Why B is incorrect:** Amazon ElastiCache does not convert schemas, and Amazon Neptune is a graph database rather than a general-purpose data migration service. * **Why C is incorrect:** Amazon RDS is a database service, not a schema conversion tool, and Amazon DynamoDB is not a general-purpose replication target for relational databases without application redesign. * **Why D is incorrect:** Amazon Neptune does not convert relational schemas, and AWS SCT does not provide ongoing data replication. AWS DMS provides that migration capability.