Pass Your Microsoft 70-516 Exam Easy!

@Oleksandr
@ Jay
@Lyudmyla

Lyudmila is correct. Tried in code also.
context2 EntityState is Unchanged if u go with B so no update to db, if u try C then EntityState is Modified and u will update db.

@Oleksandr

Let's look at variant B, you mentioned:
context2.Attach(part1);
context2.ApplyCurrentValues("Parts", part1);

Here part1 object is attached to context. By the second line we try to apply current values, but we pass object part1 again. So, no changes would be detected because objects are the same.
And only if objects are different in context and in passing arguments, applying changes will take effect.
And exactly this situation is described in link I gave. That's why my answer is:

context2.Attach(part1);
context2.ObjectStateManager.ChangeObjectState(part1, System.Data.EntityState.Modified);

@Lyudmyla

the reason because I choose the answer B is the following:

according to this link
http://msdn.microsoft.com/en-us/library/bb896248.aspx
we need to check the ID of the object part1. If it is not 0, then this object is not new and needs to be updated. And I think that part1.PartId is not 0, because we've retrieved it from DB via context1.

But if you've checked it with code developing, I'll take your answer :-)

@Oleksandr and @Jay

Guys, according to this link
http://msdn.microsoft.com/en-us/library/bb896248.aspx
the answer B is not correct. And actually I checked this question and answers on code developing and in my case only variant C worked:

context2.Attach(part1);
context2.ObjectStateManager.ChangeObjectState(part1, System.Data.EntityState.Modified);

Did anyone else check this question via code to be sure?

@Jay

I would choose the answer B:
context2.Attach(part1);
context2.ApplyCurrentValues("Parts", part1);

Here is the reference:
http://msdn.microsoft.com/en-us/library/bb896271.aspx

"If the object being attached has updated property values, use one of the following methods [.] System.Data.Objects.ObjectContext.ApplyCurrentValues()" (c)

I think this is exactly our case, because part1 is the attached object with updated property values:
4. Updates the data in part1.
5. Updates the database by using a new ContosoEntities context object named context2.

But wait for Lyudmyla's comment.

@azzlack & @Lyudmyla

There is one question were you are opting for contradictory answers. Would be grateful if you could verify which one is correct.

QUESTION:
=========
You are adding a process to the application. The process performs the following actions:

1. Opens a ContosoEntities context object named context1.
2. Loads a Part object into a variable named part1.
3. Calls the Dispose() method on context1.
4. Updates the data in part1.
5. Updates the database by using a new ContosoEntities context object named context2.

AZZLACK HAS GONE ANSWER B

context2.Attach(part1);
context2.ApplyCurrentValues("Parts",part1);

LYUDMYLA HAS GONE ANSWER C

context2.Attach(part1);
context2.ObjectStateManager.ChangeObjectState(part1, System.Data.EntityState.Modified);

from Israel
passed 920 yesterday
the testlet from azzlak is a same
the others Q from stalker and MK.
Thanks guys

passed with 840 ,with azzlack ,stalker and MK,

there are new question

there are 2 question in testlet
around 4-5 question in exam

@Lyudmyla
thanks alot!

@Hen correct one is:
IEnumerable<Tuple<int, Part>> result = part.Descendants
.GroupBy(p => p)
.Select(g => Tuple.Create(g.Count(), g.Key));

If you make distinct() before groupBy(), you will receive all parts with count 1.

Okay the following seems right:
IEnumerable<Tuple<int, Part>> result = part.Descendants
.GroupBy(p => p)
.Select(g => Tuple.Create(g.Count(), g.Key));

Because I had 100% in the "Querying Data" and "Manipulating Data" parts of my exam.

Thx for the dumbs!!!

In this dumb there is the following question:
The application must provide a component part list for any product. The component part list must give the quantity of
each distinct part that is required to manufacture that product.

You need to create a LINQ expression that deliversa a result of type IEnumerable<Tuple<int,Part>> to meet the
requirements.
Which expression should you use?

-> the answer in the dumb is:
IEnumerable<Tuple<int, Part>> result = part.Descendants
.GroupBy(p => p)
.Select(g => Tuple.Create(g.Count(), g.Key));

But what about the following answer:
IEnumerable<Tuple<int, Part>> result = part.Descendants
.Distinct()
.GroupBy(p => p)
.Select(g => Tuple.Create(g.Count(), g.Key));

