Cloud Databases (DynamoDB, Cloud SQL, Cosmos DB) Interview Questions Answers

Home Computer Science Cloud Computing Cloud Databases (DynamoDB, Cloud SQL, Cosmos DB)

Professional Cloud Databases (DynamoDB, Cloud SQL, Cosmos DB) FAQ Questions and Answers

Welcome to our comprehensive Trivia Quiz and interview preparation guide. Below you will find a curated list of popular Trivia Questions and Answers specifically for Cloud Databases (DynamoDB, Cloud SQL, Cosmos DB). Whether you are preparing for a technical interview or just testing your knowledge, these FAQ Questions will help you succeed.

What is a cloud database?

A cloud database is a database service built, deployed, and accessed via a cloud platform, offering scalability and managed infrastructure.

What is Amazon DynamoDB?

DynamoDB is a fully managed NoSQL database service provided by AWS designed for high performance and scalability.

What is Google Cloud SQL?

Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server on Google Cloud Platform.

What is Azure Cosmos DB?

Cosmos DB is a globally distributed, multi-model NoSQL database service by Microsoft Azure.

Which data models does Cosmos DB support?

Cosmos DB supports document, key-value, graph, and column-family data models.

Is DynamoDB a relational or NoSQL database?

DynamoDB is a NoSQL database optimized for key-value and document data.

What SQL engines are supported by Google Cloud SQL?

Google Cloud SQL supports MySQL, PostgreSQL, and SQL Server.

What are the main benefits of using DynamoDB?

High scalability, low latency, fully managed service, and built-in security.

What consistency models does Cosmos DB provide?

Cosmos DB offers five consistency models: strong, bounded staleness, session, consistent prefix, and eventual consistency.

How does Cloud SQL handle backups?

Cloud SQL provides automated backups and point-in-time recovery.

Can DynamoDB handle transactions?

Yes, DynamoDB supports ACID transactions for coordinated updates.

What is partition key in DynamoDB?

A partition key is a primary key component used to distribute data across partitions.

What is a global table in DynamoDB?

Global tables provide multi-region, fully replicated tables for global applications.

How does Cosmos DB ensure low latency globally?

By replicating data across multiple Azure regions with automatic failover.

What are Cloud SQL read replicas?

Read replicas improve read scalability by replicating data asynchronously.

Can Cosmos DB automatically scale throughput?

Yes, Cosmos DB offers automatic throughput scaling based on workload.

What is a provisioned throughput in DynamoDB?

It is the amount of read/write capacity allocated to a table or index.

Does Cloud SQL support high availability?

Yes, Cloud SQL supports HA with automatic failover and replication.

What is a container in Cosmos DB?

A container is a schema-agnostic container for JSON documents with provisioned throughput.

What types of indexes are used in DynamoDB?

DynamoDB uses primary keys, local secondary indexes, and global secondary indexes.

How do you monitor Cloud SQL performance?

Using Google Cloud Console, Stackdriver Monitoring, and logs.

What programming languages can be used with DynamoDB?

Any language that supports AWS SDKs like Python, Java, JavaScript, .NET, etc.

How does Cosmos DB handle multi-master replication?

It allows writes to be accepted in multiple regions with conflict resolution.

Can you run custom SQL queries in DynamoDB?

No, DynamoDB uses a NoSQL query language, not traditional SQL.

What is Cloud SQL instance?

An instance is a managed database environment hosting one or more databases.

What security features do these cloud databases offer?

Encryption at rest and transit, IAM integration, network isolation, and audit logging.

How does DynamoDB handle scaling?

It automatically partitions and scales tables based on throughput.

What backup options does Cosmos DB provide?

Automated backups with configurable retention periods and manual backups.

What is a Cloud SQL failover replica?

A standby instance that can be promoted in case of primary failure.

How does DynamoDB pricing work?

Pricing is based on provisioned throughput, storage used, and data transfer.

What data consistency does Cloud SQL provide?

Strong consistency as it is a relational database.

What are Cosmos DB's SLAs?

99.999% availability, low latency, and throughput guarantees.

How do you migrate an on-premise database to Cloud SQL?

Using Database Migration Service or manual export/import.

Can you perform joins in DynamoDB?

No, joins are not supported; data modeling requires denormalization.

What is a throughput unit in Cosmos DB?

A Request Unit (RU) is the currency for throughput provisioned.

How do you secure Cloud SQL instances?

With SSL connections, IAM roles, private IPs, and firewall rules.

What is DynamoDB Streams?

A feature that captures data changes for real-time processing.

What are Cosmos DB's API options?

APIs for SQL, MongoDB, Cassandra, Gremlin, and Table storage.

Does Cloud SQL support read scaling?

Yes, via read replicas.

What are DynamoDB Global Secondary Indexes (GSI)?

Indexes with different partition and sort keys to support queries.

What are common use cases for Cosmos DB?

IoT, retail, gaming, real-time personalization, and global apps.

How do you monitor and troubleshoot DynamoDB?

Using AWS CloudWatch and DynamoDB console metrics.

How is data replicated in Cloud SQL?

Using synchronous or asynchronous replication for HA and read replicas.

Can Cosmos DB handle JSON documents?

Yes, it is optimized for JSON document storage.

What is the maximum item size in DynamoDB?

400 KB per item.

How do you optimize queries in Cloud SQL?

By indexing, query optimization, and performance tuning.

What is the pricing model for Cosmos DB?

Based on provisioned throughput (Request Units), storage, and data transfer.

Can DynamoDB be integrated with AWS Lambda?

Yes, for event-driven architectures using DynamoDB Streams.

What disaster recovery options exist in Cloud SQL?

Automated backups, replication, and failover.

What is multi-region replication in Cosmos DB?

Replication of data across multiple Azure regions for availability and low latency.