MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

In a scenario where you need your Azure Database for the PostgreSQL server which is deployed on PREMISE, to have high performance on multiple regions, what deployment mode would you choose?

A	Hypervisor
B	Hyperscale
C	RDS
D	Flexible Server

Explanation:

Detailed explanation-1: -For organizations that need to customize their PostgreSQL deployments, and need to overcome the limitations of the Azure Database for PostgreSQL managed service, the self-managed Azure VM option is the most appropriate option. However, this option comes with greater complexity and difficulty of managing storage.

Detailed explanation-2: -Azure Database for PostgreSQL-Flexible Server offers high availability configurations with automatic failover capabilities. The high availability solution is designed to ensure that committed data is never lost because of failures and that the database won’t be a single point of failure in your software architecture.

Detailed explanation-3: -The Single Server deployment option offers three pricing tiers: Basic, General Purpose, and Memory Optimized. Each tier offers different resource capabilities to support your database workloads.

Detailed explanation-4: -You can use Azure Database Migration Service to migrate the databases from an on-premises PostgreSQL instance to Azure Database for PostgreSQL with minimal downtime. In other words, migration can be achieved with minimal downtime to the application.

There is 1 question to complete.