I guess this one is right.
Any comments?
Best wishes, Hen

Passed the exam 920/1000 an hr back with MK, Azzlack, dxjonet and stalker.
3 new questions
1. Entities - States Class, Cities, Delete of state id raises which exception - (EntityException, Constraint Exception, Update Exception, ENtityUpdateException)
2. Class Workflow - Has Workstepflow inside. Get workflow data as well as related workstepflow. Dont rem options
3.You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application. You use the ADO.NET Entity Framework Designer to model entities.

You need to create a Plain Old CLR Object (POCO) class that can be used with the ObjectContext.CreateObject method to create a proxy.

What should you do?
Ans - Create a custom data class in which all properties and methods are Virtual.

All, pls go through Training kit, MK, Azzlack, dxjonet and stalker dumps.
Please double check all ans in dumps

Hi guys Today i cleared that exam with 960/1000 marks with the help of
azz/mk/dxjo/stalker but still there were 10-12 new question so we careful while preparing the exam .

Passed on 26th of January with score 920 with azz/mk/dxjo.

Passed with 900. 17 new questions. Most of them from samples in MSDN. In testlet one new question. Be careful in preparation. Thanks,

920 with azz/mk/dxjo. 10-15 new questions for me

MK+Azzlack+dxjonet are V. good
Main 60 questions = 2 hours 30 minutes (About 17 in main were new questions)
Testlet 15 questions = 30 minutes

MK+Azzlack+dxjonet I got 920/1000
Main 60 questions = 2 hours 30 minutes (About 12 in main were new questions)
Testlet 15 questions = 30 minutes

This dump is very good. Thanks azzlack

Hi stefan
Good score man
are the whole question from the dumps you mentioned
and if no how many questions from out ?

MK+Azzlack+dxjonet link I got 940/1000.
Thanks you all :)

Thank dxjonet very much for your information. Hope see your fully new questions soon. I will create dump later but I must study first, I will take exam on friday 20 Jan

Troll , the questions which I included in the link are the new questions which I faced in the exam last week :) the testlet question " the new one" was an image that include a function mapping for a stored procedure the SP return a collection of products"you have to figure that by ur self :p" and you have to choose the collection type for the function import:

A- choose parts from entities.
B- choose a scaler with Int32
C- Choose a string scaler.
D- create a complex type and name it products.

The answer is D.

I will include the rest in the dumb or if you have time to help me in creating the new dump i will be happy :)

I have a new question very similar with the one dxjonet upload. But i have only question not have answer :| . About 40 new question. dxjonet upload answer for 24 question. Nice effort. Here the link question if anyone know answer plz inform me. New question both VB and C#. Let we together and make new dump for every one http://www.mediafire.com/?lauv8p7abxyc6jy

hi all , can you confirm that dxjonet's link are the new question for exam ?

Thanks a lot dxjonet for the link
goodluck in your next exam
i postponed my exam, inshallah be uploaded them.
and thanks again.

Hi dxjonet and Jordan - Jo. I'm waiting for both you confirm the new question dxjonet posted is really will appear on test exam (you will take test on Sunday right) ?

And it's very wonderful if dxjonet you can upload remain new questions. I looking for your new post
Thanks in advance.

jo - Jordan I'm fine and sorry I can't upload the new dump before that date since I have an exam also Sunday but this is a link which includes most of the new questions as I said before i will upload a new dump soon

http://blog.dxjo.info/exam-70-516-ts-accessing-data-with-microsoft-net-framework-4-sample-preparation-questions/

good luck all.

Friend of mine failed the exam so if any one got the new question plz make a new dump.

Dear dxjonet from Jordan,
kefak ?
Good grade .
i'm planing to take the exam on Sunday so if you can upload the questions and answers before this time.
Thanks in advance.

I passed the exam with a score of 940 on 11/1/2012, 45% of the questions are new , one new question on the testlet, the remaining questions are from MK and Azzlack's dumps, I will upload a new dump with the new questions as soon as I can.

i have the new questions of 70-516 around 50+ , any one can hekp me to answers them? Email me i will get you the doc file if you are able to find answers for me for both C# and VB part. here is my email: paulk99@ymail.com

Passed today with a 920. Two new questions in the testlet and about 45% new questions on the test.

