Question 6

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
  • Question 7

    Match the Azure Cosmos DB APIs to the appropriate data structures.
    To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
    NOTE: Each correct match is worth one point.

    Question 8

    You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
    You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact.
    What should you do on the SQL pool?
  • Question 9

    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 10

    You have a SQL query that combines customer data and order data. The query includes calculated columns.
    You need to persist the SQL query so that other users can use the query. What should you create?