MCTS SQL Server 2005

What scares me about the 70-431 exam is the huge amount of complicated
T-SQL commands. Look at the syntax of any T-SQL command with all its
options; many many options, how can I remember them. Do I need to
remember all these instructions for the exam. Please let me know.If you learn it, you don't have to remember it :) On top of that, I think it
is an easier test than 7.0 or 2000. Just practice and understand why and you
will be fine.
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"lrantisi" <lrantisi@.gmail.com> wrote in message
news:b833a574-8d18-4b79-9498-b84df470ec14@.e23g2000prf.googlegroups.com...
> What scares me about the 70-431 exam is the huge amount of complicated
> T-SQL commands. Look at the syntax of any T-SQL command with all its
> options; many many options, how can I remember them. Do I need to
> remember all these instructions for the exam. Please let me know.|||Agree!
70-431 was mutch easier that 70-228/70-229 and 70-028/029
but the follow ups 70-441/70-442 and 70-443/70-444
are more complicated that SQL2000 or SQL7 exams
what is good - You can optain quite easyly MCTS SQL2005
What I can recomment - for repeating, self training and getting the point of
real tests - go thorugh some preparation provider material (measureup or
something like)
But the main point is - You dont know exact syntacs or exact options for
every single thing (I don't know for example and in real life BOL is always
opened on my hand, during work, during traiining etc - unfortunately not
allowed during exams :))
You have to know and understand the principles of things. The structure, the
goal, the reason and the target of sql sentences.
As I remember - there wasn't so much in 431 about performance stuff
With bests
Henn
PS! Let me know when You pass the 431 :)
"jason" <jason-r3move@.statisticsio.com> kirjutas sõnumis
news:93A5B69C-EA5B-4269-9C70-6D3B7EDE0E5F@.microsoft.com...
> If you learn it, you don't have to remember it :) On top of that, I think
> it is an easier test than 7.0 or 2000. Just practice and understand why
> and you will be fine.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
> "lrantisi" <lrantisi@.gmail.com> wrote in message
> news:b833a574-8d18-4b79-9498-b84df470ec14@.e23g2000prf.googlegroups.com...
>> What scares me about the 70-431 exam is the huge amount of complicated
>> T-SQL commands. Look at the syntax of any T-SQL command with all its
>> options; many many options, how can I remember them. Do I need to
>> remember all these instructions for the exam. Please let me know.
>

MCTS SQL Server 2005

What scares me about the 70-431 exam is the huge amount of complicated
T-SQL commands. Look at the syntax of any T-SQL command with all its
options; many many options, how can I remember them. Do I need to
remember all these instructions for the exam. Please let me know.
If you learn it, you don't have to remember it On top of that, I think it
is an easier test than 7.0 or 2000. Just practice and understand why and you
will be fine.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"lrantisi" <lrantisi@.gmail.com> wrote in message
news:b833a574-8d18-4b79-9498-b84df470ec14@.e23g2000prf.googlegroups.com...
> What scares me about the 70-431 exam is the huge amount of complicated
> T-SQL commands. Look at the syntax of any T-SQL command with all its
> options; many many options, how can I remember them. Do I need to
> remember all these instructions for the exam. Please let me know.
|||Agree!
70-431 was mutch easier that 70-228/70-229 and 70-028/029
but the follow ups 70-441/70-442 and 70-443/70-444
are more complicated that SQL2000 or SQL7 exams
what is good - You can optain quite easyly MCTS SQL2005
What I can recomment - for repeating, self training and getting the point of
real tests - go thorugh some preparation provider material (measureup or
something like)
But the main point is - You dont know exact syntacs or exact options for
every single thing (I don't know for example and in real life BOL is always
opened on my hand, during work, during traiining etc - unfortunately not
allowed during exams )
You have to know and understand the principles of things. The structure, the
goal, the reason and the target of sql sentences.
As I remember - there wasn't so much in 431 about performance stuff
With bests
Henn
PS! Let me know when You pass the 431
"jason" <jason-r3move@.statisticsio.com> kirjutas snumis
news:93A5B69C-EA5B-4269-9C70-6D3B7EDE0E5F@.microsoft.com...
> If you learn it, you don't have to remember it On top of that, I think
> it is an easier test than 7.0 or 2000. Just practice and understand why
> and you will be fine.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
> "lrantisi" <lrantisi@.gmail.com> wrote in message
> news:b833a574-8d18-4b79-9498-b84df470ec14@.e23g2000prf.googlegroups.com...
>
sql

