AWS Cloud Practitioner Questions | Databases
📌 Notice
This is a Quiz accompanying the blog post:
“Pass the AWS Certified Solutions Architect Associate Certification SAA-C03-(Episode 20: Databases)”
🔹 Focus: AWS Cloud Practitioner Preparation Quiz
🔹 For theoretical concepts and exam-style questions, please refer to the main blog post.
Question 1:
Which database helps you store relational datasets, with SQL language compatibility and the capability of processing transactions such as insert, update, and delete?
Correct Answer : (2) Specifically designed for storing relational datasets, supports SQL language, and can handle transactional operations like insert, update, and delete
Question 2:
Which AWS service provides you with caching capability that is compatible with Redis API?
Correct Answer : (4) It provides caching capabilities and is specifically designed to work with the Redis API, allowing for efficient data retrieval and improved application performance. This aligns with the objective of understanding AWS services designed for in-memory data storage solutions.
Question 3:
You want to migrate an on-premises MongoDB NoSQL database to AWS. You don’t want to manage any database servers, so you want to use a managed NoSQL Serverless database, that provides you with high availability, durability, and reliability, and the capability to take your database global. Which database should you choose?
Correct Answer : (2) It is a fully managed, serverless NoSQL database that offers high availability, durability, and the ability to scale globally, making it ideal for migrating your MongoDB database to AWS while minimizing management overhead.
Question 4:
You are looking to perform Online Transaction Processing (OLTP). You would like to use a database that has built-in auto-scaling capabilities and provides you with the maximum number of replicas for its underlying storage. What AWS service do you recommend?
Correct Answer : (3) It is designed for Online Transaction Processing (OLTP), offering auto-scaling capabilities, high performance, and the ability to create up to 15 read replicas, ensuring both availability and efficient data handling. This aligns perfectly with your need for a robust database solution.
Question 5:
As a Solutions Architect, a startup company asked you for help as they are working on an architecture for a social media website where users can be friends with each other, and like each other’s posts. The company plan on performing some complicated queries such as “What are the number of likes on the posts that have been posted by the friends of Mike?”. Which database do you recommend?
Correct Answer : (3) It is specifically built for handling highly connected data in graph format, making it ideal for the complex queries involved in a social media context, such as tracking likes among friends. This is a classic graph traversal query. Choose Neptune. Ideal for social networks, recommendation engines, fraud detection, and knowledge graphs.
🧠 What does this query involve?
- First, find Mike’s friends →
User → Friend relationship - Then get posts made by those friends →
Friend → Post relationship - Then find likes on those posts →
Post → Like relationship
Question 6:
You have a set of files, 100MB each, that you want to store in a reliable and durable key-value store. Which AWS service do you recommend?
Correct Answer : (2) It serves as a reliable and durable key-value store, perfectly suited for storing large files like your 100MB objects. S3’s architecture allows for easy retrieval using the unique object paths as keys, aligning with your needs for efficient storage and access.
Question 7:
A company has an on-premises website that uses ReactJS as its frontend, NodeJS as its backend, and MongoDB for the database. There are some issues with the self-hosted MongoDB database as there is a lot of maintenance required and they don’t have and can’t afford the resources or experience to handle those issues. So, a decision was made to migrate the website to AWS. They have decided to host the frontend ReactJS application in an S3 bucket and the NodeJS backend on a set of EC2 instances. Which AWS service can they use to migrate the MongoDB database that provides them with high scalability and availability without making any code changes?
Correct Answer : (2) It is a fully managed document database service that is compatible with MongoDB, allowing you to migrate your existing database without requiring code changes. This choice provides high scalability and availability, perfectly aligning with your goals to simplify maintenance and utilize AWS services efficiently.
Question 8:
A company using a self-hosted on-premises Apache Cassandra database which they want to migrate to AWS. Which AWS service can they use which provides them with a fully managed, highly available, and scalable Apache Cassandra database?
Correct Answer : (4) It is a fully managed database service compatible with Apache Cassandra, designed to provide high availability and scalability while simplifying the migration process. This aligns perfectly with your need to transition from a self-hosted Cassandra environment to a robust AWS solution.
Question 9:
An online payment company is using AWS to host its infrastructure. Due to the application’s nature, they have a strict requirement to store an accurate record of financial transactions such as credit and debit transactions. Those transactions must be stored in secured, immutable, encrypted storage which can be cryptographically verified. Which AWS service is best suited for this use case?
Correct Answer : (3)
Question 10:
A startup is working on developing a new project to reduce forest fires due to climate change. The startup is developing sensors that will be spread across the entire forest to make some readings such as temperature, humidity, and pressures which will help detect the forest fires before it happens. They are going to have thousands of sensors that are going to store a lot of readings each second. There is a requirement to store those readings and do fast analytics so they can predict if there is a fire. Which AWS service can they use to store those readings?
Correct Answer : (1) It is specifically designed for storing and analyzing time-series data, making it ideal for your startup’s needs of handling and quickly analyzing sensor readings for predicting forest fires. This choice aligns perfectly with the objective of managing large volumes of fast-changing data efficiently.
