Free Microsoft 70-777 Exam Dumps Questions & Answers

You have an Azure Cosmos DB database that uses the SQL API. The database contains a collection. The collection contains multiple documents. The documents use several different ISON schemas.
Two common queries are performed as shown in the following table.

Which index kind will provide the fastest execution of each query? To answer, drag the appropriate index kinds to the correct queries. Each index kind may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE Each correct selection is worth one point.

Correct Answer:

You have an Azure Cosmos DB account named Account1 that uses the SQL APL Account1 contains a collection named Coll1
You need to ensure that you can run GROUP BY aggregate queries against Coll1.
What should you do?

• A.  In Coll1, create a user-defined function.
• B.  In Coll1, configure a Range index against the queried path at the maximum precision.
• C.  Deploy an Azure function and configure a Cosmos DB output binding
• D.  Deploy an Apache Spark duster in Azure HDInsight and configure a Cosmos DB connector

You have an Azure Cosmos DB database that uses the SQL API. The database contains a collection named People. People contains SON documents that describe the relationships between individual people and their fends.
The following is a sample of the JSON document.

You need to create a SQL query that retrieves the names of Karen Archer's friend. The results must be formatted as shown in the following output.

Which SQL query should you use?

• A.  SELECT VALUE friend.name FROM people JOIN friend IN people. Friends. WIERE people-name = "Karen Archer"
• B.  SELECT friend FROM people JOIN friend IN people. Friends. WIERE people-name = "Karen Archer"
• C.  SELECT VALUE friend FROM people JOIN friend IN people. Friends. WIERE people-name = "Karen Archer"
• D.  SELECT friend FROM people JOIN friend IN people. Friends. WIERE people-name = "Karen Archer"

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

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 TTL value for Coll1 to 129,600.
Does this meet the goal?

• A.  Yes
• B.  No