70-464 Premium VCE File
70-464.vce - ExamCollection Verified - Instant Download
202 Questions & Answers
Get Unlimited Access to ALL Premium Files$69.99

Download Microsoft.BrainDump.70-464.v2013-09-02.by.Anonymous.79q.vce

Exam: 70-464 - Developing Microsoft SQL Server 2012/2014 Databases
Size: 5.59 MB
# of downloads: 275
Free Download:

Rating:

1 liked this dump 0 disliked
Click here to Like Dislike

VCE Simulator for Microsoft 70-464 Exam
Comments

* The most recent comments are at the top.

Note:

Use VCE Exam Simulator only to play VCE files properly.


Necro

  • United States
  • Oct 08, 2013
  • Report Comment

Yes, maybe something is missing but, if that is the case I will stay with AES_256, because is a more computable security option and stronger than a 3 round 56bit (168) encryption.


Wing

  • United States
  • Sep 24, 2013
  • Report Comment

Seems like many of these questions are missing information or the options have nothing to do with the question presented. Has anyone validated this practice exam?


Kat

  • United States
  • Sep 17, 2013
  • Report Comment

Fair enough Necro. Perhaps you can clarify an answer for me.

Q. 67 - With the question given I cannot determine why AES_256 is a better answer than TRIPLE_DES_3KEY. Both are viable encryption algorithms. My theory is that part of the question is missing that indicates using the strongest encryption method or some other criteria. This would explain using the 256 bit option over the 192 bit option.


Necro

  • United States
  • Sep 16, 2013
  • Report Comment

2) Exam A, question 7
The question only says "blocked from updating", but says you still need to read the data. Repeatable Read can allow dirty reads and MS says to only use when necessary. I would pick Serializable.
http://technet.microsoft.com/en-us/library/ms173763.aspx
---------------------------------------------------------------
Both questions have the same tag about "MS says to only use when necessary" lol

this question is not very clear because both isolation level will hold the lock, Serializable restrict to much even if doesn't allow dirty read, but after this range lock is applied you can't not only updating you can't insert either anything that can match the statement of the sp1 and that is a behavior that I will not agree in a e-commerce site like amazon.

So just like the question have only "blocked from updating" and don't said anything about Insert or not allow dirty read I will stay with "repeatable read"


Kat

  • United States
  • Sep 16, 2013
  • Report Comment

Khrun,
1) Exam A, question 3. - The question specifies a one-way encryption. One way encryption is a hash, while two way is encryption. SHA-1 is used for performing a hash while AES-256 is for two way encryption. Therefore, SHA-1 should be used here. There is another version of the question that states two way encryption and should use AES-256.

2) Exam A, question 7
The question only says "blocked from updating", but says you still need to read the data. Repeatable Read can allow dirty reads and MS says to only use when necessary. I would pick Serializable.
http://technet.microsoft.com/en-us/library/ms173763.aspx

3) Exam A, question 13.
I agree with you. The Contact lookup is already performing a Seek, so this answer seems completely wrong to me. The answer should be trying to limit the Index Scan operations, so your answer seems more correct.

4) Exam A, question 18.
Views are good for joining many tables together, but do not accept parameters. The question says "for a given sales order" to generate the results and then use the result to perform a join. To get a given sales order you have to accept an OrderID, generate the results, and then allow a join, so A is more correct.
http://technet.microsoft.com/en-us/library/ms191007.aspx

5) Exam A, question 70.
One of the given requirements is "A table-valued function will be created to search products by type.". Therefore, you are correct D should be the answer rather than B because you need a table-valued function.


Khrun Morjov

  • Russian Federation
  • Sep 05, 2013
  • Report Comment

Thanks for dump.
I have several questions.

1) Exam A, question 3.
Is it possible to execute such command?
CREATE SYMMETRIC KEY Key1
WITH ALGORITHM = SHA1
ENCRYPTION BY CERTIFICATE Cert1;

I'm not sure that we can use SHA1 as algorithm in this case

2) Exam A, question 7
"Sp1 is used to read and change the price of all the products sold on e-commerce site.
You need to ensure that other transactions are blocked from updating product data while sp1 executing.
Which transaction isolation level should you use is sp1?"

Is 'repeatable read' not enough for exclusive locking existing rows till the end of transaction with UPDATE ?

3) Exam A, question 13.
What for we need index on the 'Contact' table?
Is the index on SalesOrderHeader(OrderDate) include (SalesPersonId, SubTotal) not better?

4) Exam A, question 18.
"For a given sales order, you need to retrieve the OrderID, Quantity, and LineTotal columns for all of the items in the OrderDetails table.
The solution must ensure than the results can be joined to other tables.
Which code segment should you execute?"

Is 'CREATE VIEW..' not correct answer? View is enough for getting all items and join to other tables.

5) Exam A, question 70.
The query returns dataset, but not xml data.
IMHO answer D looks more suitable.

Report Comment

Verify:

Add Comment

Name: *
E-mail: *

This e-mail will not be published.

Comment: *

Comment will be moderated and published within 1-4 hours.

Rate file: * Like!     Dislike
Verification: * Secure Code
Type the characters from the picture.  
VCE Exam Simulator Free DemoVCE Exam Simulator Free Demo
Read about VCE Exam Simulator
Download VCE Exam Simulator

Training Products

Premium File

  • 202 Questions & Answers
  • Instant Download
  • $69.99

Get Unlimited Access to the all ExamCollection PREMIUM VCE files!
Prep4sure - Professional IT Certification Training
BrainDumps - Get Real Exam Questions
Actual Tests - Lifetime Access to IT Exams

Related Blog Posts

Site Search:

Close
Only Registered Members Can Download VCE Files

Please fill out your email address below in order to Download VCE files or view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted By 1.2M IT Certification Candidates Every Month
  • VCE Files Simulate Real exam environment
  • Instant download After Registration.
Please provide a correct E-mail address
Email Address:

A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Close
Log into your ExamCollection Account

Please Log In to download VCE file or view Training Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

E-mail:
*  
Password:
* Forgot password?
 

Only registered Examcollection.com members can download vce files or view training courses.

Registration is free and easy - just provide your E-mail address. Click Here to Register

Close
DO YOU HAVE A VCE PLAYER?
Play VCE files with Avanset VCE Simulator

Your file is being downloaded.

All tests on this site have been created with VCE Exam Simulator.

VCE Exam Simulator is interactive testing engine developed for certification exam preparation.

Files with VCE extension can be opened with this program.

Before you can open any file on this site you will need to download VCE Exam Simulator

Download VCE Player
I already have it
Close
Like this VCE file?

Log in to make your opinion count.

E-mail:
*  
Password:
* Forgot password?
 

Only registered Examcollection.com members can rate files.

Registration is free and easy - just provide your E-mail address. Click Here to Register

Close

Close
Download Free Demo of VCE
Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.


Simply submit your e-mail address below to get started with our interactive software demo of your free trial.


Enter Your Email Address

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.