|
||||||||||||
Home
Tutorials
Exam Formatter
Upload
FAQ
Contact
|
||||||||||||
|
Practice Exams:
Microsoft
Cisco
CompTIA
RedHat
Citrix
|
||||||||||||
|
HP
IBM
CheckPoint
CIW
LPI
Novell
VMware
CWNP
EXIN
Other
|
||||||||||||
|
||||||||||||
|
Not bad for learning.
However MS has added new questions, so only about 85% of the exam came from it.
Some were new questions and some were existing questions with slightly modified answers. So make sure you don't just simply remember the answers and you should know the material as well!
Good thing is that there was absolutely no free text, code typing of any sort for my one.
The 90% of administration section and 50% of Development section doesn't exist in this dump
Exam A, Q38.
Suggested answer is B, but I answered "...to perform transactional replication" (answer F) and scored 1,000 points in admin section.
I had 2 or 3 questions not in the dump and I think that 1 or 2 answers may be wrong, but still manage to have 87%!
Thanks Burgos!
But I think some of the answers are absolutely wrong!
I passed first session (25 questions of querying) 700/1000. Passing score is 700 as you all know. I almost failed the first session although I memorized all of your answers.
I passed second session (25 questions of administration) 866/1000.
Does no mean the answer is wrong?
Took the exam recently and passed. No typing of queries for me.
I think this should be union all in order to retain duplicates. Someone, please confirm.
Suggested answer is b:
"create proc blah with execute as user = 'dbo' as delete from blah"
User='dbo' isn't valid & gives a syntax error. If this was the answer, it should be
"create proc blah with execute as 'dbo' as delete from blah"
I think the right answer is D - ownership chaining means that the delete permissions are never checked on the underlying table. http://msdn.microsoft.com/en-us/library/ms188354.aspx
Talks about having 3 corrupt pages, and how to restore.
Suggested answer is restore a full backup and a diff - no t-log backups - how is that the right answer?
Surely if you need to restore with minimal data loss, you want to restore the t-logs along with full/diff?
http://msdn.microsoft.com/en-us/library/ms175166.aspx
http://msdn.microsoft.com/en-us/library/ms187827.aspx
@Marc - The only other option I saw was the Synchronous server on the same subnet. I'm not 100% sure if that'd be a correct option or not.
So I'd say Replication is the right answer, as its the only solution that keep DB online.
I allready had "one choice" questions, "multiple choice" questions, "drag and drop" questions and "ordered list" questions.
Good luck!.
http://msdn.microsoft.com/en-us/library/ff878253.aspx#Indexing
Answer C is correct, though.
Cannot schema bind view 'Sales.uv_CustomerFullName' because name 'Customers' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.
This would compile, though:
CREATE VIEW Sales.uv_CustomerFullName
WITH SCHEMABINDING
AS
SELECT FirstName, LastName
FROM dbo.Customers
How exactly does the query part of the exam work? Is there an actual parser available, or would you really have to type up code in one go without being able to verify it?