MCTS Exam 70-431 Database Administration Study Documementation and Samples ?

Hi,

I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005.

The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed.

This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material.

No books are published yet.

Does anyone have any good ideas on where to find 'good' samples and tutorials meant for a person who is studying for the new Microsoft SQL Server 2005 Database Administrator Exam MCTS 70-431?

All answers and ideas in 'any form' are appreciated.

Thank you very much.

Andre

Hi Andre,

I am also looking out for various resources for preparation of MCTS. We can collaborate, what do u say?

|||

I am also going forward for the exam.

One of the books for MCTS windows application will be out any day now..

|||The book has been published and is now available online for purchase!
|||

Where is the URL for the book purchase information?

AIMDBA

|||

Here is the url for the (a) book on the subject: http://www.amazon.com/gp/product/073562271X/104-7297463-7574318?v=glance&n=283155

That being said, does anyone know of any sites that contain links to online material for the test? Something similar to http://www.codeclinic.com/70-320skills.htm ?

|||

From the amazon book url given above, has anyone checked out the other 70-431 learning books shown below.

59% buy

MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Application Development Foundation (Pro - Developer) by Tony Northrup $44.09

36% buy the item featured on this page:

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server(TM) 2005 Implementation and Maintenance (Pro - Certification) by Solid Quality Learning $37.79

3% buy

MCTS 70-431 Exam Cram : Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram) by Thomas Moore $23.09

2% buy

MCTS : Microsoft SQL Server 2005 Implementation and Maintenance Study Guide (70-431) by Joseph L. Jorden $31.49

1% buy

MCITP: SQL Server 2005 Designing Database Solutions Study Guide (70-441) by Victor Isakov $31.49

Thanks,

AIMDBA

|||

Has anyone had a chance to check out the new Transcender learning material:

http://www.transcender.com/product.aspx?product%5Fid=Cert%2D70%2D431&dept%5Fid=102210

Thanks,

AIMDBA

|||

The 70-431 Training Kit from Microsoft Press that we wrote hit the shelves about 2 weeks ago. We designed this book to not only meet all of the objectives necessary for the exam, but also to become a core reference for SQL Server 2005. This book very definitely goes well beyond the exam while also covering everything that you need to know on the exam.

There's also one really big difference with this book, it contains a voucher for a 15% discount on the exam which is worth almost the price of the entire book. The exam engine that ships with the book was designed with questions that mimic what you are going to see on the exam. So, combine what you get with the 15% exam discount along with the cost of buying exam simulation software, then you are getting a book for free that goes well beyond the exam itself.

http://www.amazon.com/exec/obidos/ASIN/073562271X/mssqlservercom/102-4828681-7857756

|||I bought the book that Michael talks about from Amazon and it should arrive within a week or so. Amazon has free shipping on this book too. Great deal! Michael, if you read this I am super excited to read your book!!
|||Thanks. We're looking for feedback.|||Hi Michael, I have a question for you. I received my book today and I read that you recommend not using your primary PC for the study because it will alter the OS. I'm in a bit of a pinch because my secondary PC has an older OS that won't work with the CD. It's a Windows 98 and I would need to upgrade to 2000 Pro. I really don't have the money to do that right now and I'm wondering how risky it would be to use my primary PC. Would you be able to tell me what types of changes are made that could put my PC at risk and what the worst case scenario would be?

