All fields

“RDS & Databases” in Information Technology

34 questions across 3 technologies.

Information Technology

34 questions in 3 technologies

#QuestionTechnologyTopicLevel
1What is Amazon RDS and what benefits does it provide over managing a database server yourself on EC2? AWS › RDS & DatabasesAWSRDS & DatabasesBeginner
2What is Multi-AZ deployment in RDS, and how does it improve database availability? AWS › RDS & DatabasesAWSRDS & DatabasesBeginner
3What is the difference between an RDS read replica and a Multi-AZ standby instance, and when should you use each? AWS › RDS & DatabasesAWSRDS & DatabasesIntermediate
4What is Amazon Aurora, and how does it differ from standard RDS MySQL or PostgreSQL in terms of performance and architecture? AWS › RDS & DatabasesAWSRDS & DatabasesIntermediate
5How does automated backup and point in time recovery work in RDS, and what recovery options does it provide? AWS › RDS & DatabasesAWSRDS & DatabasesIntermediate
6How does RDS Proxy help applications manage database connections more efficiently, particularly for serverless architectures using Lambda? AWS › RDS & DatabasesAWSRDS & DatabasesAdvanced
7How should an organization design a comprehensive database resilience and disaster recovery strategy combining Multi-AZ, read replicas, cross region replication, and automated backups? AWS › RDS & DatabasesAWSRDS & DatabasesAdvanced
8What is Amazon Redshift and how is it different from a typical relational database like RDS? AWS › Amazon Redshift & Data WarehousingAWSAmazon Redshift & Data WarehousingBeginner
9How does GuardDuty support monitoring for threats specific to Amazon S3, EKS, and RDS beyond general EC2 and account level threats? AWS › AWS Security Hub & GuardDutyAWSAWS Security Hub & GuardDutyIntermediate
10How should passwords be securely stored in a Node.js application's database, and why is bcrypt commonly used? Node.js › Authentication & AuthorizationNode.jsAuthentication & AuthorizationBeginner
11How does Doctrine ORM integrate with Symfony to let you work with database records as PHP objects, and what role do entities play in this? PHP › Symfony Framework EssentialsPHPSymfony Framework EssentialsIntermediate
12What is Amazon DynamoDB and what type of database is it? AWS › Amazon DynamoDBAWSAmazon DynamoDBBeginner
13What is Amazon ElastiCache and why do applications use it? AWS › Amazon ElastiCache (Redis & Memcached)AWSAmazon ElastiCache (Redis & Memcached)Beginner
14What is the main difference between the Redis and Memcached engines in ElastiCache? AWS › Amazon ElastiCache (Redis & Memcached)AWSAmazon ElastiCache (Redis & Memcached)Beginner
15What is AWS Backup and how does it simplify managing backups across multiple AWS services? AWS › AWS Backup & Disaster RecoveryAWSAWS Backup & Disaster RecoveryBeginner
16What is the difference between Recovery Point Objective and Recovery Time Objective in disaster recovery planning? AWS › AWS Backup & Disaster RecoveryAWSAWS Backup & Disaster RecoveryBeginner
17What is AWS Database Migration Service and what problem does it solve? AWS › AWS Database Migration Service & Application MigrationAWSAWS Database Migration Service & Application MigrationBeginner
18What is the AWS Schema Conversion Tool, and how does it work alongside DMS for heterogeneous migrations? AWS › AWS Database Migration Service & Application MigrationAWSAWS Database Migration Service & Application MigrationBeginner
19What is AWS KMS and what role does it play in encrypting data across AWS services? AWS › AWS KMS & Data EncryptionAWSAWS KMS & Data EncryptionBeginner
20What is AWS Secrets Manager and what problem does it solve for applications that need database credentials or API keys? AWS › AWS Secrets Manager & Parameter StoreAWSAWS Secrets Manager & Parameter StoreBeginner
21How do compute, storage, database, and networking services typically work together in a simple three tier web application architecture? AWS › Core Services OverviewAWSCore Services OverviewBeginner
22What is the difference between a public subnet and a private subnet within a VPC? AWS › VPC & NetworkingAWSVPC & NetworkingBeginner
23What are Global Secondary Indexes and Local Secondary Indexes in DynamoDB? AWS › Amazon DynamoDBAWSAmazon DynamoDBIntermediate
24What caching strategies are commonly implemented using ElastiCache, such as lazy loading and write through? AWS › Amazon ElastiCache (Redis & Memcached)AWSAmazon ElastiCache (Redis & Memcached)Intermediate
25What is the difference between SPICE import mode and direct query mode in QuickSight? AWS › Amazon QuickSight & Business IntelligenceAWSAmazon QuickSight & Business IntelligenceIntermediate
26How does DMS support continuous data replication using change data capture to minimize downtime during a migration? AWS › AWS Database Migration Service & Application MigrationAWSAWS Database Migration Service & Application MigrationIntermediate
27How does automatic secret rotation work in Secrets Manager, and why is it an important security practice? AWS › AWS Secrets Manager & Parameter StoreAWSAWS Secrets Manager & Parameter StoreIntermediate
28How does a Volume Gateway provide block storage that can be used for backup or as a primary storage volume for on premises applications? AWS › AWS Storage GatewayAWSAWS Storage GatewayIntermediate
29What role does the AWS Well-Architected Framework play in guiding decisions across all of these core services as an application grows in complexity? AWS › Core Services OverviewAWSCore Services OverviewIntermediate
30What is the difference between EBS backed and instance store backed EC2 instances in terms of data persistence? AWS › EC2 & ComputeAWSEC2 & ComputeIntermediate
31How does CloudFormation calculate and apply changes when you update an existing stack, and what is a change set? AWS › IaC (CloudFormation)AWSIaC (CloudFormation)Intermediate
32How do CloudFormation parameters and outputs make templates more reusable and flexible across different environments? AWS › IaC (CloudFormation)AWSIaC (CloudFormation)Intermediate
33How does Lambda concurrency work, and what is the difference between reserved concurrency and the account level concurrency limit? AWS › Lambda & ServerlessAWSLambda & ServerlessIntermediate
34How does Lambda support running functions within a VPC, and what performance considerations does this introduce compared to functions that do not need VPC access? AWS › Lambda & ServerlessAWSLambda & ServerlessAdvanced