DP-420: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB

Question #: 121
Topic #: 2
HOTSPOT –
You are developing an application that will connect to an Azure Cosmos DB Core (SQL) API account. The account has a single read-write region and one additional read region. The regions are configured for automatic failover.
The account has the following connection strings. (Line numbers are included for reference only.)



For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

No answers

Selected Answer: B
———————————————————————-

Question #: 122
Topic #: 4
HOTSPOT –
You have an Azure Cosmos DB Core (SQL) API account that frequently receives the same three queries.
You need to configure indexing to minimize RUs consumed by the queries.
Which type of index should you use for each query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

No answers

Selected Answer: D
———————————————————————-

Question #: 123
Topic #: 5
HOTSPOT –
You have an Azure Cosmos DB Core (SQL) API account named account1.
You have the Azure virtual networks and subnets shown in the following table.



The vnet1 and vnet2 networks are connected by using a virtual network peer.
The Firewall and virtual network settings for account1 are configured as shown in the exhibit.



For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

No answers

Selected Answer: C
———————————————————————-

Question #: 124
Topic #: 1
You maintain a relational database for a book publisher. The database contains the following tables.



The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.
What should you include in the solution?

1. Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.
   B. Create Author, Book, and Bookauthorlnk documents in the same container.
   C. Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.
   D. Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

Selected Answer: A
———————————————————————-

Question #: 125
Topic #: 4
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained is 20 KB.
You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute.
You need to minimize the consumption of the request units (RUs) associated to the reads by App1.
What should you do?

1. In App1, modify the connection policy settings
   B. In App1, change the consistency level of read requests to consistent prefix
   C. In account1, provision a dedicated gateway and integrated cache
   D. In account1, change the default consistency level to bounded staleness

Selected Answer: C
———————————————————————-

Question #: 126
Topic #: 2
You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes.
You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority.
Which parameter should you check in the stored procedure function?

1. isTombstone
   B. conflictingItems
   C. existingItem
   D. incomingItem

Selected Answer: A
———————————————————————-

Question #: 127
Topic #: 5
You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.
You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.
Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Wrap Key
   B. Get
   C. List
   D. Update
   E. Sign
   F. Verify
   G. Unwrap Key

Selected Answer: B
———————————————————————-

Question #: 128
Topic #: 1
You maintain a relational database for a book publisher. The database contains the following tables.



The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.
What should you include in the solution?

1. Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.
   B. Create Author, Book, and Bookauthorlnk documents in the same container.
   C. Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.
   D. Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

Selected Answer: A
———————————————————————-

Question #: 129
Topic #: 4
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained is 20 KB.
You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute.
You need to minimize the consumption of the request units (RUs) associated to the reads by App1.
What should you do?

1. In App1, modify the connection policy settings
   B. In App1, change the consistency level of read requests to consistent prefix
   C. In account1, provision a dedicated gateway and integrated cache
   D. In account1, change the default consistency level to bounded staleness

Selected Answer: C
———————————————————————-

Question #: 130
Topic #: 2
You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes.
You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority.
Which parameter should you check in the stored procedure function?

1. isTombstone
   B. conflictingItems
   C. existingItem
   D. incomingItem

Selected Answer: A
———————————————————————-

Question #: 131
Topic #: 5
You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.
You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.
Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Wrap Key
   B. Get
   C. List
   D. Update
   E. Sign
   F. Verify
   G. Unwrap Key

Selected Answer: C
———————————————————————-

Question #: 132
Topic #: 1
You maintain a relational database for a book publisher. The database contains the following tables.



The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.
What should you include in the solution?

1. Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.
   B. Create Author, Book, and Bookauthorlnk documents in the same container.
   C. Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.
   D. Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

Selected Answer: A
———————————————————————-

Question #: 133
Topic #: 4
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained is 20 KB.
You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute.
You need to minimize the consumption of the request units (RUs) associated to the reads by App1.
What should you do?

1. In App1, modify the connection policy settings
   B. In App1, change the consistency level of read requests to consistent prefix
   C. In account1, provision a dedicated gateway and integrated cache
   D. In account1, change the default consistency level to bounded staleness

Selected Answer: C
———————————————————————-

Question #: 134
Topic #: 2
You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes.
You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority.
Which parameter should you check in the stored procedure function?

1. isTombstone
   B. conflictingItems
   C. existingItem
   D. incomingItem

Selected Answer: A
———————————————————————-

Question #: 135
Topic #: 5
You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.
You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.
Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Wrap Key
   B. Get
   C. List
   D. Update
   E. Sign
   F. Verify
   G. Unwrap Key

