You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.
SELECT
IS_NUMBER( " 1234 " ) AS A,
IS_NUMBER(1234) AS B,
IS_NUMBER({prop: 1234}) AS C
What is the output of the query?
You are designing an Azure Cosmos DB for NoSQL solution.
You plan to create a new container named Container1 that will store product data for automotive repair pans as shown in the following table.
The data will be stored in Container! as shown in the following table
You need to recommend a data partitioning solution for the database. The solution must spread the workload to minimize I/O contention.
Which column should you recommend for the physical partition key and the logical partition key? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have an application that queries an Azure Cosmos 06 for NoSQL account.
You discover that the following two queries run frequently,
You need to minimize the request units (RUs) consumed by reads and writes. What should you create?
You have an Azure Cosmos DB for NoSQL database that hosts a container named Container1. Container1 stores customer documents that have the following structure.
You need to retrieve the city of residence and the age of each customer who is older than 40.
Which three statements should you run in sequence to build the query? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
You have an Azure Cosmos DB database that contains a container named container 1. The container1 container is configured with a maximum of 20,000 RU/s and currently contains 240 GB of data.
You need to estimate the costs of container1 based on the current usage.
How many RU/s will be charged?
You have an Azure Cosmos DB for NoSQL account that uses the default consistency level. How can the consistency level be modified as part of a query request?
You have an Azure Cosmos DB for NoSQL account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception. The runtime exception prevents conflicts from being resolved.
You need to use an Azure function to resolve the conflicts. What should you use?
You are building an application that will store data in an Azure Cosmos DB for NoSQL account. The account uses the session default consistency level. The account is used by five other applications. The account has a single read-write region and 10 additional read regions.
Approximately 20 percent of the items stored in the account are updated hourly.
Several users will access the new application from multiple devices.
You need to ensure that the users see the same item values consistently when they browse from the different devices. The solution must not affect the other applications.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You have an Azure Cosmos DB Core (SQL) API account named storage1 that uses provisioned throughput capacity mode.
The storage1 account contains the databases shown in the following table.
The databases contain the containers shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
