IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 70-777 問題集  / 70-777 問題練習

Microsoft 70-777 問題練習

Implementing Microsoft Azure Cosmos DB Solutions 試験

最新更新時間: 2021/01/10,合計32問。

2021新年のギフト:70-777 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、70-777 問題集を使用してください。

 / 3

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.



正解:

Question No : 2
You are implementing security for an Azure Cosmos DB account that uses the SQL API.
The account has the following collections:
- Movies A collection of move information
- Reviews A collection of move review information
You identify three types of access for Cosmos DB as shown in the following table.



You need to identity which method to use to configure the access types. The solution must use the principle of least privilege.
Which method should you identity for each access type? To answer, drag the appropriate methods to the correct access types. Each method 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.



正解:

Question No : 3
You have an Azure Cosmos DB account that uses the SQL API. The account has a limit of 2,500 request units per second (RU/s). The default consistency level is set to Eventual.
You discover that you frequently exceed the Ru/s limit.
You need to recommend strategies to reduce the number of request units (RUs) consumed.
Which two possible strategies can you recommend to achieve this goal? Each correct answer presents a complete solution. NOTE. Each correct selection is worth one point.

正解:

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 consistency level of Account1 to Strong.
Does this meet the goal?

正解:

Question No : 5
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?

正解:

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

正解:

Question No : 7
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 database that uses the Table API. The database contains a table that includes the student data of a school. A subset of the data is shown in the following table.



Another student named Matt Berg joins the school.
You need to add a new entity for the new student.
Solution: You run the following Azure Power Shell command.
Add-StorageTableRow -table $Table_name -partitionKey 2 -rowkey (“matt_berg_9041”) -property @{“First Name”-”Mathew”; Last Name"-"Berg"; "Age"-9}

正解:

Question No : 8
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 database that uses the Table API. The database contains a table that includes the student data of a school. A subset of the data is shown in the following table.



Another student named Matt Berg joins the school.
You need to add a new entity for the new student.
Solution: You run the following Azure Power Shell command.
Add-StorageTableRow -table $Table_name -partitionKey 1 -rowkey (“matt_berg_9041”) -property @{“First Name”-”Matt”; Last Name"-"Berg"; "Age"-9}
Does this meet the goal?

正解:

Question No : 9
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 database that uses the Table API. The database contains a table that includes the student data of a school. A subset of the data is shown in the following table.



Another student named Matt Berg joins the school.
You need to add a new entity for the new student.
Solution: You run the following Azure Power Shell command.
Add-StorageTableRow -table $Table_name -partitionKey 1 -rowkey (“matt_berg_0723”) -property @{“First Name”-”Matt”; Last Name"-"Berg"; "Age"-9}
Does this meet the goal?

正解:

Question No : 10
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?

正解:

Question No : 11
You have an Azure Cosmos DB account named Account1 that uses the SQL APL Account1 contains a collection named Coll1.
You have an Apache Spark cluster in Azure HDInsight. The duster is located in the same Azure region as Account1.
You configure a Spark to Cosmos DB connector to access Coll1.
You successfully use the following code to run non-aggregate queries from within a Spark session by using the connector (Line numbers are included for reference only.)
01 query= client QueryDocuments (
02 collLink, querystr,
03 options=
04 {
05 ‘enablecrossPartitionQuery': True
06 },
07 partition_key-None)
08 df = spark.createDataFrame(list(query))
You need to modify the code to ensure that you can run couNT aggregate quenes.
What should you do?

正解:

Question No : 12
You have an Azure Cosmos DB account that uses the SQL API. The account contains a collection.
You have an Apache Spark cluster in Azure HDInsight. The cluster is located in the same Azure region as the Cosmos DB account.
You need to ensure that you can use a Spark to Cosmos DB connector to run Microsoft Power BI queries against the Cosmos DB data.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order



正解:

Question No : 13
You have a client that uses a MongoDB database.
You migrate the MongoDB database to an Azure Cosmos DB account that uses the MongoDB API.
You update the client to use the following connection string:
mongodb://mongoadmin:7AMtgNcbJUFL7whv0C4PypWQ[email protected]mymongodbapi.documents.azure.com:10255/?replicaSet=globaldb
After updating the client, you discover that the client cannot connect.
You need to ensure that the client can connect to the Cosmos DB account by using the MongoDB API.
What should you do to connect the client?
A, Add sst=true to the connection string
B. Increase the request units per second (RU/s) for the collection.
C. From the Access control (AM) blade of the Cosmos DB account, add Monogamian
D. Change the port number to 27017

正解:

Question No : 14
You have an Azure Cosmos DB database that uses the MongoDB API.
You need to build a sharded collection that has a database named mydb, a collection named mycol, and a hashed shard key named mykey.
How should you complete the command? To answer, drag the appropriate values to the correct targets. Each value 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.



正解:

Question No : 15
You have an Azure Cosmas DB database and a virtual machine that hosts a middle-tier application.
You need to ensure that only connections from the virtual machine can be used to access the database.
What should you do?

正解:

 / 3