PostgreSQL Migration - LTI Mindtree

Why would a company use Azure DMS?

• To create new databases from scratch

• To migrate existing databases to Azure

• To delete databases in Azure

• To run database queries

Which phase of the database migration process involves capturing changes that occur during the initial migration?

• Schema conversion

• Data migration

• Cutover

• Data synchronization

Azure DMS supports both online and offline database migrations for PostgreSQL.

True or False

• True

• False

In the context of Azure DMS, what is a "Data Migration Project"?

• A group of data analysts working on a project

• A way to organize database files

• A logical container for defining and managing the database migration process

• A type of database schema

Which Azure service allows you to host PostgreSQL databases as a fully managed service?

• Azure Virtual Machines

• Azure SQL Database

• Azure Cosmos DB

• Azure Database for PostgreSQL

When would you consider using Azure Database for PostgreSQL General Purpose?

• For small-scale applications

• Workloads that require balanced compute and memory with scalable I/O throughput.

• Only for on-premises deployments

• For legacy database systems

Azure Database for PostgreSQL supports automatic failover for high availability.

True or False

• True

• False

How does Azure Database for PostgreSQL ensure data security and compliance?

• By requiring manual encryption of data

• Through automatic backups and retention policies

• By relying on third-party security tools

• By providing built-in security features like encryption and firewall rules

What are the three primary service tiers available for Azure Database for PostgreSQL - Flexible Servers?

• Bronze, Silver, and Gold

• Free, Basic, and Premium

• Burstable, General Purpose, and Memory Optimized

• Dev, Test, and Production

Which feature in Azure Database for PostgreSQL prevents a server from running out of storage and becoming read-only.

• High Availability

• Storage auto-growth

• Backups

• Workload Type