What should you recommend?

A company has many applications. Each application is supported by separate on-premises databases.

You must migrate the databases to Azure SQL Database.

You have the following requirements:

– Organize databases into groups based on database usage.

– Define the maximum resource limit available for each group of databases.

You need to recommend technologies to scale the databases to support expected increases in demand.

What should you recommend?
A . Read scale-out
B . Managed instances
C . Elastic pools
D . Database sharding

View Answer

Answer: C

Explanation:

SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price. You can configure resources for the pool based either on the DTU-based purchasing model or the vCore­based purchasing model.

Incorrect Answers:

D: Database sharding is a type of horizontal partitioning that splits large databases into smaller components, which are faster and easier to manage.

Reference: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool