40 / 54
W H I T E P A P E R
www.persistent.com
© 2017 Persistent Systems Ltd. All rights reserved.
References
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-what-isFeatures
• The storage and compute nodes are functions independently so that we can scale out the storage
capacity or compute speed without depending on other nodes.
• Easy integration with PowerBI, ADF, Azure Table storage, SQL database azure services as
well as third party tools (see
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-partner-business-intelligence
).
• Increase, decrease, pause, or resume compute nodes.
• Automatically backs-up (un-paused) data at regular intervals.
10.3.2.8 Azure SQL database
The Azure SQL database is a cloud based transactional database service. Azure SQL enables to store relational
data in the cloud. It is based on SQL server database engine.
Features
• Encryption allow to protect sensitive data such as card number etc.
• Auto Scale is used to change the Azure SQL database tier. Azure SQL database offers three types of
tiers (basic, standard and premium) with multiple performance levels to handle different workloads.
• Auditing tracks database events and writes them to an audit log in your Azure Storage account.
• Database authentication using Azure Active Directory (AAD).
• Active geo-replication replication.
• Application Role enables an application to run with its own, user-like permissions and also enable access
to specific data to only those are running application.
• Azure Active directory authentication for user authentication of databases.
References
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features10.3.2.9 Backup service
This service can be used to take backup, restore your data in the cloud. It provides set of components/agent
which we need to install on on-premises or cloud based machine to take data backup. The component, or agent,
that you deploy depends on what you want to protect.
References
https://docs.microsoft.com/en-us/azure/backup/backup-introduction-to-azure-backup#which-azure-backup-
components-should-i-use
10.3.2.10 Virtual Machines
Azure virtual machines are useful when you want to create/deploy windows or Linux machine on cloud. The
virtual machine will be useful for development and test, application in cloud and extended datacenter. It provides
various machine images. We can scale the machine instances as per our business requirement.
Supported images
https://docs.microsoft.com/en-us/azure/virtual-machines/virtual-machines-windows-overview40