Microsoft Exam Questions

Which code segment should you use?

A performance issue exists in the application. The following code segment is causing a performance bottleneck:

var colors = context.Parts.GetColors();

You need to improve application performance by reducing the number of database calls. Which code segment should you use?

A.
var colors = context.Parts.OfType<Product>().Include(“Colors”).GetColors();

B.
var colors = context.Parts.OfType<Product>().Include(“Product.Color”).GetColors();

C.
var colors = context.Parts.OfType<Product>().Include(“Parts.Color”).GetColors();

D.
var colors = context.Parts.OfType<Product>().Include(“Color”).GetColors();