Thanks so much!
Alexx
|||Another question I didn't ask- How about using Microsoft Virtual Server 2005 environment to test on? It's a free download, so the price is right for me.

Thanks again,
Alexx
|||

Since you're not going to build a cluster with the 70-431 exam content, then you don't need Virtual Server. Virtual PC will work just fine. That's where I recommend that you do all of your testing. The primary reason is that it provides an isolated environment for your testing that won't impact other things. The second reason is that it becomes a self-contained image. So, you can build the base environment once, stop Virtual PC, make a copy of the .vhd & .vmc files, and then start everything back up. If you blow something up or just want to reset everything, all you have to do is shut down the VPC image and copy the .vhd and .vmc files back over.

All of the instructions for setup are done from a VERY conservative standpoint. I don't necessarily agree with that particular one, but I got overruled. The SQL Server setup is going to drop .NET Framework 2.0 on your machine along with the Native Access Client and some setup support files. It then installs everything else which includes services and some other things.

It obviously isn't dangerous to do, you just have more software on your machine to contend with and SQL Server is completely stable. For testing/training environments, we're always going to recommend finding a machine you can blow up so that you can play as much as you want without having to worry about impacting anything else you are doing.

|||Thank you SO much for your reply! I am really excited to get 'er up and running and start the training. I hope you will continue checking this board as we all appreciate your expert advice.

Later on~
Alexx

MCTS Exam 70-431 Database Administration Study Documementation and Samples ?

Hi,

I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005.

The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed.

This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material.

No books are published yet.

Does anyone have any good ideas on where to find 'good' samples and tutorials meant for a person who is studying for the new Microsoft SQL Server 2005 Database Administrator Exam MCTS 70-431?

All answers and ideas in 'any form' are appreciated.

Thank you very much.

Andre

Hi Andre,

I am also looking out for various resources for preparation of MCTS. We can collaborate, what do u say?

|||

I am also going forward for the exam.

One of the books for MCTS windows application will be out any day now..

|||The book has been published and is now available online for purchase!|||

Where is the URL for the book purchase information?

AIMDBA

|||

Here is the url for the (a) book on the subject: http://www.amazon.com/gp/product/073562271X/104-7297463-7574318?v=glance&n=283155

That being said, does anyone know of any sites that contain links to online material for the test? Something similar to http://www.codeclinic.com/70-320skills.htm ?

|||

From the amazon book url given above, has anyone checked out the other 70-431 learning books shown below.

59% buy

MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Application Development Foundation (Pro - Developer) by Tony Northrup $44.09

36% buy the item featured on this page:

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server(TM) 2005 Implementation and Maintenance (Pro - Certification) by Solid Quality Learning $37.79

3% buy

MCTS 70-431 Exam Cram : Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram) by Thomas Moore $23.09

2% buy

MCTS : Microsoft SQL Server 2005 Implementation and Maintenance Study Guide (70-431) by Joseph L. Jorden $31.49

1% buy

MCITP: SQL Server 2005 Designing Database Solutions Study Guide (70-441) by Victor Isakov $31.49

Thanks,

AIMDBA

|||

Has anyone had a chance to check out the new Transcender learning material:

http://www.transcender.com/product.aspx?product%5Fid=Cert%2D70%2D431&dept%5Fid=102210

Thanks,

AIMDBA

|||

The 70-431 Training Kit from Microsoft Press that we wrote hit the shelves about 2 weeks ago. We designed this book to not only meet all of the objectives necessary for the exam, but also to become a core reference for SQL Server 2005. This book very definitely goes well beyond the exam while also covering everything that you need to know on the exam.

There's also one really big difference with this book, it contains a voucher for a 15% discount on the exam which is worth almost the price of the entire book. The exam engine that ships with the book was designed with questions that mimic what you are going to see on the exam. So, combine what you get with the 15% exam discount along with the cost of buying exam simulation software, then you are getting a book for free that goes well beyond the exam itself.

http://www.amazon.com/exec/obidos/ASIN/073562271X/mssqlservercom/102-4828681-7857756

