Practice Test
True or False: Azure SQL Database is a service that can be used to store relational data in Microsoft Azure.
- True
- False
Answer: True
Explanation: Azure SQL Database is a fully managed relational database service provided by Microsoft in Azure.
Multiple select: Which of the following are solutions for storing relational data in Azure?
- a) Azure SQL Database
- b) Azure Cosmos DB
- c) Azure Storage Account
- d) Azure Data Lake
Answer: a) Azure SQL Database, b) Azure Cosmos DB
Explanation: Both Azure SQL Database and Azure Cosmos DB provide mechanisms for storing relational data. Azure Storage Account and Azure Data Lake are more suited for unstructured data.
Single select: What is the default replication strategy of Azure SQL Database?
- a) Locally redundant
- b) Zone-redundant
- c) Geo-redundant
- d) Read-access geo-redundant
Answer: c) Geo-redundant
Explanation: Azure SQL database uses geo-redundant backup as the default replication strategy to create backups at least once every hour.
True or False: Azure Data Lake is a relational database service.
- True
- False
Answer: False
Explanation: Azure Data Lake is a highly scalable data storage and analytics service, but it’s not a relational database service.
Multiple select: Which of the following are advantages of Azure SQL Database?
- a) Automatic backups
- b) Built-in high availability
- c) Autoscale
- d) Transaction consistency
Answer: a) Automatic backups, b) Built-in high availability, c) Autoscale, d) Transaction consistency
Explanation: Azure SQL Database provides all of these benefits for relational data storage.
Single select: What is the pricing model of Azure SQL Database?
- a) Pay-as-you-go
- b) Fixed price
- c) Transaction-based pricing
- d) None of the above
Answer: a) Pay-as-you-go
Explanation: Azure SQL Database follows a pay-as-you-go pricing model where you only pay for what you use.
True or False: Azure Cosmos DB only supports NoSQL data and cannot store relational data.
- True
- False
Answer: False
Explanation: While Azure Cosmos DB is known for its NoSQL capabilities, it can also store and manage relational data.
Multiple select: Which services can be used to migrate relational data to Azure?
- a) Azure Migrate
- b) Azure Data Factory
- c) Azure Site Recovery
- d) Azure Databricks
Answer: a) Azure Migrate, b) Azure Data Factory
Explanation: Both Azure Migrate and Azure Data Factory can be used to migrate relational data to Azure.
Single select: Which Azure service provides the most cost-effective solution for storing relational data?
- a) Azure SQL Database
- b) Azure Table Storage
- c) Azure Cosmos DB
- d) It depends on the specific needs and usage patterns of the application.
Answer: d) It depends on the specific needs and usage patterns of the application.
Explanation: The most cost-effective solution can vary according to the specific needs and usage patterns of each application.
True or False: You must manually configure backups in Azure SQL Database.
- True
- False
Answer: False
Explanation: Azure SQL Database provides automatic backups, reducing the need for manual management.
Interview Questions
What is the most recommended Azure service for storing relational data?
The most recommended Azure service for storing relational data is Azure SQL Database.
Which Azure service will you use for maximum scalability and throughput for mission-critical applications using relational data?
You should use Azure Cosmos DB for maximum scalability and throughput for mission-critical applications using relational data.
How does Azure SQL Database secure the relational data stored?
Azure SQL Database secures the data by using tools such as Azure Active Directory, firewall rules, and Advanced Threat Protection.
What can Azure Data Lake be used for in context of relational data?
Azure Data Lake can be used for storing and analyzing large amounts of structured (relational) and unstructured data.
Can we store relational data using Azure Blob Storage?
Azure Blob Storage is not typically used for relational data. It’s primarily used for storing unstructured data such as documents, photographs, and video files.
Which Azure service supports both non-relational and relational data?
Azure Cosmos DB supports both non-relational and relational data.
Can Azure Table Storage be used for storing relational data?
No, Azure Table Storage is not suitable for storing relational data. It is designed for storing large amounts of structured, non-relational data.
What is the purpose of Azure SQL Managed Instance in storing relational data?
Azure SQL Managed Instance is used when enterprises have large scale SQL server databases that they want to modernize by moving to the cloud. It provides fully managed SQL Server engine with native virtual network support.
What Azure service is best for migration of large amount of relational data to the cloud?
Azure Database Migration Service is best for migration of large amount of relational data to the cloud.
Which Azure service offers the highest compatibility with most SQL Server features, with benefits of operating in a managed environment?
Azure SQL Managed Instance offers the highest compatibility with most SQL Server features, with the benefits of operating in a managed environment.
How is data redundancy ensured in Azure SQL Database?
In Azure SQL Database, data redundancy is achieved by automatically creating and maintaining replicas of all databases to protect against data loss.
What Azure service would work best for storing semi-structured or NoSQL data?
Azure Cosmos DB is the recommended service for storing semi-structured or NoSQL data.
Is it possible to store and process both relational and non-relational data in the same database on Azure? If yes, which service allows it?
Yes, it is possible. Azure Cosmos DB allows the storage and processing of both relational and non-relational data in the same database.
What Azure service manages backups of relational databases automatically?
Azure SQL Database manages backups of relational databases automatically.
Can we host the MySQL relational database in Azure?
Yes, we can host the MySQL relational database in Azure using the Azure Database for MySQL service.
extutorials.com