PrepAway - Latest Free Exam Questions & Answers

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

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

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.

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


Leave a Reply