1) You have 50,000 records in a database file and you know you want to add another 100,000 records in the next several weeks. (or max 144 rows per page) what fill factor would you use to maximize performance *** variation, THANK YOU MICROSOFT! , it is mentioned that a new index is created (else you would probably use default) and that you will change your fill factor, also that you want fast INPUT into the tables. [if you want fast read OUTPUT, the fill factor should be high!]
a) 0 (default setting)
b) 30

Some dumps say A, some say B. What do you think?
---------------------------------------
2) Southwest Financial Services uses Oracle for their HumanResources database. Woodgrove Bank uses SQL Server for their HumanResources database. The employee tables are defined in the following chart.

Southwest Financial Services
employee table (Oracle) emp_id - fname - Iname - address - city - state - zip_code

Woodgrove Bank employee table (SQL Server) emp_id - First_name - Last_name - Address_line1 - Address_Iine2 - city - state - zip code

Woodgrove Bank purchases Southwest Financial Services. You need to combine the HumanResources databases of the two companies. What should you do to combine the rows from the Oracle employee table into the existing SQL Server employee table?
A. Use the SQL statement INSERT INTO.
C. Use the SQL statement BULK INSERT

Why INSERT INTO is the preferrred answer, but BULK INSERT is not?

Report this post to a moderator

First answer buy the book!!

Second answer learn the subject!!

Once you have done this and you still don't know then come back - don't use the dumps!!

__________________
One Exam leads to another! Where will it ever end?

Report this post to a moderator

I'll use these as test questions for myself.

Q1.
I have answer as b)30 because...

FILLFACTOR=0 is the same as FILLFACTOR=100

Because there will be a substantial amount of updating FILLFACTOR=30 is the best requirement, allowing room for new records. (This can change if clustered index on identity column)


Q2. I have answer as a) INSERT INTO not b) BULK INSERT for the simple reason that with BULK INSERT the table structure definitons have to be the same.. same column widths not names. This example shows a difference in the table descriptions by one column and so INSERT is required to format the input specification.

Report this post to a moderator

First answer buy the book!!

Second answer learn the subject!!

Once you have done this and you still don't know then come back - don't use the dumps!!


Good answers!!!!

__________________
Andy C
CCNP, CCVP, CCDA, CQS (WLANSE, WLANFE, Unity Support, IPT Design, IPT Express , IPCC Express, IP Communications Express, CallManager Express), JNCIS-M #1027, JNCIS-FWV #311, F5CSE, CCSE NG, MCSE NT4/2K, MCSE:Messaging, ITIL, A+

Report this post to a moderator

Wbafrank I'm really disappointed in your response to the question and the level of respect that you have shown. Your a moderator of this board, and should not be antagonizing other members. If someone has a question you should do one of the following:

A. Answer the question in a positive manner, and Maybe supplying additional resources the person could look at to find out more.
OR
B. Keep your mouth shut. There is no need to belittle anyone for there questions.

Braden

Report this post to a moderator

I agree with bbowers.

Surely a reasonable message that braindumps aren't part of this forum would have been sufficient.

I saw a post a few weeks ago by some guy espousing the joys/benefits of braindumps. I didn't see anything from the Moderator, questionable or not!

Can anyone tell me what other topics are "discouraged" (I won't say censored since I absolutely abhor censorship and anyone who tries to impose it)? Better to let people know now than make a post and be flamed for it.

Don't you think?

__________________
Dirty Deeds done Dirt Cheap

Report this post to a moderator

Perhaps a message when a user signs up that clearly states that braindumps are not tolerated here. I can't remember seeing that.

If it was something that was part of the signup, I think it should be it's only page during the sign up process. In big bold letters, BRAINDUMPS ARE NOT TOLERATED ON THIS SITE. Accept or Deny

Well, that's my constructive suggestion.

Report this post to a moderator

    Definatly if there are certian question groups that are not within the realm of this message board they should be clearly stated.
    I've only been a member for about two weeks now and I had no idea that there were certian question sources that are discouraged, even if they were totally on topic.
    Although I have to say I don't get the big deal about these brain dump questions. I've never seen "brain dump" but a question is a question. If slam would have just asked his question without quoting the source no one would have been the wiser. And with that being the case why wouldn't it be a ligitiment question.

Braden

Report this post to a moderator