Cleared my exam with 920 marks on 21st December 2011.
MK and Azzlack's dumps are good.
All the questions in testlet was from Azzlack.
Around 40% questions were different in the main test as compared to what you find in MK.
So, I would say that better go through the book first and then do these dumps.

Hi bella,
you can find it in the link below:

http://www.nauss.edu.sa/University%20Efforts/MCTS%20Self-Paced%20Training%20Kit%20(Exam%2070-536)%20Microsoft.NET%20Framework%202.0%20Application%20Development%20Foundation.pdf

sorry for bad English

Testlet of MK + Azzlack helped me a lot to pass on 21.12 in Bulgaria 960 points. Testlet is the same, but there are 20-23 new questions of 60. Most of the new questions are connected to ADO.NET and LINQ to SQL, but the most difficult questions in my oppinion (connections, security) are from the azzlack test. There are lots of questions about Entity Framework and data access with entity sql that the azzlack contains too. Thank you azzlack and MK

first 20 questions or so same, last 5questions same, 13of 15 questions in testlet were same (azzlack&mk)

This exam isn't easy:/
Passed 90%

just 100% correct.. 17 questions were the same

Hi guys, today I've passed the exam from Italy with 880 /1000 points but thare were a lot of differences from dumps : I've studied using the training kit and using azzlack and Mk dumps:

1 - The number of questions are 60 + 15 Testlet = 75 Questions in 2 Hours and 30 minutes for 60 q and 30 Minutes for testlet
2 - In the testlet there is a 1 new question
3 - In the exam (60 question) there are 25 new questions

Passed last Friday with 940 Marks
Total Question 75 (60+15):
about 36 from Azzlack
and all 15 from MK Teslets.
The other questions were new.
Thanks MK And Azzlack For Dumps

Passed Today with 940 Marks
Exam has been Changed
Total Question 75,
around 25 from azzlack
and 15 from MK which actually Teslets
and the Rest Questions were Totally new

Thanks MK And Azzlack For Dumps

Excuse me, what is Testlet?
Thanks a lot

Got 960 on Dec 10. About 22 over 60 in main questions are new. All questions in Testlet are in azzlack's dump. MK and azzlack's dumps are enough to pass. Thanks MK & azzlack SOOOO MUCH!!!!
Thanks all others for posting dumps and useful comments!

Just passed the test today. Testlet contains 3 new questions. 12 are from this dump.

MK and Azzlacks are %100 valid in Turkey

Dec 2 2011, Italy 880/1000 some new questions, in particular 2 in testlet and 4 in main questions, azzlack dump + MK for to pass this exam, thank you all

took exam on 1/12 same question + same testlet
no new questions

I passed today in Vietnam, >90% questions are in MK + Azzlacks dumps.
Exam 130':
1. Case tudy (Azzlacks testlet): 15 questions. 1 new question, check previous post.
2. Main Quest (MK): 35 questions. 2 new questions.
Thanks MK and Azzlacks a lot.

Passed several days ago with 960 out of 1000.

All question in MK + Azzlack(testlet)

thanks a lot,

Otherwise it should be:
.OrderBy(x => x.Name).Skip(currentIndex).Take(pageSize)
(A, D and E)

So what is the right answer:- if sorting is required after taking the page data then I believe following should be the Answer:-


Skip(currentIndex).Take(pageSize).OrderBy(x => x.Name)
(E, D and A)

Passed today with score 880/1000. Dump still 90% valid - had 1 or 2 new questions.
One of the new questions (not the same word by word, but almost exact):
In the UI of your application You are viewing paged and sorted data. From UI You have variables: currentIndex and pageSize.
You need to desing LINQ query to get paged data from Your data source named dts. Data need to be sorted by Name property of the queried object type.

You have parts of LINQ query (on one draggable list):
A. .OrderBy(x => x.Name)
B. .Take(currentIndex)
C. .Skip(pageSize)
D. .Take(pageSize)
E. .Skip(currentIndex)
You need to put qury parts to other draggable list (there can be any number of answers - even all). You need to sort Your answers (they need to be in the correct order).

Completed this exam 6 days ago, dump is good got 80%

What is a 'testlet'?, it the same as "case of study"?. Greets.

Thanks for clearing up things.
Gracias por la aclaracion, desarrolladorwebspain :)

All question in MK + Azzlack. (SPAIN) THANKS!

Passed Yesterday 920/100 in the netherlands. All questions in the DUMP

