exam questions

Exam DP-420 All Questions

View all questions & answers for the DP-420 exam

Exam DP-420 topic 1 question 2 discussion

Actual exam question from Microsoft's DP-420
Question #: 2
Topic #: 1
[All DP-420 Questions]

HOTSPOT -
You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Europe.
You run the following Azure CLI script.

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:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Yes -
The Automatic failover option allows Azure Cosmos DB to failover to the region with the highest failover priority with no user action should a region become unavailable.

Box 2: No -
West Europe is used for failover. Only North Europe is writable.
To Configure multi-region set UseMultipleWriteLocations to true.

Box 3: Yes -
Provisioned throughput with single write region costs $0.008/hour per 100 RU/s and provisioned throughput with multiple writable regions costs $0.016/per hour per 100 RU/s.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-multi-master https://docs.microsoft.com/en-us/azure/cosmos-db/optimize-cost-regions

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
nqthien041292
Highly Voted 1 year, 10 months ago
Vote YNN
upvoted 24 times
...
wispa2001
Highly Voted 1 year, 10 months ago
1:No 2:Yes 3:No
upvoted 12 times
ognamala
1 year, 7 months ago
Your first answer is incorrect - in the above, there is a change of the priority zero, effectively changing the write region.
upvoted 1 times
ognamala
1 year, 7 months ago
Your second answer is also incorrect - again the priority 0 is changing which initiates manual failover - so that should be No.
upvoted 1 times
...
...
Ranzzzan
1 year ago
Should be YNY. for the third one tried it on pricing calculator, the cost does not change.
upvoted 2 times
...
...
anto69
Most Recent 4 days, 9 hours ago
Y-N-N (ChatGPT verified with correct explanation)
upvoted 1 times
...
YellowSky002
2 months ago
If the account has a single write, how do these commands impact the number of databases or writable ones? There is ONLY one primary database , there is no other database.
upvoted 1 times
...
[Removed]
4 months, 2 weeks ago
Answer is YNN
upvoted 1 times
...
60919_S
6 months, 1 week ago
Which is the right answer totally confused .
upvoted 2 times
...
Shiven
7 months ago
1-Y 2-N 3-Y failover_priority - (Required) The failover priority of the region. A failover priority of 0 indicates a write region. The maximum value for a failover priority = (total number of regions - 1). Failover priority values must be unique for each of the regions in which the database account exists. Changing this causes the location to be re-provisioned and cannot be changed for the location with failover priority 0.
upvoted 3 times
...
orionduo
7 months, 2 weeks ago
The anwser are correct. A failover priority of 0 indicates a write region. The price of West Euro and North Euro for Costome DB is just exactly the same. You may check it with Azure Pricing Calculator: https://azure.microsoft.com/en-us/pricing/calculator/
upvoted 1 times
...
azuredemo2022three
9 months, 2 weeks ago
Answer should be No - After running the script, there will not be an instance of Azure Cosmos DB in North Europe that is writable. The script sets the failover priority of North Europe to 0, indicating that it is a secondary region and not writable. Yes - After running the script, the Azure Cosmos DB instance in West Europe will still be writable. The script does not change the failover priority or zone redundancy of the West Europe region, so it remains the primary region and writable. Yes - The cost of the Azure Cosmos DB account is unaffected by running the script. The script only modifies the configuration and failover policies of the account, but it does not change the pricing or billing aspects of the account.
upvoted 1 times
azuredemo2022three
9 months ago
Yes, Answer is YNN
upvoted 1 times
...
...
kel7718
1 year, 3 months ago
A failover priority of 0 indicates a write region (https://learn.microsoft.com/en-us/rest/api/cosmos-db-resource-provider/2021-04-01-preview/database-accounts/failover-priority-change?tabs=HTTP) Knowing this, North Europe is now 0 so write region, first answer is thus Yes. West Europe is now 1 and we did not enable multiple write regions so we can no longer write to west europe and costs haven't increased as it is still a single write region. YNN
upvoted 1 times
Alex22022
1 year, 1 month ago
Costs have increased since North Europe is added. Now we have two regions instead of one. Each region is billed: https://learn.microsoft.com/en-us/training/modules/configure-replication-manage-failovers-azure-cosmos-db/4-evaluate-cost-distributing-data-globally But since the statment is 'The cost ... is unaffected ...', the answer is no. Therefore: YNN
upvoted 2 times
...
...
codingdown
1 year, 3 months ago
bah , not clear at all
upvoted 2 times
...
ognamala
1 year, 7 months ago
Yes - triggering a manual failover by changing priority zero causes write and read regions to be swapped No - triggering a manual failover by changing priority zero causes write and read regions to be swapped Yes - unaffected only because we are switching between west and north europe, if it was say switzerland it would be more expensive
upvoted 7 times
...
SQLK
1 year, 7 months ago
Why option C is yes??
upvoted 1 times
Alex22022
1 year, 1 month ago
C is No because each region is billed additionally. Equivalent emxample from the docs: https://learn.microsoft.com/en-us/training/modules/configure-replication-manage-failovers-azure-cosmos-db/4-evaluate-cost-distributing-data-globally
upvoted 1 times
...
susejzepol
1 year, 3 months ago
I think because they are un the same región. This cause that cost doesn't increase.
upvoted 1 times
...
...
Gtus
1 year, 9 months ago
The third statement here is tricky. Normally, Azure resource price is different for regions, this applicable to Cosmos DB as well. However, the price of West Euro and North Euro for Costome DB is just exactly the same. You may check it with Azure Pricing Calculator: https://azure.microsoft.com/en-us/pricing/calculator/
upvoted 4 times
...
lakime
1 year, 10 months ago
IMO C should be No
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago