DP-420: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DBDemo

You have the indexing policy shown in the following exhibit.

Use the drop-down menus to choose the answer that responds to each question based on the information in the graphic.

You have an Azure Cosmos DB database that contains a container named container1.

You need to make sure items stored in container1 do not expire unless their TTL value is explicitly configured.

What should you do?

You have an Azure subscription containing an Azure Cosmos DB for NoSQL account. The account has a container named Container1 that stores product data and stock-level information.

You need to implement a stored procedure that accepts these parameters:

• productid
• productName
• initialStockLevel

The solution must create the following:

• An item containing the product data
• An item containing the stock-level data for each product

Complete the stored procedure.

function addNewProduct(productID, productName, initialStockLevel) {

    var dbContext = getContext();

    var container = dbContext.Select…

    var product = {

        id: productID,

        type: "product",

        name: productName

    };

    var productStockLevel = {

        id: productID,

        type: "productStockLevel",

        currentStockLevel: initialStockLevel

    };

    var containerLink = container.Select…

    var productAccepted = container.createDocument(containerLink, product,

        function (productError, addedProduct) {

            if (productError) throw new Error('Error' + productError.message);

            var productStockLevelAccepted = container.createDocument(containerLink, productStockLevel,

                function (productStockLevelError, addedProductStockLevel) {

                    if (productStockLevelError) throw new Error('Error' + productStockLevelError.message);

                    context.getResponse().setBody({

                        product: addedProduct,

                        stocklevel: addedProductStockLevel

                    });

                });

        });

}

You have a database in an Azure Cosmos DB SQL API Core (SQL) account used for development.

The database is changed once per day by a batch process.

You must be able to restore the database if the most recent batch process fails, while minimizing costs.

How should you configure the backup settings?

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Item upserts in container1 occur every three seconds.

You have an Azure Functions app named function1 that is intended to run whenever items are inserted or replaced in container1.

You find that function1 runs, but it does not run for every upsert.

You need to ensure that function1 processes each upsert within one second after the upsert.

Which property in the Function.json file for function1 should you change?

You have an Azure Cosmos DB for NoSQL account.

You configure diagnostic settings to send all log data to a Log Analytics workspace.

You need to determine when the provisioned request units per second (RU/s) for resources in the account were changed.

You write the following query:

AzureDiagnostics -  
| where Category == "ControlPlaneRequests"  

What should you add to the query?

You are migrating a relational database to Azure Cosmos DB for NoSQL. The existing database contains the following relational tables.

The most commonly run query for each reference table returns all items in that reference table.

You need to migrate every reference table to Azure Cosmos DB while minimizing the number of containers. Configure storage for the reference tables.

You have an Azure Cosmos DB for NoSQL account that contains a container named Container1. Container1 stores items in the following format.

You need to change the contents of Container1 so they conform to the following format.

How should you complete the JSON Patch document?

[

  { "op": Select… Select… "/color", "path": "/inventory/color" }

]

You have an Azure Cosmos DB for NoSQL account that contains a database named DB1 and a container named Container1.

You need to manage the account by using the Azure Cosmos DB SDK.

What should you do?

You plan to build an operational system that stores data in an Azure Cosmos DB Core (SQL) API account.

You need to configure the account to meet these requirements:

• Support Spark queries.
• Support analysis of data from the previous six months.
• Pay for analytical compute only when queries run.

Which three actions should you take? Each correct answer represents part of the solution.

NOTE: Each correct selection is worth one point.

You need to create a data store for a directory of small and medium-sized businesses (SMBs). The data store must satisfy these requirements:

• Store companies and the users who work for them. Each company will have fewer than 1,000 users.
• Some users have data larger than 2 KB.
• Associate each user with only one company.
• Provide the capability to browse by company.
• Provide the capability to browse users by company.
• Whenever a company or user profile is selected, display a details page for the company and all related users.
• Be optimized for data reads.

Which design should you implement to optimize the data store for reading data?

You have an Azure Cosmos DB for NoSQL account with multiple write regions.

You need to receive an alert when requests directed to the database exceed the available request units per second (RU/s).

Which Azure Monitor signal should you use?

You have an Azure Cosmos DB Core (SQL) API account that an application named App1 uses. You open the account's Insights pane and view the following chart.

You have an Azure subscription containing the resources shown in the following table.

You need to create a container in db1 with these attributes:

• Name: Container1
• Encryption: Client-side encryption with Always Encrypted

Which three actions should you take, in sequence?

You have an Azure Cosmos DB account called account1.

You need to access account1 from an on-premises environment by using a Site-to-Site VPN.

What should you use?

You have an Azure subscription containing an Azure Cosmos DB for NoSQL account. The account has a database named DB1 and an Azure Key Vault named KV1.

You need to create a container named Container1 in DB1. The solution must ensure that item properties in Container1 are encrypted by using Always Encrypted.

Which four actions should be performed, in order?

The following is an example document in orders.

The orders container uses customerId as its partition key.

You need to produce a report of the total items ordered per month, by item type. The solution must meet these requirements:

• Ensure that the report runs as quickly as possible.
• Minimize request unit (RU) consumption.

What should you do?

You need to choose the partition key for con-iot1. The solution must satisfy the IoT telemetry requirements.

What should you choose?

You have an app named App1 that uses an Azure Cosmos DB for NoSQL database.

App1 uses the spatial columns shown in the following table.

You need to design an indexing strategy for App1.

Which columns can be indexed using spatial indexes?

You have an Azure subscription containing an Azure Cosmos DB for NoSQL account named account1 and a Log Analytics workspace named Workspace1. Workspace1 stores account1’s logs.

You need to determine which operations consumed the most request units per second (RU/s) over the past 24 hours.

Complete the query.

Select…
| where ResourceProvider=="MICROSOFT.DOCUMENTDB" and Category==Select…
| where TimeGenerated >= ago(1d)

| summarize max(responseLength_s), max(requestLength_s), max(requestCharge_s), count = count() by OperationName,
requestResourceType_s, userAgent_s, collectionRid_s

You have an Azure Cosmos DB Core (SQL) API account named account1 with the disableKeyBasedMetadataWriteAccess property enabled.

You are developing an app named App1 that DevUser1 will use to create containers in account1. DevUser1 has a non-privileged user account in the Azure Active Directory (Azure AD) tenant.

You need to ensure that DevUser1 can use App1 to create containers in account1.

What should you do?

You are designing three apps named App1, App2, and App3. Each app will use its own Azure Cosmos DB for NoSQL account. The apps have these consistency requirements:

• App1: Reads must always return an item's most recently committed version when the commit occurred in the same session.
• App2: Reads must always return an item's most recently committed version, even when the commit occurred in a different session.
• App3: Write latency must be minimized, and data staleness is acceptable.

You need to recommend a default consistency level for each Azure Cosmos DB for NoSQL account while minimizing concurrency.

Each consistency level may be used once, more than once, or not at all.

You have an Azure Cosmos DB for NoSQL account named account1.

You plan to implement a multi-region write scenario.

You enable multi-region writes for account1.

Which two actions should you take next? Each correct answer presents part of the solution.

> NOTE: Each correct answer is worth one point.

You have an Azure subscription containing an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1.

At some time during the previous 4S hours, Container1 was deleted.

You need to restore the account to the point immediately before Container1 was deleted. The solution must minimize administrative effort.

What should you do first?