|||I bought the book that Michael talks about from Amazon and it should arrive within a week or so. Amazon has free shipping on this book too. Great deal! Michael, if you read this I am super excited to read your book!!|||Thanks. We're looking for feedback.|||Hi Michael, I have a question for you. I received my book today and I read that you recommend not using your primary PC for the study because it will alter the OS. I'm in a bit of a pinch because my secondary PC has an older OS that won't work with the CD. It's a Windows 98 and I would need to upgrade to 2000 Pro. I really don't have the money to do that right now and I'm wondering how risky it would be to use my primary PC. Would you be able to tell me what types of changes are made that could put my PC at risk and what the worst case scenario would be?

Thanks so much!
Alexx|||Another question I didn't ask- How about using Microsoft Virtual Server 2005 environment to test on? It's a free download, so the price is right for me.

Thanks again,
Alexx |||

Since you're not going to build a cluster with the 70-431 exam content, then you don't need Virtual Server. Virtual PC will work just fine. That's where I recommend that you do all of your testing. The primary reason is that it provides an isolated environment for your testing that won't impact other things. The second reason is that it becomes a self-contained image. So, you can build the base environment once, stop Virtual PC, make a copy of the .vhd & .vmc files, and then start everything back up. If you blow something up or just want to reset everything, all you have to do is shut down the VPC image and copy the .vhd and .vmc files back over.

All of the instructions for setup are done from a VERY conservative standpoint. I don't necessarily agree with that particular one, but I got overruled. The SQL Server setup is going to drop .NET Framework 2.0 on your machine along with the Native Access Client and some setup support files. It then installs everything else which includes services and some other things.

It obviously isn't dangerous to do, you just have more software on your machine to contend with and SQL Server is completely stable. For testing/training environments, we're always going to recommend finding a machine you can blow up so that you can play as much as you want without having to worry about impacting anything else you are doing.

|||Thank you SO much for your reply! I am really excited to get 'er up and running and start the training. I hope you will continue checking this board as we all appreciate your expert advice.

Later on~
Alexx

MCTS Exam 70-431 Database Administration Study Documementation and Samples ?

Hi,

I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005.

The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed.

This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material.

No books are published yet.

Does anyone have any good ideas on where to find 'good' samples and tutorials meant for a person who is studying for the new Microsoft SQL Server 2005 Database Administrator Exam MCTS 70-431?

All answers and ideas in 'any form' are appreciated.

Thank you very much.

Andre

Hi Andre,

I am also looking out for various resources for preparation of MCTS. We can collaborate, what do u say?

|||

I am also going forward for the exam.

One of the books for MCTS windows application will be out any day now..

|||The book has been published and is now available online for purchase!
|||

Where is the URL for the book purchase information?

AIMDBA

|||

Here is the url for the (a) book on the subject: http://www.amazon.com/gp/product/073562271X/104-7297463-7574318?v=glance&n=283155

That being said, does anyone know of any sites that contain links to online material for the test? Something similar to http://www.codeclinic.com/70-320skills.htm ?

|||

From the amazon book url given above, has anyone checked out the other 70-431 learning books shown below.

59% buy

MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Application Development Foundation (Pro - Developer) by Tony Northrup $44.09

36% buy the item featured on this page:

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server(TM) 2005 Implementation and Maintenance (Pro - Certification) by Solid Quality Learning $37.79

3% buy

MCTS 70-431 Exam Cram : Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram) by Thomas Moore $23.09

2% buy

MCTS : Microsoft SQL Server 2005 Implementation and Maintenance Study Guide (70-431) by Joseph L. Jorden $31.49

1% buy

MCITP: SQL Server 2005 Designing Database Solutions Study Guide (70-441) by Victor Isakov $31.49

Thanks,

AIMDBA

|||

Has anyone had a chance to check out the new Transcender learning material:

http://www.transcender.com/product.aspx?product%5Fid=Cert%2D70%2D431&dept%5Fid=102210

