DESCRIBE CORE AZURE SERVICES (30-35%)
2/4 DESCRIBE SOME OF THE CORE PRODUCTS AVAILABLE IN AZURE:
Describe products available for Databases such as
-Azure SQL Database,
-Azure Database for MySQL,
-Azure Database for PostgreSQL,
-Azure Database Migration service
Just 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.