Passed Yesterdat 940/100. All questions in the DUMP

Answer: D

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application that uses the Entity Framework. You create an Entity Data Model (EDM) named Model. You need to ensure that the Storage Schema Definition Language (SSDL) of the EDM can be modified without rebuilding the application. What should you do?
A. Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string. metadata=res://*/Model.csdl|res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string="& "
B. Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string. metadata=res://*/Model.csdl|res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string& ="& "
C. Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string. metadata=.Model.csdl|.Model.ssdl|.Model.msl; provider=System.Data.SqlClient; provider connection string="& "
D. Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string. metadata=.Model.csdl|.Model.ssdl|.Model.msl; provider=System.Data.SqlClient; provider connection string& ="& "

You are developing a Microsoft .NET Framework 4 application. You create an Entity Data Model (EDM) by using the Microsoft ADO.NET Entity Data Model Designer (Entity Designer). The EDM contains a complex type. You need to map a stored procedure to the complex type by using the Entity Designer. What should you do?
A. Add an association to the stored procedure.
B. Add a code generation item that has the name of the stored procedure.
C. Add a function import for the stored procedure.
D. Add an entity that mirrors the properties of the complex type.
Answer: C

Passed today with Miriam + MK + Azzlack 900/1000. Thanks for the dumps

Passed today with MK + Azzlack, 960/1000.

Still Valid 100% passed today 960/1000

@SpongeBob: I understand that there were no new questions in your exam, right? Only from MK and Azzlack?
Thank you.

Steel Valid 100% . All questions are right. Use this one and MK !!!

@Luis:
LoadOrCreate is a user defined method on the ContosoEntities.cs file so A is the correct answer.

Question or Item 7 says the answer is LoadOrCreate, when I search that on google there is no info about that method, I think the answer of the test is wrong here, I would have answered override the save changes method, anyone??

@Karl: Congrats!!!! Do you remember any of the new questions, or at least, a hint about them?

Passed with 860 using MK and Azzlack. But atention!!

You should know that i find 4 new questions on the testlets and about 10 new questions on the normal test. Not easy at all. study!!

Use the MK and Azzlack Dump!

After 3 times reproved. Today i passed with 860.

It´s the hardest test of all roadmap.


Thanks for all efforts!!

NewbieBr

Passed today 980 with dump from MK and Azzlack. From report, I knew that I got one wrong answer in the section of "Managing connections and context".
btw, I used Artiom's answer C for "You are adding a process to the application." If this question belongs to "Managing connections and context", it's wrong answer; otherwise, it's correct answer. And the correct answer for "You need to ensure detection of unauthorized changes to the row values." is the one with RSA creating signature column (NOT MD5).

nik from Unknown - Oct 24 2011, 2:18 AM Report Spam
I think the answer is B - "becose the main purpose of using hashing functions is to determine whether data has changed. Hashing does not encrypt your data."- i found this words in Self-Paced Training Kit for Exam 70-516.
Am i right?

Hi, Jesus is right. The answer should be A and not MD5. To create a RSA digital signature, a hash would take place prior before it is encrypted with private key. The verification to be done using the public key to the signature column. The signature column contain - hashed + encrypted of all the row information which is better security than MD5 because only user with private key can encrypt to create the dignatal signature. MD5 would still work but hacker can re-hash and store the value back to MD5 column easiliy. RSA woudl required the owner private key.
Hope that clarify things

Passed today with 920, all ques from MK and Azzlack, Thanks. Couple of wrong question is there in both I think.

Hello, passed today with 860. Same questions as MK and Azzlack. This is my second try to take the exam. The testlet was same as previous time( same as azzlack ) with 2 different questions. Some new questions in the other part, as well.

Passed with 940 yesterday, 1 or 2 new questions, all others from MK + Azzlack dumps Thanks v much

passed with 840 - used MK and this testlets - about 1-2 new question in testlets and about 5 new in main quistions part

this is valid em Brazil 960/1000
MK + Azzlack dumps
thanks MK and Azzlack

I've failed the first try and it was a couple of days ago. The testlet was the same as this one. I will try to retake it in three days and I am quite sure the testlet will be different. Did anyone retake this test? Do you know other testlets I can study? Any suggestions?

I passed with more than 95%. Just review the dump by MK and This test let. And that's enough.

