2.4: Scaling Azure SQL Flashcards
What is the standard protection available for Azure SQL databases in terms of resilience?
a) Locally redundant storage
b) Zone redundancy
c) Serverless compute
d) Database replicas
a) Locally redundant storage
Which Azure SQL tiers offer the option for business critical or premium performance?
a) Basic and General
b) Standard and Premium
c) General and Premium
d) Basic and Standard
b) Standard and Premium
What is the main advantage of using the business critical or premium tiers for Azure SQL databases?
a) Faster throughputs
b) Lower cost
c) Zone redundancy
d) Locally redundant storage
a) Faster throughputs
What is the purpose of using Elastic pools in Azure SQL?
a) To consolidate multiple databases and manage them as a single resource
b) To increase the maximum storage capacity of a single database
c) To enable automatic scaling of resources based on workload demand
d) To enable cross-region replication for disaster recovery purposes
a) To consolidate multiple databases and manage them as a single resource
When would you choose to use sharding in Azure SQL?
a) When you need to replicate data across multiple regions
b) When you want to partition a single database into multiple smaller databases
c) When you want to optimize performance by distributing data across multiple servers
d) When you need to encrypt sensitive data at rest and in transit
c) When you want to optimize performance by distributing data across multiple servers
What is the purpose of Azure SQL Database Hyperscale?
a) To provide automatic scaling of compute resources based on workload demand
b) To enable high availability and disaster recovery for Azure SQL databases
c) To support massive data storage and provide near-instantaneous backups and restores
d) To enhance security and compliance by providing advanced threat protection
c) To support massive data storage and provide near-instantaneous backups and restores
