MCSD MCSD Performance Optimization and Scalability

Question 1

Which .NET profiling tool built into Visual Studio helps identify CPU hotspots and memory allocations in running applications?

Accepted Answer

Visual Studio Diagnostic Tools / Performance Profiler

Answer

Application Insights SDK

Answer

BenchmarkDotNet

Answer

dotnet-counters CLI

Question 2

What is the primary advantage of using async/await in ASP.NET Core for I/O-bound operations?

Accepted Answer

It frees thread pool threads to handle other requests while waiting for I/O to complete

Answer

It executes I/O operations on a dedicated high-priority thread

Answer

It automatically retries failed I/O operations without developer intervention

Answer

It converts synchronous library calls into parallel CPU work

Question 3

In Azure, which service provides a distributed, in-memory cache that reduces database load for frequently accessed data?

Accepted Answer

Azure Cache for Redis

Answer

Azure SQL Elastic Pool

Answer

Azure Table Storage

Answer

Azure Service Bus

Question 4

Which IMemoryCache method in ASP.NET Core stores a value and specifies that it should expire 10 minutes after it was last accessed?

Accepted Answer

cache.Set() with SlidingExpiration = TimeSpan.FromMinutes(10)

Answer

cache.Set() with AbsoluteExpiration = TimeSpan.FromMinutes(10)

Answer

cache.Add() with ExpirationPolicy.Sliding(10)

Answer

cache.Store() with TimeToLive = 600

Question 5

What does the Response Caching middleware in ASP.NET Core do when a [ResponseCache] attribute is applied to a controller action?

Accepted Answer

It stores the HTTP response and serves it directly for matching subsequent requests without executing the action

Answer

It compresses the response body before sending it to clients

Answer

It logs all HTTP responses to Azure Monitor for analysis

Answer

It queues the response for delivery to offline clients

Question 6

Which SQL Server execution plan artifact indicates that adding an index could significantly improve query performance?

Accepted Answer

A Missing Index hint displayed in the execution plan

Answer

A Table Scan node with a high cost percentage

Answer

A Sort operator with tempdb spill warnings

Answer

A Key Lookup operator with nested loops