70-431 (MCTS SQL)
Jul 10, 2006
Hi,
Somebody can speak (tips) about exam 70-431?
Tips?
Amount Questions?
Time ?
ADVERTISEMENT
MCTS 70-431 Help
Apr 1, 2008Can anyone tell me how many questions there are in the exam and what the pass rate is please.
Also can anyone tell me the nature of the questions that are asked or anything else that might help please.
Kind Regards
Rob
Regarding MCTS
Jul 2, 2007hi Everybody,
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.
Thanx in advance .
MCDBA Or MCTS
Feb 7, 2007For 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.
View 13 Replies View RelatedMCTS SQL 2005
Nov 21, 2006Hi everybody;
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.
Thanks
70-431 (MCTS - SQL 2005)
Jul 10, 2006Hi,
Somebody can speak (tips) about exam 70-431?
Tips?
Amount Questions?
Time ?
....
MCTS SQL Server 2005?
Apr 14, 2008I 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.
Thanks
SQL Server Training For MCTS
May 9, 2007I 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
MCTS: SQL Server 2005, 70-431
Jan 21, 2008Hi All,
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.
Your help is greatly appreicated.
Thanks,
DBSTARTER
MCTS Sql Server 2005
Oct 29, 2007I am studying for my MCTS sql server 2005 from home
and was just wondering how long it should take me to get through it
throughly. I am going through the Microsoft Implementation and maintainace self kit book.
Many thanks
Rob
MCTS 2005 SQL SERVER
Nov 24, 2007i am considering studying for the MCTS in SQL Server 2005 - can anyone offer advice if the Elearning material is useful?
Thanks
Gathered Materila For MCTS 70 - 445 Exam
Apr 29, 2008
Hi ,
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???
With regards,
Maruthi...
Buying SQL Server For MCTS Training?
Mar 18, 2008Hi Everyone,
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?
Thanks!
MCTS 70-431: SQL Server 2005 Implementation And Maintenance
Dec 24, 2006
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!
MCTS Exam For Business Intelligence SQL Server 2005
Mar 8, 2008
Hi All,
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.
Thanks& Regards,
Maruthi
Can I Use Sql Server 2005 Developer Edition With Windows Xp Home Edition SP2 For MCTS Exam 70-431 Preparation?
Dec 21, 2007Hi
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?
Thanks
gifty