exam questions

Exam AZ-303 All Questions

View all questions & answers for the AZ-303 exam

Exam AZ-303 topic 4 question 3 discussion

Actual exam question from Microsoft's AZ-303
Question #: 3
Topic #: 4
[All AZ-303 Questions]

The developers at your company request that you create databases in Azure Cosmos DB as shown in the following table.

You need to create the Azure Cosmos DB databases to meet the developer request. The solution must minimize costs.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. Create three Azure Cosmos DB accounts, one for the databases that use the Core (SQL) API, one for CosmosDB2, and one for CosmosDB4.
  • B. Create two Azure Cosmos DB accounts, one for CosmosDB2 and CosmosDB4 and one for CosmosDB1 and CosmosDB3.
  • C. Create one Azure Cosmos DB account for each database.
  • D. Create three Azure Cosmos DB accounts, one for the databases that use the MongoDB API, one for CosmosDB1, and one for CosmosDB3.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
Note:
Microsoft recommends using the same API for all access to the data in a given account.
One throughput provisioned container per subscription for SQL, Gremlin API, and Table accounts.
Up to three throughput provisioned collections per subscription for MongoDB accounts.
The throughput provisioned on an Azure Cosmos container is exclusively reserved for that container. The container receives the provisioned throughput all the time.
Incorrect Answers:
A: DB2 and DB4 can use the same account.
C: The most costly alternative.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput#set-throughput-on-a-container

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
azurecert2021
Highly Voted 4 years, 5 months ago
Correct answers are C and D following is the justification for the same. DB1 and DB3 cannot share same CosmosDB account as multiple-write is available on account level not on Database level. DB1 needs multiple write regions but DB1 must has only one write region answer A and B is ruled out as A is saying one account for core SQL API it means DB1 and DB3 will be added to same account same in B where it saying one ac for DB1 and DB3 which is not possibe due to different write regions which is set at ac level hence need different ac for this 2 db is required at least. throughput can be set at DB level or container level or both ,container lever is preffered. https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-multi-master?tabs=api-async Cosmos accounts initially configured with single write region can be configured to multiple write regions with zero down time hence it is at ac level
upvoted 65 times
rdemontis
3 years, 11 months ago
exactly!
upvoted 4 times
...
abhishek_arya02
4 years ago
D can't be the option as the cost need to minimize.
upvoted 1 times
...
a_r_c
4 years, 1 month ago
i don't see option "C" as complete solution, though!
upvoted 1 times
a_r_c
4 years, 1 month ago
No ignore my above comment. C & D it is.
upvoted 2 times
...
...
...
Deepbond
Highly Voted 4 years, 5 months ago
Correct answers are C and D DB1 and DB3 cannot share same CosmosDB account as multiple-write is available on account level not on Database level. DB1 needs multiple write regions but DB1 must has only one write region
upvoted 18 times
...
itvinoth83
Most Recent 3 years, 2 months ago
Appeared in exam on 28-03-2022
upvoted 1 times
...
sandeepmalik
3 years, 2 months ago
In today's exam. Score 900+ Correct answer. CD
upvoted 1 times
...
shree178
3 years, 3 months ago
On exam today 19-2-2022.. Passed with 871.
upvoted 1 times
...
nd78
3 years, 4 months ago
on Exam today 21st Jan, 2022
upvoted 1 times
...
Dawn7
3 years, 5 months ago
Selected Answer: CD
I will go with C&D
upvoted 1 times
...
rabindra_barik
3 years, 5 months ago
C & D is correct
upvoted 1 times
...
Dawn7
3 years, 5 months ago
I will go with C&D
upvoted 1 times
...
F1fans
3 years, 5 months ago
This question appeared on AZ304 with the same option.B & D aren't right?
upvoted 1 times
...
plmmsg
3 years, 5 months ago
answer is C & D
upvoted 1 times
...
jmay
3 years, 5 months ago
Selected Answer: CD
Multi-region write is deinfedable at the DB account level. So DB1 and DB3 must be of different accounts. RUs are definable at the container level, which you don;t need to worry about too much at when creating the DB account (still need to budget for the total RUs). As a result, CD are correct.
upvoted 1 times
...
quantumray
3 years, 6 months ago
Question appeared On AZ-303 exam on 08/12/2021 - 49 questions, 4Q - Fabrikan case study
upvoted 1 times
...
edmacoar123
3 years, 6 months ago
On exam today 19/11/21. Select C and D. Score 860.
upvoted 3 times
...
student22
3 years, 7 months ago
C,D --- Separate multi region write db
upvoted 1 times
...
syu31svc
3 years, 9 months ago
If you provision throughput on a database, all the containers, for example collections/tables/graphs within that database can share the throughput based on the load. Throughput reserved at the database level is shared unevenly, depending on the workload on a specific set of containers. CosmosDB1 needs multi write regions. This is costly compared to single region write. Combining CosmosDB1 with CosmosDB3 will make both of these databases multi write regions and further increases cost. So, either we can create separate Cosmos database for each request or merge only MongoDB API databases as one database and create separate databases for SQL API databases. Both of these options will give us same price. https://docs.microsoft.com/en-us/azure/cosmos-db/optimize-cost-throughput
upvoted 7 times
syu31svc
3 years, 9 months ago
C and D are the answers
upvoted 2 times
...
...
AAPaul
3 years, 11 months ago
I had this question in the exam that i took on July 14th 2021
upvoted 2 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 ...