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 have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you create a container that has the following configurations:

• Partition key: CompanylD

• Composite unique key: UserName and EmailAddress

To the container, you plan to add the data items shown in the following table.

How many conflicts will occur?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1 that stores customer data. Each customer data item includes the customer ' s name and zero or more related business categories in an array.

You need identify customers that have one of their business categories set to " retail " . The solution must return the customerName and businessCategories fields.

How should you complete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a database named db1in an Azure Cosmos DB for NoSQL account named account 1.

You need to write JSON data to db1 by using Azure Stream Analytics. The solution must minimize costs.

Which should you do before you can use db1 as an output of Stream Analytics?

You have an Azure Cosmos DB account named accounts

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 Cosmos DB container named container1.

You need to insert an item into contained. The solution must ensure that the item is deleted automatically after two hours.

How should you complete the item definition? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have the following Azure Resource Manager (ARM) template.

You plan to deploy the template in incremental mode.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

You are designing a data model for an Azure Cosmos DB for NoSQL account.

What are the partition limits for request units per second (RU/s) and storage? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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 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?