Exam AZ-303 All Questions

View all questions & answers for the AZ-303 exam

Exam AZ-303 topic 2 question 35 discussion

Actual exam question from Microsoft's AZ-303

Question #: 35
Topic #: 2

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

The SQL Database servers have the elastic pools shown in the following table.

SQL1 has the SQL databases shown in the following table.

What will occur if you add DB1 to Pool1?

A. The vCores on DB1 will decrease to two.
B. The maximum data size of Pool1 will increase to 22 GB.
C. The maximum data size of DB1 will decrease to 6 GB.
D. The vCores on Pool1 will increase to four.

Show Suggested Answer

Suggested Answer: A 🗳️

by erunit at May 31, 2021, 7:34 p.m.

Comments

Submit Cancel

Amit3

Highly Voted 4 years ago

I tested in my lab as well and A is correct.

upvoted 35 times

RKSBBSR

3 years, 7 months ago

Correct Ans - A. (Tested in my lab. ) Elastic Pool Vcore and maximum data size will never increase automatically. DB with more Vcore and maximum data size can be moved into elastic pool but will be constrained by the Vcore , Memory size of the elastic pool.

upvoted 4 times

...

jd94

Highly Voted 4 years ago

6/12/2021. Passed the exam. Vcore decrease to 2.

upvoted 15 times

Kalpeshhingu

4 years ago

As per my lab test, A is correct. As you mention it was in exam, so which answer is correct. A or D

upvoted 2 times

crazyaboutazure

3 years, 11 months ago

A is correct

upvoted 1 times

...

heamgu

3 years, 12 months ago

Thanks!

upvoted 2 times

...

sandeepmalik

Most Recent 3 years, 2 months ago

In today's exam. Score 900+ Correct answer. A... vCore decrease to 2.

upvoted 1 times

...

nd78

3 years, 4 months ago

on Exam today 21st Jan, 2022

upvoted 1 times

...

Fartfart

3 years, 5 months ago

Selected Answer: A

The pool dictates the vcore

upvoted 1 times

...

Dawn7

3 years, 5 months ago

Selected Answer: A

I will go with A

upvoted 1 times

...

plmmsg

3 years, 5 months ago

A is correct

upvoted 1 times

...

AdSax

3 years, 5 months ago

Selected Answer: A

Should be A

upvoted 1 times

...

xyz213

3 years, 5 months ago

Selected Answer: A

A is correct tested and confirmed from my trainer and in my Lab. Also a good answer from RKSBBSR: Elastic Pool Vcore and maximum data size will never increase automatically. DB with more Vcore and maximum data size can be moved into elastic pool but will be constrained by the Vcore , Memory size of the elastic pool.

upvoted 2 times

...

tomatosis

3 years, 5 months ago

On exam 23 Dec 2021

upvoted 1 times

...

Mr_RJ

3 years, 5 months ago

Selected Answer: A

correct

upvoted 2 times

...

Noexperience

3 years, 6 months ago

Whoever gives the answer D has to be rewarded :-).. Either he doesn't have hands-on experience or typo .

upvoted 1 times

...

Dpejic

3 years, 6 months ago

On exam today 22/11/21 Score 839

upvoted 2 times

...

syu31svc

3 years, 9 months ago

Answer is A The previous vCores allocated for the database will not be applicable once database is moved to a pool. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-scale

upvoted 6 times

...

tita_tovenaar

3 years, 10 months ago

A is correct, moving DBs in or out of a pool doesn't change the pool's resources. Moving B1 in pool1 means that it 'leaves' its cores and storage behind, and has to live with pool resources. Following ref does not state this directly but gives plenty of examples confirming the mechanism: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-resource-management

upvoted 5 times

...

VMUN

3 years, 11 months ago

26-June-21, Passed the exam. Answered - A

upvoted 2 times

...

henry1985

4 years ago

Tested and vCore option disappeared from the database compute + storage config. Data max size remained at 30 GB. So I think A

upvoted 2 times

...

Load full discussion...