Selected Answer: D
———————————————————————-

Question #: 136
Topic #: 1
You maintain a relational database for a book publisher. The database contains the following tables.



The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.
What should you include in the solution?

1. Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.
   B. Create Author, Book, and Bookauthorlnk documents in the same container.
   C. Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.
   D. Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

Selected Answer: A
———————————————————————-

Question #: 137
Topic #: 4
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained is 20 KB.
You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute.
You need to minimize the consumption of the request units (RUs) associated to the reads by App1.
What should you do?

1. In App1, modify the connection policy settings
   B. In App1, change the consistency level of read requests to consistent prefix
   C. In account1, provision a dedicated gateway and integrated cache
   D. In account1, change the default consistency level to bounded staleness

Selected Answer: C
———————————————————————-

Question #: 138
Topic #: 2
You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes.
You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority.
Which parameter should you check in the stored procedure function?

1. isTombstone
   B. conflictingItems
   C. existingItem
   D. incomingItem

Selected Answer: A
———————————————————————-

Question #: 139
Topic #: 5
You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.
You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.
Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Wrap Key
   B. Get
   C. List
   D. Update
   E. Sign
   F. Verify
   G. Unwrap Key

Selected Answer: C
———————————————————————-

Question #: 140
Topic #: 1
You maintain a relational database for a book publisher. The database contains the following tables.



The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.
What should you include in the solution?

1. Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.
   B. Create Author, Book, and Bookauthorlnk documents in the same container.
   C. Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.
   D. Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

Selected Answer: A
———————————————————————-

Question #: 141
Topic #: 4
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained is 20 KB.
You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute.
You need to minimize the consumption of the request units (RUs) associated to the reads by App1.
What should you do?

1. In App1, modify the connection policy settings
   B. In App1, change the consistency level of read requests to consistent prefix
   C. In account1, provision a dedicated gateway and integrated cache
   D. In account1, change the default consistency level to bounded staleness

Selected Answer: C
———————————————————————-

Question #: 142
Topic #: 2
You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes.
You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority.
Which parameter should you check in the stored procedure function?

1. isTombstone
   B. conflictingItems
   C. existingItem
   D. incomingItem

Selected Answer: A
———————————————————————-

Question #: 143
Topic #: 5
You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.
You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.
Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Wrap Key
   B. Get
   C. List
   D. Update
   E. Sign
   F. Verify
   G. Unwrap Key

Selected Answer: A
———————————————————————-

Question #: 144
Topic #: 1
You maintain a relational database for a book publisher. The database contains the following tables.



The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.
What should you include in the solution?

1. Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.
   B. Create Author, Book, and Bookauthorlnk documents in the same container.
   C. Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.
   D. Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

Selected Answer: A
———————————————————————-

Question #: 145
Topic #: 4
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained is 20 KB.
You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute.
You need to minimize the consumption of the request units (RUs) associated to the reads by App1.
What should you do?

1. In App1, modify the connection policy settings
   B. In App1, change the consistency level of read requests to consistent prefix
   C. In account1, provision a dedicated gateway and integrated cache
   D. In account1, change the default consistency level to bounded staleness

Selected Answer: C
———————————————————————-

Question #: 146
Topic #: 2
You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes.
You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority.
Which parameter should you check in the stored procedure function?

1. isTombstone
   B. conflictingItems
   C. existingItem
   D. incomingItem

Selected Answer: A
———————————————————————-

Question #: 147
Topic #: 5
You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.
You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.
Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Wrap Key
   B. Get
   C. List
   D. Update
   E. Sign
   F. Verify
   G. Unwrap Key

Selected Answer: B
———————————————————————-

Question #: 148
Topic #: 1
You maintain a relational database for a book publisher. The database contains the following tables.



The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.
What should you include in the solution?

1. Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.
   B. Create Author, Book, and Bookauthorlnk documents in the same container.
   C. Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.
   D. Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

Selected Answer: A
———————————————————————-

Question #: 149
Topic #: 4
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained is 20 KB.
You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute.
You need to minimize the consumption of the request units (RUs) associated to the reads by App1.
What should you do?

1. In App1, modify the connection policy settings
   B. In App1, change the consistency level of read requests to consistent prefix
   C. In account1, provision a dedicated gateway and integrated cache
   D. In account1, change the default consistency level to bounded staleness

Selected Answer: C
———————————————————————-

Question #: 150
Topic #: 2
You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes.
You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority.
Which parameter should you check in the stored procedure function?

