Question 11

You maintain a relational database for a book publisher. The database contains the following tables.

The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.
What should you include in the solution?
  • Question 12

    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?
  • Question 13

    You have an Apache Spark pool in Azure Synapse Analytics that runs the following Python code in a notebook.

    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 14

    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 15

    You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format.
    Which three configuration items should you include in the solution? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.