This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What is the primary difference between the single database and elastic pools deployment models in Azure SQL Database?
The single database model allows for the allocation of storage and compute resources to a group of databases, while the elastic pools model manages each database individually in terms of scale and data size.
In the single database model, each database has its own dedicated resources, while in the elastic pools model, resources are shared among multiple databases within the same pool.
In the single database model, resources are shared among multiple databases, while in the elastic pools model, each database has its own dedicated resources.
How does the Hyperscale service tier affect the time needed to create database backups or to scale up or down?
It increases the time based on the volume of data in the database.
It requires a constant amount of time, regardless of the volume of data in the database.
It's no longer dependent on the volume of data in the database.
What is the main difference between geo-replication and auto-failover groups in terms of replication type?
Geo-replication uses synchronous replication, while auto-failover groups use asynchronous replication.
Both geo-replication and auto-failover groups use asynchronous replication.
Geo-replication uses asynchronous replication, while auto-failover groups use synchronous replication.
What is the main function of Microsoft Copilot in Azure SQL Database?
It allows database administrators to manage developers' tasks.
It translates SQL queries into natural language.
It enhances SQL management and troubleshooting by offering natural language to SQL conversion and self-help for database administration.
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?