DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Part 2
Question #: 61
Topic #: 5
You need to create a database in an Azure Cosmos DB Core (SQL) API account. The database will contain three containers named coll1, coll2, and coll3. The coll1 container will have unpredictable read and write volumes. The coll2 and coll3 containers will have predictable read and write volumes. The expected maximum throughput for coll1 and coll2 is 50,000 request units per second (RU/s) each.
How should you provision the collection while minimizing costs?
- Create a serverless account.
B. Create a provisioned throughput account. Set the throughput for coll1 to Autoscale. Set the throughput for coll2 and coll3 to Manual.
C. Create a provisioned throughput account. Set the throughput for coll1 to Manual. Set the throughput for coll2 and coll3 to Autoscale.
Selected Answer: B
———————————————————————-
Question #: 62
Topic #: 1
HOTSPOT –
You have a database in an Azure Cosmos DB Core (SQL) API account.
You plan to create a container that will store employee data for 5,000 small businesses. Each business will have up to 25 employees. Each employee item will have an emailAddress value.
You need to ensure that the emailAddress value for each employee within the same company is unique.
To what should you set the partition key and the unique key? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
No answers
Selected Answer: B
———————————————————————-
Question #: 63
Topic #: 3
HOTSPOT –
You configure Azure Cognitive Search to index a container in an Azure Cosmos DB Core (SQL) API account as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:
No answers
Selected Answer: B
———————————————————————-
Question #: 64
Topic #: 2
The settings for a container in an Azure Cosmos DB Core (SQL) API account are configured as shown in the following exhibit.
Which statement describes the configuration of the container?
- All items will be deleted after one year.
B. Items stored in the collection will be retained always, regardless of the items time to live value.
C. Items stored in the collection will expire only if the item has a time to live value.
D. All items will be deleted after one hour.
Selected Answer: C
———————————————————————-
Question #: 65
Topic #: 4
You have the following query.
You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query.
What should you recommend?
- a composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)
B. a composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for (sensor DESC, value DESC, timestamp DESC)
C. a composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC, sensor ASC)
D. a composite index for (sensor ASC, value ASC, timestamp ASC)
Selected Answer: A
———————————————————————-
Question #: 66
Topic #: 6
HOTSPOT –
You need to select the capacity mode and scale configuration for account2 to support the planned changes and meet the business requirements.
What should you select? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
No answers
Selected Answer: B
———————————————————————-
Question #: 67
Topic #: 5
You need to create a database in an Azure Cosmos DB Core (SQL) API account. The database will contain three containers named coll1, coll2, and coll3. The coll1 container will have unpredictable read and write volumes. The coll2 and coll3 containers will have predictable read and write volumes. The expected maximum throughput for coll1 and coll2 is 50,000 request units per second (RU/s) each.
How should you provision the collection while minimizing costs?
- Create a serverless account.
B. Create a provisioned throughput account. Set the throughput for coll1 to Autoscale. Set the throughput for coll2 and coll3 to Manual.
C. Create a provisioned throughput account. Set the throughput for coll1 to Manual. Set the throughput for coll2 and coll3 to Autoscale.
Selected Answer: B
———————————————————————-
Question #: 68
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.
You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West
US`)
What is the effect of running the command?
- The account will be unavailable to writes during the change
B. The provisioned throughput for account1 will increase
C. The account will be configured for multi-region writes
D. A manual failover will occur
Selected Answer: A
———————————————————————-
Question #: 69
Topic #: 4
You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of container1 is set to none.
You configure Azure Cognitive Search to extract data from container1 and make the data searchable.
You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index.
What should you do to resolve the issue?
- Modify the index attributes in Cognitive Search to Searchable
B. Modify the index attributes in Cognitive Search to Retrievable
C. Modify the indexing policy of container1 to exclude the /* path
D. Change the indexing mode of container1 to consistent
Selected Answer: D
———————————————————————-
Question #: 70
Topic #: 5
HOTSPOT –
You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.
The database is modified once per day in a batch process.
You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.
How should you configure the backup settings? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
No answers
Selected Answer: A
———————————————————————-
Question #: 71
Topic #: 1
HOTSPOT –
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.
The orderId property is used as the partition key.
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 #: 72
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.
You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West
US`)
What is the effect of running the command?
- The account will be unavailable to writes during the change
B. The provisioned throughput for account1 will increase
C. The account will be configured for multi-region writes
D. A manual failover will occur
Selected Answer: A
———————————————————————-
Question #: 73
Topic #: 4
You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of container1 is set to none.
You configure Azure Cognitive Search to extract data from container1 and make the data searchable.
You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index.
What should you do to resolve the issue?
- Modify the index attributes in Cognitive Search to Searchable
B. Modify the index attributes in Cognitive Search to Retrievable
C. Modify the indexing policy of container1 to exclude the /* path
D. Change the indexing mode of container1 to consistent
Selected Answer: D
———————————————————————-
Question #: 74
Topic #: 5
HOTSPOT –
You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.
The database is modified once per day in a batch process.
You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.
How should you configure the backup settings? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
No answers
Selected Answer: C
———————————————————————-
Question #: 75
Topic #: 1
HOTSPOT –
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.
The orderId property is used as the partition key.
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 #: 76
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.
You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West
US`)
What is the effect of running the command?
- The account will be unavailable to writes during the change
B. The provisioned throughput for account1 will increase
C. The account will be configured for multi-region writes
D. A manual failover will occur
Selected Answer: A
———————————————————————-
Question #: 77
Topic #: 4
You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of container1 is set to none.
You configure Azure Cognitive Search to extract data from container1 and make the data searchable.
You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index.
What should you do to resolve the issue?
- Modify the index attributes in Cognitive Search to Searchable
B. Modify the index attributes in Cognitive Search to Retrievable
C. Modify the indexing policy of container1 to exclude the /* path
D. Change the indexing mode of container1 to consistent
Selected Answer: D
———————————————————————-
Question #: 78
Topic #: 5
HOTSPOT –
You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.
The database is modified once per day in a batch process.
You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.
How should you configure the backup settings? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
No answers
Selected Answer: B
———————————————————————-
Question #: 79
Topic #: 1
HOTSPOT –
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.
The orderId property is used as the partition key.
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 #: 80
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.
You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West
US`)
What is the effect of running the command?
- The account will be unavailable to writes during the change
B. The provisioned throughput for account1 will increase
C. The account will be configured for multi-region writes
D. A manual failover will occur
Selected Answer: A
———————————————————————-
Question #: 81
Topic #: 4
You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of container1 is set to none.
You configure Azure Cognitive Search to extract data from container1 and make the data searchable.
You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index.
What should you do to resolve the issue?
- Modify the index attributes in Cognitive Search to Searchable
B. Modify the index attributes in Cognitive Search to Retrievable
C. Modify the indexing policy of container1 to exclude the /* path
D. Change the indexing mode of container1 to consistent
Selected Answer: D
———————————————————————-
Question #: 82
Topic #: 5
HOTSPOT –
You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.
The database is modified once per day in a batch process.
You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.
How should you configure the backup settings? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
No answers
Selected Answer: B
———————————————————————-
Question #: 83
Topic #: 1
HOTSPOT –
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.
The orderId property is used as the partition key.
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: D
———————————————————————-
Question #: 84
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.
You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West
US`)
What is the effect of running the command?
- The account will be unavailable to writes during the change
B. The provisioned throughput for account1 will increase
C. The account will be configured for multi-region writes
D. A manual failover will occur
Selected Answer: A
———————————————————————-
Question #: 85
Topic #: 4
You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of container1 is set to none.
You configure Azure Cognitive Search to extract data from container1 and make the data searchable.
You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index.
What should you do to resolve the issue?
- Modify the index attributes in Cognitive Search to Searchable
B. Modify the index attributes in Cognitive Search to Retrievable
C. Modify the indexing policy of container1 to exclude the /* path
D. Change the indexing mode of container1 to consistent
Selected Answer: D
———————————————————————-
Question #: 86
Topic #: 5
HOTSPOT –
You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.
The database is modified once per day in a batch process.
You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.
How should you configure the backup settings? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
No answers
Selected Answer: C
———————————————————————-
Question #: 87
Topic #: 1
HOTSPOT –
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.
The orderId property is used as the partition key.
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: D
———————————————————————-
Question #: 88
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.
You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West
US`)
What is the effect of running the command?
- The account will be unavailable to writes during the change
B. The provisioned throughput for account1 will increase
C. The account will be configured for multi-region writes
D. A manual failover will occur
Selected Answer: A
———————————————————————-
Question #: 89
Topic #: 4
You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of container1 is set to none.
You configure Azure Cognitive Search to extract data from container1 and make the data searchable.
You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index.
What should you do to resolve the issue?
- Modify the index attributes in Cognitive Search to Searchable
B. Modify the index attributes in Cognitive Search to Retrievable
C. Modify the indexing policy of container1 to exclude the /* path
D. Change the indexing mode of container1 to consistent
Selected Answer: D
———————————————————————-
Question #: 90
Topic #: 5
HOTSPOT –
You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.
The database is modified once per day in a batch process.
You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.
How should you configure the backup settings? 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 #: 91
Topic #: 1
HOTSPOT –
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.
The orderId property is used as the partition key.
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: D
———————————————————————-
Question #: 92
Topic #: 2
You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.
You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West
US`)
What is the effect of running the command?
- The account will be unavailable to writes during the change
B. The provisioned throughput for account1 will increase
C. The account will be configured for multi-region writes
D. A manual failover will occur
Selected Answer: A
———————————————————————-
Question #: 93
Topic #: 4
You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of container1 is set to none.
You configure Azure Cognitive Search to extract data from container1 and make the data searchable.
You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index.
What should you do to resolve the issue?
- Modify the index attributes in Cognitive Search to Searchable
B. Modify the index attributes in Cognitive Search to Retrievable
C. Modify the indexing policy of container1 to exclude the /* path
D. Change the indexing mode of container1 to consistent
Selected Answer: D
———————————————————————-
Question #: 94
Topic #: 5
HOTSPOT –
You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.
The database is modified once per day in a batch process.
You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.
How should you configure the backup settings? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
No answers
Selected Answer: B
———————————————————————-
Question #: 95
Topic #: 1
HOTSPOT –
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.
The orderId property is used as the partition key.
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 #: 96
Topic #: 1
You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.
The following is a sample of the data.
You need to select a partition key that meets the following requirements for writes:
✑ Minimizes the partition skew
✑ Avoids capacity limits
✑ Avoids hot partitions
What should you do?
- Use timestamp as the partition key.
B. Create a new synthetic key that contains deviceId and sensor1Value.
C. Create a new synthetic key that contains deviceId and deviceManufacturer.
D. Create a new synthetic key that contains deviceId and a random number.
Selected Answer: D
———————————————————————-
Question #: 97
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: D
———————————————————————-
Question #: 98
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: A
———————————————————————-
Question #: 99
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: B
———————————————————————-
Question #: 100
Topic #: 1
You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.
The following is a sample of the data.
You need to select a partition key that meets the following requirements for writes:
✑ Minimizes the partition skew
✑ Avoids capacity limits
✑ Avoids hot partitions
What should you do?
- Use timestamp as the partition key.
B. Create a new synthetic key that contains deviceId and sensor1Value.
C. Create a new synthetic key that contains deviceId and deviceManufacturer.
D. Create a new synthetic key that contains deviceId and a random number.
Selected Answer: D
———————————————————————-
Question #: 101
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 #: 102
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 #: 103
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: B
———————————————————————-
Question #: 104
Topic #: 1
You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.
The following is a sample of the data.
You need to select a partition key that meets the following requirements for writes:
✑ Minimizes the partition skew
✑ Avoids capacity limits
✑ Avoids hot partitions
What should you do?
- Use timestamp as the partition key.
B. Create a new synthetic key that contains deviceId and sensor1Value.
C. Create a new synthetic key that contains deviceId and deviceManufacturer.
D. Create a new synthetic key that contains deviceId and a random number.
Selected Answer: D
———————————————————————-
Question #: 105
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: D
———————————————————————-
Question #: 106
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: B
———————————————————————-
Question #: 107
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: B
———————————————————————-
Question #: 108
Topic #: 1
You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.
The following is a sample of the data.
You need to select a partition key that meets the following requirements for writes:
✑ Minimizes the partition skew
✑ Avoids capacity limits
✑ Avoids hot partitions
What should you do?
- Use timestamp as the partition key.
B. Create a new synthetic key that contains deviceId and sensor1Value.
C. Create a new synthetic key that contains deviceId and deviceManufacturer.
D. Create a new synthetic key that contains deviceId and a random number.
Selected Answer: D
———————————————————————-
Question #: 109
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: C
———————————————————————-
Question #: 110
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 #: 111
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 #: 112
Topic #: 1
You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.
The following is a sample of the data.
You need to select a partition key that meets the following requirements for writes:
✑ Minimizes the partition skew
✑ Avoids capacity limits
✑ Avoids hot partitions
What should you do?
- Use timestamp as the partition key.
B. Create a new synthetic key that contains deviceId and sensor1Value.
C. Create a new synthetic key that contains deviceId and deviceManufacturer.
D. Create a new synthetic key that contains deviceId and a random number.
Selected Answer: D
———————————————————————-
Question #: 113
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: A
———————————————————————-
Question #: 114
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: B
———————————————————————-
Question #: 115
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: D
———————————————————————-
Question #: 116
Topic #: 1
You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.
The following is a sample of the data.
You need to select a partition key that meets the following requirements for writes:
✑ Minimizes the partition skew
✑ Avoids capacity limits
✑ Avoids hot partitions
What should you do?
- Use timestamp as the partition key.
B. Create a new synthetic key that contains deviceId and sensor1Value.
C. Create a new synthetic key that contains deviceId and deviceManufacturer.
D. Create a new synthetic key that contains deviceId and a random number.
Selected Answer: D
———————————————————————-
Question #: 117
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 #: 118
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: A
———————————————————————-
Question #: 119
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 #: 120
Topic #: 1
You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.
The following is a sample of the data.
You need to select a partition key that meets the following requirements for writes:
✑ Minimizes the partition skew
✑ Avoids capacity limits
✑ Avoids hot partitions
What should you do?
- Use timestamp as the partition key.
B. Create a new synthetic key that contains deviceId and sensor1Value.
C. Create a new synthetic key that contains deviceId and deviceManufacturer.
D. Create a new synthetic key that contains deviceId and a random number.
Selected Answer: D
———————————————————————-
