Table of Contents

1. Challenge

   Log in to the Azure Portal

   Log in to the Azure Portal using the provided credentials.

2. Challenge

   Create an Azure Cosmos DB Account

   1. Click the three-line menu icon in the top left corner of the page, and click Azure Cosmos DB.
   2. Click Add.
   3. Select the resource group the lab created for you.
   4. Provide an account name (must be unique).
   5. For API, leave it as Core(SQL).
   6. For Apply Free Tier Discount, click Do Not Apply.
   7. For Location, select the region (US) West US.
   8. Leave all the other values at their defaults, and click Review + create.
   9. Verify all is well, and click Create.
   10. Once the deployment is complete, click Go to resource.

   Note: The deployment could take up to 15 minutes. Feel free to carry out other tasks while you wait. Also, at times the deployment screen does not accurately report that it is finished. To mitigate this, check the status on the resource's overview page.

3. Challenge

   Create the Database and Container

   1. Click on Data Explorer in the left-hand menu.
   2. Click New Container.
   3. Enter the following values:
      • Database id: Players
      • Container id: Profiles
      • Partition key: /team
   4. Leave all other values at their defaults, and click OK.
4. Challenge

   Add Items to the Database

   1. Expand the Players database, expand Profiles, and click on Items.

   2. Click New Item.

   3. Enter the following text into the document area on the right:

      {
          "id": "1",
          "team": "blue",
          "gamerTag": "Lando Commando",
          "statusMessage": "glhf :)",
          "isOnline": true
      }
      

   4. Click Save.

   5. Repeat the above steps with the following values:

      • id: 2
      • team: red
      • gamerTag: delmarDB
      • statusMessage: select * from victory
      • isOnline: false
5. Challenge

   Query the Items

   1. By default, all your items are selected.

   2. Click Edit Filter.

   3. Replace the default query with the following:

      WHERE c.team = 'red'
      

   4. Notice only our red team member is returned.