QUESTION NO: 1
You have an Azure Cosmos DB account named Account1. Account1 contains a database named DB1. DB1 contains a collection named Coll1. Coll1 contains a stored procedure named Sp1. Sp1 reads the data in Coll1.
You need to create a user named User1 who will have the permissions to run Sp1.
How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have an Azure Cosmos DB account named Account1. Account1 contains a database named DB1. DB1 contains a collection named Coll1. Coll1 contains a stored procedure named Sp1. Sp1 reads the data in Coll1.
You need to create a user named User1 who will have the permissions to run Sp1.
How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION NO: 2
You have an Azure Cosmos DB account named Account1.
You need to grant a new member of your IT staff access to read the read-write keys of Account1. The solution must use the principle of least privilege.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have an Azure Cosmos DB account named Account1.
You need to grant a new member of your IT staff access to read the read-write keys of Account1. The solution must use the principle of least privilege.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION NO: 3
You have an Azure Cosmos DB account that uses the SQL API.
You have a data repository in Azure Storage. The repository includes customer inventory data and customer-specific text files stored as blobs. The maximum size of an individual blob is 5 MB and the total size of the blobs is 5 GB.
You plan to create a collection named Coll1 that will contain multiple documents. Each document will contain information about an individual customer.
You need to recommend a solution to migrate the blobs.
The solution must meet the following requirements:
- Ensure that you can retrieve the text files when querying the data in Cosmos DB.
- Minimize costs.
What should you recommend?
You have an Azure Cosmos DB account that uses the SQL API.
You have a data repository in Azure Storage. The repository includes customer inventory data and customer-specific text files stored as blobs. The maximum size of an individual blob is 5 MB and the total size of the blobs is 5 GB.
You plan to create a collection named Coll1 that will contain multiple documents. Each document will contain information about an individual customer.
You need to recommend a solution to migrate the blobs.
The solution must meet the following requirements:
- Ensure that you can retrieve the text files when querying the data in Cosmos DB.
- Minimize costs.
What should you recommend?
Correct Answer: C
Vote an answer
QUESTION NO: 4
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 null.
Does this meet the goal?
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 null.
Does this meet the goal?
Correct Answer: A
Vote an answer
QUESTION NO: 5
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.
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:
QUESTION NO: 6
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?
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?
Correct Answer: A
Vote an answer