Azure SQL Elastic Pools Quiz

1. Premium Elastic Pools provide higher performance and lower latency compared to Standard pools. True or False?

True

False

2. Elastic Pools provide built-in threat detection and advanced data security features. True or False?

True

False

3. How many Elastic Pools can be created within a single Azure SQL Server instance?

Multiple pools per server are supported

Only one pool per server

Maximum of five pools

Pools cannot share a server

4. What is a key advantage of using Elastic Pools for SaaS applications with multiple customer databases?

Simplified resource management and cost optimization across tenants

Guaranteed performance for all customers at all times

Elimination of need for backups

Automatic data encryption without configuration

5. Elastic Pools support both SQL Server authentication and Azure AD authentication. True or False?

True

False

6. Which feature allows automatic scaling of Elastic Pools based on demand?

Auto-scaling is not available; manual adjustment required

Azure Autoscale rules (preview)

Automatic scaling occurs every hour

Scaling requires database migration

7. What is the maximum storage capacity for a Premium Elastic Pool?

4 TB per pool

250 GB per pool

1 TB per database

Unlimited storage

8. Elastic Pool pricing is based on the total eDTUs allocated to the pool, not individual database usage. True or False?

True

False

9. Can you resize an Elastic Pool without downtime to the databases?

Yes, resize operations are non-disruptive

No, all databases must go offline

Only during maintenance windows

Resizing is not supported

10. Which scenario is most cost-effective for using an Elastic Pool?

Multiple databases with variable, unpredictable usage patterns

Single database with constant high demand

Databases requiring dedicated resources always

Archival databases with rare access

11. What is the primary benefit of using Azure SQL Elastic Pools?

Shared compute and storage resources across multiple databases

Guaranteed zero downtime for all databases

Automatic backup to on-premises servers

Unlimited database size without cost increase

12. What is the purpose of setting a maximum eDTU per database in an Elastic Pool?

Prevent resource hogging by individual databases

Eliminate all performance issues

Reduce backup frequency

Force databases to use only Basic tier

13. Which monitoring tool provides real-time insights into Elastic Pool resource consumption?

Azure Portal and Query Performance Insight

SQL Server Management Studio only

Local Event Viewer

Notepad log files

14. Elastic Pools are designed for workloads with predictable resource usage patterns. True or False?

True

False

15. How does Azure monitor database performance within an Elastic Pool?

Using DTU percentage and resource utilization metrics

Manual log file review only

Real-time SMS alerts to administrators

Annual audits by Microsoft engineers

16. What is the maximum number of databases supported in a Standard Elastic Pool?

100 databases

500 databases

1000 databases

Unlimited

17. Which Azure SQL service tier supports Elastic Pools?

Standard and Premium tiers

Basic tier only

Hyperscale tier exclusively

Free tier with limitations

18. In an Elastic Pool, the minimum number of eDTUs per database is typically set to ensure baseline performance. True or False?

True

False

19. What does DTU stand for in Azure SQL Database?

Database Transaction Unit

Data Transfer Utility

Dynamic Tier Upgrade

Distributed Table Unit

20. Which resource is shared among databases in an Elastic Pool?

EDTUs (elastic Database Transaction Units)

Backup storage only

User login credentials

Physical server hardware exclusively

Azure DBA Elastic Pools for Azure SQL Quiz

1. Premium Elastic Pools provide higher performance and lower latency compared to Standard pools. True or False?

2.

What first name or nickname would you like us to use?

2. Elastic Pools provide built-in threat detection and advanced data security features. True or False?

3. How many Elastic Pools can be created within a single Azure SQL Server instance?

4. What is a key advantage of using Elastic Pools for SaaS applications with multiple customer databases?

5. Elastic Pools support both SQL Server authentication and Azure AD authentication. True or False?

6. Which feature allows automatic scaling of Elastic Pools based on demand?

7. What is the maximum storage capacity for a Premium Elastic Pool?

8. Elastic Pool pricing is based on the total eDTUs allocated to the pool, not individual database usage. True or False?

9. Can you resize an Elastic Pool without downtime to the databases?

10. Which scenario is most cost-effective for using an Elastic Pool?

11. What is the primary benefit of using Azure SQL Elastic Pools?

12. What is the purpose of setting a maximum eDTU per database in an Elastic Pool?

13. Which monitoring tool provides real-time insights into Elastic Pool resource consumption?

14. Elastic Pools are designed for workloads with predictable resource usage patterns. True or False?

15. How does Azure monitor database performance within an Elastic Pool?

16. What is the maximum number of databases supported in a Standard Elastic Pool?

17. Which Azure SQL service tier supports Elastic Pools?

18. In an Elastic Pool, the minimum number of eDTUs per database is typically set to ensure baseline performance. True or False?

19. What does DTU stand for in Azure SQL Database?

20. Which resource is shared among databases in an Elastic Pool?