Azure SQL Database and Managed Instance: Deployment, Migration, and
Management
1. What is the main focus of the COOS294 To implement and manage storage in
module? Azure.
2. What are the two main types of databases Relational databases and non-relational
discussed? databases.
3. How is data stored in a relational database? Data is stored in tables.
4. What type of data can non-relational data- Structured, unstructured, or semi-struc-
bases store? tured data.
5. What is a key advantage of relational data- Data integrity is high due to constraints and
bases regarding data integrity? relationships.
6. What is a disadvantage of non-relational Data consistency/integrity can be easily
databases? compromised.
, Azure SQL Database and Managed Instance: Deployment, Migration, and
Management
sj
7. Name one example of a relational data- MySQL, SQL Server, or Oracle Database.
base.
8. Name one example of a non-relational MongoDB, Neo4j, or Cassandra.
database.
9. What is Azure SQL Database? A fully managed, highly scalable PaaS data-
base service designed for the cloud.
10. What is the purpose of Azure SQL Managed To provide near-100% compatibility with
Instance? on-premises SQL Server instances while
abstracting the underlying hardware.
11. What does IaaS stand for? Infrastructure as a Service.
, Azure SQL Database and Managed Instance: Deployment, Migration, and
Management
sj
12. What does PaaS stand for? Platform as a Service.
13. What is a key feature of SQL Server on It allows for a virtual machine running SQL
Azure Virtual Machines? Server, making it an IaaS solution.
14. What is the availability percentage of Azure 99.995%.
SQL Database?
15. What is a significant benefit of using Azure It automates updates, backups, and recov-
SQL Database? ery.
16. What is the main use case for SQL Server For migrations and applications requiring
on Azure VMs? access to operating system features.
17. What is one of the pros of relational data- Data consistency and integrity.
bases?
18. What is one of the cons of non-relational Data processing can be slow.
databases?
Management
1. What is the main focus of the COOS294 To implement and manage storage in
module? Azure.
2. What are the two main types of databases Relational databases and non-relational
discussed? databases.
3. How is data stored in a relational database? Data is stored in tables.
4. What type of data can non-relational data- Structured, unstructured, or semi-struc-
bases store? tured data.
5. What is a key advantage of relational data- Data integrity is high due to constraints and
bases regarding data integrity? relationships.
6. What is a disadvantage of non-relational Data consistency/integrity can be easily
databases? compromised.
, Azure SQL Database and Managed Instance: Deployment, Migration, and
Management
sj
7. Name one example of a relational data- MySQL, SQL Server, or Oracle Database.
base.
8. Name one example of a non-relational MongoDB, Neo4j, or Cassandra.
database.
9. What is Azure SQL Database? A fully managed, highly scalable PaaS data-
base service designed for the cloud.
10. What is the purpose of Azure SQL Managed To provide near-100% compatibility with
Instance? on-premises SQL Server instances while
abstracting the underlying hardware.
11. What does IaaS stand for? Infrastructure as a Service.
, Azure SQL Database and Managed Instance: Deployment, Migration, and
Management
sj
12. What does PaaS stand for? Platform as a Service.
13. What is a key feature of SQL Server on It allows for a virtual machine running SQL
Azure Virtual Machines? Server, making it an IaaS solution.
14. What is the availability percentage of Azure 99.995%.
SQL Database?
15. What is a significant benefit of using Azure It automates updates, backups, and recov-
SQL Database? ery.
16. What is the main use case for SQL Server For migrations and applications requiring
on Azure VMs? access to operating system features.
17. What is one of the pros of relational data- Data consistency and integrity.
bases?
18. What is one of the cons of non-relational Data processing can be slow.
databases?