1. isTombstone
   B. conflictingItems
   C. existingItem
   D. incomingItem

Selected Answer: A
———————————————————————-

Question #: 151
Topic #: 5
You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.
You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.
Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Wrap Key
   B. Get
   C. List
   D. Update
   E. Sign
   F. Verify
   G. Unwrap Key

Selected Answer: A
———————————————————————-

Question #: 152
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level.
You configure account1 to use a dedicated gateway and integrated cache.
You need to ensure that App1 can use the integrated cache.
Which two actions should you perform for App1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Change the consistency level of requests to session.
   B. Change the account endpoint to http://account1.documents.azure.com.
   C. Change the account endpoint to http://account1.sqlx.cosmos.azure.com.
   D. Change the connection mode to direct.
   E. Change the consistency level of requests to strong.

Selected Answer: AC
———————————————————————-

Question #: 153
Topic #: 1
You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.



What is the output of the query?

1. [{“A”: false, “B”: true, “C”: false}]
   B. [{“A”: true, “B”: false, “C”: true}]
   C. [{“A”: true, “B”: true, “C”: false}]
   D. [{“A”: true, “B”: true, “C”: true}]

Selected Answer: A
———————————————————————-

Question #: 154
Topic #: 5
You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector”
   B. “key.converter”: “org.apache.kafka.connect.json.JsonConverter”
   C. “key.converter”: “io.confluent.connect.avro.AvroConverter”
   D. “connect.cosmos.containers.topicmap”: “iot#telemetry”
   E. “connect.cosmos.containers.topicmap”: “iot”
   F. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector”

Selected Answer: ACD
———————————————————————-

Question #: 155
Topic #: 4
You have an application that queries an Azure Cosmos DB Core (SQL) API account.
You discover that the following two queries run frequently.



You need to minimize the request units (RUs) consumed by reads and writes.
What should you create?

1. a composite index for (name DESC, timestamp ASC)
   B. a composite index for (name ASC, timestamp ASC) and a composite index for (name DESC, timestamp DESC)
   C. a composite index for (name ASC, timestamp ASC)
   D. a composite index for (name ASC, timestamp DESC)

Selected Answer: B
———————————————————————-

Question #: 156
Topic #: 3
You have an Azure Cosmos DB Core (SQL) API account.
The change feed is enabled on a container named invoice.
You create an Azure function that has a trigger on the change feed.
What is received by the Azure function?

1. only the changed properties and the system-defined properties of the updated items
   B. only the partition key and the changed properties of the updated items
   C. all the properties of the original items and the updated items
   D. all the properties of the updated items

Selected Answer: D
———————————————————————-

Question #: 157
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level.
You configure account1 to use a dedicated gateway and integrated cache.
You need to ensure that App1 can use the integrated cache.
Which two actions should you perform for App1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Change the consistency level of requests to session.
   B. Change the account endpoint to http://account1.documents.azure.com.
   C. Change the account endpoint to http://account1.sqlx.cosmos.azure.com.
   D. Change the connection mode to direct.
   E. Change the consistency level of requests to strong.

Selected Answer: AC
———————————————————————-

Question #: 158
Topic #: 1
You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.



What is the output of the query?

1. [{“A”: false, “B”: true, “C”: false}]
   B. [{“A”: true, “B”: false, “C”: true}]
   C. [{“A”: true, “B”: true, “C”: false}]
   D. [{“A”: true, “B”: true, “C”: true}]

Selected Answer: A
———————————————————————-

Question #: 159
Topic #: 5
You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector”
   B. “key.converter”: “org.apache.kafka.connect.json.JsonConverter”
   C. “key.converter”: “io.confluent.connect.avro.AvroConverter”
   D. “connect.cosmos.containers.topicmap”: “iot#telemetry”
   E. “connect.cosmos.containers.topicmap”: “iot”
   F. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector”

Selected Answer: ACD
———————————————————————-

Question #: 160
Topic #: 4
You have an application that queries an Azure Cosmos DB Core (SQL) API account.
You discover that the following two queries run frequently.



You need to minimize the request units (RUs) consumed by reads and writes.
What should you create?

1. a composite index for (name DESC, timestamp ASC)
   B. a composite index for (name ASC, timestamp ASC) and a composite index for (name DESC, timestamp DESC)
   C. a composite index for (name ASC, timestamp ASC)
   D. a composite index for (name ASC, timestamp DESC)

Selected Answer: C
———————————————————————-

