MENU
An online retail application requires data to be synchronized between multiple SQL Server databases. This provides clearer reporting from
multiple databases at the Same time for consistency at the end of each business day.
What is the best way to fulfill this requirement?
35 comments · newest first
SH
Shawnna
10 months ago
Wait, can we really sync multiple databases like that? Sounds risky!
IS
Isabelle
11 months ago
A is too basic, we need better synchronization!
GE
Gennie
11 months ago
Not sure about D, what if there's a single point of failure?
CH
Charlette
11 months ago
I agree, D is definitely the way to go!
ZE
Zena
11 months ago
Option D seems like the best choice for high availability.
BE
Beula
11 months ago
I'm a bit confused about whether having one Time Machine is sufficient for all databases. I thought we needed a more robust setup for synchronization.
CL
Clarence
12 months ago
I feel like option D might be the best choice since it aligns with what we learned about high availability and consistency across databases.
GL
Glendora
12 months ago
I think option B sounds familiar because we practiced scenarios with multiple databases as a group, but I can't recall the exact benefits.
BO
Boris
1 year ago
I remember we discussed the importance of having all databases in the same Availability Group for synchronization, but I'm not sure if that's the only factor to consider.
HO
Hoa
1 year ago
I'm not entirely sure about this one. The options seem similar, but I'm not confident I fully understand the differences between them. I'll make my best guess, but I may need to come back to this question if I have time at the end.
BA
Bambi
1 year ago
Okay, I've got this. The key is to have all the databases in the same DBVM and register them in Era. Option B looks like the best choice since it allows for multiple databases to be managed as a group with a single Time Machine.
JU
Julian
1 year ago
Hmm, I'm a bit confused by the wording of the question. I'll need to think through the different options carefully to understand which one best fulfills the requirement of synchronizing data between multiple SQL Server databases.
RU
Ruthann
1 year ago
This seems like a straightforward question about database synchronization. I think I know the right approach, but I'll carefully read through the options to make sure I don't miss anything.
CH
Chaya
1 year ago
Okay, I think I've got this. The key is to re-enable the interfaces, so I'll focus on the options that directly address that.
TE
Terry
2 years ago
Haha, I bet the exam writers had fun coming up with these options. They really want to see if we know our stuff!
DE
Deandrea
2 years ago
D) Have all the databases in the same Availability Group and register databases in Era.
SC
Scarlet
2 years ago
B) Have all the databases present in the same DBVM and register databases in Era with Multiple Databases as a Group with one Time Machine.
TA
Tammara
2 years ago
A) Have all the databases present in the same DBVM and register databases in Era.
BR
Britt
2 years ago
Wow, this question is really testing our database management knowledge. I'm going to have to think hard about this one.
HE
Herschel
2 years ago
C) Have all the databases present in the same DBVM and register databases in Era with One Database with One Time Machine.
SH
Sharee
2 years ago
B) Have all the databases present in the same DBVM and register databases in Era with Multiple Databases as a Group with one Time Machine.
GA
Garry
2 years ago
A) Have all the databases present in the same DBVM and register databases in Era.
ZA
Zack
2 years ago
B is the way to go! Grouping the databases together with one Time Machine is a great way to manage the synchronization.
FL
Florinda
2 years ago
I'm not sure, but having all the databases present in the same DBVM and registering databases in Era with Multiple Databases as a Group with one Time Machine could also work.
PR
Princess
2 years ago
C seems like a good option too. One database with one Time Machine could work for keeping the data consistent across the databases.
MA
Marlon
2 years ago
I'm pretty sure the answer is D. Having the databases in the same Availability Group and registering them in Era makes the most sense for synchronizing data across multiple databases.
CA
Catarina
2 years ago
I agree with the user comment, option D with all the databases in the same Availability Group seems like the most efficient choice.
SH
Sheridan
2 years ago
Yes, it's important to have a reliable method like this for clearer reporting across multiple databases.
ME
Melvin
2 years ago
Having all the databases in the same group definitely simplifies the synchronization process.
IS
Isreal
2 years ago
I agree, having them in the same Availability Group would ensure consistency in reporting.
JA
Jaclyn
2 years ago
I disagree, I believe option B with Multiple Databases as a Group with one Time Machine is the way to go.
BE
Becky
2 years ago
I think the best option is D. It makes sense to have all the databases in the same Availability Group for data synchronization.
JE
Jerry
2 years ago
I think option A is the best way to fulfill the requirement.
AN
Angella
2 years ago
I agree with Jenise. Having all the databases in the same Availability Group will ensure data synchronization and consistency.
JE
Jenise
2 years ago
I think the best way is to have all the databases in the same Availability Group and register databases in Era.