Exam AZ-303 All Questions

View all questions & answers for the AZ-303 exam

Exam AZ-303 topic 1 question 64 discussion

Actual exam question from Microsoft's AZ-303

Question #: 64
Topic #: 1

You have an Azure subscription that contains the resource groups shown in the following table.

You have the Azure SQL servers shown in the following table.

You create an Azure SQL database named DB1 on Sql1 in an elastic pool named Pool1.
You need to create an Azure SQL database named DB2 in Pool1.
Where should you deploy DB2?

A. Sql1
B. Sql2
C. Sql3
D. Sql4

Show Suggested Answer

Suggested Answer: A 🗳️
The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

by azurecert2021 at Jan. 5, 2021, 7:55 p.m.

Comments

Submit Cancel

azurecert2021

Highly Voted 4 years, 5 months ago

elastic pools are associated with SQL DB server hence to utilize the pool resource efficiently by multiple db we should deploy it on same SQL server SQL1

upvoted 38 times

KaiserdomTW

3 years, 11 months ago

So answer is SQL1

upvoted 1 times

...

azurecert2021

Highly Voted 4 years, 5 months ago

given answer it correct.

upvoted 10 times

...

sachinp2305

Most Recent 3 years, 2 months ago

Correct Answer - Appeared in today's exam 29 March 2022

upvoted 1 times

...

itvinoth83

3 years, 2 months ago

In Exam today, 28-03-2022

upvoted 1 times

...

sandeepmalik

3 years, 2 months ago

In today's exam. Score 900+ Correct answer.

upvoted 2 times

...

shree178

3 years, 3 months ago

On exam today 19-2-2022.. Passed with 871.

upvoted 1 times

...

EW3772

3 years, 3 months ago

Selected Answer: A

Answer is A

upvoted 1 times

AD3

3 years, 3 months ago

Was it on the exam?

upvoted 1 times

...

moon2351

3 years, 4 months ago

Answer is A

upvoted 1 times

...

syu31svc

3 years, 9 months ago

Sql1 is part of Pool1. You need to add a database DB2 to Pool. So you can add DB2 to Sql1. Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview A is the answer

upvoted 4 times

...