I've passed the exam today (80%), you'll need to review MK (dump questions) and azzlack (Testlet).

I think the answer is B - "becose the main purpose of using hashing functions is to determine whether data has changed. Hashing does not encrypt your data."- i found this words in Self-Paced Training Kit for Exam 70-516.
Am i right?

What about last question (. You need to ensure detection of unauthorized changes to the row values..).
Which answer is correct A or B?

why dump says it has 17 questions, if in fact has only 15, what are the other two missing

Smurf, you are a damn smurf :) Everyone can modify the MD5-hash too. Only people with the key can modify the RSA hash. So the answer is still A, and the original row values are still accessible for all. Or am I wrong?

Passed yesterday 980 using MK (dump questions) and azzlack (Testlet).

HI @hemanth, The question about duplicates has wrong answer here. U can read about that a few posts below. And check post of @smurf. Good luck

Passed today with score 960. the testlet dump azzlack.17q.vce is valid.
All questions from MK and Azzlack testlet. Some question may have wrong answer in the dump. i do the exact same choice for all questions as per dump of MK and testlet but why two answer are wrong?
i remeber one question below
1-Entityframework connection string qestion of MK dump does not have the option available in the exam

Hello Artiom ,

are test let answers correct or did u tried different answers.

@brn have u read my posts? I wrote that is valid

The test is valid??

The answer for question 17 to detect unauthorized changes to row and user can view the original values.

The answer should be B. To use the MD5 to generate the hash in column signature. Just think again and you know why it is that so.

Thanks alot azzlack!!!!!!!!!!!!

Hi @Terry & everyone. Passed 920 today, two my colleagues 980 (both).
all 35 questions from dump of MK, and 15 in testlet - all questions from this one.
Good luck to everyone

@Artiom: Thanks a lot!! Good luck tomorrow, come back to let us know how it went!

sorry, made a little misttake, State is Unchanged
//Answer "B"
using (PassG context = new PassG())
{
context.Attach(item); //=>item.EntityState = Unchanged!!!!!!!!

it you don't believe me - make test it. I wrote next code:
public MainWindow()
{
InitializeComponent();

String nameAfter = GetName(); //Initial name: "Andrew"

Employee item;
using (PassG g = new PassG())
{
item =g.Employees.Where(e => e.EmployeeID == 2).Single();
}
item.FirstName = "Exam";//we change name to "Exam" =>item.EntityState = Modified


nameAfter = GetName(); // name in DB is still "Andrew"

//Answer "B"
using (PassG context = new PassG())
{
context.Attach(item); //=>item.EntityState = Modified!!!!!!!!
context.SaveChanges();
}
nameAfter = GetName();//Name in DB is still Andrew, but should be "Exam"!!!!! son - it's wrong answer

//Answer "C"
using (PassG context = new PassG())
{
context.Attach(item); //
context.ObjectStateManager.ChangeObjectState(item, EntityState.Modified); //=>item.EntityState = Modified

context.SaveChanges();

}
nameAfter = GetName();//=="Exam"
}

private String GetName()
{
using (PassG g = new PassG())
{
return g.Employees.Where(e => e.EmployeeID == 2).Single().FirstName;
}
}
}

Hi @Terry. I've tested both answers.
When u attach an object from other context, context at that time has no in cache object with the same key. Object attached - and state=Unchanged;
Next you call ApplyCurrentValues. But it make sense if in cache is an original object. But in our case - update object in cache and u apply his current values to it - it doesn't make sense - and object state remains unchanged => context won't save it.

In case of ObjectStateEntry - you explicitly tell context to change to modified state, therefore context will save it on next call of SaveChanges method.

Hope I explained it a good way. Sorry for English, it's not my native language.
Will be glad to answer to ur questions.

BTW: tomorrow is my exam)

@Artiom: Can you explain why it is right and wrong, it is confusing to people when you just give simple one liners like that. Thanks!

Other questions are right. By the way: the question about duplicate colors:
A: returns bool
C: returns IEnumerable<bool>
so=> right answers are B,D

The question "You are adding a process to the application. The .." has invalid answer B; The right answer is "C"

Dumps only have 17 questions:(

Nice testlet dump. Just what everyone was looking for, assuming the answers are correct. These answers are different than the Hebrew Doc and Sancho shots. I hope it's safe to assume that your answers are right? :)

Regardless, good job on getting it into the .vce format.