exam questions

Exam AZ-303 All Questions

View all questions & answers for the AZ-303 exam

Exam AZ-303 topic 1 question 37 discussion

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

HOTSPOT -
You have an Azure subscription that contains the Azure SQL servers shown in the following table.

The subscription contains the elastic pools shown in the following table.

The subscription contains the Azure SQL databases shown in the following table.

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:
Note: You cannot add databases from different servers into the same pool

Box 1: Yes -
Pool2 contains DB2 but DB1 and DB2 are on Sql1. DB1 can thus be added to Pool2.

Box 2: Yes -
Pool3 is empty.

Box 3: Yes -
Pool1 contains DB1 but DB3 and DB1 are on Sql1. DB3 can thus be added to Pool1.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

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
kr78
Highly Voted 4 years, 7 months ago
Answer is Y N Y
upvoted 117 times
hamzeh69
4 years, 1 month ago
Agree correct YNY
upvoted 7 times
...
...
satbim
Highly Voted 4 years, 7 months ago
Hi Guys, can anyone please explain "Yes" for 2nd question? My answer is "No" because DB3 is on SQL1 and Pool3 is configured on SQL2, we can not move DB3 to Pool3 as it is not on SQL1.
upvoted 23 times
SyntaxError
4 years, 7 months ago
Hey Satbim, I found the discussion here on this link. https://www.examtopics.com/discussions/microsoft/view/38304-exam-az-303-topic-1-question-37-discussion/
upvoted 4 times
...
W3master
4 years, 7 months ago
Hi @satbim, I think you're right => box 2 should be NO, as you can't add a DB to a different server's pool even if the pool is empty
upvoted 4 times
...
widurr
4 years, 7 months ago
I've tested this and second answer is "no". DB2 does not appear in the list of available databases to add to pool3 in Azure Portal.
upvoted 34 times
...
...
BalaDxb
Most Recent 3 years, 4 months ago
Answer should be Y N Y
upvoted 1 times
...
hikpd
3 years, 4 months ago
Moderator, please correct the answer
upvoted 1 times
...
justfordevelopment
3 years, 4 months ago
In the exam on 12-03-2022. Total 50 questions including case study. "Litware Acquired Fabricam" case study.
upvoted 1 times
MassMs
3 years, 4 months ago
how many case studies are in the exam
upvoted 1 times
...
...
[Removed]
3 years, 5 months ago
Answer should be Yes No Yes
upvoted 1 times
...
plmmsg
3 years, 7 months ago
Tested. Answer is Y N Y.
upvoted 1 times
...
Azurenit
3 years, 7 months ago
Answer is YNY
upvoted 1 times
...
Chris76
3 years, 8 months ago
The answer contradicts the options. It starts with a note: "Note: You cannot add databases from different servers into the same pool" And then for second option it neglects the very same note. Should be: YNY
upvoted 1 times
...
edmacoar123
3 years, 8 months ago
On exam today 19/11/21. Answer YNY. Score 860.
upvoted 3 times
...
syu31svc
3 years, 11 months ago
I would say Yes No Yes You cannot add databases from different servers into the same pool https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview
upvoted 2 times
...
MinhajR
3 years, 11 months ago
On Exam 27/08/2021
upvoted 4 times
...
br1jes
3 years, 11 months ago
Answer is Y N Y
upvoted 2 times
...
MatiUllah
4 years, 1 month ago
Was on exam 3 July 2021 YNY
upvoted 5 times
...
Kunal13
4 years, 1 month ago
Y-N-Y You can create multiple pools on a server, but you can't add databases from different servers into the same pool.
upvoted 1 times
...
vipin0114
4 years, 1 month ago
Answer is YNY
upvoted 2 times
...
nfett
4 years, 1 month ago
answer is correct. ref this url https://docs.microsoft.com/en-us/azure/azure-sql/database/logical-servers -- server can be in a diff region. so it holds true here since the region is the same.
upvoted 1 times
pentium75
4 years ago
How is that related to regions? B means that you add a database on server SQL1 to a pool that is hosted on server SQL2. I don't think this can work.
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 ...