|
||||||||||||
Home
Tutorials
Exam Formatter
Upload
FAQ
Contact
|
||||||||||||
|
Practice Exams:
Microsoft
Cisco
CompTIA
RedHat
Citrix
|
||||||||||||
|
HP
IBM
CheckPoint
CIW
LPI
Novell
VMware
CWNP
EXIN
Other
|
||||||||||||
|
||||||||||||
|
New Question
Thanks
Just to clarify this question:
You have a table named Sales that has the following three columns: Duty, Freight and Customs. You need to add a new column to table which would show Duty+Freight+Customs.
Which option should you implement to minimize data store?
Answer is: computed data column, the only one that doesn't use storage
Não é válido no Brasil. Fiz o teste hoje, 13/01/2012 e não caíram nenhuma destas questões na prova.
from what i can remember
1) there are 5 dml statements in a stored proc
u wish to to rollback the one that fails
and commit the previous ones to it
a) SET EXACT_ABORT_ON
b) SET IMPLICIT ON and COMMIT after each statement
c) SET IMPLICIT ON and wrap each one in a BEGIN and COMMIT TRAN
?) cannot remember
2) You have a production system and a test system that duplicates
the production system but has no processes running on it
You wish to get info on the on the performance of the I/O, queries etc
a) Run sql profiler on the prod system
b) Run sql profiler on the test system
c) cannot remember
d) cannot remember
3) With reference to "Question" from Unknown below
I wish to further clarify with additional info
You have a table named Sales that has the following three columns: Duty, Freight and Customs.
You need to add a new column to table which would show Sales+Freight+Customs.
Which option should you implement
A. Persisted Computed Column
B. Computed Column
C. Numeric data type
D. Money data type
Ans in Dump C)is defo wrong,,,so its a toss up between between A) or B)
"Which option should you implement" should read "Which option should you implement so the table storage is the minimum"
So i went for b) because that would take less storage than a Persisted column ...since it computed on the fly
good luck guys
still valid...
Good Luck :-)
guys DUMP has been changed around 10-20 questions you will get from this dumps rest of questions are coming from outside.......so be carefull guyssssss
Sill valid in South Africa. I also passed with 914. 50 Questions, 4-5 new Questions. 2 Questions from this discussion. With this dump it is very easy to pass. Good luck!
Good luck future MCTIP
You have a table that contains an XML column named XMLData1. The column contains the following nodes:
- Title
- Description
- Author
- Weight
- NumPages
You need to design stored procedure thet will return inly the Title and Description in an tabular result set. The solution must be developed by using minimum amount of effort.
How should you extract the information?
- Execute sp_preparedocument.
- Use FOR XMLPATH in a select statement.
- Use XMLData1.Exist() in a select statement.
- Use XMLData1.Query() in a select statement.
Thanks for all, guys!
1) DB of size 100 GB is used for archiving and reporting. When analysed with SQL profiler, its found that there is a lot of page I/O which is causing the bottleneck for response time. How do you reduce I/O and increase response time?
a) Use Row compression.
b) Use table partitioning.
c) Use DBCC SHRINKDATABASE command.
d) Use DBCC SHRINKFILE command.
2) There are 4 branches of a company in different countries. How do you design you DB topology so that they take least amount of time to be syncronised?
a) Use Log Shipping.
b) Use Database mirroring.
?
?
Sorry I dont remember the last 2 options of the 2nd question
some questions not in this file
few new questions, some answers in this dump are not correct, read books and use your brain
good luck future MCITP
still valid 100%
4-6 New Questions, But Still 100% Valid,
I get 807/1000
passed with 850
Passed today twith 9xx marks.
(Exam 70-451).
Thanks in Advance.
Question:
You have a table named Sales that has the following three columns: Duty, Freight and Customs.
You need to add a new column to table which would show Sales+Freight+Customs.
Which option should you implement
A. Persisted Computed Column
B. Computed Column
C. Numeric data type
D. Money data type
The correct answer in this dump is C.
I would think that it has to be B.
What du you think?
Passed yesterday with 8xx marks.
good luck.......
10 new questions
one of them
Your company is developing an application. The database platform for the application will be
vendor-independent.
You need to ensure that the application automatically stores the current date and time data when a record
is inserted or updated, regardless of the database platform.
What should you do?
A. Use the datetime2 data type.
B. Use Entity Framework and DateTime.Now.
C. Create an INSERT trigger that uses the GETDATE() function.
D. Create a database column that has a default value of GETDATE().
Answer: B
other question cant remember 3-4 difficult ones
good luck every one
Good luck