No organization that is on the growth path or intending to have a more customer base and new entry into the market will restrict its infrastructure and design for one Database option. There are two levels of Database selection

• a.  **The needs assessment **
• **b. Selecting the kind of database **
• c. Selection of Queues for communication
• d. Selecting the technology player

Options to choose from:

1. Transactional Databases:
2. • Azure selection — Data Factory, Redis, CosmosDB, Azure SQL, Postgres SQL, MySQL, MariaDB, SQL Database, Maria DB, Managed Server
3. Data warehousing:
4. • Azure selection — CosmosDB
5. • Delta Lake — Data Brick’s Lakehouse Architecture.
6. Non-Relational Database:
7. _- _Azure selection — CosmosDB
8. Data Lake:
9. • Azure Data Lake
10. • Delta Lake — Data Bricks.
11. Big Data and Analytics:
12. • Data Bricks
13. • Azure — HDInsights, Azure Synapse Analytics, Event Hubs, Data Lake Storage gen1, Azure Data Explorer Clusters, Data Factories, Azure Data Bricks, Analytics Services, Stream Analytics, Website UI, Cognitive Search, PowerBI, Queries, Reports.
14. Machine Learning:
15. • Azure — Azure Synapse Analytics, Machine Learning, Genomics accounts, Bot Services, Machine Learning Studio, Cognitive Services, Bonsai.

Key Data platform services would like to highlight

• 1. Azure Data Factory (ADF)
• 2. Azure Synapse Analytics
• 3. Azure Stream Analytics
• 4. Azure Databricks
• 5. Azure Cognitive Services
• 6. Azure Data Lake Storage
• 7. Azure HDInsight
• 8. Azure CosmosDB
• 9. Azure SQL Database

#azure-databricks #azure #microsoft-azure-analytics #azure-data-factory #azure series