Thanks,

AIMDBA

|||

The 70-431 Training Kit from Microsoft Press that we wrote hit the shelves about 2 weeks ago. We designed this book to not only meet all of the objectives necessary for the exam, but also to become a core reference for SQL Server 2005. This book very definitely goes well beyond the exam while also covering everything that you need to know on the exam.

There's also one really big difference with this book, it contains a voucher for a 15% discount on the exam which is worth almost the price of the entire book. The exam engine that ships with the book was designed with questions that mimic what you are going to see on the exam. So, combine what you get with the 15% exam discount along with the cost of buying exam simulation software, then you are getting a book for free that goes well beyond the exam itself.

http://www.amazon.com/exec/obidos/ASIN/073562271X/mssqlservercom/102-4828681-7857756

|||I bought the book that Michael talks about from Amazon and it should arrive within a week or so. Amazon has free shipping on this book too. Great deal! Michael, if you read this I am super excited to read your book!!
|||Thanks. We're looking for feedback.|||Hi Michael, I have a question for you. I received my book today and I read that you recommend not using your primary PC for the study because it will alter the OS. I'm in a bit of a pinch because my secondary PC has an older OS that won't work with the CD. It's a Windows 98 and I would need to upgrade to 2000 Pro. I really don't have the money to do that right now and I'm wondering how risky it would be to use my primary PC. Would you be able to tell me what types of changes are made that could put my PC at risk and what the worst case scenario would be?

Thanks so much!
Alexx
|||Another question I didn't ask- How about using Microsoft Virtual Server 2005 environment to test on? It's a free download, so the price is right for me.

Thanks again,
Alexx
|||

Since you're not going to build a cluster with the 70-431 exam content, then you don't need Virtual Server. Virtual PC will work just fine. That's where I recommend that you do all of your testing. The primary reason is that it provides an isolated environment for your testing that won't impact other things. The second reason is that it becomes a self-contained image. So, you can build the base environment once, stop Virtual PC, make a copy of the .vhd & .vmc files, and then start everything back up. If you blow something up or just want to reset everything, all you have to do is shut down the VPC image and copy the .vhd and .vmc files back over.

All of the instructions for setup are done from a VERY conservative standpoint. I don't necessarily agree with that particular one, but I got overruled. The SQL Server setup is going to drop .NET Framework 2.0 on your machine along with the Native Access Client and some setup support files. It then installs everything else which includes services and some other things.

It obviously isn't dangerous to do, you just have more software on your machine to contend with and SQL Server is completely stable. For testing/training environments, we're always going to recommend finding a machine you can blow up so that you can play as much as you want without having to worry about impacting anything else you are doing.

|||Thank you SO much for your reply! I am really excited to get 'er up and running and start the training. I hope you will continue checking this board as we all appreciate your expert advice.

Later on~
Alexx

MCTS 70-431: SQL Server 2005 Implementation and Maintenance

Hi, I am about to take a MCTS 70-431 exam next week.

I tried to find few information regarding this exam, but I cannot find what I need at Microsoft site.

I wonder if anyone has taken this exam or knows about any information about this exam.

My Questions:

Q1: Number of questions on the exam

Q2: Passing Score or percentange or numbers of right questions

Q3: Format of exam:

Definition, concepts, case study, or simulation?

Q4: What if I fail? Retake policy

Do I pay same amount to take it again?

Any information is really helpful and appreciated.

Thank you so much!

One additional question

Q5: How long is the exam?

2 hours, 3 hours?

Please let me know. Thanks.

|||The answers of far as I can remeber:

Q1: About 40
Q2: 700 Answers are scored different, so it is about 70% of the questions answered)
Q3: its all about knowing the database, maintaining, designing, working, syntax, indexes. Its really easy to get thorugh the test if you have some practise.
Q4: There are special offers which might get you the opportunity to retake the exam for a lower price or no fees at all. Refer to the www.microsoft.com/mcp for more information.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Mcsd Exam

