ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam
Go to Exam

Exam AZ-304 topic 3 question 4 discussion

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

HOTSPOT -
Your company is designing a multi-tenant application that will use elastic pools and Azure SQL databases. The application will be used by 30 customers.
You need to design a storage solution for the application. The solution must meet the following requirements:
✑ Operational costs must be minimized.
✑ All customers must have their own database.
✑ The customer databases will be in one of the following three Azure regions: East US, North Europe, or South Africa North.
What is the minimum number of elastic pools and Azure SQL Database servers required? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: 3 -
The server, its pools & databases must be in the same Azure region under the same subscription.

Box 2: 3 -
A server can have up to 5000 databases associated to it.
Reference:
https://vincentlauzon.com/2016/12/18/azure-sql-elastic-pool-overview/
by mchint01 at Oct. 5, 2020, 6:29 p.m.

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
Submit Cancel
RasiR
Highly Voted 4 years, 4 months ago
If they mentioned, The customer databases will be in the following three Azure regions; Then, that means it is ok to have the databases in all three regions. BUT, They mentioned, The customer databases will be in ONE OF THE following three Azure regions, which means all the databases must be in ONLY ONE region, and it can be East US, North Europe, or South Africa North. A server can have up to 5000 databases associated to it. So the answer should be 1 Azure SQL database server and 1 Elastic pool.
upvoted 37 times
wwwmmm
2 years, 4 months ago
This is not a logic test, what if several customer dbs fall into different regions, then will 1 server and 1 pool still fit the purpose? I think it should be 3 servers, 3 pools.
upvoted 1 times
...
rsharma007
3 years, 7 months ago
Customer DB will be in one of the 3 regions. So they should have that option which can only be achieved by having an elastic pool in each region. It is ok to have to have it all in one region, but that wouldn't meet the requirement .
upvoted 6 times
ShivaUdari
1 year, 8 months ago
It's not DB, it's DB's. So all three will be in any one region.
upvoted 1 times
...
...
examineezer
3 years, 6 months ago
I think what the question meant was "the customer databases will be across three regions". They're not testing grammar or logic.
upvoted 19 times
Warriors
3 years, 1 month ago
And how do you know what the question meant? Did you set it? If you interpret the question as is, then @RasiR is correct
upvoted 3 times
...
...
...
mchint01
Highly Voted 4 years, 7 months ago
Correct
upvoted 28 times
...
Chris_Munnik
Most Recent 2 years, 11 months ago
The customers only need their on DB, not their own server. And the fact that the customer databases will be in ONE OF THE following three Azure regions, means it will be 1 & 1.
upvoted 3 times
...
Zsolt72
3 years, 1 month ago
I mean the key here is the multi tenant application that is a cross region architecture for possible customers from different regions. So I suppose the mentioned 3 regions should contains the infrastructure. 3/3
upvoted 2 times
...
cloudera
3 years, 1 month ago
All the customer databases will be in one of the three regions or the database can spread across 3 regions? The question is not clear. If the database can spread across 3 regions then the answer is correct. If not, 1 DB server and 1 Elastic pool.
upvoted 2 times
...
ranjitklive
3 years, 1 month ago
Answer --> 3, 3 Customer can belong to any of the 3 regions given. So, we need 3 DB servers at the very least. One elastic pool per DB server, therefore 3 Elastic Pool.
upvoted 1 times
...
therealss
3 years, 2 months ago
It's pretty obvious to me that "a multi-tenant app with 30 customers" might need 3 regions BECUASE those disparate customers could have varying legal requirements that require them store corporate data in a specific geography. This scenario is much more likely than "hey, let's spin a wheel and decide where our 1 central DB is...one of these 3 is good!". So back to the answer, I'd go with 3 and 3.
upvoted 3 times
...
Uglydotcom
3 years, 3 months ago
One SQL server to hold one elastic pool in each of the 3 regions mentioned, so answer is 3 pools, 3 servers.
upvoted 1 times
...
Dpejic
3 years, 4 months ago
On exam 24.12.2021
upvoted 4 times
...
donathon
3 years, 5 months ago
Elastic Pool can only stretch across a single region so it should be 3 3.
upvoted 5 times
...
sharepoint_Azure_pp
3 years, 6 months ago
i choose 3 & 3 cleared with 900 on 17th October 2021
upvoted 14 times
...
waqas
3 years, 7 months ago
Given answers are correct.
upvoted 1 times
...
syu31svc
3 years, 7 months ago
If the customers can be in one of the three Azure Regions, this means that it will probably have customers in all regions, these are the regions where the customers will be, so you will need 3 elastic pools, one for each region and one sql server for each region.
upvoted 3 times
davidfernandezperrino
3 years, 3 months ago
yeah, that's the key. Customers can be in one of the three azure regions, but you have 30 customers, and they are not saying that "all customers are in the same region", so you have to cover the three regions => 3 elastic pools with 3 servers
upvoted 1 times
...
...
dkltruong88
3 years, 7 months ago
Was in exam today 1-10-2021. I passed with score 896. I chose 3 and 3
upvoted 5 times
...
bingomutant
4 years, 5 months ago
The customer databases will be in one of the following three Azure regions - this is ambiguous. Does it mean ALL databases must be in one region - or each customer database can be in one of 3 regions? I think it must be the latter so 3/3. But there is doubt.
upvoted 3 times
...
Oliz
4 years, 5 months ago
how did we arrive at 3 for the number of DB servers? why not 1 since 5000 DBs can be hosted on a server? Moreover, the question said the databases would be hosted in ONE of the 3 regions mentioned.
upvoted 2 times
mmmore
4 years, 5 months ago
This is a bit of a trick question. My first thought was 3 databases and 3 elastic pools. Given that you will use 3 separate regions. But it could be that they actually mean that the databases should be in ONE of the three regions. I that case you need 1 db and elastic pool.
upvoted 4 times
MaxBlanche
4 years, 5 months ago
✑ All customers must have their own database. ✑ The customer databases will be in one of the following three Azure regions: East US, North Europe, or South Africa North. This means that we'll have many dbs, part on region 1, part on region 2 and part on region 3. So we'll need 3 servers and 3 pools.
upvoted 3 times
...
TheAzureArchitect
3 years, 6 months ago
Microsoft don't do trick questions. You were correct with 3 and 3.
upvoted 2 times
...
...
...
saditya1
4 years, 5 months ago
correct
upvoted 2 times
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago