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:
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.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool
Answer #2 should be No, as DB3 is on Sql2 sever while Pool2 is on Sql1 sever. A database can only be moved into pools on same server.
yes-no-yes; pools are server-bound. Cannot move a DB to a pool on another server.
Yes No Yes, this is a repeated question where the ans is Y-N-Y.
Yes-No-Yes is the correct answer
Yes-No-Yes
repeat topic 1 Q37
too many answers are wrong, why? yny Note: You cannot add databases from different servers into the same pool
I’m starting to wonder the same. I didn’t pay to get wrong answers :(
YNY is the correct answer
Pool3 is on SQL2 server but none of the database is on SQL2 server, how can DB3 be moved to pool3?, Answer should be Yes, No, No.
Sorry my bad, Answer should be Yes, No, Yes
Answers are: Yes No Yes : Yes -Since the databases are on the same sever and the elastic pools are also on the same server, the databases can be removed from on pool and then added to another pool. No:Since the elastic pool is present on another server, we can't add the database to this pool. Yes:Since both the database and the elastic pool are on the same server , we can add the database to the pool.
CAN you please tell me practical lab (azure lab ) question are still in exam or just MCQ based exam
On exam today 19/11/21. Select YNY. Score 860.
Yes -No-Yes