AZ- 900: Describe products available for Databases such as...
-
DESCRIBE CORE AZURE SERVICES (30-35%)
2/4 DESCRIBE SOME OF THE CORE PRODUCTS AVAILABLE IN AZURE:Describe products available for Databases such as
-Cosmos DB,
-Azure SQL Database,
-Azure Database for MySQL,
-Azure Database for PostgreSQL,
-Azure Database Migration serviceJust trying to get my end round this section in regards to the AZ-900 exam. I assume in the exam I will get a question that will be a scenario and I will have to recommend which db is best. In terms of revision, I can separate the dbs in that Cosmos DB is noSQL and accessible by mutiple API's: Cassandra, MongoDB, Gremlin etc... The other dbs are relational dbs.
I am struggling to distinguish the latter 3 dbs, Why would I choose one over the other, If I got an exam question on which db to choose, I would struggle. They all seem high availability. Any pointers on what the key differences are in that which one would be favoured over the other? Seems more I dive into this, the more confused I get. Thank you.
-
I wouldn't spend too much time on the differences.
For the AZ-900 It's more important for this exam to understand the types of databases Azure offers. Understanding that if you are considering migrating a workload that uses PostgreSQL, Azure supports that. If your developers want to create a new app that uses MySQL, Azure supports that.