Final Exam: Working with Azure Cosmos Database

WHAT YOU WILL LEARN

• 

  Recognize the properties of cloud databases and what makes them different from on-premises systems
  

  recall the benefits of cloud-hosted databases and the features which make them powerful storage solutions
  

  delineate the factors to consider when picking the best database for a particular use case
  

  compare and contrast relational and nosql databases, including the benefits and drawbacks of each type of system
  

  identify the key features and use cases of azure cosmos db
  

  recognize the different application programming interfaces (apis) for cosmos db and choose the appropriate api for a given situation
  

  calculate the capacity and costs for a cosmos db database and container
  

  use the different cosmos db apis
  

  set up a cosmos db account with the nosql api
  

  use the cosmos db web console to add items to a container and apply different schemas to the items
  

  execute basic queries on data in a cosmos db container
• 

  create an azure data factory instance to set up a migration into cosmos db
  

  set up an azure sql relational database to serve as the source for a migration to cosmos db
  

  use the sql server import extension in azure data studio to load data from a csv file into an azure sql database
  

  view the default container for a cosmos db index policy
  

  recall the influence of a container index policy on the request units consumed by queries
  

  recognize the need for composite indexes in cosmos db and how these can be defined in the index policy
  

  enable various order by queries on a container by defining multiple composite indexes
  

  disable indexes for a container and recognize the effect that has on queries
  

  install the required libraries to build a python app that can interact with a cosmos db instance
  

  use the cosmos db client to query for items in a container
  

  set up a cosmos db account with the mongodb api and provision a database and collection within that