Question #: 161
Topic #: 3
You have an Azure Cosmos DB Core (SQL) API account.
The change feed is enabled on a container named invoice.
You create an Azure function that has a trigger on the change feed.
What is received by the Azure function?

1. only the changed properties and the system-defined properties of the updated items
   B. only the partition key and the changed properties of the updated items
   C. all the properties of the original items and the updated items
   D. all the properties of the updated items

Selected Answer: D
———————————————————————-

Question #: 162
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level.
You configure account1 to use a dedicated gateway and integrated cache.
You need to ensure that App1 can use the integrated cache.
Which two actions should you perform for App1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Change the consistency level of requests to session.
   B. Change the account endpoint to http://account1.documents.azure.com.
   C. Change the account endpoint to http://account1.sqlx.cosmos.azure.com.
   D. Change the connection mode to direct.
   E. Change the consistency level of requests to strong.

Selected Answer: AC
———————————————————————-

Question #: 163
Topic #: 1
You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.



What is the output of the query?

1. [{“A”: false, “B”: true, “C”: false}]
   B. [{“A”: true, “B”: false, “C”: true}]
   C. [{“A”: true, “B”: true, “C”: false}]
   D. [{“A”: true, “B”: true, “C”: true}]

Selected Answer: A
———————————————————————-

Question #: 164
Topic #: 5
You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector”
   B. “key.converter”: “org.apache.kafka.connect.json.JsonConverter”
   C. “key.converter”: “io.confluent.connect.avro.AvroConverter”
   D. “connect.cosmos.containers.topicmap”: “iot#telemetry”
   E. “connect.cosmos.containers.topicmap”: “iot”
   F. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector”

Selected Answer: ACD
———————————————————————-

Question #: 165
Topic #: 4
You have an application that queries an Azure Cosmos DB Core (SQL) API account.
You discover that the following two queries run frequently.



You need to minimize the request units (RUs) consumed by reads and writes.
What should you create?

1. a composite index for (name DESC, timestamp ASC)
   B. a composite index for (name ASC, timestamp ASC) and a composite index for (name DESC, timestamp DESC)
   C. a composite index for (name ASC, timestamp ASC)
   D. a composite index for (name ASC, timestamp DESC)

Selected Answer: D
———————————————————————-

Question #: 166
Topic #: 3
You have an Azure Cosmos DB Core (SQL) API account.
The change feed is enabled on a container named invoice.
You create an Azure function that has a trigger on the change feed.
What is received by the Azure function?

1. only the changed properties and the system-defined properties of the updated items
   B. only the partition key and the changed properties of the updated items
   C. all the properties of the original items and the updated items
   D. all the properties of the updated items

Selected Answer: D
———————————————————————-

Question #: 167
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level.
You configure account1 to use a dedicated gateway and integrated cache.
You need to ensure that App1 can use the integrated cache.
Which two actions should you perform for App1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Change the consistency level of requests to session.
   B. Change the account endpoint to http://account1.documents.azure.com.
   C. Change the account endpoint to http://account1.sqlx.cosmos.azure.com.
   D. Change the connection mode to direct.
   E. Change the consistency level of requests to strong.

Selected Answer: AC
———————————————————————-

Question #: 168
Topic #: 1
You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.



What is the output of the query?

1. [{“A”: false, “B”: true, “C”: false}]
   B. [{“A”: true, “B”: false, “C”: true}]
   C. [{“A”: true, “B”: true, “C”: false}]
   D. [{“A”: true, “B”: true, “C”: true}]

Selected Answer: A
———————————————————————-

Question #: 169
Topic #: 5
You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector”
   B. “key.converter”: “org.apache.kafka.connect.json.JsonConverter”
   C. “key.converter”: “io.confluent.connect.avro.AvroConverter”
   D. “connect.cosmos.containers.topicmap”: “iot#telemetry”
   E. “connect.cosmos.containers.topicmap”: “iot”
   F. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector”

Selected Answer: ACD
———————————————————————-

Question #: 170
Topic #: 4
You have an application that queries an Azure Cosmos DB Core (SQL) API account.
You discover that the following two queries run frequently.



You need to minimize the request units (RUs) consumed by reads and writes.
What should you create?

1. a composite index for (name DESC, timestamp ASC)
   B. a composite index for (name ASC, timestamp ASC) and a composite index for (name DESC, timestamp DESC)
   C. a composite index for (name ASC, timestamp ASC)
   D. a composite index for (name ASC, timestamp DESC)

Selected Answer: B
———————————————————————-

