March 14, 2022 at 7:33 pm
Hi, I am software developer, there are certains aspects of Sql that I don´t know about, can you please help me solve this question?
Which of the following is not a benefit of SQL Server Replication?
A. Load balancing
B. Offline processing
C. Redundancy
D. Distributed query load
E. Lower licensing costs
March 14, 2022 at 7:37 pm
What test are you taking ?
Is this a pre-spam practice post ?
March 15, 2022 at 2:04 am
It is a DBA test, so there are themes I do not know deeply.
Spam? what?
March 15, 2022 at 8:12 am
So if it’s a test, please can you elaborate on each particular point of the answer?
We don’t just give out answers to tests without you showing some knowledge of the question and particular answers.
To further bolster the learning,
What does replication require?
Does it require any additional hardware?
What do you need to do to use a different server prior to installing SQL?
March 15, 2022 at 12:56 pm
You sure you got the question right? Looking through that list I can only see one thing that IS a benefit. Replication does not load balance. Replication doesn't distribute queries. Replication absolutely doesn't reduce licensing costs (you're adding a second server for crying out loud, at least a second, if you want it stable, a third). So, I'm more than a little confused by the question.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 15, 2022 at 1:26 pm
Could be a multi-checkbox type question.
March 15, 2022 at 1:31 pm
It is a question of a company test... I do not know who made it, so...
Replication.
Technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency
Benefits:
Load balancing
Offline processing
Redundancy
ILoad balancing
Used to distribute traffic across multiple servers in a server farm.
Load balancers improve application availability and responsiveness and prevent server overload.
I guess Distributed query load can be, but I have doubs with costs cause the test has tricky questions... so what you think?
March 15, 2022 at 1:38 pm
I don't believe the load balancing aspect, at all.
Yes, you can move some queries offline. However, that is not load balancing. Load balancing is the automated process of distributing where a query gets executed. Replication allows for offline processing, but not load balancing.
Also, distributed? Is it?
Look, I'm not trying to provide the answer here without education, but if the question you have is bad, your answers are going to be problematic.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 15, 2022 at 3:56 pm
It is a DBA test, so there are themes I do not know deeply.
Spam? what?
Not to worry... we see a whole lot of new "users" of the site that are actually SPAM. The ploy is that they'll ask a question such as you have and then come back and edit the post by adding a link to training, some product, etc. Some SPAM detectors don't pick up on such a ploy.
But we do. The response about "spam" was someone's way of letting the rest of us know that they also suspect the same possible upcoming issue. I have to admit, I also suspected it simply because it "fit the pattern".
With that, let me say, "Welcome aboard!".
--Jeff Moden
Change is inevitable... Change for the better is not.
March 15, 2022 at 4:16 pm
Could be a multi-checkbox type question.
That's what I was thinking, as well.
I also hate such "company tests". They're either written by people at the company that may not know as much as the applicant or they scraped a couple of interview questions off a web site and, although the applicant may actually mark the correct answer(s), the people giving the test don't know and so they mark it wrong. And, frequently, the tests are automatically graded and a highly qualified applicant may get automatically passed up.
An example of that is one that I ran across in an interview a long time ago. The question was being asked by someone in HR because the DBA didn't bother to show up for the interview and the question was "What's the one place where you wouldn't want to execute a stored procedure even if you could". I found out years later that the answer they were looking for was "In a user defined function". Well hell... that's just not true. You CAN execute a stored procedure from a function using OPENROWSET and it CAN be a good idea.
Here's another one... if someone asks "What are all the reasons why you shouldn't use Random GUIDs"? 99.5% of the people are looking for "Size" of the underlying datatype and "Massive fragmentation owing to the random nature of GUIDs". That last one is a myth that has been perpetuated for more than 2 decades by bad information and bad testing. If it's on a multiple choice test, should I answer what I know is right or what I think they think is the right answer and then what happens if they're a part of the 0.5% that actually knows the correct answer? And a lot of such tests are online with no possibility of scribbling in note somewhere.
Heh... and don't get me started on questions about supposed "Best Practices" questions.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply