I have started gathering required materrials for MCTS 70 - 445 Certification Exam.
Up to this period, I have
1.Microsoft SQL Server 2005 Integration Services Step By Step Book
2.Microsoft SQL Server 2005 Analysis Services Step By Step Book
3. Microsoft SQL Server 2005 Reporting Services Step By Step Book
and the main text book for this exam is MCTS 70-445 Implementation and Maintainance sql server 2005 BI
Is there any need for more material for studying MCTS 70-445 exam???
If any,please inform me as early as possible.
I heard SQL Server 2008 has been released in the market..so is there any separate MCTS Exam for this edition also???
I would like take MCTS exam in Business Intelligence(Dataware Housing).For this I want to know about the MCTS Certification Business Intelligence (SQL Server 2005 ). Any one can suggest how to prepare for this exam and what is the CODE for this Exam? And also is SQL Server 2008 has been released or not???
Please respond to this mail and thanks in advance.
Hi I am interested in taking MCTS exam 70-431 for sql server 2005 implementation and maintainance. I have been reading the hardware requirements for the instalation of sql server versions and realise that enterprise and developer editions have same minimum requirements for the operation system. I understand that the Developer Edition includes all the functionality of SQL Server 2005 Enterprise Edition, but it is licensed for use as a development and test system, not as a production server.
Also I undestand that the developer edition supports the Windows XP Home Edition with SP2 or later but the enterprise edition does not support this operating system. The evaluation/trial version is for the enterprise edition. Can I use the developer version of sql server 2005 for my practice exercises instead of using the trial version? I have all hardware requirements for the trial enterprise version except that I am using Microsoft windows Xp home edition version 2002 with SP2. I am trying to see if I can use the developer version of sql server 2005 as it is cheaper for me to buy this software than buying the new operating system for my computer. According to the microsoft book for the MCTS exam 70-431 there is a section which states that before you begin you should have Microsoft Windows Server 2003 running on your computer on an NTFS file system (NTFS) partition. Will I still be ok to use the book and be able to do all the tests in the book if i am using the developer version of sql server 2005 with my Microsoft windows Xp home edition than using the trial version which comes with the book?
I am trying to write a stored procedure, which does a couple of things.
First thing is it looks up a persons Location based on an ID number, which is passed from an external Script. This will return four Values from a table.
I want to insert those four values into another table, along with another ID passed to the procedure from the same script.
My question is, what do I do to the script below to get the four values out of the first look up, into the insert?
The Field names returned from the SELECT are, AREA1, AREA2, AREA3, AREA4
I am sitting for the Microsoft MCTS eaxm(70-528:Web Based Client Development) next week.
I have a confution regarding the question below.
THE QUESTION:
You create a Web Form. The Web Form allows users to log on to a Web site. You implement the login logic using a Login control named Login1. The membership data for the application is stored in a SQL Express database in the App_Data directory. You need to configure your application so that the membership data is stored in a local Microsoft SQL Server database. You add the following code segment to the Web.config file. <membership defaultProvider="MySqlProvider"> <providers> <add name="MySqlProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="MySqlProviderConnection"/> </providers> </membership> Which two additional actions should you perform? (Each correct answer presents part of the solution. Choose two.)
The six options are:
A. Use Aspnet_regsql.exe to create the Microsoft SQL Server database. B. Set Login1's MembershipProvider property to MySqlProviderConnection. C. Add the following code segment to the Web.config file. <connectionStrings> <add name="MySqlProviderConnection" connectionString="valid connection string" /></connectionStrings> D. Add the following code segment to the Web.config file. <appSettings><add key="MySqlProviderConnection" value="valid connection string" /></appSettings> E. In the ASP.NET configuration settings within IIS, ensure that Role Management Enabled is selected. F. Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the membership provider for your application.
Somewhere it is written that the two options are
A,D
Somewhere the options are:
B,D
Somewhere there are different options.
Two of my friend sat for the exam and one of them answered A,C
Another answered B,D
Both of them were incorrect.................
Can anybody please tell me which two options are correct with a brief explanation??
There confutions with 3-4 more questions.I will post them in few days.
For my last 3 years I have work with the SQL 2000 as a database analysis. Now I want to get a certification to prepare me to look for a better job. Which certification is more valuable in today job marker MCTS or MCDBA.
i'm preparing the MCTS certification for SQL Server 2005. So i need some materials which will be practical for me to get started with the engine and tool.
I am aspiring to do the MCTS SQL Server 2005 certification. However, since the SQL Server 2008 is released, I was wonder if doing 2005 is a right choice?. Does anyone you know if when the 2008 certification will likely replace the 2005, is it going to be in this year? or any guidance/information is appreciated.
I am looking for some good training. I do not do well just reading books on my own. How have you trained for this cert. I am a developer and would like to start moving in the DB Admin direction a little more. thanks
I'm interested in doing MCTS: SQL Server 2005. Could any one please let me know any link where I can find any study material/practice tests for free for the Exam 70-431.
I am looking to buy SQL Server for my home computer solely for the purpose of training for Exam 70-431 Microsoft Certified Technology Specialist: SQL Server 2005. My inclination is to buy SQL Server Developer Edition from Amazon.com for $41.99. Is this the best thing for me to do? What is the difference between Developer, Express and Standard in terms of training for the certification exam?
Hello, Im new so please be gentle. I'm just in the midst of studying for the SQL2K admin exam, and was going to to the Design exam straight afterwards. Ive heard that a person is much better off learing T-SQL before doing the design exam, is this the case? I will learn T-SQL anyway, but I'm wondering if learning before the design exam will make life easier for me?
Does anyone know of a good book that will prepare you for this exam. I know that in some early discussions that Mike Hoetch warned against some of the new books on the market.
i had the implementing database on sql server 7.0 exam this morning. there's a question that confuse me too much, it's fellowed
there are 3 columns on which you wanna create the composite index, A,B and C, A is almost identical, B is almost 50% identical and C is only 10% identical, i had the implementing database on sql server 7.0 exam this morning. there's a question that confuse me too much, it's fellowed
there are 3 columns on which you wanna create the composite index, A,B and C, A is almost identical, B is almost 50% identical and C is only 10% identical, then they asked which index enable the fastest query? the choices: A.clustered (A,B,C) B.nonclustered (A,B,C) C.clustered (C,B,A) D.nonclustered (C,B,A)
i think the sequence must be C,B,A, but how about the clustered or nonclustered? i guess it's will be nonclustered.
ok, it's there.
could you help me? i wanna know when should be clustered besides the primary key and when should be the nonclustered.thanx!
Consider the following time line: 8:00 You accomplish the full database backup. 8:10 User1 enters the order 53 for customer 10, whose name in the database is XXXXX (I can't remember, but not Bill Smith) 8:12 User2 at remote server changes the name XXXXX to YYYYY 8:13 User3 changes the name YYYYY to ZZZZZ 8:14 User3 commit the transaction. 8:20 Media fails for database. 8:30 You restore the database from 8:00 backup. What is the status of the order 53 in the database? a) The order 53 is not in the database. b) The order 53 is in the database and name is XXXXX. c) The order 53 is in the database and name is YYYYY. d) The order 53 is in the database and name is ZZZZZ.
Ans: B The name was already there.
The answer is B but I think th answer is A becouse He or Her restroe the database from 8:00
I think the 53 order maked after 8:00 so there is not order 53 in the backup database
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.
Hello all, I am preparing for 70-228 (SQL server Administration) exam. I was looking on the internet for some exam oriented questions or question bank kind of thing. I found couple of them but those are not sufficient. I would appreciate if you could let me know if you know any sites where i can get some more questions to solve. I would really appreciate if anybody has a questions bank and would like to share it with me. Thanking in advance. Mandar
I've gone through the Microsoft press study material for Exam 70-229. It is okay but not really comprehensive. I'd appreciate any supporting book that deals with the exam topics inside out... And info on any site which offers good practise exams is also appreciated.