Question #: 171
Topic #: 3
You have an Azure Cosmos DB Core (SQL) API account.
The change feed is enabled on a container named invoice.
You create an Azure function that has a trigger on the change feed.
What is received by the Azure function?

1. only the changed properties and the system-defined properties of the updated items
   B. only the partition key and the changed properties of the updated items
   C. all the properties of the original items and the updated items
   D. all the properties of the updated items

Selected Answer: D
———————————————————————-

Question #: 172
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level.
You configure account1 to use a dedicated gateway and integrated cache.
You need to ensure that App1 can use the integrated cache.
Which two actions should you perform for App1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Change the consistency level of requests to session.
   B. Change the account endpoint to http://account1.documents.azure.com.
   C. Change the account endpoint to http://account1.sqlx.cosmos.azure.com.
   D. Change the connection mode to direct.
   E. Change the consistency level of requests to strong.

Selected Answer: AC
———————————————————————-

Question #: 173
Topic #: 1
You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.



What is the output of the query?

1. [{“A”: false, “B”: true, “C”: false}]
   B. [{“A”: true, “B”: false, “C”: true}]
   C. [{“A”: true, “B”: true, “C”: false}]
   D. [{“A”: true, “B”: true, “C”: true}]

Selected Answer: A
———————————————————————-

Question #: 174
Topic #: 5
You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector”
   B. “key.converter”: “org.apache.kafka.connect.json.JsonConverter”
   C. “key.converter”: “io.confluent.connect.avro.AvroConverter”
   D. “connect.cosmos.containers.topicmap”: “iot#telemetry”
   E. “connect.cosmos.containers.topicmap”: “iot”
   F. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector”

Selected Answer: ACD
———————————————————————-

Question #: 175
Topic #: 4
You have an application that queries an Azure Cosmos DB Core (SQL) API account.
You discover that the following two queries run frequently.



You need to minimize the request units (RUs) consumed by reads and writes.
What should you create?

1. a composite index for (name DESC, timestamp ASC)
   B. a composite index for (name ASC, timestamp ASC) and a composite index for (name DESC, timestamp DESC)
   C. a composite index for (name ASC, timestamp ASC)
   D. a composite index for (name ASC, timestamp DESC)

Selected Answer: C
———————————————————————-

Question #: 176
Topic #: 3
You have an Azure Cosmos DB Core (SQL) API account.
The change feed is enabled on a container named invoice.
You create an Azure function that has a trigger on the change feed.
What is received by the Azure function?

1. only the changed properties and the system-defined properties of the updated items
   B. only the partition key and the changed properties of the updated items
   C. all the properties of the original items and the updated items
   D. all the properties of the updated items

Selected Answer: D
———————————————————————-

Question #: 177
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level.
You configure account1 to use a dedicated gateway and integrated cache.
You need to ensure that App1 can use the integrated cache.
Which two actions should you perform for App1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. Change the consistency level of requests to session.
   B. Change the account endpoint to http://account1.documents.azure.com.
   C. Change the account endpoint to http://account1.sqlx.cosmos.azure.com.
   D. Change the connection mode to direct.
   E. Change the consistency level of requests to strong.

Selected Answer: AC
———————————————————————-

Question #: 178
Topic #: 1
You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.



What is the output of the query?

1. [{“A”: false, “B”: true, “C”: false}]
   B. [{“A”: true, “B”: false, “C”: true}]
   C. [{“A”: true, “B”: true, “C”: false}]
   D. [{“A”: true, “B”: true, “C”: true}]

Selected Answer: A
———————————————————————-

Question #: 179
Topic #: 5
You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

1. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector”
   B. “key.converter”: “org.apache.kafka.connect.json.JsonConverter”
   C. “key.converter”: “io.confluent.connect.avro.AvroConverter”
   D. “connect.cosmos.containers.topicmap”: “iot#telemetry”
   E. “connect.cosmos.containers.topicmap”: “iot”
   F. “connector.class”: “com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector”

Selected Answer: ACD
———————————————————————-

Question #: 180
Topic #: 4
You have an application that queries an Azure Cosmos DB Core (SQL) API account.
You discover that the following two queries run frequently.



You need to minimize the request units (RUs) consumed by reads and writes.
What should you create?

1. a composite index for (name DESC, timestamp ASC)
   B. a composite index for (name ASC, timestamp ASC) and a composite index for (name DESC, timestamp DESC)
   C. a composite index for (name ASC, timestamp ASC)
   D. a composite index for (name ASC, timestamp DESC)

Selected Answer: C
———————————————————————-