I intend writing MCSD exams and would need some dumps on it.. if anyone happens to have, please kindly send me some @. gomesea@.yahoo.com. I would glady appreciate it. Presently, I've written thr 70-305 exam.I love posts like these. This is the persons first and only post, and they aren't willing to come back for the info, we have to e-mail it to him.

Good luck buddy|||I love posts like these. This is the persons first and only post, and they aren't willing to come back for the info, we have to e-mail it to him.

Good luck buddy

No, no, please, you don't understand. He's sincere...trust me...er, trust him! :D

Regards,

hmscott

PS. Actually, he's an M$ plant, and if you do e-mail him the dumps, he's waiting to nail you with an IP suit.

hmscott|||One note for MCSD certification!
It is a developer path among Microsoft certifications. Only 70-229 is an optional exam that is related with SQL
70-305 is obviously not related with SQL Server!

Eralper
http://www.kodyaz.com|||Or even better perhaps, you can take 70-431 instead :)

MCP Exam Study Query

Your question is not very clear.
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself!
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>|||Hi All,
I'm currently studying for MCP exam 70-229. I'm on the database logical
modeling section, and have come up with this question:
In a non-identifying relationship, how would a join work, or is the term
used to describe a situation where a relationship is at fault?
Many Thanks,
Simon.|||Your question is not very clear.
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>|||Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself!
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>

MCP Exam Study Query

Hi All,
I'm currently studying for MCP exam 70-229. I'm on the database logical
modeling section, and have come up with this question:
In a non-identifying relationship, how would a join work, or is the term
used to describe a situation where a relationship is at fault?
Many Thanks,
Simon.Your question is not very clear.
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>|||Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself! :)
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another Certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I'm currently studying for MCP exam 70-229. I'm on the database logical
>> modeling section, and have come up with this question:
>> In a non-identifying relationship, how would a join work, or is the
>> term used to describe a situation where a relationship is at fault?
>> Many Thanks,
>> Simon.
>>
>sql

MCP Exam - 70-229

Dear All,
I am considering taking the above exam in the next few ws.
I have attended the course that accompanies the Exam and have read the
course material.
I have also recently started reading Inside SQL Server 2000 by Kalen
Delaney.
I have been using SQL 2000 for the past 18-24 Months.
Can anyone give me any information regarding the above exam? Typically
how long is the exam and any guidance re: revision would be most
helpful.
Many thanks
BarryTypically
> how long is the exam
Its about 180 minutes (plus additional time for non native english
speakers)
For content look here (but experience is the best for preparing)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Barry" <barry.oconnor@.singers.co.im> schrieb im Newsbeitrag
news:1116000519.113047.167620@.g14g2000cwa.googlegroups.com...
> Dear All,
> I am considering taking the above exam in the next few ws.
> I have attended the course that accompanies the Exam and have read the
> course material.
> I have also recently started reading Inside SQL Server 2000 by Kalen
> Delaney.
> I have been using SQL 2000 for the past 18-24 Months.
> Can anyone give me any information regarding the above exam? Typically
> how long is the exam and any guidance re: revision would be most
> helpful.
> Many thanks
> Barry
>|||I took the exam and it was 3 hours I believe.
Your best source of all information are the BOL, IMO.
I would read Microsoft's site about the contents of the exam
and then brush up on them using the BOL.
"Barry" <barry.oconnor@.singers.co.im> wrote in message
news:1116000519.113047.167620@.g14g2000cwa.googlegroups.com...
> Dear All,
> I am considering taking the above exam in the next few ws.
> I have attended the course that accompanies the Exam and have read the
> course material.
> I have also recently started reading Inside SQL Server 2000 by Kalen
> Delaney.
> I have been using SQL 2000 for the past 18-24 Months.
> Can anyone give me any information regarding the above exam? Typically
> how long is the exam and any guidance re: revision would be most
> helpful.
> Many thanks
> Barry
>|||Armando, Jens
Thank you both for your replies - I'm off for some light reading(!) :-D
Barry

