Online Access Free 70-777 Practice Test

You have an Azure Cosmos DB account named Account1 that uses the SQI. API Account1 contains a database named DB1. DB1 contains a collection named Coll. The default TTL value for Coll1 is-1.
You plan to develop an application that will include a Cosmos DB trigger in an Azure function.
You need to recommend a process to remove documents from Coll1.
The solution must meet the following requirements:
- Ensure that the removed documents are recorded in the change feed.
- Minimize request unit (RU) consumption.
What should you recommend?

• A.Set the TTL value for the documents to-1 Delete the documents.
• B.Add a property named IsDeleted to the documents and set the value to True, Delete the documents.
• C.Add a property named IsDeleted to the documents and set the value to True. Set the TTL value for the documents to 1.
• D.Change the default TTL value for Coll1 to 1 Set the TTL value for the documents to-1. Delete the documents.

You create an Azure Cosmos DB account named Account1 that uses the MongoDB API.
In Account1 you create a database named DB1 that contains a collection named Coll1.
You plan to migrate content from an on-premises MongoDB database to Coll1.
You need to identify the latency from the on-premises MongoDB database to Account1.
What should you do first?

• A.From MongoDB Shell, run setverboseShell,
• B.Run mongoexport.exe
• C.Run mongoimport.exe
• D.From MongoDB Shell, run Mongo, setReadPref.

You are designing an Azure Cosmos DB database that will use the SQL API.
You have an application that will write the sale of products to the database. Before a sale is written, the application will verify whether the products in the sale exist. A typical sale includes 10 products.
You need to recommend a design for the database. The solution must minimize storage space.
What should you recommend

• A.Create a collection for products. For each product, create a document in the products collection that contains embedded documents for each sale of the product
• B.Create a collection for each product. In each collection, create a document for each sale of the product.
• C.Create a collection for products and a collection for sales. Create a document for each product in the products collection. For each sale, create a document in the sales collection that references the product documents.
• D.Create a collection for sales. For each sale, create a document in the sales collection that contains embedded documents for each product in the sale.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure Cosmos DB account named Account1 that uses the SQL APL Account1 contains a collection named Coll1.
You create a document named doc1 and set the TTL value for the document to 86,400. Thirty-six hours later, you discover that doc1 still exists in Coll1.
You need to ensure that documents are removed from Coll1 when the TTL for the documents expires.
Solution: You set the default consistency level of Account1 to Strong.
Does this meet the goal?

• A.Yes
• B.No

You have an Azure Cosmos DB account named Account1 that uses the SQL API. Account1 contains a collection named Person that has the following structure.
{
"lastFirst": string,
"address": {
"cityName": string,
"stateName": string
}
}
Person has an index on lastFirst
You need to create an indexed query that returns the following results.
{{
"Location": (
"state": "wA"
"city": "Seattle"
}
"Client": (
"person": "Smith, Ben"
}
}}
In which order should you place the code segments? To answer, move all code segments from the lest of code segments to the answer area and arrange them in the correct order.

Correct Answer: