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
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 vCorebased 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