MCDBA (SQL Server 2000) exams still available ?

Can anybody answer :
Are MCDBA (SQL Server 2000) exams still available today ?
Is it worth going for this exam today, in spite of the fact SQL Server 2005 has been released ?Of course the credentials are still good and will be available for awhile. You can find more information on the microsoft site.|||even if they were, why bother? mainline support for 2K ends next April and I suspect the credentials go dead soon as well. it's like you can still get a job doing VB6 but it is not likely going to be a good or exciting job.|||mainline support for 2K ends next April

not that I care, but I was under the impression that MS support for each major release of SQL Server goes for 10 years. apparently that's not the case?|||i am pretty sure that extended support begins next April, but mainline support ends and I believe extended support comes at a cost.|||not that I care, but I was under the impression that MS support for each major release of SQL Server goes for 10 years. apparently that's not the case?

depends on your definition of "support".

Mainstream support will end April 2008. I believe that you are right that "extended support" will continue for another 5 years beyond that point. I believe that it means there will be no more patches, no more hotfixes (at least none that are for general release) after April 2008, but MS will take your money and answer your calls and maintain links to existing downloads on their site. There's an MS web site somewhere that details what the phases of support are and what they consist of and how long each lasts. I don't have that google magic tonight.

...sigh...it's been a long week and a long day.

Regards,

hmscott|||Hotfixes are NOT for general relese, and I'm so bored with the Microsoft Courseware when it comes to terminology:

