Programming Impact DS0-001 Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A .NET developer is using Entity Framework Core to query a database. The developer writes a LINQ query that filters on a property that is not mapped to a database column. When the query is executed, it throws an exception. What is the most likely cause?

   • AThe database connection string is incorrect.
   • BThe query is trying to use a client-side function that cannot be translated to SQL.
   • CThe LINQ query is using `AsNoTracking()`.
   • DThe database table does not have a primary key.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A .NET developer is using Entity Framework Core and needs to retrieve a list of customers and their orders. The developer wants to avoid the N+1 query problem. Which method should be used in the LINQ query?

   • A`.FirstOrDefault()`
   • B`.Include(c => c.Orders)`
   • C`.ThenInclude(c => c.Orders)`
   • D`.AsNoTracking()`
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which of the following is a key benefit of using an ORM tool in application development?

   • AIt eliminates the need for database administrators
   • BIt reduces the amount of boilerplate data-access code developers must write
   • CIt allows applications to run without a database server
   • DIt guarantees that all SQL queries are optimally tuned
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which Entity Framework method is used to add a new entity to the database?

   • AAttach()
   • BAdd()
   • CUpdate()
   • DRemove()
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is a common effect of running a large number of concurrent write operations on a database server?

   • ADecreased disk I/O because writes are batched automatically
   • BIncreased lock contention and potential blocking
   • CNo impact on server resources if the database is optimized
   • DImproved query performance due to caching
   Reveal Solution Discussion Select an answer first