Question 1

You have an Azure Cosmos DB Core (SQL) API account.
You configure the diagnostic settings to send all log information to a Log Analytics workspace.
You need to identify when the provisioned request units per second (RU/s) for resources within the account were modified.
You write the following query.
AzureDiagnostics
| where Category == "ControlPlaneRequests"
What should you include in the query?
  • Question 2

    You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.
    The database is modified once per day in a batch process.
    You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.
    How should you configure the backup settings? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 3

    You have an application named App1 that reads the data in an Azure Cosmos DB Core (SQL) API account. App1 runs the same read queries every minute. The default consistency level for the account is set to eventual.
    You discover that every query consumes request units (RUs) instead of using the cache.
    You verify the IntegratedCacheiteItemHitRate metric and the IntegratedCacheQueryHitRate metric. Both metrics have values of 0.
    You verify that the dedicated gateway cluster is provisioned and used in the connection string.
    You need to ensure that App1 uses the Azure Cosmos DB integrated cache.
    What should you configure?
  • Question 4

    You are creating a database in an Azure Cosmos DB Core (SQL) API account. The database will be used by an application that will provide users with the ability to share online posts. Users will also be able to submit comments on other users' posts.
    You need to store the data shown in the following table.

    The application has the following characteristics:
    Users can submit an unlimited number of posts.
    The average number of posts submitted by a user will be more than 1,000.
    Posts can have an unlimited number of comments from different users.
    The average number of comments per post will be 100, but many posts will exceed 1,000 comments.
    Users will be limited to having a maximum of 20 interests.
    For each of the following statements, select Yes if the statement is true. Otherwise, select No.
    NOTE: Each correct selection is worth one point.

    Question 5

    You have a database in an Azure Cosmos DB Core (SQL) API account. The database is backed up every two hours.
    You need to implement a solution that supports point-in-time restore.
    What should you do first?