Description of the standard terminology that is used to describe Microsoft software updates (http://support.microsoft.com/kb/824684/en-us)|||even if they were, why bother? mainline support for 2K ends next April and I suspect the credentials go dead soon as well. it's like you can still get a job doing VB6 but it is not likely going to be a good or exciting job.
Well, in my opinion the 2000 certs have something I miss from 2005, and visa versa. I'd actually like DBAs to have both.

The 2005 certs (MCITP) are really great as they cover a lot of design issues, as well as a requirement for broad knowledge (MCTS) of the product. However, the MCITPs (and especially Database Administrator) does not test certain skills which should be mandatory, as general troubleshooting of server, network, directory service etc. This skills should be mandatory, and tested. In 2000 they were, at least to a point.

I certainly hope that Microsoft takes the best from both the 2000 and the 2005 track when they start developing the certification track for Katmai|||Well, in my opinion the 2000 certs have something I miss from 2005, and visa versa. I'd actually like DBAs to have both.

good thing I'm not a DBA. I have neither! :)|||Hotfixes are NOT for general relese, and I'm so bored with the Microsoft Courseware when it comes to terminology:

Description of the standard terminology that is used to describe Microsoft software updates (http://support.microsoft.com/kb/824684/en-us)

Then M$ is not very good at following it's own terminology:

Cumulative hotfix package (build 2153) for SQL Server 2005 is available (http://support.microsoft.com/kb/918222)

:D

But what else is new...?

Regards,

hmscott|||Well, in my opinion the 2000 certs have something I miss from 2005, and visa versa. I'd actually like DBAs to have both.

I have met DB professionals with both or one or the other I would not hire or let near my DB servers. Last year I had this 22 or 23 year old kid in support and I swear all he did was spend a month on Braindumps per exam and boom he was certified. No sweat. Repitition and regurgatation. Doesn't make him a good dba. I think he got a 900 or close to it on both exams.|||I have met DB professionals with both or one or the other I would not hire or let near my DB servers. Last year I had this 22 or 23 year old kid in support and I swear all he did was spend a month on Braindumps per exam and boom he was certified. No sweat. Repitition and regurgatation. Doesn't make him a good dba. I think he got a 900 or close to it on both exams.

Conversely, I have met individuals with no certifications whatsoever who could run rings around me (or just about anyone else).

Formal education/certification is a means to an end (competence and skill) and not an end in and of itself.

Regards,

hmscott

MCDBA

Can anyone recomend a good book for the 70-228 exam.
I have a pretty decent sql2k admin book, i just need someting to guide me
through the exam prep.
Im a big fan of the Sybex Study Guides.
"mat" <mat@.discussions.microsoft.com> wrote in message
news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
> Can anyone recomend a good book for the 70-228 exam.
> I have a pretty decent sql2k admin book, i just need someting to guide me
> through the exam prep.
>
|||Me too.
"ChrisR" <noemail@.bla.com> schrieb im Newsbeitrag
news:OgmGJmdSFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Im a big fan of the Sybex Study Guides.
>
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
>

MCDBA

Can anyone recomend a good book for the 70-228 exam.
I have a pretty decent sql2k admin book, i just need someting to guide me
through the exam prep.Im a big fan of the Sybex Study Guides.
"mat" <mat@.discussions.microsoft.com> wrote in message
news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
> Can anyone recomend a good book for the 70-228 exam.
> I have a pretty decent sql2k admin book, i just need someting to guide me
> through the exam prep.
>|||Me too.
"ChrisR" <noemail@.bla.com> schrieb im Newsbeitrag
news:OgmGJmdSFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Im a big fan of the Sybex Study Guides.
>
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
>> Can anyone recomend a good book for the 70-228 exam.
>> I have a pretty decent sql2k admin book, i just need someting to guide me
>> through the exam prep.
>

MCDBA

Can anyone recomend a good book for the 70-228 exam.
I have a pretty decent sql2k admin book, i just need someting to guide me
through the exam prep.Im a big fan of the Sybex Study Guides.
"mat" <mat@.discussions.microsoft.com> wrote in message
news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
> Can anyone recomend a good book for the 70-228 exam.
> I have a pretty decent sql2k admin book, i just need someting to guide me
> through the exam prep.
>|||Me too.
"ChrisR" <noemail@.bla.com> schrieb im Newsbeitrag
news:OgmGJmdSFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Im a big fan of the Sybex Study Guides.
>
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:98BB2489-7DA4-402C-8A83-1F1253A2633F@.microsoft.com...
>

MCAD free online test

Hi everyone,
I am searching for free online MCAD exam test.
I could only find ucertify online free test.
If you know any link about this, would you please inform me ?

Thanks

and also I am searching for 70-229 exam online test.

Thanks

|||

Hi, I encounter a question which make me confused.

You are a database developer for an insurance company. The insurance company has a multi-tier application that is used to enter data about its policies and the owners of the policies. The policyowner information is stored in a table named Owners. The script that was used to create this table
is shown below:
CREATE TABLE Owners
(
OwnerID int IDENTITY (1, 1) NOT NULL,
FirstName char(20) NULL,
LastName char(30) NULL,
BirthDate date NULL,
CONSTRAINT PK_Owners PRIMARY KEY (Owner ID)
)
When information about policy owners is entered, the owner’s birth date is not included; the database needs
to produce a customized error message that can be displayed by the data entry application. You need to
design a way for the database to validate that the birth date is supplied and to produce the error message if
it is not. What should you do?
A. Add a CHECK constraint on the BirthDate column.
B. Create a rule, and bind the rule to the BirthDate column.
C. Alter the Owners table so that the BirthDate column does not allow null.
D. Create a trigger on the Owners table that validates the BirthDate column
Answer:D

So I think that the answer ccan also be 'C', is not it ?

Would you please explain this to me ?

Thanks

|||

The key sentence is :

"the database needs to produce a customized error message that can be displayed by the data entry application."

You won′t get a customized error message (Because you won′t be able to create one) if you set the column no to allow NULL values.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,
While inserting a record to the table, since we modified the BirtDate not to allow null, does not it also create an error ?

Thanks

|||Sure but it will only create Error Number 515, you won′t be able to customize that message. In a trigger you can catch the error and throw a custom one with raiserror.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Sorry, I did not care the 'customized' meaning.
Sorry again,
Thanks,
Mert