Practice Test
True or False: Azure Backup is a built-in Azure service you can use to backup and restore your data in Azure Cloud.
- Answer: True
Explanation: Azure Backup is a built-in service provided by Azure that you can use to back up (or protect) and restore your data in the Microsoft cloud.
Which of the following Azure services can be used to automate database backups:
- a) Azure Functions
- b) Azure Logic Apps
- c) Azure Automation
- d) Azure Event Grid
Answer: c) Azure Automation
Explanation: Azure Automation enables the automated control of tasks through runbooks, which can be used to setup automated backups of the databases.
True or False: Azure Site Recovery is a service specifically designed for database backup and recovery solutions.
- Answer: False
Explanation: Azure Site Recovery is primarily a disaster recovery service, not specifically designed for database backup and recovery.
Which backup solution would be most appropriate for an Azure SQL Database?
- a) Azure Backup
- b) Azure Site Recovery
- c) Azure Blob Storage
- d) Azure SQL Database’s built-in backup
Answer: d) Azure SQL Database’s built-in backup
Explanation: Azure SQL Database has built-in backup and restore capabilities that are more suited for its backup and recovery than other Azure services.
Which of the following is not a recovery service in Azure?
- a) Azure Backup Service
- b) Azure Site Recovery Service
- c) Azure Database Migration service
- d) Azure Backup Server Service
Answer: c) Azure Database Migration service
Explanation: Azure Database Migration service is to migrate databases from multiple database sources to Azure Data platforms, not a recovery service.
True or False: Point-in-time restore is a feature of Azure SQL Database that allows recovery of a database to any point within the last 35 days.
- Answer: True
Explanation: This feature allows restoring the database to any moment in time, within a retention period of 7-35 days.
What provides native support for backing up and restoring Azure VMs?
- a) Azure Disk Backup
- b) Azure Backup
- c) Azure Site Recovery
- d) Azure DevOps
Answer: b) Azure Backup
Explanation: Azure Backup provides a simple, secure and cost-effective solution to backup Azure VMs without needing to deploy any backup infrastructure.
True or False: Azure Cosmos DB automatically takes backups of your data at regular intervals without affecting the performance of write and read operations.
- Answer: True
Explanation: Backups in Azure Cosmos DB are automatic, and the performance of write and read operations aren’t affected.
For managing and executing backups, Azure uses:
- a) Recovery Services vault
- b) Azure Storage Account
- c) Azure Kubernetes Service
- d) Azure Logic Apps
Answer: a) Recovery Services vault
Explanation: Azure Recovery Services vault is a management entity that stores recovery points created over time.
True or False: Regular Azure Storage Account can be used for long-term data retention.
- Answer: False
Explanation: Normal Azure Storage Account isn’t designed for long term data retention. Instead you could use Azure Backup or Azure Archive Storage for longer data retention.
Interview Questions
What is Azure Backup?
Azure Backup is a scalable solution with zero capital investment and minimal operational expenses to backup/copy data online. It provides three types of backup- system backup, file backup, and personal backup.
Which Azure service is recommended for disaster recovery of on-premises Hyper-V VMs?
Azure Site Recovery is recommended for disaster recovery of on-premises Hyper-V VMs.
What is the main feature of Azure SQL Database Point in Time Restore?
Azure SQL Database Point in Time Restore allows you to restore a database to any point within the retention period, typically up to 35 days.
Can Azure Backup protect SQL Server databases and SAP HANA databases?
Yes, Azure Backup can protect SQL Server databases in Azure VMs and SAP HANA databases in Azure VMs.
What is the function of Azure Backup’s Soft Delete feature?
Soft Delete is a feature in Azure Backup that provides additional recovery points in case your backup data gets deleted.
What Azure feature can be used to backup and restore Cosmos DB?
Azure Cosmos DB provides periodic automated backups and restorations upon request for backup and restore procedures.
Can Azure Site Recovery be used for planned failovers?
Yes, Azure Site Recovery can be used for both planned failovers for expected outages and unplanned failovers for unexpected outages.
Is Azure Storage Service Encryption used for at-rest encryption of Azure Backup data?
Yes, Azure Backup data is encrypted as it’s stored in the Recovery Services vault with Azure Storage Service Encryption.
How does the Azure Backup provide encryption?
Azure Backup provides encryption through two methods, Azure-generated keys and customer-managed keys.
What is Geo-Restore in Azure SQL Database?
Geo-Restore is the default recovery option in Azure SQL Database. It restores the database backup from a geo-replicated backup, granting an RTO of 12 hours.
Can I create a backup of a managed instance database to a storage account using Azure SQL Managed Instance?
No. Azure SQL Managed Instance does not support backups to a storage account.
What kind of backup solution is recommended for NoSQL databases in Azure?
Azure Cosmos DB, a fully-managed NoSQL database for modern app development, offers automatic and manual backup options for NoSQL databases.
Are there any size restrictions for Azure Backup?
No, Azure Backup can handle any amount of data. It can back up data up to 9999GB per disk for a maximum of 54,400GB.
Can Azure Backup protect SharePoint Online and Exchange Online?
No, Azure Backup currently does not support backup and restore for SharePoint Online and Exchange Online.
What kind of replication is offered by Azure Storage for data redundancy?
Azure Storage offers Local Redundant Storage (LRS), Zone-Redundant Storage (ZRS), Geo-Redundant Storage (GRS) and Read-Access Geo-Redundant Storage (RA-GRS) for data redundancy.
extutorials.com